Learn Excel in few minutes | How to do summation and filter the fastest way in Excel

Hello friends, another day of learning in MS EXCEL. If you have missed my previous video about Fastest Navigation process in MS Excel, please follow the link below:

https://rumble.com/vhmu9h-learn-excel-basics-in-10-min-how-to-move-or-navigate-in-excel-the-fastest-w.html

In this video I will be demonstrating about how will you do summation for rows/columns in the fastest way, how will you place filter fastest than the normal method and also how will you combine the two functions for a better optimization and lesser time consuming way.

-------------------------------------------------------------------------------------------------------------------------

The Shortcuts used in the demonstration are
Summation of a Row/Column = ALT + "="
Dragging of a Formula or Data Vertically Downwards = CTRL + D
To Copy = CTRL + C
To Paste = CTRL + V
Placing Filter on a Column = ALT + D + F +F
To Undo your last Move = CTRL + Z
To Remove filter = ALT + D + F +F

-------------------------------------------------------------------------------------------------------------------------

The Shortcuts used in the previous video are:
To add a new column - CTRL +Space, CTRL + "+"
To Delete a column - CTRL + Space, CTRL + "-"
Navigate Right - CTRL + Right Arrow
Navigate Left - CTRL + Left Arrow
Navigate Upward - CTRL + Up Arrow
Navigate Downward - CTRL + Down Arrow
Selection of Cells Right - SHIFT + CTRL + Right Arrow
Selection of Cells Left - SHIFT + CTRL + Left Arrow
Selection of Cells Upward - SHIFT + CTRL + Up Arrow
Selection of Cells Downward - SHIFT + CTRL + Down Arrow
Navigate forward between worksheets CTRL + Page Down
Navigate Backward between worksheets CTRL + Page up
Navigate between two or more open excel files CTRL + Tab
Navigate between two or more open different application files Alt + Tab or Windows + Tab

-------------------------------------------------------------------------------------------------------------------------

Please hit the SUBSCRIBE to follow my Channel as well as its Videos. Please Share the video as much as you can to help others because "Sharing is Caring"

Please feel free to write to me @ coresmart195@gmail.com