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

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.

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!

@LearnitTraining

3 жыл бұрын

We appreciate that!

@ITInfo5920

9 ай бұрын

Good teaching method

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.

@sultanacademy491

Жыл бұрын

could you send me this exercise sheet?

@loveshighermind2879

Жыл бұрын

Thanks for your honesty. I'm trying to power through it in one sitting; not realistic expectation.

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

@LearnitTraining

3 жыл бұрын

You're very welcome!

I've taken several tutorials on Excel. This by far is the best one. It's extremely thorough!

@LearnitTraining

3 жыл бұрын

Wow, thanks!

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🙏💙

@LearnitTraining

3 жыл бұрын

Glad it helped!

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!

@LearnitTraining

3 жыл бұрын

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.

@LearnitTraining

3 жыл бұрын

Hi Arun! Thank you very much for your continued support! You comments and suggestions are always welcomed!

@storytimeinfuntown5936

2 жыл бұрын

Yes! He is excellent !!

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.

@LearnitTraining

3 жыл бұрын

You're very 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!

@LearnitTraining

3 жыл бұрын

You're very welcome!

im starting to love using excel since watching this tut vid thnx a lot dude

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

@LearnitTraining

3 жыл бұрын

You're very welcome!

@vickijohnson3203

3 жыл бұрын

DITTO

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!

@LearnitTraining

3 жыл бұрын

You are so welcome!

this guy is absolutely amazing at teaching

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!

@LearnitTraining

3 жыл бұрын

You're very welcome Kay L!

@great4ever845

3 жыл бұрын

Can I gain certification with this?

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.

@LearnitTraining

3 жыл бұрын

Thank you for the kind words Ibraheem! Thank you for watching too!

"now that we have that down 😏 I want you to know 😏 that the ribbon 😏 is pretty customizable 😏" i love your intonation

Very Professional way of teaching. I have learned lots of new shortcuts to become more efficient. 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.

@LearnitTraining

3 жыл бұрын

Glad it was helpful!

Mr. Faz, your tutorials are the best tutorials. They are professionally taught and just what we need to learn. Thank you for this!

@LearnitTraining

Жыл бұрын

You're very welcome!

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.

@lesliejaquez8401

3 жыл бұрын

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

@johnkodhek

2 жыл бұрын

Encouragement I needed to see. 🤝

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!

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 :-)

@LearnitTraining

3 жыл бұрын

Glad it was helpful!

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) 😊

@LearnitTraining

2 жыл бұрын

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

@LearnitTraining

2 жыл бұрын

Great to hear! Thank you for watching!

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

@LearnitTraining

2 жыл бұрын

Awesome, thank you!

Thanks so much for this well delivered course. Really helpful and informative.

@LearnitTraining

3 жыл бұрын

You're very welcome!

Wonderful teaching style and thank you

Thank you for taking the time to help us out with your knowledge. Much appreciated.

@LearnitTraining

3 жыл бұрын

Glad it was helpful!

This was a good refresher. Really well done. Easy to understand. Thank you

@LearnitTraining

3 жыл бұрын

You're very welcome!

Nice video! Tip: put on 1.25x speed to save some time xD

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 🇮🇳

@LearnitTraining

2 жыл бұрын

You are most welcome!

What a best way to revision! Thanks boss man, the video is awesome

@LearnitTraining

4 жыл бұрын

Glad it helped!

Thanks Faz I love excel and your tips it inspired me to create my own tutorials specific for finance functions

@LearnitTraining

3 жыл бұрын

Happy to help!

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%🎉🙌🏼

@LearnitTraining

Жыл бұрын

Good luck!!!

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.

@LearnitTraining

3 жыл бұрын

Glad to help!

the way you teach Karim is super helpful and straightforward. thanks a bunch

@LearnitTraining

3 жыл бұрын

You're very welcome!

Very nice and detailed video!

I just wanna say this is long but worth it!

@LearnitTraining

3 жыл бұрын

Thank you Narinder Kaur! We always want to give everyone a full class!

Thank You so much for taking your time to provide this Tutorial. i needed this as a refresher!

@LearnitTraining

2 жыл бұрын

You are so welcome!

Thank You so much for this!!! This channel is the definition of Providing Value!!

@LearnitTraining

2 жыл бұрын

Thank so much for watching Puneeth!

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

@LearnitTraining

2 жыл бұрын

Happy to help!

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

@LearnitTraining

6 ай бұрын

You're so welcome!

Excellent video, your voice is soothing . Easy to learn. Thank you.

@LearnitTraining

3 жыл бұрын

Thank you kindly!

The value is absolutely insane for free content

@LearnitTraining

2 жыл бұрын

We are glad you think so TOBN!

you are amazing!!! May God bless you always for helping people like me: You were born to to teach people. thank you so much

@LearnitTraining

2 жыл бұрын

Thank you so much for watching!

Absolutely amazing ! Thank you for creating these !

@LearnitTraining

2 жыл бұрын

Glad you like them!

Thank you so much for this video, I learned a lot today. keep videos coming.

@LearnitTraining

3 жыл бұрын

You got it!

Hi Faz, Just a querie regarding the section "Simple Functions (Part 2)". When you were adding the totals for "Server 1" and "Server 3" (=$1500), you also added the "Auto Total" to the sum thus doubling the total to $3000. The same with "Average" which possibly should be $1500/10 entries (=$150) as opposed to $3000/15 entries (=$200). Also, would "Count" be 10 as opposed to 15, as the "Auto Total" should not be included in the count, also? "Min" and "Max" could go either way I suppose. Could be me, but just say'n. Thanks Jon.

I love the red arrows that you use. I suppose that remembering all the shortcuts comes with practice.

@LearnitTraining

3 жыл бұрын

