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 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!
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.
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!!
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!!!!!
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.
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.
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
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?
@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
@@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.
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 .
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?
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 .
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
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
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
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".
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!
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.
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.
You're very welcome!
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!
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
Great job!
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
Just started watching it...I'm so addicted. Thank you so much
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.
Enjoy all your lessons. Ive learned so much! I turned on UA-cam and I see this tutorial and I could not wait to view. Thank you again!!!
So happy to hear you enjoy them. You’re welcome!
Thank you for excellent teaching. What was initially quite daunting is now less so. Great job!!!
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!!
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!!!!!
Thank you. I learned ( still learning) Excel from your videos. Very thorough, to the point, excellent tutorial. 🙏
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.
Thank you so much, teacher!
You are welcome!
I was able to understand things so much better because of how you explain it. Thank you so much!
Thankyou soo much Jamie!
You clearly explain everything in details , God Bless you!
Amazing. I will be watching this over and over again until it's imprinted in my brain. Thank you so much.
Hi,i'm really enjoying your videos and learning a lot.watching from Puerto Rico.thank you so much
You have some amazing videos! Thank you for teaching me about the Unique & Filter formulas.
Very Much appreciated. I have Finance a pivot table excels test coming. Hopefully, see more examples. Thank You so much
Glad I could help!
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.
Thank you!!! looking forward to the next video of intermediate level.
Thank you very much sir for the tutorials. I am a student and your lesson is very helpful for me. Love from Banglasesh.
You’re welcome. I’m happy to hear the lessons are helpful.
Thanks alot Jamie, I have assisted with your tutorials
Thank you mate ...I've just downloaded the video will watch it soon 😊😊...
Can you please make more videos please??
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
Awesome lesson! I figured out the last step with Vlookup before you said what to do!
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?
thanke you so much teacher....good life for you
Thank you, your vids helps alot!
I have to take an assessment for job placement and all of these have been extremely helpful. Thank you Jamie!
How did you do on your assessment?
@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
@@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.
And 1 mistake only? Insane. 😯😑
@sajerrels oh no multiple mistakes lol. But I did ok!
Thank you!!! looking forward to the next one!
Your videos have been insightful and helpful. Thank you so much for making them, Jamie
You’re very welcome!
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 .
That's great to hear!
Thanks buddy I use PivotTable every day during my work nice to know some more stuff about it.
You’re are very welcome!
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 so much. I'm glad I came across your channel
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?
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 .
An amazing resource Thank you!!!
love your effort. thanks a million
Thank you Jamie, really helpful. God Bless
Found it....these are awesome.
Glad you like them!
Great tips. However, walter white is the Owner not the sales manager.😁
Thank you so much.
Just subscribed to your channel recently. Great useful tips. I have learned so much already. Excellent teacher ! Thank you soooo much !
Thanks 🙏 . I so glad to hear the videos are helpful.
Simplified to my level
Very helpful
Thank you! This was very helpful!!!!
Many thanks
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
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
Thank you so much teahers tech keep up doing like this you help me alot
You're very welcome!
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
Your video is good thanks
Very helpful. Thank you
You’re welcome!
thanks for the knowledge Teacher
You’re welcome!
informative, thanks jammie
All your Tutorial videos has been helpful.
My excel don't have =UNIQUE function😢
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
Thank you so much for all these videos! just to let you know, the links are not working anymore :)
Nice and informative.
great tutorial, thank you
You’re welcome!
at what point can you move from the beginner to intermediate? if yu wanted to go in order
it's very helpful.
Thank you
I can't see the links, where are they
What if there are multiple matches?
does anyone know why pivot table options are greyed out @ 11.15? TIA
Thank you!
Great information
Glad it was helpful!
Weldone
Thanks for this
My pleasure!
How do I use Vlookup to find information in a different tab?
Just starting computer can help me get better please
Finding it helpful☺️
Glad it was helpful!
How to use this unique job title of drop-down function in excel 2007??
Is there a lesson 2 for this?
i would love to get a package of excel for business or for working as manager , thanks for ur videos!
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".
How can ı use your data to practice?
Nice job! Thank you!
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
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!
Yes, thank you ❤ I was wondering why it didn't work for me .
Create a video of all excel tabs and how to use all of them
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.
Walter White as sales manager is a bit suspicious.
youre the best
hi sir what is mca in computer
I didn't get unique function on my 2010 excel version .
Big up yourself
No Stanley?..haha
I’m just not sure if I can trust this tutorial if Pam is outselling Dwight…
Lol!
The video has no sound
UNIQUE fx only with 360...doesn't appear to be a good work around
Version
Thank You