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

Screeners helps trader in saving lot of time in filtering best stocks out of 5000+ listed stocks.

Here is the list of top 7 Free Strategy and its respective screeners that I use:

Also, last screener is my favorite to pick early momentum stocks.

1/ Golden Crossover:

Golden Crossover of 20 EMA above 200 EMA is a good strategy used by the trader. This screener will help you in identifying stocks that has given golden

2/ CCI Momentum:

CCI is a good indicator to find out stocks that are bullish and are in momentum. I had already shared a thread on the same.

This screener will help in identifying stocks for which CCI has crossed above

3/ Bullish Engulfing:

Bullish Divergence is a setup used by contrarian traders.
This screener will help in identifying stocks in which bullish divergence is

4/ Bearish Engulfing:

Bearish Divergence is a setup used by traders to take contra trades.
This screener will help in identifying stocks in which bearish divergence is