Intermediate Microsoft Excel Tutorial - Level Up! 🚀

[@CJ-03g]

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!

[@MelanieBechtel]

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!

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

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

[@ifeanyiemmanuel3500]

Thanks teacher's tech. Love your teachings

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

[@BN-yt4et]

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

[@laurythul7230]

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

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

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

[@DMSLYRB]

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

[@samneupane4244]

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

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

[@m.zohaibbaig7612]

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

[@campingadventures8760]

Hi,i'm really enjoying your videos and learning a lot.watching from Puerto Rico.thank you so much

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

[@lakiabarr14]

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

[@fromjaxflorida]

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

[@hfawazfarooq4262]

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

[@lapolitica6590]

Thank you so much, teacher!

[@TeachersTech]

You are welcome!

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

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

[@PatrickPondia]

Thanks alot Jamie, I have assisted with your tutorials

[@rocker99000]

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

[@YetundeTaiwo-ju3zb]

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

[@CHIMKEL_]

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

[@TeachersTech]

You’re very welcome!

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

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

[@valentinmatei7882]

Thank you, your vids helps alot!

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

[@lakshmijanakiram5415]

Thank you Jamie, really helpful. God Bless

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

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

[@DailyLessons365]

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

[@wardahiftekharumair]

Please make a full video on industrial level project in which all these functions of microsoft excel utilize ... so that would be helpfull in building a good portfolio

[@rhodaashby6004]

An amazing resource Thank you!!!

[@francisjunior-p6j]

love your effort. thanks a million

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

[@ESCHON3478]

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

[@rasalih9200]

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

[@TeachersTech]

You're very welcome!

[@minabizz8355]

Thank you! This was very helpful!!!!

[@Marcelo-officepro]

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

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

[@haribhaktagope8944]

informative, thanks jammie

[@InduPal-w6o]

Hi Jamie, I am getting count instead of sum in pivot table I even changed it from count to sum using value field setting but then also I am getting 0 value .

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

[@violetjaskula992]

Very helpful. Thank you

[@TeachersTech]

You’re welcome!

[@anthonycampazestupinan4922]

thanks for the knowledge Teacher

[@TeachersTech]

You’re welcome!

[@wardahiftekharumair]

Thank you so much.

[@zaynz5442]

Very helpful

[@markmcfadden9338]

Found it....these are awesome.

[@TeachersTech]

Glad you like them!

[@Anikvikram]

Nice and informative.

[@garystevenson5331]

Your video is good thanks

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

[@qinli4720]

it's very helpful.

[@mercurious6699]

great tutorial, thank you

[@TeachersTech]

You’re welcome!

[@hamzamohammed3684]

Simplified to my level

[@s.baskaravishnu22]

Many thanks

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

[@HealthClinics]

Great information

[@TeachersTech]

Glad it was helpful!

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

[@emmanuelmisiati6163]

Finding it helpful☺️

[@TeachersTech]

Glad it was helpful!

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

[@zaraissaka]

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

[@lucyakabueze6543]

Thanks for this

[@TeachersTech]

My pleasure!

[@c3p039]

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

[@ihebharzali6410]

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

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

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

[@owolabi.emmanuel]

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

[@hassan-ci1se]

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

[@akashgowdag3275]

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

[@scguy681]

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

[@PankajSharma-ey9ni]

What if there are multiple matches?

[@robertsammie7810]

I can't see the links, where are they

[@Gimleh]

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

[@danielraines4808]

Thank you!

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

[@jehushaphat]

Is there a lesson 2 for this?

[@jacksonfreddieabwang6521]

Weldone

[@benysmart1643]

Thank you

[@garystevenson5331]

Just starting computer can help me get better please

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

[@hacerizci1782]

How can ı use your data to practice?

[@milkalove9591]

youre the best

[@hajiseerat000]

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

[@asmaa22sattar90]

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

[@cheufdphil2487]

Nice job! Thank you!

[@romeonuez]

hi sir what is mca in computer

[@keneliokamyata9373]

Big up yourself

[@matthewmok7115]

Walter White as sales manager is a bit suspicious.

[@JoanMuoti-ot9ce]

The video has no sound

[@donaldwynn8694]

No Stanley?..haha

[@DailyChuckles724]

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

[@TeachersTech]

Lol!

[@joystonlobo18]

Version

[@suzannedaquila8082]

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

[@manjitkaur-rf7vx]

Thank You