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.

I've used Microsoft Excel for 20 years, and these 20 tips & functions will make you an expert and increase your productivity 100X📊

Don't ever use Excel again without knowing these 20 tips & functions:

Here are 20 MUST KNOW Microsoft Excel tips & functions (with pictures & examples of each below):

(1) Wildcards
(2) Duplicate
(3) Remove Duplicates
(4)Transpose
(5) Filter
(6) Conditional Formatting
(7) Sparklines
(8) Pivot Tables
(9) Auto-fill
(10) TRIM

11-20:

(11) XLOOKUP
(12) IF
(13) SUMIF
(14) SUMIFS
(15) COUNTIF
(16) COUNTIFS
(17) UPPER, LOWER, PROPER
(18) CONVERT
(19) Stock Market data
(20) Geography / Maps

Let's discuss each in detail (with pictures & examples):

(1) Wildcards

A wildcard is a special character that allow you to perform partial matches on text in your Excel formulas.

Excel has three wildcards: an asterisk "*", question mark "?", and "~"

(2) Duplicate

Duplicate the data from the cell above.

Ctrl + D fills and overwrites a cell with the contents of the cell above it

6 websites that offer FREE Microsoft Excel training, that will help you become an expert:

- https://t.co/odmoHMXleu
- https://t.co/YjXkPPbdy2
- https://t.co/JtRzjEqpb0
- https://t.co/MqUk56qOHd
- https://t.co/tE03ekN8qp
-