Boost your Excel speed with these 25 Excel shortcuts. It is specially designed for Excel users who are just getting started as well as advanced users.
🔗 Check out our 24 hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
We covered the following topics:
00:00 Introduction to MS Excel Shortcuts
01:01 Press Shortcuts Ctrl + Arrow Keys (To move across the range)
01:45 Press Ctrl + Shift + Arrow Keys (To select Data in Excel)
02:33 Press Ctrl + Shift + End (To choose the active cell to the last cell in MS Excel)
05:47 Press Ctrl + Spacebar (To select the entire column in Excel)
06:39 Press Ctrl + Spacebar + Plus (To add a column in MS Excel)
06:52 Press Ctrl + Spacebar + Minus (To delete the column in Excel)
07:04 Press Shift + Spacebar (To select the entire row in Excel)
07:42 Press Ctrl + Shift + Plus (To add row in Excel)
07:48 Press Ctrl + Y (To redo the process)
08:35 Press Ctrl + (To show all formulas in MS Excel)
10:43 Press Ctrl + ; (To add today's date in Excel)
11:13 Press Ctrl + Shift + 3 (To apply date format 'dd-mmm-yy' in Excel)
12:09 Press Ctrl + Shift + ; (To add current time in Excel)
12:38 Press Ctrl + ; + Spacebar + Ctrl + Shift + ; (To add Date and Time in one cell in Excel)
13:27 Press Ctrl ++ 1 (To open Format Cell in Excel)
15:33 Press Alt + A + T (To activate and deactivate Filter in Excel)
17:10 How to use Add to access toolbar function in Excel
18:14 How to use more commands function in Excel
To watch more videos visit: www.excelsuperstar.org/
To Buy an Excel Course visit: www.courses.excelsuperstar.org
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar
14 июл 2024