Excel 2019 Beginner Tutorial
Вставка
- Опубліковано 21 лип 2024
- Excel 2019 Beginner Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: bit.ly/36ZPKzO
Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.
What it is: Microsoft’s spreadsheet application used to clean and organize data.
What you'll learn: We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Advanced section, we show you the various tools and ways to sort and filter data in a timely manner. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Expert training starts with basic functions like the IF function. After that, we explore complex Database functions, provide an introduction to Macros, and show you how to save time by automating common Excel tasks.
For ad free training and certificates please join Learnit Anytime:
www.learnitanytime.com
Enroll in our live, instructor-led Excel classes:
bit.ly/3GnV553
For Private Group Trainings please visit:
www.learnit.com/private-group...
Start 0:00
Introduction 0:03
Start Screen & Templates 0:59
Ribbon & Quick Access Toolbar 6:04
Backstage View 12:44
Smart Lookup & Tell Me 15:33
Interface 18:49
Navigation 22:36
Keyboard Shortcuts 26:03
Entering Text 30:18
Number Formats 36:08
Deleting & Formatting 40:20
AutoSum 44:55:01
Simple Formulas 49:29
Simple Functions (Part 1) 52:57
Simple Functions (Part 2) 59:18
Absolute Referencing 1:03:01
Moving & Copying Data 1:09:15
Inserting Rows & Columns 1:12:16
AutoFill 1:16:57
Cell Styles 1:22:52
Worksheet Themes 1:27:26
Excel Templates 1:32:40
Freeze Panes 1:35:39
Grouping Worksheets 1:41:01
Page Layout View 1:43:56
Custom Views 1:45:54
Spell Check 1:48:13
Printing 1:49:58
#Excel
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
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!
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.
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.
what tool he is using to make those red annotation and arrow ?
could you send me this exercise sheet?
Thanks for your honesty. I'm trying to power through it in one sitting; not realistic expectation.
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!
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.
I've taken several tutorials on Excel. This by far is the best one. It's extremely thorough!
Wow, thanks!
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
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!
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!
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
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 !!
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!
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?
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!
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!
im starting to love using excel since watching this tut vid thnx a lot dude
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!
this guy is absolutely amazing at teaching
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!
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.
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!
"now that we have that down
😏 I want you to know 😏 that the ribbon 😏 is pretty customizable 😏" i love your intonation
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!
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 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!
Thanks so much for this well delivered course. Really helpful and informative.
You're very welcome!
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!
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.
Wonderful teaching style and thank you
Thank you for taking the time to help us out with your knowledge. Much appreciated.
Glad it was helpful!
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. 🤝
This was a good refresher. Really well done. Easy to understand. Thank you
You're very welcome!
Thank You so much for this!!! This channel is the definition of Providing Value!!
Thank so much for watching Puneeth!
the way you teach Karim is super helpful and straightforward. thanks a bunch
You're very welcome!
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!
Very nice and detailed video!
Excellent video, your voice is soothing . Easy to learn. Thank you.
Thank you kindly!
Thanks Faz I love excel and your tips it inspired me to create my own tutorials specific for finance functions
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
You're so welcome!
Thank You so much for taking your time to provide this Tutorial. i needed this as a refresher!
You are so welcome!
I have an upcoming Excel certification next week, and this video is really helpful. Thank you so much!
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!
This was so helpful! Thank you so much!!
You're so welcome!
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??
Absolutely amazing ! Thank you for creating these !
Glad you like them!
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!!!
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!
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!💐👍🏼
This was an awesome tutorial. Thank you!
You're very welcome!
What a best way to revision! Thanks boss man, the video is awesome
Glad it helped!
I just wanna say this is long but worth it!
Thank you Narinder Kaur! We always want to give everyone a full class!
Nice video! Tip: put on 1.25x speed to save some time xD
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! 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!
Comprehensive and well presented. Thank you.
Glad it was helpful!
Thank you so much for this video, I learned a lot today. keep videos coming.
You got it!
Very informative video- concise and straight to the point.
Thank you for watching!
The value is absolutely insane for free content
We are glad you think so TOBN!
Thank you, Learnit Training. This is a very organized way of learning. The presentation was easy to follow as well.😊
You are 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 :/
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! :)
Hi Caspervermeulen1 - We recommend going right into the Excel Advanced 2019 video
@@LearnitTraining Thanks a ton! Will get right to it. :)
EXCELLENT Instruction. Thanks
You're welcome!
Really, you are a great instructor!
Great thanks!
You are welcome!
Great video! very clear and easy to understand
Great to hear!
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!!!.
This was excellent! Great for beginners!
Glad you enjoyed it!
Thank you so much, your tutorial is very helpful and I've learned a lot.
You're very welcome!
Thanks man great work. Learnt a lot although I was using excel for 1 year or so regularly.
You're very welcome!
Day #1: 49:29
Day #2: 1:03:03
Mr. Karim has such a beautiful accent! Greetings from Brazil :)
👍
Really awesome video! I love teaching Excel to beginners too and I post some interesting tutorials daily
I'll check it out!
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)
Hi Bruce! You can ask our instructors questions directly on Offsite our online community - bit.ly/30HMjvw
yes we have to
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.
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?
oh my, the quick access! So dope!
Thank you for watching!
1:13:55 that F4 keyboard shortcut is the best thing. Works in lots of other programs, including word.
Great tip!
Thank you for this video, I have a question tho. If you are using € (euro) instead of $ (dollars) what key should I use (for the copy paste sum at the 1:06:30) instead of the f4?
Thanks in advance!
I figured it out, using the currency of $ (dollar) doesn't affect any kind of work if you are using € (euro) or something else. Thus in my opinion it is the same thing for every different kinds of currency.
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..?
That is super useful how you have bookmarked different parts of your video :)
Chapters are always helpful!
He really loves the word expose.
Superb content. Thank you.🙏👍
You are very welcome!
Thank You so much tis video it was really helpful! I have learned a lot!
Thank you for the kind words Thabile!
Thank You for the teaching and sharing . Helps me alot :)
You're very welcome!
Brilliantly put together
Thank you very much Mark!
Thank you for this tutorial
You're welcome 😊
Thank you so much much I learned a lot from you
Do you have SQL course please share
ua-cam.com/video/AFY3z4FwRg0/v-deo.html
Can you do a review Taskade next? 🌟🌟🌟
Thanks for presentation !
Our pleasure!
Im so happy...Ive learned so much
Thank you, it's a very good course!
You are welcome!
Thank you very much ❤️
You did a great job
You're 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
thx, very fun and easy to learn :)
Glad you liked it!
Starting point to build up my career I'm enjoying learning again :):)
Good luck JB JB!
the teaching style is very good ...
Thanks for making a video for beginners like me!
You're very welcome!
This is an excellent resource
Thank you for watching!
Very helpful
Much thanks
You're welcome
Great... i have to install it ... thanks