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

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Learn Excel to excel

Learn Excel to excel Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @exceltoexcel

Nov 19
8 must-know Excel Chart designs and tricks
#excel #excelcharts
Add Target Line in Excel Charts
youtube.com/shorts/6G2PbXB…
Make Actual vs Target Charts in Excel
youtube.com/shorts/TjZW_8J…
Read 10 tweets
Nov 12
9 must-know Excel SUM Functions Tricks
#excel
1. Excel DSUM Function
youtube.com/shorts/x5yIV8Q…
2. VLOOKUP + SUM Functions
youtube.com/shorts/I12zVxg…
Read 11 tweets
Nov 5
7 must know Advanced Excel VLOOKUP Tricks
#excel #vlookup
2. Case-sensitive VLOOKUP
youtube.com/shorts/TnxN0sj…
Read 9 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

:(