I've used Microsoft Excel for 20 years and these 10 shortcuts will make you an Excel Guru in 5 minutes & maximize your productivity 100x:
🧵 Don't use Excel without knowing these 10 shortcuts:
(1) Repeat the Last Action: Ctrl + Y
You have just applied a formatting style to a cell, use Ctrl + Y to quickly apply the same formatting to another cell.
(2) Display Formulas in cells: Ctrl + ~
If you have a cell that contains a formula, you can use Ctrl + ~ to switch between the formula view and the value view of the cell. This allows you to see the underlying formula used to calculate the cell value.
(3) AutoSum: Alt + =
The AutoSum shortcut is useful for quickly calculating the sum of a range of cells without having to manually type in the formula
(4) Insert current date: Ctrl + ; (date)
When tracking the progress of a project, add the date each time a task is completed. Use Ctrl + ; to quickly insert the current date.