HI Earth we use Zoomit to produce those arrows and yes, practice makes perfect! Thank you for your continued support!

@earth7451

3 жыл бұрын

@@LearnitTraining - I will continue with the advance Excel course today. Greetings from Pacific Heights in San Francisco!💐👍🏼

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!

@LearnitTraining

2 жыл бұрын

Thank you so much for subscribing Ayo! It helps us so much!

This was so helpful! Thank you so much!!

@LearnitTraining

3 жыл бұрын

You're so welcome!

This was an awesome tutorial. Thank you!

@LearnitTraining

Ай бұрын

You're very welcome!

I have an upcoming Excel certification next week, and this video is really helpful. Thank you so much!

@LearnitTraining

3 жыл бұрын

Glad it was helpful!

Really, you are a great instructor! Great thanks!

@LearnitTraining

2 жыл бұрын

You are welcome!

Comprehensive and well presented. Thank you.

@LearnitTraining

3 жыл бұрын

Glad it was helpful!

He really loves the word expose.

Very informative I have a question. When you added Column Saturday, Sunday and the New Server rows Do you not have to update your Total with formulas cells etc to reflect those changes or is it done automatically? Example =sum(B4:F4) Once Saturday and Sunday are added would you not have to update the formula to =sum(B4:H4)

@LearnitTraining

3 жыл бұрын

Hi Bruce! You can ask our instructors questions directly on Offsite our online community - bit.ly/30HMjvw

@afthababu1380

2 жыл бұрын

yes we have to

Very informative video- concise and straight to the point.

@LearnitTraining

Жыл бұрын

Thank you for watching!

Thank you! Thank you! I'm getting a job because I have been able to learn Excel through this wonderful tutorial!

@LearnitTraining

2 жыл бұрын

You're very welcome! Congratulations on the new job!

Thanks man great work. Learnt a lot although I was using excel for 1 year or so regularly.

@LearnitTraining

2 жыл бұрын

You're very welcome!

Really awesome video! I love teaching Excel to beginners too and I post some interesting tutorials daily

@LearnitTraining

3 жыл бұрын

I'll check it out!

Thank you, Learnit Training. This is a very organized way of learning. The presentation was easy to follow as well.😊

@LearnitTraining

Жыл бұрын

You are very welcome!

Day #1: 49:29 Day #2: 1:03:03 Mr. Karim has such a beautiful accent! Greetings from Brazil :)

@LearnitTraining

5 ай бұрын

👍

Thank You so much tis video it was really helpful! I have learned a lot!

@LearnitTraining

3 жыл бұрын

Thank you for the kind words Thabile!

EXCELLENT Instruction. Thanks

@LearnitTraining

4 жыл бұрын

You're welcome!

This was excellent! Great for beginners!

@LearnitTraining

2 жыл бұрын

Glad you enjoyed it!

Great video! very clear and easy to understand

@LearnitTraining

Жыл бұрын

Great to hear!

Thank you so much, your tutorial is very helpful and I've learned a lot.

@LearnitTraining

Жыл бұрын

You're very welcome!

That is super useful how you have bookmarked different parts of your video :)

@LearnitTraining

2 жыл бұрын

Chapters are always helpful!

oh my, the quick access! So dope!

@LearnitTraining

3 жыл бұрын

Thank you for watching!

Thank you for this tutorial

@LearnitTraining

4 жыл бұрын

You're welcome 😊

Im so happy...Ive learned so much

Thank You for the teaching and sharing . Helps me alot :)

@LearnitTraining

2 жыл бұрын

You're very welcome!

Hello Faz, Thanks a lot for this series you've put together! Do we continue with the Excel Intermediate 2016 video or do we go straight to the Excel Advanced 2019 course? I'd appreciate it if anyone could tell me! :)

@LearnitTraining

3 жыл бұрын

Hi Caspervermeulen1 - We recommend going right into the Excel Advanced 2019 video

@kasupa14

3 жыл бұрын

@@LearnitTraining Thanks a ton! Will get right to it. :)

1:13:55 that F4 keyboard shortcut is the best thing. Works in lots of other programs, including word.

@LearnitTraining

Жыл бұрын

Great tip!

Thank you very much ❤️ You did a great job

@LearnitTraining

2 жыл бұрын

You're welcome 😊

Brilliantly put together

@LearnitTraining

3 жыл бұрын

Thank you very much Mark!

Thank you, it's a very good course!

@LearnitTraining

3 жыл бұрын

You are welcome!

Thanks for presentation !

@LearnitTraining

3 жыл бұрын

Our pleasure!

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

thx, very fun and easy to learn :)

@LearnitTraining

3 жыл бұрын

Glad you liked it!

Great... i have to install it ... thanks

the teaching style is very good ...

"It actually is connected to the internet. You can see the definition for table. Here, it is talking about an actual table. It's powered by Bing." hahahaha

Hello!. I have one question about excel. every time i'm writing the number 10 in A1 excel excel is change it to 0,1 and how can i fix it?. thanks 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..?

Superb content. Thank you.🙏👍

@LearnitTraining

25 күн бұрын

You are very welcome!

Perfect

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.

Does someone know the shortcut for showing the formula inside the cell for Macs? 1:04:30

Starting point to build up my career I'm enjoying learning again :):)

@LearnitTraining

2 жыл бұрын

Good luck JB JB!

Thanks for making a video for beginners like me!

@LearnitTraining

2 жыл бұрын

You're very welcome!

Really Thank you so much i was searching like this I get it Thank you so so much

@LearnitTraining

3 жыл бұрын

You are welcome and thank you for watching!

Am actually learning the book now Excel 2019

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 :/

Nice.

Thanks for this lesson

@LearnitTraining

3 жыл бұрын

No worries!