Table of Contents

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Microsoft Excel

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Microsoft Excel is a software program, which is included in Microsoft Office. Its features include calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for applications. It is useful in creating spreadsheets, in which the data is laid in rows and columns; and stored in the form of documents. 

/* padding-bottom: 32px; */ /* padding-top: 32px; */

/* padding-bottom: 32px; */ /* padding-top: 32px; */ Starts Every Week Live Virtual Classroom 7500

Ranks Amongst Top #5 Upskilling Courses of all time in 2021 by India Today

-->

It is also used to perform various statistical calculations like descriptive statistics. Advanced Excel Course is used for a variety of purposes as the data is easy to store and recover. These excel spreadsheets are secured and offer the option of setting up passwords. The main features of Excel include sorting of tabulated data, adding formulas to the sheets, inserting table, and calculating a large amount of information appropriately.

/* padding-bottom: 32px; */ /* padding-top: 32px; */

/* padding-bottom: 32px; */ /* padding-top: 32px; */

A number of marketers use Microsoft Excel almost every day, whether to analyze data, or to create chart, or to run a report to present at the next business meeting. 

/* padding-bottom: 32px; */ /* padding-top: 32px; */

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Doing such tasks are time-consuming and require a lot of effort. However, Excel helps us to spend less time in selecting, formatting, and entering formulas for our data. For this Microsoft Excel have many shortcuts. In order to save time and be quick with all the work, we can use Excel keyboard shortcuts. 

/* padding-bottom: 32px; */ /* padding-top: 32px; */

What is Microsoft Excel?

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Microsoft Excel is the most popular tool used across the world. The tool is used in almost every organization in the world. It is also a business intelligence tool that helps organizations handle huge amounts of data. Mastering MS Excel will help you handle other data handling tools like Power BI, Google Sheets, and many more.

What is an Excel shortcut used for? 

/* padding-bottom: 32px; */ /* padding-top: 32px; */

The most common difference between a beginner and a professional is how fast an individual works with an application or software. Having knowledge of Excel shortcuts will help you land a better position in whichever field you want to work in. You can be an accountant, analyst, surveyor, professor, architect, or human resource professional. Excel is the fundamental tool of any organization. Mostly, Small scale industries and large scale industries.

Some of the benefits you master Excel Shortcuts such as :-

/* padding-bottom: 32px; */ /* padding-top: 32px; */

More productivity

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Less Stress

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Less usage of Mouse

/* padding-bottom: 32px; */ /* padding-top: 32px; */

High efficiency

/* padding-bottom: 32px; */ /* padding-top: 32px; */

easy access to the toolbar.

/* padding-bottom: 32px; */ /* padding-top: 32px; */

For a beginner, it would be difficult to master or remember all the shortcuts. However, by using shortcuts instead of running your mouse continuously on screen you will get used to using shortcuts.

30 Excel Shortcuts That You Should Know 

/* padding-bottom: 32px; */ /* padding-top: 32px; */

For your reference, I am enclosing 30 Excel shortcuts that are frequently used in MS Excel.

Basic/Advanced Level Excel shortcut keys

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Ctrl+N

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Open new workbook

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Ctrl +

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Add rows and columns

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Ctrl-

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Deletes rows and columns

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Ctrl + S.

/* padding-bottom: 32px; */ /* padding-top: 32px; */

To save content on a spreadsheet

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Ctrl+A

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Select all on a spreadsheet

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Alt+Enter

/* padding-bottom: 32px; */ /* padding-top: 32px; */

To start fresh line within the cell

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Alt + H + D + C:

/* padding-bottom: 32px; */ /* padding-top: 32px; */

This combination will erase selected columns

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Alt + A

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Data Tab

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Alt + M

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Formula Tab

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Ctrl+K

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Select the text and hyperlink

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Ctrl + F4.

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Close

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Ctrl+H

/* padding-bottom: 32px; */ /* padding-top: 32px; */

FInd and Replace

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Ctrl+Y

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Redo

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Ctrl+z

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Undo

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Shift+ arrow key

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Helps you to control cells while selecting

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Shift +ctrl+arrow key

/* padding-bottom: 32px; */ /* padding-top: 32px; */

helps you to select entire cells with data

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Win+prtsc

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Helps you to take screenshot of spreadsheet

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Ctrl + Shift + L+Alt + Down Arrow

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Filter

/* padding-bottom: 32px; */ /* padding-top: 32px; */

ctrl+;

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Current date

/* padding-bottom: 32px; */ /* padding-top: 32px; */

ctrl+shift+;

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Current time

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Ctrl+1

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Format cell

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Alt+H+B

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Borders

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Ctrl+pageup 

/* padding-bottom: 32px; */ /* padding-top: 32px; */

To access next sheet

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Ctr+pagedown

/* padding-bottom: 32px; */ /* padding-top: 32px; */

To access previous sheet

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Alt+H+L+H+D

/* padding-bottom: 32px; */ /* padding-top: 32px; */

dialog box to remove duplicates

/* padding-bottom: 32px; */ /* padding-top: 32px; */

=vl

/* padding-bottom: 32px; */ /* padding-top: 32px; */

To create the vlookup syntax, quickly

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Alt+R

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Review Tab

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Alt+F1

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Charts

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Ctrl+shift+F

/* padding-bottom: 32px; */ /* padding-top: 32px; */

To alter the color of the font

/* padding-bottom: 32px; */ /* padding-top: 32px; */

A+W+V+G

/* padding-bottom: 32px; */ /* padding-top: 32px; */

To remove and apply gridlines

Cities in India Where Henry Harvin Course in Provided  

/* padding-bottom: 32px; */ /* padding-top: 32px; */

BangaloreChennai,  GurgaonKolkataMumbaiJaipurHyderabadLucknowChennaiGurgaonKolkata Pune

Henry Harvin Advanced Excel Course Fees

/* padding-bottom: 32px; */ /* padding-top: 32px; */

https://www.henryharvin.com/schedule/advanced-excel-course

Other Henry Harvin Courses

Conclusion 

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Excel shortcut keys are a sometimes underestimated way to increase productivity when working with an Excel model. These shortcut keys perform important operations that vastly boost efficiency and speed when employed instead of hovering on the toolbar. Because most of us have a habit of frequently switching between our mice, it is crucial to be aware of shortcuts. Your editing process will be speedier and more focused if you are proficient with these shortcuts.

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Recommended Reads:-

/* padding-bottom: 32px; */ /* padding-top: 32px; */

Also Check Media Link – Insight Success

Also, check this video:-

/* padding-bottom: 32px; */ /* padding-top: 32px; */

/* padding-bottom: 32px; */ /* padding-top: 32px; */

E&ICT IIT Guwahati Best Data Science Program

Ranks Amongst Top #5 Upskilling Courses of all time in 2021 by India Today

View Course

Recommended videos for you

Interested in Henry Harvin Blog?
Get Course Membership Worth Rs 6000/-
For Free

Our Career Advisor will give you a call shortly

Someone from India

Just purchased a course

1 minutes ago

Noida Address:

Henry Harvin House, B-12, Sector 6, Noida, Uttar Pradesh 201301

FREE 15min Course Guidance Session:

Henry Harvin Student's Reviews
Henry Harvin Reviews on Trustpilot | Henry Harvin Reviews on Ambitionbox |
Henry Harvin Reviews on Glassdoor| Henry Harvin Reviews on Coursereport