I wish all TH-cam tutorials were this easy to follow along. Thank you a million times. This has helped me so much. Thanks Mo Jones for your way of explaining thoroughly.
This video is amazing!! I have a request, please also create a 'Data Analysis Full Course for Google Sheets' as well, or provide a detailed short video of 'Data Analysis using Google Sheets'. Thanks!
Watched the whole tutorial in one go along with practice, I must say this is gold mine for data analyst to cover each and every part of the excel along with advance excel skills. Thank you Mo.jones and Learnit for this tutorial.
Amazing the beginning. Please if I want to make a suggestion about the duration of the video. Sir if possible you can make the videos Short, about 20-min and make a series it will be so helpful to catch all the content. Thank you!
Thankyou so much for this video❤. This is what true content means. It was easy to follow and the reasoning for using functions was even easier to grasp.
Being a TH-camr myself , I know it must have taken a lot of efforts to combine multiple videos into one video or even if you shoot a 7 hour long video, it still takes lot of efforts and of course appreciate that .. Most interesting part for me in this video is Power Pivot because I am getting started with Power Pivot and I am well versed with rest of the features . Good video,thank you for uploading video
I recently watched this Excel data analysis video and I was thoroughly impressed! The instructor did an outstanding job breaking down complex concepts into easy-to-understand steps. Whether you're a beginner or looking to polish your skills, this video covers it with clarity and precision. The pacing was perfect, and the examples used were practical and relevant. I especially appreciated the tips and shortcuts to save time in everyday tasks. The visual aids and on-screen prompts made it easy to follow along and practice simultaneously. This video has significantly boosted my confidence in using Excel, and I can now handle data more efficiently. Highly recommend it to anyone looking to enhance their Excel skills! Good job Learnit!
Thank you for teaching and sharing knowledges. You help so many people with no money to apply for a course. Thank you so much. Please keep sharing free education.
What an excellent course! Thanks so much for creating it! Great lecturer. Material is well structured and easily explained. I ve leant a lot of new information already. Haven't finished the course yet. Cannot wait to use all the information i ve learnt in my data analysis. Must watch this course if you want to start learning Power BI after it. Lots of extremely useful information! Many thanks for your hard work!
I have completed previous Excel Training 4h and it was amazing. Now I am on this one. I appreciate for all. I would love to see SQL lessons as well if possible. It is really important for Data Analysis :)
We also have the same courses available ad-free for members like yourself! SQL Querying Basics Full Course Tutorial (2+ Hours): th-cam.com/video/mmA4ApUMIaA/w-d-xo.html SQL Server Reporting Services: Data Analysis Full Course Tutorial (7+ Hours): th-cam.com/video/SKa3ujlz9uI/w-d-xo.html
@@LearnitTraining 43 minutes in, and I've already learned so much about how I can apply this to my profession. Maybe in the future you can use sports performance data for a data analytics course.
I have always been so scared to use excel because I am not very proficient in data. I have been able to watch this tutorial with ease and understand the concepts, I never thought I'd actually enjoy using functions and tools like XLOOKUP and Pivot Tables. I cannot thank you enough! I feel like I will be able to apply and use XLOOKUP or Pivot Tables and Charts wherever needed at my job, seriously I cannot thank you enough!! I have never had the inclination to complete any tutorial but you just made it so easy that this was the first tutorial I ever completed, with ease. THANKS A TON!
Learnit always helps self taught learner thank you so much for this course i hope one day you guys provide Machine learning complete course so we can learn from the finest youtube channel
thank you very much for the great video and the efforts you put into, all of my time i was deal with the excel work on my daily working day by going through this training i was learning a lot of new things and knowledge, thank you again for your time spent on this video.
God day, I am struggling to calculate the gross income following the method you use. Either I get an error message or 10-digit total instead of what you get.
Is this beginner, intermediate, expert? Im trying to understand if this is a full course or something like i have came across in the past where people call it a full course but in reality they then sell u onto a bigger course on udemy. I want to learn beginner and intermediate and then depending on what subjects are covered in intermediate decide then whether to continue to learn the expert? I dont want to waste studying time by trying to find good resources. Can u pls advise me with links to the videos i shoild be watching using the latest microsoft 365 yearly subscription
Sir Great Video but i am not understand because i am not understands English larger people wait for video in Urdu or Hindi almost same plz convert video .plz for understand problem
HI.. I HAVE TRIED THIS IN excel 2007. In gross pay formula when i click =pay rate some error comes in and Table4 is written after = sign. may i knw whats the error ?
6:12:26 gross pay apply only for one cell, link row range give error and link column range only for one cell. Plz help what change i have to do with my excel.
Exercise Files: learnitanytime.com/p/exercise-files-excel-data-analysis-full-course-tutorial-2024
thanks
Pls this learning exercise can't open in my phone
@@helenonwuchekwa152 Mine as well 😥
thank you
link isn't working
I wish all TH-cam tutorials were this easy to follow along. Thank you a million times. This has helped me so much. Thanks Mo Jones for your way of explaining thoroughly.
You're very welcome!
This video is amazing!! I have a request, please also create a 'Data Analysis Full Course for Google Sheets' as well, or provide a detailed short video of 'Data Analysis using Google Sheets'. Thanks!
We definitely are looking into make a Google Sheets version of this class.
This is the one excel course to rule them all. Clear easy to follow instructions and well organized for easy follow along. Thank you.
You are very welcome!
Watched the whole tutorial in one go along with practice, I must say this is gold mine for data analyst to cover each and every part of the excel along with advance excel skills. Thank you Mo.jones and Learnit for this tutorial.
Great to hear!
Just started your course and I want to let you know that so far I like the way you talk and explain things
Thanks!
Amazing the beginning. Please if I want to make a suggestion about the duration of the video. Sir if possible you can make the videos Short, about 20-min and make a series it will be so helpful to catch all the content. Thank you!
We do have shorter versions of the videos available.
Thankyou so much for this video❤. This is what true content means. It was easy to follow and the reasoning for using functions was even easier to grasp.
You're welcome 😊
Being a TH-camr myself , I know it must have taken a lot of efforts to combine multiple videos into one video or even if you shoot a 7 hour long video, it still takes lot of efforts and of course appreciate that .. Most interesting part for me in this video is Power Pivot because I am getting started with Power Pivot and I am well versed with rest of the features . Good video,thank you for uploading video
Please split them in peace by its criteria, too long
Thank you so much for the kind words! Also good luck on your channel! Subbed!
I recently watched this Excel data analysis video and I was thoroughly impressed! The instructor did an outstanding job breaking down complex concepts into easy-to-understand steps. Whether you're a beginner or looking to polish your skills, this video covers it with clarity and precision.
The pacing was perfect, and the examples used were practical and relevant. I especially appreciated the tips and shortcuts to save time in everyday tasks. The visual aids and on-screen prompts made it easy to follow along and practice simultaneously.
This video has significantly boosted my confidence in using Excel, and I can now handle data more efficiently. Highly recommend it to anyone looking to enhance their Excel skills!
Good job Learnit!
Thank you so much for the kind words! We hope you learned everything you needed to!
I am far from finished but I have to say the way you explain things are clear and very precise! Awesome job, thank you!
Awesome, thank you!
In a word, thank you! I have much gratitude for your making things easier!
You are so welcome!
Thank you for teaching and sharing knowledges. You help so many people with no money to apply for a course. Thank you so much. Please keep sharing free education.
You are very welcome!
This course cover all the topics about data analysis using excel ! Thanks for it🤩
Most welcome 😊
Im starting the course. Hope I will learn a lot from it!!!
Hope you learned everything you needed
6:28:26 The way I've been looking for. Thank You
You are very welcome!
Hands down best learning channel on TH-cam.
Appreciate that!
What an excellent course! Thanks so much for creating it! Great lecturer. Material is well structured and easily explained. I ve leant a lot of new information already. Haven't finished the course yet. Cannot wait to use all the information i ve learnt in my data analysis. Must watch this course if you want to start learning Power BI after it. Lots of extremely useful information! Many thanks for your hard work!
Glad you enjoyed it!
I have completed previous Excel Training 4h and it was amazing. Now I am on this one. I appreciate for all. I would love to see SQL lessons as well if possible. It is really important for Data Analysis :)
Thanks for watching! Check out our SQL Training playlist here: th-cam.com/play/PLoyECfvEFOjYH2C2vl2A8yBPrbkVSbj9l.html
We also have the same courses available ad-free for members like yourself!
SQL Querying Basics Full Course Tutorial (2+ Hours): th-cam.com/video/mmA4ApUMIaA/w-d-xo.html
SQL Server Reporting Services: Data Analysis Full Course Tutorial (7+ Hours): th-cam.com/video/SKa3ujlz9uI/w-d-xo.html
@@LearnitTraining Thank you :)
Glad to have come across this Channel. Its very Helpful and Insightful. As a TH-camr Myself. Who has Plans on Data Analysis. This was a Goldmine.
Thanks!
Thank you for creating this course. Just started and hopefully developing this skill will help to become a more efficient physical education teacher
Best of luck!
@@LearnitTraining 43 minutes in, and I've already learned so much about how I can apply this to my profession. Maybe in the future you can use sports performance data for a data analytics course.
Thank you so much for this comprehensive course. It was all I wanted 😍😍
You are very welcome!
Thanks REALLY GOOD!!
Glad you like it!
Was searching for a course like this for hours, Thank You Learnit Training !
Glad it was helpful!
this is the best video I found for excel on TH-cam. so articulately explained.😄
Glad it was helpful!
This is the Best Excel Video i ever watch for Data Analysis Thank you for this
You are very welcome!
thank you so much!
thank you, thank you, and thank you!
amazing tone and speed of voice.
Glad you liked it!
I have always been so scared to use excel because I am not very proficient in data. I have been able to watch this tutorial with ease and understand the concepts, I never thought I'd actually enjoy using functions and tools like XLOOKUP and Pivot Tables. I cannot thank you enough! I feel like I will be able to apply and use XLOOKUP or Pivot Tables and Charts wherever needed at my job, seriously I cannot thank you enough!! I have never had the inclination to complete any tutorial but you just made it so easy that this was the first tutorial I ever completed, with ease. THANKS A TON!
You are very welcome Nymphadora Tonks! We are glad were able to help you be a better Excel user!
This video is amazing. It helps me a lot to learn many functions and uses of excel. God bless you❤
Glad it was helpful!
Learnit always helps self taught learner thank you so much for this course
i hope one day you guys provide Machine learning complete course so we can learn from the finest youtube channel
We are making videos on AI Tools like ChatGPT and Co-pilot but Machine Learning is really well covered by Freecodebootcamp!
I have really learnt a lot from your training. Thank you
You are welcome!~
I appreciate the effort you invested in creating this video
Glad you enjoyed it!
Thank you for this amazing video. I have learned a lot of new ways of doing.
You are so welcome!
Thank you for this tutorial sir it was very helpful for a Newbie like me .
You are very welcome!
Thank you in advance for this Tutorial.
Welcome 😊
Just Love it👏👏👏👏👏👏👏👏
Thanks!
Good job sir! This is by far the best video so far! Much love from Nigeria.
Thank you for the kind words!
Thank you so much for this 7hours tutorial!
Any time!
Precise and intelligent presentation
Thank you!
Thank you very much for this tutorial, you are amazing!
You are very welcome!
Amazing turtorial... And free... I appreciate it... Thank you! ❤
thank you very much for the great video and the efforts you put into, all of my time i was deal with the excel work on my daily working day by going through this training i was learning a lot of new things and knowledge, thank you again for your time spent on this video.
Thank you for posting!
Our pleasure!
Bestest video on excel thank you so muchbbh ❤
You're welcome 😊
Your are the best.. Thank you
You are welcome!
Thanks!
Thank you so much Sami Ali Elghrably! Your support helps us continue to make new videos each week!
Thank you so much for this, it really helped me a lot and may we also have the one for Power BI
That is coming soon!
Thanks a lot for your lessons
It's our pleasure!
Hope I will learn a lot from watching the tutorial!!
We do too!
Thank you for this tutorial. It is exactly what I was looking for.
You are welcome!
Big thanx sir
Most welcome
Thank you
You're welcome
This no non sense Excel Data Analysis Course, Loved the straight to point and clear explanation.
Thanks!
Thanks so much
You're welcome!
Thank you 🙏
You’re welcome 😊
Well Done!
Thanks!
Excellent
Thank you! Cheers!
thank you very much!
You're welcome!
This is excellent
Thanks!
Thank you.
Very efficient
Thanks!
well explained ❤ sir, 😊
You are welcome!
Starting this also after watching the 4.29 hours one...❤❤❤
Glad you are learning so much from us!
🎉🎉🎉Thank you so much
You are so welcome
Thank you so much for this course. Is it possible to Upload data analysis on Excel with chatgpt.
We are working on it!
Nice course
Thanks
God day, I am struggling to calculate the gross income following the method you use. Either I get an error message or 10-digit total instead of what you get.
Exactly looking for
👍👍👍💯💯💯
awesome...
Thanks!
Amazing
Thanks!
kindly make a video on looker studio as well
We will look into it!
Is this from scratch to advanced and is it enough for interview purpose.
It will give you a great foundation! The best advice we can give for interviews is practice, practice, practice.
Is this beginner, intermediate, expert? Im trying to understand if this is a full course or something like i have came across in the past where people call it a full course but in reality they then sell u onto a bigger course on udemy. I want to learn beginner and intermediate and then depending on what subjects are covered in intermediate decide then whether to continue to learn the expert?
I dont want to waste studying time by trying to find good resources. Can u pls advise me with links to the videos i shoild be watching using the latest microsoft 365 yearly subscription
All of the above! We recommend checking our all our Full Course videos on our channel to find all the training you need completely free!
Sir a course in microsoft 365 using AI would be very helpful....kindly consider
Here you go: th-cam.com/video/Fr0nM_-jpjc/w-d-xo.html
dynamic array doesn't work in my Excel sheet. I have office 2016 (link to a row rang & a column rang)
This article may help: support.microsoft.com/en-us/office/dynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531
What app are you using to draw on your screen while you simultaneously screen record?
Tq sir 😊
You are welcome!
Sir Great Video but i am not understand because i am not understands English larger people wait for video in Urdu or Hindi almost same plz convert video .plz for understand problem
Noted!
Thank you so much for sharing but the file is not opening
We just tested the link and files. They are currently working.
Pls upload mysql course for data analyst..
We will look into it!
My excel does not have a tool for analyzing data, What do you think i should do?
Please what version of Excel was used in making this tutorial ?
This was recorded using Excel 365
When "Thanks" have to be said
You are welcome!
HI.. I HAVE TRIED THIS IN excel 2007. In gross pay formula when i click =pay rate some error comes in and Table4 is written after = sign. may i knw whats the error ?
Nice
Thanks
Thank you very much Sir, for the first time i understand the Formulas
Great to hear! Hope you learn lots more!
@@LearnitTraining Very much! Alot of things i have been doing it manually now i find it easy to get with PIVOT Tables Thank you am enjoying the course
6:12:26 gross pay apply only for one cell, link row range give error and link column range only for one cell. Plz help what change i have to do with my excel.
could you please explain a complete project using excel
In a future video!
i have applied xlookup formula and values are filled in some cells and some cells are showing N/A error.
3:37:40
👍👍👍👍
can I practice this on google sheet?
We do have a Google Sheets class available as well.
I can't find the Xlookup function in my Excel sheet. I have office 2019
Unfortunately XLOOKUP is not available on Excel 2019
Hello how can i use this learning for profit? If you can provide me i am willing to do salary/profit sharing.
That BASS
👍
5:54:52
👍👍👍
is data cleaning included in this course ?
is this enough for data analytics.
Practice, practice, and more practice
I couldn't find the practice file, can you share here please Sir?
Exercise Files: learnitanytime.com/p/exercise-files-excel-data-analysis-full-course-tutorial-2024
Hi can i get a entry level job for data analytics
Indeed.com is a great place to start your job hunt!
how to add analyze data
Hopefully you learned a lot from this video!