7 Tips and Tricks in Excel - Level 300 (Expert Level)
Tips and Tricks are always the most requested session of any Excel conference I've ever spoken at. And it makes sense since it's supposed to be the biggest gain in the shortest time. So that was the reasoning behind this series. It was initially only going to be "My favorite 7 Tips and Tricks in Excel," but I realized there were a lot more than seven that I wanted to talk about. So it became a series with my top seven tips and tricks in Excel at every level of "mastery" in Excel. This video is my top seven Tips and Tricks in Excel - Level 300. So that would be Expert level.
This tutorial was made using Excel 365, but all methods work with Excel 2016 and above.
File if you want to follow along:https://bit.ly/3GdWXgd
Links to other videos and blog posts that are relevant:
Dependent Data Validation List - https://bit.ly/3InpEJl
Power Pivot vs. Regular Pivot (from trick #6): https://bit.ly/31ASK7q
7 Tips & Tricks - Level 100: • 7 Tips and Tricks in Excel - Level 100
7 Tips & Tricks - Level 200: • 7 Tips and Tricks in Excel - Level 200 (In...
7 Tips & Tricks - Level 300: This Video
Chapters:
0:00 Excel Olympics Animation
0:08 Introduction to the 7 Tips and Tricks - Expert Level
1:15 Tip 1 - Inquire AddIn
7:08 Tip 2 - Forecast Sheet
10:33 Tip 3 - Dependent DropDown Lists
15:38 Tip 4 - The Excel LET Function
18:50 Tip 5 - Very Hidden Sheet
20:36 Tip 6 - Pivot Table as Formulas
24:50 Tip 6 - Advanced Filter in Excel
29:44 Conclusion
30:15 Outro
Gear Used:
US Links
Camera: Canon EOS R6 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - https://amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP
Laptop: Dell XPS 15 - https://amzn.to/3effMmT
Lights: Elgato Key Light - https://amzn.to/3vcs6v9
Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y
Recorded With: Camtasia - https://www.techsmith.com/video-edito...
Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub
Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK
Disclaimer: Some links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support!
#Excel #ExcelOlympics #gasperkamensek