Intermediate Microsoft Excel Tutorial - Level Up! 🚀

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 Interm...
Keep learning with these Excel classes:
How to use Power Query: • How to use Power Query...
How to use Power Pivot: • How to use Power Pivot...
How to use the XLOOKUP Function: • How to use the XLOOKUP...
Drop-down lists with XLOOKUP: • How to use XLOOKUP to ...
Drop-down with the INDIRECT function: • Quickly Create Multipl...
Excel beginners video tutorials: • Excel for Beginners: E...
Function Lessons in Excel: • Formulas and Function ...

[@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.

[@TeachersTech]

You're very welcome!

[@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!!

[@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!

[@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.

[@BN-yt4et]

Thank you for excellent teaching. What was initially quite daunting is now less so. Great job!!!

[@samneupane4244]

Thank you. I learned ( still learning) Excel from your videos. Very thorough, to the point, excellent tutorial. 🙏

[@asana.mardanloo3024]

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

[@designsbye3819]

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.

[@fromjaxflorida]

Amazing. I will be watching this over and over again until it's imprinted in my brain. Thank you so much.

[@MeGolf92]

Enjoy all your lessons. Ive learned so much! I turned on KZbin and I see this tutorial and I could not wait to view. Thank you again!!!

[@TeachersTech]

So happy to hear you enjoy them. You’re welcome!

[@lakiabarr14]

I was able to understand things so much better because of how you explain it. Thank you so much!

[@m.zohaibbaig7612]

Thankyou soo much Jamie! You clearly explain everything in details , God Bless you!

[@nikanraghami6223]

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.

[@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.

[@CHIMKEL_]

Your videos have been insightful and helpful. Thank you so much for making them, Jamie

[@TeachersTech]

You’re very welcome!

[@MelanatedBeauty68]

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!!!!!

[@DMSLYRB]

You have some amazing videos! Thank you for teaching me about the Unique & Filter formulas.

[@hfawazfarooq4262]

Thank you!!! looking forward to the next video of intermediate level.

[@ESCHON3478]

Thank you!!! looking forward to the next one!

[@laurythul7230]

Just started watching it...I'm so addicted. Thank you so much

[@valentinmatei7882]

Thank you, your vids helps alot!

[@ReggaeQueeny]

Just subscribed to your channel recently. Great useful tips. I have learned so much already. Excellent teacher ! Thank you soooo much !

[@TeachersTech]

Thanks 🙏 . I so glad to hear the videos are helpful.

[@lakshmijanakiram5415]

Thank you Jamie, really helpful. God Bless

[@user-ki2pp6oy4k]

Thanks alot Jamie, I have assisted with your tutorials

[@rickieagie2562]

I started following ur lessons wen I had zero knowledge on excel but am improving at a higher level. Thank you so much for being a great teacher

[@TeachersTech]

Great job!

[@lapolitica6590]

Thank you so much, teacher!

[@TeachersTech]

You are welcome!

[@YetundeTaiwo-ju3zb]

Thank you so much. I'm glad I came across your channel

[@duncanlam158]

Very Much appreciated. I have Finance a pivot table excels test coming. Hopefully, see more examples. Thank You so much

[@TeachersTech]

Glad I could help!

[@rhodaashby6004]

An amazing resource Thank you!!!

[@user-ke6vi7pz2r]

love your effort. thanks a million

[@minabizz8355]

Thank you! This was very helpful!!!!

[@Wo.0ziE]

Thanks buddy I use PivotTable every day during my work nice to know some more stuff about it.

[@TeachersTech]

You’re are very welcome!

[@DailyLessons365]

Thank you mate ...I've just downloaded the video will watch it soon 😊😊... Can you please make more videos please??

[@rocker99000]

Awesome lesson! I figured out the last step with Vlookup before you said what to do!

[@s.baskaravishnu22]

Many thanks

[@zaynz5442]

Very helpful

[@danielraines4808]

Thank you!

[@geoffreymainye9712]

I have enjoyed listening your lecture and i was able to do it on my own and in the near future i wish to can get more from your experience apart from admiring your style of teaching .

[@TeachersTech]

That's great to hear!

[@hamzamohammed3684]

Simplified to my level

[@rasalih9200]

Thank you so much teahers tech keep up doing like this you help me alot

[@TeachersTech]

You're very welcome!

[@adewaleaina8450]

Thank you so much for your videos. Is there a way to do the multiple drop down list without the unique and filter functions as I don't have them on my excel?

[@Marceloexcelyword]

thanke you so much teacher....good life for you

[@violetjaskula992]

Very helpful. Thank you

[@TeachersTech]

You’re welcome!

[@qinli4720]

it's very helpful.

[@haribhaktagope8944]

informative, thanks jammie

[@stevenkatopwa3403]

Hi thank you for the tutorials really helpful. I am want to create an inspection matrix in excel for an instrumentation department for a process plan and track compliance, execution and percentage of completion. Hoe can I go about that? Any guidance will be very helpful.

[@mullemeck5923]

Hi! I am looking to create a document for my workers where they input simple data in, say Sheet1 - and that data then moves into sheet2 in a nice structured way. Specifically they input articlenr, time spent, and a datestamp (22xxyy) What video would you recommend me to watch? Thanks

[@manjitkaur-rf7vx]

Thank You

[@hassan-ci1se]

Great tips. However, walter white is the Owner not the sales manager.😁

[@Anikvikram]

Nice and informative.

[@benysmart1643]

Thank you

[@anthonycampazestupinan4922]

thanks for the knowledge Teacher

[@TeachersTech]

You’re welcome!

[@chiga2004]

Hi Jamie, I am using an older version of Microsoft hence do not have a unique function. Can you please suggest and explain any alternate function of this? Thank you

[@md.manjumulhaque3827]

Thank you very much sir for the tutorials. I am a student and your lesson is very helpful for me. Love from Banglasesh.

[@TeachersTech]

You’re welcome. I’m happy to hear the lessons are helpful.

[@mercurious6699]

great tutorial, thank you

[@TeachersTech]

You’re welcome!

[@lucyakabueze6543]

Thanks for this

[@TeachersTech]

My pleasure!

[@ihebharzali6410]

i would love to get a package of excel for business or for working as manager , thanks for ur videos!

[@jamesr4717]

I have to take an assessment for job placement and all of these have been extremely helpful. Thank you Jamie!

[@sajerrels]

How did you do on your assessment?

[@jamesr4717]

@sajerrels I did ok! It also depends on the test. I used my phone for it 😂 but it was timed and you had to answer fast and were only allowed one mistake. So considering that, I did ok but not great. The test was hard even for an advanced person. But I at least proved under a time limit I can have the answers I need if I'm on an actual job. But I took a separate one on Indeeds job website and did just fine on my own with these basics. That one was much easier

[@sajerrels]

@@jamesr4717 that's great! I haven't had to use pivot tables in the past 10 years and I'm looking for a new job. I need to brush up on my skills and find practice tests. I am nervous to say the least.

[@sajerrels]

And 1 mistake only? Insane. 😯😑

[@jamesr4717]

@sajerrels oh no multiple mistakes lol. But I did ok!

[@chmun77]

Hi. Sadly the function UNIQUE() is not available in the older version of Excel i.e. 2016 and the hash-tag is also not allowed in older Excel versions. Regardless, I'm learning new things from the video and that's very helpful! Thank you!

[@mirasard]

Yes, thank you ❤ I was wondering why it didn't work for me .

[@halahani7688]

Great great job 👏🏼

[@TeachersTech]

Thank you!! 😊

[@garystevenson5331]

Your video is good thanks

[@milkalove9591]

youre the best

[@owolabi.emmanuel]

All your Tutorial videos has been helpful. My excel don't have =UNIQUE function😢

[@HealthClinics]

Great information

[@TeachersTech]

Glad it was helpful!

[@smokeyvision9240]

Hi there what feature would people say is the best to fill cells from a table? I have repairs and would like to fill out forms with costs and codes, etc from a table I have without having to retype it all everytime

[@markmcfadden9338]

Found it....these are awesome.

[@TeachersTech]

Glad you like them!

[@emmanuelmisiati6163]

Finding it helpful☺️

[@TeachersTech]

Glad it was helpful!

[@anggrainingtias178]

hi it is always nice to watch your tutorial. But I kinda face some problem because my excel didn't support the unique formula :( Do you have other ways to do multiple dependant drop-drowns without unique formula?

[@saihananaidoo1014]

Hi please forward a link so that I can practice pivot tables with the data you have. Thank you.

[@jehushaphat]

Is there a lesson 2 for this?

[@chandlergarrison7271]

I'm confused as to how you got/came up with the formula for vlookup? can you explain where the 4 and false come from

[@cheufdphil2487]

Nice job! Thank you!

[@akashgowdag3275]

How to use this unique job title of drop-down function in excel 2007??

[@Gimleh]

How do I use Vlookup to find information in a different tab?

[@zaraissaka]

Thank you so much for all these videos! just to let you know, the links are not working anymore :)

[@jacksonfreddieabwang6521]

Weldone

[@scguy681]

at what point can you move from the beginner to intermediate? if yu wanted to go in order

[@keneliokamyata9373]

Big up yourself

[@hajiseerat000]

Create a video of all excel tabs and how to use all of them

[@PankajSharma-ey9ni]

What if there are multiple matches?

[@c3p039]

does anyone know why pivot table options are greyed out @ 11.15? TIA

[@hacerizci1782]

How can ı use your data to practice?

[@garystevenson5331]

Just starting computer can help me get better please

[@ishroldan9385]

Hope someone can help. Question on the data validation tips: Why is '#' not working on my data validation list? Error says, "The source currently evaluates to an error".

[@jayniedesigns3609]

Thanks sir Ur videos have been helpful to me but I don't understand this particular video cos it is not clear.. I mean I can't see Ur computer

[@robertsammie7810]

I can't see the links, where are they

[@donaldwynn8694]

No Stanley?..haha

[@asmaa22sattar90]

I didn't get unique function on my 2010 excel version .

[@user-yf1tc7xv6g]

hi sir what is mca in computer

[@joystonlobo18]

Version

[@JoanMuoti-ot9ce]

The video has no sound

[@DailyChuckles724]

I’m just not sure if I can trust this tutorial if Pam is outselling Dwight…

[@TeachersTech]

Lol!

[@suzannedaquila8082]

UNIQUE fx only with 360...doesn't appear to be a good work around