Intermediate Microsoft Excel Tutorial - Level Up! 🚀

109,317
0
Published 2022-10-10
Welcome to our Intermediate Excel Mastery Series! In this comprehensive tutorial, we delve deep into pivotal Excel features and share insider tips to revolutionize your spreadsheet capabilities.

🚀 What's Inside:

✅ Master Pivot Tables & Pivot Charts: From basic setup to advanced layouts, learn everything you need to create dynamic reports.
✅ Uncover secrets of VLOOKUP: Step beyond basics with advanced applications and hidden tricks.
✅ Create Multiple Dependent Drop-Down Lists: A game-changer for data organization.
✅ Discover the power of UNIQUE Function: Effortlessly extract unique values from datasets.
✅ Implement Data Validation: Control user input with precision.
✅ Master a Nested FILTER Function: Combine with UNIQUE for ultra-precise data filtering.

🌟Perfect for All Levels: Whether you're a student, professional, or a passionate Excel enthusiast, this video series caters to all. Follow our step-by-step approach and apply these techniques to elevate your data analysis and presentation skills.

🔍 Detailed Timestamps for Easy Navigation:

0:00 Introduction to Advanced Excel
1:12 PivotTable Creation from Range/Table
2:16 Crafting Recommended PivotTables
3:01 Detailed PivotTable from Range/Table
3:55 PivotTable Fields: Adding & Reporting
4:50 Customizing PivotTable Field Layouts
7:20 Sorting PivotTable Columns/Rows
8:58 Integrating Filter Fields in PivotTables
9:59 Employee-Specific Report Generation
11:51 PivotTable Advanced Tips & Tricks
15:43 Integrating a PivotChart
19:02 VLOOKUP Function: Advanced Uses
27:42 Crafting Multiple Dependent Drop-Down Lists
29:42 UNIQUE Function: Data Extraction Simplified
30:40 Excel Data Validation: Techniques and Tips
32:03 Nested FILTER & UNIQUE Functions: Advanced Data Manipulation
35:58 VLOOKUP: Final Result Optimization

📈 Take Your Excel Skills to New Heights: Watch, learn, and transform the way you handle data in Excel. Don't forget to like, share, and subscribe for more expert Excel tutorials!

Practice Sheet PivotTables: bit.ly/PivotTable_data
Practice Sheet VLOOKUP: bit.ly/VLOOOKUP_data
Practice Sheet Multiple Dependant Drop-downs: bit.ly/Drop-Down_list

Check out this Intermediate Excel class:    • Microsoft Excel Intermediate Class: E...  

Keep learning with these Excel classes:
How to use Power Query:    • How to use Power Query -  Microsoft E...  
How to use Power Pivot:    • How to use Power Pivot - Microsoft Ex...  

How to use the XLOOKUP Function:    • How to use the XLOOKUP Function in Mi...  
Drop-down lists with XLOOKUP:    • How to use XLOOKUP to Create Dependen...  
Drop-down with the INDIRECT function:    • Quickly Create Multiple Dependent Dro...  
Excel beginners video tutorials:    • Excel for Beginners: Easy Steps to Ge...  

Function Lessons in Excel:    • Formulas and Function in Microsoft Excel  

All Comments (21)
  • Hi,i'm really enjoying your videos and learning a lot.watching from Puerto Rico.thank you so much
  • @resshmi78
    Jamie, thank you so much for your videos, they have been immensely helpful and you explain the functions/features so well. The videos are so easily understandable - you are truly gifted!!
  • @feefaw1060
    Thank you so much for this! I have an excel demo test tomorrow and this helps me understand so much better than my lecturer's recorded lessons. For a beginner, it makes me feels easy to use all these formulas.
  • @user-jh6ek1vd6n
    Thank you very much for taking your time with this tutorial. It was a great refresher for me since it as been a couple of years since I have used these functions. Your explanations were clear and concise and will be following you to get more tutorials!
  • @user-vk7lv2ss8e
    Thank you so very much for your Excel training. It has helped me so much in understanding excel and improving my competency in it. Your teaching skills are wonderful and you explain very well.
  • Thank you so much Jamie for all the Excel videos. They are all great and I have learned Exel with you. The best online teacher I have ever seen
  • @BN-yt4et
    Thank you for excellent teaching. What was initially quite daunting is now less so. Great job!!!
  • @derekemrie2987
    I made it through all the beginner tutorials, very well done, I am not a "Newbie" but still it is advisable to brush up on things that one has not used regularly for some time (upcoming job offer requires Excel and MS Word knowledge). I will also go through the intermediate tutorials as well, AND IT'S GREAT that each little section is date/time stamped so one can simply skip anything not wanted (or go back to it if a later session proves that some preveious knowledge may not be quite up to par/remembered). Thank you very much. I am also a PT educator, students love seeing that all that math they learn can be done via software, but they have to have the mathematics basics to understand what they want to do.
  • Wow this is so helpful. I just transitioned into a new position and you explained this so well. I’ll definitely be checking out your videos daily now.
  • Thank you. I learned ( still learning) Excel from your videos. Very thorough, to the point, excellent tutorial. 🙏
  • Amazing. I will be watching this over and over again until it's imprinted in my brain. Thank you so much.
  • @lakiabarr14
    I was able to understand things so much better because of how you explain it. Thank you so much!
  • You are an absolutely amazing trainer! Thank you very much for sharing your knowledge and taking the time to prepare the practice sheets so we can follow along. I am so glad I found your page. Thank You!!!!!
  • Actually learned a few useful tips here, thanks a lot. I'm also very eager to learn how to make a dropdown list with search suggestions as I type for my work.
  • Thankyou soo much Jamie! You clearly explain everything in details , God Bless you!
  • @MeGolf92
    Enjoy all your lessons. Ive learned so much! I turned on YouTube and I see this tutorial and I could not wait to view. Thank you again!!!
  • @laurythul7230
    Just started watching it...I'm so addicted. Thank you so much
  • @DMSLYRB
    You have some amazing videos! Thank you for teaching me about the Unique & Filter formulas.
  • @CHIMKEL_
    Your videos have been insightful and helpful. Thank you so much for making them, Jamie