Thread by @exceltoexcel

5 must-know Excel skills
#excel #learnexcel #exceltricks #exceltips

1. Learn keyboard + mouse shortcuts:
- Ctrl + E [Flash Fill]:
youtube.com/shorts/uzPo_CP…
- Ctrl + = [Auto Sum]:
youtube.com/shorts/feldd-P…
- Rearrange columns quickly:
youtube.com/shorts/bvUhr1A…
- ALT + O + A [Quick format]:
youtube.com/shorts/HHFTv2f…

2. Make drop-down lists in Excel:
- Make lists manually:
youtube.com/shorts/tXOovKn…
- Make lists from data:
youtube.com/shorts/pM2I9qR…
- Dependent drop-down lists:
youtube.com/shorts/TkrGq7S…

3. Use Go-to Special tool to:
- Hide error rows: youtube.com/shorts/JTbZ8sR…
- Delete blank rows:
youtube.com/shorts/ayqJKsr…
- Insert subtotals:
youtube.com/shorts/B-mGYDF…

4. Use conditional formatting to:
- Compare lists for duplicates:
youtube.com/shorts/d19ut7e…
- Highlight based on cell value:
youtube.com/shorts/UmJAq8z…
- Insert data bars: youtube.com/shorts/hquscnb…

5: Use Custom number formatting to:
- Hide cell values/data range:
youtube.com/shorts/7dJ1l0z…
- Add leading zeroes:
youtube.com/shorts/FPAQaDT…
- Format numbers as phone nos:
youtube.com/shorts/ZZ1v9ar…
- Make Custom data labels in charts:
youtube.com/shorts/3bMwXYU…

Subscribe: bit.ly/3z2rzRw for daily #Excel tips

Don't forget to follow
@exceltoexcel