I'm just going to do a little checklist of where I left the video so... Day #1: 18:49 Day #2: 44:54 Day #4: 1:09:15 Day #6: 1:32:40 Day #7: 1:53:15 (Finished :D) Thank you so much for this Tutorial! ❤️ I'll keep with the next one now.
This is an excellent tutorial. Not everyone is capable of teaching. It takes an innate talent to be able to teach effectively. The person narrating and instructing in this video and the other Excel tutorials is a natural born teacher. Excellent!
Are you looking for a comprehensive video on excel? This is where to go. The tutor really took good care of the beginners and went well from the beginning to the end. Thanks and keep up the good work.
Just keep in mind at approximately 1:16:00 when you are describing the find and replace for blank cells, if you replace blanks with zeros that will impact your cells with descriptive stats formulas (average, min, max, count, etc.). If you replace blanks with a dash or "blank" those cells will not be impacted.
I have been using Excel for a while, but I decided to watch this beginner video anyhow and I'm so happy I did...I realized there's a lot I don't know! Faz speaks clearly and is very detailed. Even if you know excel, it might be a good refresher for some tips. I highly recommend. Thank you!
Thank You! As an old beginner, I have been mesmerized by your tutorial, ease of understanding, Calmness of voice and careful use of your cursor. You, sir, have blown my mind!
This tutorial is for beginners. However, when I went through it I learned some wonderful tricks and tips which are very useful in our routine life. Definitely, its value addition in our knowledge. The tutorial is very well planned and narrated through out the session. I suggest, even if you are not a beginner, you will learn some amazing tricks.
Karim Bhai(Brother) you are the best excel tutor, I like the way you break each detail into chunks so that it can be crystal clear. One thing that has stunned my mind during this whole tutorial is you didn't seem to be a tutor but a brother, a friend. What A human being! Sending you Love and thanks from 🇮🇳
Thanks a million for sharing this complete prefect video. I learned alot totaly free. You made my day because I was searching for such tutorial. Good job🙏💙
Thank you for this!! I spent two weeks in a course trying to learn this material, but I couldn't make heads or tails of it, and in one sitting, with this tutorial, I was able to learn the beginner's level of the course! The Instructor is not only knowledgeable, his voice and tone are not off-putting!! -:) Most people don't realize how much of a difference that makes to some learners, especially as we're all attempting to learn the new normal of learning remotely. Again, thank you so much!!!
WHY WASNT YOU MY TEACHER IN SCHOOL IM JUST 24 mins in && CAN TELL YOU ARE A WONDERFUL TEACHER!!!! IM DEFINITELY GONNA WATCH THIS OVER && UNTIL IM COMFORTABLE THEN I WILL GO BACK && TAKE THE MS EXCEL 2019 GRADED PROJECT!!! I WANNA MAKE AN 100%🎉🙌🏼
This video is EXCELLENT! I am a basic Excel user but I’m trying to become more advanced so this video is just what I needed. The way you explain everything is so clear and concise-I love your teaching style! Thanks!
Thank you SO much for this excellent tutorial. I'm not exactly a numbers person so this vid really helped me understand a spreadsheet I've been having trouble with. Your teaching method is very clear, and easy to learn from. Your voice is pleasing to listen to, with no distracting hesitations, pauses or mannerisms. Better than other tutorials I've tried. I'm going to try the Advanced Tutorial now.
My first time to watch your tutorial but OMG this is awesome, i love it already and i like the fact that our able to specify every single detail. keep up the good work, this is really what we call teaching
Learning this to get a new job that requires excel knowledge and Faz is doing an excellent job explaining and showing how to use excel. Thank you so much.
Thank you so much for this terrific and FREE video. You have a perfect voice for what you do. It's super easy to follow and understand. Thank you again!
It's a great help. Now I know how to use my Excel 2019. I really appreciate your tutorial, it's very clear and easy to follow. That saves me a lot of time learning it in the fastest way. Thank you!
Thanks a ton. Learned a lot. Just saw you have intermediate, advanced, power user and pivot table videos too. For people that take it upon themselves to learn or may not have the means to afford traditional education, your material is priceless.
As someone who holds a highest honors degree in finance and yet somehow never touched Excel, I really need this. Between you and the Corporate Finance Institute, I think I'll be okay.
Good Morning Everyone! Mr. Tom, Whoever You Are. I Do Not Hold The Highest Honors In Anything. However, I Have Study & Learned Very Much, But I Needed To Thank You. Because, I Was Already Feeling Intellectually Low, Very Low Perhaps. Until, I Read Your Comment. Thanks For Sharing It! Some Of The Jobs That Can Possibly/Potentially Hire Me, Require MS Excel. Once Again, Thank You! G♥D Bless!!!
Thank you for another awesome informative tutorial Faz! I find it helpful to watch you explain first, then join in with you a second time. Your tutorials are .always fantastic. Thank you
Thanks a lot for your course on excel as it enable to strengthen my understanding about how to use excel in my daily job. Thanks again for your teaching and patience.
Great video, I’m not a beginner but still learnt a significant amount from this video. Content is really well delivered. Moving onto the next level now :-)
Thank you Karim !! For this wonderful tutorial. You are a great Professor. Your tutorial is well defined and I enjoyed it. God bless you. I subscribed too!
Hi, thank you for great tutorial. I've learned a lot. But I have problem with autofill. When I want to autofill days in the week it shows only word Monday not Thuesday Wednesday etc :/also double click with mon tue etc doesn't work :/
great video... i watched your excel beginner and intermediate video... now can you pls refer me to any site where i can get excel related projects and apply my knowledge..?
WOW your articulation and way of teaching is wonderful! Thanks for the video which gave me inspiration for my own classes (I give basic Excel training to students) 😊
Hello, I have a row and column with similar names I am interested in the case of a calculation to have the value from the right combination written in the calculation. metal concrete masonry metal 1 2 2.5 concrete 2.5 1 2 masonry 2 2.5 1 I am interested in choosing the combination of metal + masonry to show the value 2.5 and choosing the combination of concrete + concrete to show me the combination of 1, etc. Thank you.
This is excellent! In echoing one of the other comments I saw, not everyone can teach! I do have one question. I am at the Totals with Formulas. I'm sure I'm missing a step, but I can't determine what it is! I insert the = sign. Then I go over and select the first $50. Exactly how do I get the other cells to do the same? I clicked Shift + the cell and wasn't successful. Any clarification anyone can offer?
Just found your courses and chose to start with this one. I installed Excel 2019 recently and today as I was following along your video I noticed on the Home/New screen I am not seeing any templates at all, other than the one for 'Blank workbook'. I also do not see the search bar. This is Excel 2019, I believe. It is version 16.53. I own this license, no subscription and I am using an iMac running Big Sur. What happened to the other templates?
Thank you so much for this. Now, I'm not intimidated with Excel anymore.😆 I just wanna ask one thing, in 1:00:50 why do you include the auto total in Totals? aren't you supposed to include only B4 to F5 only??
Okay, not sure what is happening here. I used to use Excel quite a bit before I retired and recently decided to catch up and see what has changed. I am barely into this first video and I am going to look elsewhere for training. As I said in my other comment, I am using an iMac 5k 2020, running Big Sur. I installed Office 2019 Home and Student version, a one-time purchase as opposed to a subscription. So far I am seeing screens on my computer that are unlike yours and I don't know why. Do you? Have you made the same mistake many other online trainers make? Is there a difference between the Windows version and the Mac version? I bet there is. Is there a difference between the subscription version and the purchase version? I bet there is. You may not know of all the differences but you should at least alert people to the possibility they exist and explain whether or not they are real differences or can they be the result of different preferences or what? It could well be I have done something dumb but I don't think so. I believe the software you are showing is different than what I have. 👎 👎 👎
D1: Entering Text 30:18
D2: Deleting & Formatting 40:20
D3: Absolute Referencing 1:03:01
D4: AutoFill 1:16:57
D5: Excel Templates 1:32:40
D6: Printing 1:49:58
D7: To go over
I'm just going to do a little checklist of where I left the video so...
Day #1: 18:49
Day #2: 44:54
Day #4: 1:09:15
Day #6: 1:32:40
Day #7: 1:53:15 (Finished :D)
Thank you so much for this Tutorial! ❤️ I'll keep with the next one now.
could you send me this exercise sheet?
Thanks for your honesty. I'm trying to power through it in one sitting; not realistic expectation.
This is an excellent tutorial. Not everyone is capable of teaching. It takes an innate talent to be able to teach effectively. The person narrating and instructing in this video and the other Excel tutorials is a natural born teacher. Excellent!
We appreciate that!
Good teaching method
Going to add checklist by date wise
26-08-2024 : 1:09:15
28-08-2024: 1:22:51
30-08-2024: 1:52:50 (End😊😊)
And thanks Faz Karim💕💕
👍
Are you looking for a comprehensive video on excel? This is where to go. The tutor really took good care of the beginners and went well from the beginning to the end. Thanks and keep up the good work.
Thank you for the kind words Ibraheem! Thank you for watching too!
Mr. Faz, your tutorials are the best tutorials. They are professionally taught and just what we need to learn.
Thank you for this!
You're very welcome!
I've taken several tutorials on Excel. This by far is the best one. It's extremely thorough!
Wow, thanks!
Just keep in mind at approximately 1:16:00 when you are describing the find and replace for blank cells, if you replace blanks with zeros that will impact your cells with descriptive stats formulas (average, min, max, count, etc.). If you replace blanks with a dash or "blank" those cells will not be impacted.
I have been using Excel for a while, but I decided to watch this beginner video anyhow and I'm so happy I did...I realized there's a lot I don't know! Faz speaks clearly and is very detailed. Even if you know excel, it might be a good refresher for some tips. I highly recommend. Thank you!
Hi Faz, I have been using ms office for last 15 years. But I learned so many new things from your training. You are a master!
Great to hear! Thank you for watching!
Thank You! As an old beginner, I have been mesmerized by your tutorial, ease of understanding, Calmness of voice and careful use of your cursor. You, sir, have blown my mind!
You're very welcome!
This tutorial is for beginners. However, when I went through it I learned some wonderful tricks and tips which are very useful in our routine life. Definitely, its value addition in our knowledge. The tutorial is very well planned and narrated through out the session. I suggest, even if you are not a beginner, you will learn some amazing tricks.
Hi Arun! Thank you very much for your continued support! You comments and suggestions are always welcomed!
Yes! He is excellent !!
Thank you for taking the time to help us out with your knowledge. Much appreciated.
Glad it was helpful!
Thank you for being such a blessing!!! I am very grateful. God put you in the world to help people like me! Thank you again
Happy to help!
Karim Bhai(Brother) you are the best excel tutor, I like the way you break each detail into chunks so that it can be crystal clear. One thing that has stunned my mind during this whole tutorial is you didn't seem to be a tutor but a brother, a friend. What A human being! Sending you Love and thanks from 🇮🇳
You are most welcome!
Thanks a million for sharing this complete prefect video.
I learned alot totaly free. You made my day because I was searching for such tutorial. Good job🙏💙
Glad it helped!
Thank you for this!! I spent two weeks in a course trying to learn this material, but I couldn't make heads or tails of it, and in one sitting, with this tutorial, I was able to learn the beginner's level of the course!
The Instructor is not only knowledgeable, his voice and tone are not off-putting!! -:)
Most people don't realize how much of a difference that makes to some learners, especially as we're all attempting to learn the new normal of learning remotely.
Again, thank you so much!!!
You're very welcome!
DITTO
The value is absolutely insane for free content
We are glad you think so TOBN!
WHY WASNT YOU MY TEACHER IN SCHOOL IM JUST 24 mins in && CAN TELL YOU ARE A WONDERFUL TEACHER!!!! IM DEFINITELY GONNA WATCH THIS OVER && UNTIL IM COMFORTABLE THEN I WILL GO BACK && TAKE THE MS EXCEL 2019 GRADED PROJECT!!! I WANNA MAKE AN 100%🎉🙌🏼
Good luck!!!
I’ve been using excel for a while, but this is an excellent vid to relearn how to do tasks in new and more efficient ways.
Thank You so much for this!!! This channel is the definition of Providing Value!!
Thank so much for watching Puneeth!
This video is EXCELLENT! I am a basic Excel user but I’m trying to become more advanced so this video is just what I needed. The way you explain everything is so clear and concise-I love your teaching style! Thanks!
You're very welcome Kay L!
Can I gain certification with this?
Thank you! Thank you! I'm getting a job because I have been able to learn Excel through this wonderful tutorial!
You're very welcome! Congratulations on the new job!
this guy is absolutely amazing at teaching
you are amazing!!! May God bless you always for helping people like me: You were born to to teach people. thank you so much
Thank you so much for watching!
Thank you SO much for this excellent tutorial. I'm not exactly a numbers person so this vid really helped me understand a spreadsheet I've been having trouble with. Your teaching method is very clear, and easy to learn from. Your voice is pleasing to listen to, with no distracting hesitations, pauses or mannerisms. Better than other tutorials I've tried. I'm going to try the Advanced Tutorial now.
You're very welcome!
the way you teach Karim is super helpful and straightforward. thanks a bunch
You're very welcome!
Very Professional way of teaching.
I have learned lots of new shortcuts to become more efficient.
Thank you.
My first time to watch your tutorial but OMG this is awesome, i love it already and i like the fact that our able to specify every single detail. keep up the good work, this is really what we call teaching
You're so welcome!
Day #1: 49:29
Day #2: 1:03:03
Mr. Karim has such a beautiful accent! Greetings from Brazil :)
👍
Learning this to get a new job that requires excel knowledge and Faz is doing an excellent job explaining and showing how to use excel. Thank you so much.
Glad to help!
Thank you, Learnit Training. This is a very organized way of learning. The presentation was easy to follow as well.😊
You are very welcome!
Thank you so much for this terrific and FREE video. You have a perfect voice for what you do. It's super easy to follow and understand. Thank you again!
You are so welcome!
It's a great help. Now I know how to use my Excel 2019. I really appreciate your tutorial, it's very clear and easy to follow. That saves me a lot of time learning it in the fastest way. Thank you!
You're very welcome!
Thank You so much for taking your time to provide this Tutorial. i needed this as a refresher!
You are so welcome!
Thanks a ton. Learned a lot. Just saw you have intermediate, advanced, power user and pivot table videos too. For people that take it upon themselves to learn or may not have the means to afford traditional education, your material is priceless.
You're very welcome!
Very informative video- concise and straight to the point.
Thank you for watching!
As someone who holds a highest honors degree in finance and yet somehow never touched Excel, I really need this. Between you and the Corporate Finance Institute, I think I'll be okay.
Good Morning Everyone! Mr. Tom, Whoever You Are. I Do Not Hold The Highest Honors In Anything. However, I Have Study & Learned Very Much, But I Needed To Thank You. Because, I Was Already Feeling Intellectually Low, Very Low Perhaps. Until, I Read Your Comment. Thanks For Sharing It! Some Of The Jobs That Can Possibly/Potentially Hire Me, Require MS Excel. Once Again, Thank You! G♥D Bless!!!
Encouragement I needed to see. 🤝
I just wanna say this is long but worth it!
Thank you Narinder Kaur! We always want to give everyone a full class!
im starting to love using excel since watching this tut vid thnx a lot dude
This was an awesome tutorial. Thank you!
You're very welcome!
Thank you for another awesome informative tutorial Faz! I find it helpful to watch you explain first, then join in with you a second time. Your tutorials are .always fantastic. Thank you
Awesome, thank you!
Thank you so much, your tutorial is very helpful and I've learned a lot.
You're very welcome!
Excellent video, your voice is soothing . Easy to learn. Thank you.
Thank you kindly!
Thanks a lot for your course on excel as it enable to strengthen my understanding about how to use excel in my daily job. Thanks again for your teaching and patience.
Glad it was helpful!
Great video! very clear and easy to understand
Great to hear!
Comprehensive and well presented. Thank you.
Glad it was helpful!
Absolutely amazing ! Thank you for creating these !
Glad you like them!
Nice video! Tip: put on 1.25x speed to save some time xD
"now that we have that down
😏 I want you to know 😏 that the ribbon 😏 is pretty customizable 😏" i love your intonation
I have an upcoming Excel certification next week, and this video is really helpful. Thank you so much!
Glad it was helpful!
Great video, I’m not a beginner but still learnt a significant amount from this video. Content is really well delivered. Moving onto the next level now :-)
Glad it was helpful!
I love the red arrows that you use.
I suppose that remembering all the shortcuts comes with practice.
HI Earth we use Zoomit to produce those arrows and yes, practice makes perfect! Thank you for your continued support!
@@LearnitTraining - I will continue with the advance Excel course today. Greetings from Pacific Heights in San Francisco!💐👍🏼
Thank You for the teaching and sharing . Helps me alot :)
You're very welcome!
Thank you so much for this video, I learned a lot today. keep videos coming.
You got it!
This was excellent! Great for beginners!
Glad you enjoyed it!
Thank You so much tis video it was really helpful! I have learned a lot!
Thank you for the kind words Thabile!
Really, you are a great instructor!
Great thanks!
You are welcome!
Very nice and detailed video!
Excellent and best training on Excel
Glad you think so!
Thanks so much for this well delivered course. Really helpful and informative.
You're very welcome!
Superb content. Thank you.🙏👍
You are very welcome!
EXCELLENT Instruction. Thanks
You're welcome!
1:13:55 that F4 keyboard shortcut is the best thing. Works in lots of other programs, including word.
Great tip!
Thanks for making a video for beginners like me!
You're very welcome!
Great tutorial. Thanks! Which one would you recommend next? Excel 2016 Intermediate or Excel 2019 Advanced Tutorial? Thanks.
Hi Nebojsha! We recommend using the version that you are using at work/home
This was a good refresher. Really well done. Easy to understand. Thank you
You're very welcome!
You have made me much better in performing excel
Hi Justine! You are very welcome!
oh my, the quick access! So dope!
Thank you for watching!
Thank you Karim !! For this wonderful tutorial. You are a great Professor. Your tutorial is well defined and I enjoyed it. God bless you. I subscribed too!
Thank you so much for subscribing Ayo! It helps us so much!
Thank you so much much I learned a lot from you
Do you have SQL course please share
th-cam.com/video/AFY3z4FwRg0/w-d-xo.html
Thanks man great work. Learnt a lot although I was using excel for 1 year or so regularly.
You're very welcome!
Hi, thank you for great tutorial. I've learned a lot. But I have problem with autofill. When I want to autofill days in the week it shows only word Monday not Thuesday Wednesday etc :/also double click with mon tue etc doesn't work :/
Love 💟😘 this tutorial very much within my heart and mind
Thank you so much 😀
great video... i watched your excel beginner and intermediate video... now can you pls refer me to any site where i can get excel related projects and apply my knowledge..?
Thank you very much ❤️
You did a great job
You're welcome 😊
Starting point to build up my career I'm enjoying learning again :):)
Good luck JB JB!
Brilliantly put together
Thank you very much Mark!
Really
Thank you so much i was searching like this
I get it
Thank you so so much
You are welcome and thank you for watching!
Best video I've seen.
Glad you think so!
This is an excellent resource
Thank you for watching!
WOW your articulation and way of teaching is wonderful! Thanks for the video which gave me inspiration for my own classes (I give basic Excel training to students) 😊
Wow, thank you!
That is super useful how you have bookmarked different parts of your video :)
Chapters are always helpful!
Wonderful teaching style and thank you
48:50 both directions are correct and will yield 1500 though
Hello,
I have a row and column with similar names
I am interested in the case of a calculation to have the value from the right combination written in the calculation.
metal concrete masonry
metal 1 2 2.5
concrete 2.5 1 2
masonry 2 2.5 1
I am interested in choosing the combination of metal + masonry to show the value 2.5 and choosing the combination of concrete + concrete to show me the combination of 1, etc.
Thank you.
amazing and very well planned
Thank you! Cheers!
This is excellent! In echoing one of the other comments I saw, not everyone can teach! I do have one question. I am at the Totals with Formulas. I'm sure I'm missing a step, but I can't determine what it is! I insert the = sign. Then I go over and select the first $50. Exactly how do I get the other cells to do the same? I clicked Shift + the cell and wasn't successful. Any clarification anyone can offer?
Hello DianaMarie! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Oh sorry, forgot to say thankyou for very helpful tutorial
Glad it was helpful!
Shorcuts aren't working for me, any tips on that?
This was so helpful! Thank you so much!!
You're so welcome!
Just found your courses and chose to start with this one. I installed Excel 2019 recently and today as I was following along your video I noticed on the Home/New screen I am not seeing any templates at all, other than the one for 'Blank workbook'. I also do not see the search bar. This is Excel 2019, I believe. It is version 16.53. I own this license, no subscription and I am using an iMac running Big Sur. What happened to the other templates?
Thank you so much for this. Now, I'm not intimidated with Excel anymore.😆
I just wanna ask one thing, in 1:00:50 why do you include the auto total in Totals? aren't you supposed to include only B4 to F5 only??
Thanks learnit, it was plenty useful
You are welcome!
I understand this tutorial better thank you
You are welcome!
Very helpful
Much thanks
You're welcome
excuse me, what app you use for record this learn ?, that so awesome you can make rectangle and arrow as you recording
HI Hamim! We record all our course with Camtasia
This is the best tutorial thank you so much
You're welcome!
Okay, not sure what is happening here. I used to use Excel quite a bit before I retired and recently decided to catch up and see what has changed. I am barely into this first video and I am going to look elsewhere for training. As I said in my other comment, I am using an iMac 5k 2020, running Big Sur. I installed Office 2019 Home and Student version, a one-time purchase as opposed to a subscription. So far I am seeing screens on my computer that are unlike yours and I don't know why. Do you? Have you made the same mistake many other online trainers make? Is there a difference between the Windows version and the Mac version? I bet there is. Is there a difference between the subscription version and the purchase version? I bet there is. You may not know of all the differences but you should at least alert people to the possibility they exist and explain whether or not they are real differences or can they be the result of different preferences or what? It could well be I have done something dumb but I don't think so. I believe the software you are showing is different than what I have. 👎 👎 👎
That tricks and tips gives this tutorial if I read books 📚 it takes more time
Thanks for watching!