Excel 2019 Expert Tutorial
Excel 2019 Expert 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/3rwKfUf
For Private Group Trainings please visit:
www.learnit.com/private-group...
Start 0:00
Introduction 0:03
Creating & Applying Named Ranges 1:24
Navigating with Named Ranges 9:42
IF Functions (Part 1) 11:26
IF Functions (Part 2) 15:17
Introduction to Nesting Functions 18:07
The Round Function 22:16
Formula Auditing Tools 25:39
Introduction to VLOOKUP 29:40
VLOOKUP 33:58
IFERROR 36:13
Database Functions - SUMIF & AVERAGEIF 38:37
Database Functions - SUMIFS 42:42
Text Functions 46:13
Consolidate by Position 53:17
Consolidate by Category 57:34
Goal Seek 1:00:31
Introduction to Data Tables 1:03:22
Data Tables 1:06:25
Scenario Manager 1:07:45
Macros - Adding the Developer Tab 1:12:28
Macros - Recording & Running the Header Macro 1:14:42
Macros - Visual Basic Editor & Form Control 1:20:29
Macros - Adding Macros to the Ribbon 1:25:02
Macros - Exercise 1:27:38
#Excel
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
Пікірлер: 213
One of the few tutors that I truly enjoyed listening to and kept me interested all the way! Your random sense of humor is on point too!
@LearnitTraining
3 жыл бұрын
Thank you for watching and thank you for subscribing!
@ahmednavivwala1707
8 ай бұрын
@@LearnitTraining 1:01:36
Are you kidding!!!! This is FANTASTIC! The samples are PHENOMINAL & dude is crystal clear! Thanks so much!!
@LearnitTraining
3 жыл бұрын
Wow, thank you!
Thank you so much, really appreciate the time and effort for completing this useful tutorials for us. :)
Really well put together. A lot better than any of the paid for courses I have seen. Clear explanation of how nested functions work and super useful explanation of some of the analytics functions like the WhatIf analysis tabs. Perfect jumping off point at the end for anyone hoping to progress to learn macros. I added notes in a text box to each sheet of the student workbook provided as I followed along with the video - this will be a great resource for quick reference to the tools covered.
@LearnitTraining
2 жыл бұрын
Glad it was helpful!
@ahmednavivwala1707
8 ай бұрын
@@LearnitTraining 1:00:36
I do appreciate your time and effort in creating this fruitful tutorial. You rock!
@LearnitTraining
3 жыл бұрын
We appreciate that!
@ahmednavivwala1707
8 ай бұрын
@@LearnitTraining 1:01:14
Thank you sooo much for this wonderful course. Really enjoyed learning it!
@LearnitTraining
3 жыл бұрын
You're very welcome!
Another effective tutorial on Microsoft Excel. Being an ICT tutor myself, I believe alot of us will benefit from this. Thank you
@LearnitTraining
2 жыл бұрын
You're very welcome and thank you for your continued support CHITUS!
@ahmednavivwala1707
8 ай бұрын
@@LearnitTraining 1:01:46
This tutorial is well planned and easy to follow! I had been struggling to know when to use certain functions. With there remaining one day for me to certify in Excel Expert, I decided to follow this video and it really helped. Thank you!
@LearnitTraining
2 жыл бұрын
You are very welcome!
@ahmednavivwala1707
8 ай бұрын
@@LearnitTraining 1:00:57
I was looking for Excel 2019 tutorial, lucky to find your site. You have done a awesome job explaining it in detail and giving chance to practice together. No dough you are excellent tutor and keep your audiences engage. They are many utube tutorials on excel but none matches with your. Thank you
@LearnitTraining
2 жыл бұрын
You are welcome!
Great teacher and educational chennel. Please upload pivote table master and expert lever.👏🏽👏🏽👏🏽👍🏾👍🏾👍🏾
Thank you for the detailed and easy to understand module, It really kept me active all the time!!!
@LearnitTraining
3 жыл бұрын
Thank you for watching!
Thanks for intuitive tutorial excels. I haven't used excel for awhile so your tutorials really helped me a lot. So many excel tutorial out there but this one is the best.
@LearnitTraining
2 жыл бұрын
Thank for the kind words Huong! We are glad you learned a lot!
@ahmednavivwala1707
8 ай бұрын
@@LearnitTraining 1:08:24
You guys are amazing. Thank you so much for the free lesson
@LearnitTraining
3 жыл бұрын
Our pleasure and thanks for watching!
Watched all three videos and learned many things. Thank you very much Faz
@LearnitTraining
2 жыл бұрын
Thank you so much for watching Chamath!
D1: IF Functions (Part 2) 15:17 D2: Introduction to VLOOKUP 29:40 D3: Text Functions 46:13 D4: Goal Seek 1:00:31 D5: Macros - Adding the Developer Tab 1:12:28 D6: Macros - Exercise 1:27:38 D7: To go over
@ahmednavivwala1707
8 ай бұрын
1:12:37
Thanks a lot for putting together such a comprehensive training
@LearnitTraining
3 жыл бұрын
Glad it was helpful!
This was a very helpful Excel course. The instruction is clear and the practice assignments reinforce the concepts. I learned a lot!
@LearnitTraining
2 жыл бұрын
We are glad you learned so much! Thank you for watching!
@ahmednavivwala1707
8 ай бұрын
@@LearnitTraining 1:01:06
Thank you so much for caring and sharing of excel learning for your learner!
@LearnitTraining
3 жыл бұрын
My pleasure!
Hi Faz, thank you very much for this beautiful corse . in one word you are awesome!!!
@LearnitTraining
3 жыл бұрын
Thank you too!
Thank you for these amazing videos!
@LearnitTraining
3 жыл бұрын
Glad you like them!
Thank you so much for these Great Tutorials of Excel. I always tried to learn Excel from Other platforms just for the certificate, but always failed to complete it. Then I found your channel and I was so grateful to not only complete the Excel tutorial but also learned the importance of having skill than a certificate. Thank you so very much.
@LearnitTraining
2 жыл бұрын
You're very welcome!
Thanks a lot! Incredibly helpful for me
@LearnitTraining
3 жыл бұрын
You are welcome!
This is soooo helpful!!! Thank you so much!!!
@LearnitTraining
3 ай бұрын
You are very welcome!
Thank you! Appreciated! This help me so much
@LearnitTraining
3 жыл бұрын
You are welcome!
I am looking forward to watching it mate! I am sure that it's going to be another effective tutorial as good as previous tutorials which I'd had watched regarding excel were so cool.
One of the best class on Excel!!!
@LearnitTraining
2 жыл бұрын
Wow, thanks!
Incredibile Course. Easy to understand. Hope to find some other Expert Videos about Excel (Macro&Pivot Tables)! Thanks Faz. From Italy
@LearnitTraining
2 жыл бұрын
Glad you liked it!
It is just perfect and clear!! Thanks a lot 😀
@LearnitTraining
2 жыл бұрын
You're welcome 😊
thank you so much, this was very educational!
@LearnitTraining
3 жыл бұрын
Glad it was helpful!
Thank you so much I had no idea about using excel, and now I can do many things independently)))
@LearnitTraining
2 жыл бұрын
You are very welcome!
This is really helpful!! Thanks!
@LearnitTraining
3 жыл бұрын
You're so welcome!
Excellent tutorial! Nicely paced and easy to follow.
@LearnitTraining
2 жыл бұрын
Glad it was helpful!
@ahmednavivwala1707
8 ай бұрын
@@LearnitTraining 1:08:12
very incredible video, thank you very much!
@LearnitTraining
3 жыл бұрын
You're very welcome!
Thank you so much for this tutorial!
@LearnitTraining
2 жыл бұрын
You are very welcome!
Really helpful... Thank you so much :)
@LearnitTraining
3 жыл бұрын
Glad it was helpful!
You can do Xlookup instead of either Vlookup or Hlookup as Xlookup can look up vertically or horizontally.
I love how you can keep my adhd brain focused with your voice
@LearnitTraining
3 жыл бұрын
Thank you for watching CrudeSplash 55!
@daniel_960_
3 жыл бұрын
yeah it's great. But I also watch it at 1.75 speed 😂
Let take a moment of appreciation to the guy who makes our jobs easier.
@LearnitTraining
3 жыл бұрын
Thank you David!
Fantastic! Thank you!
@LearnitTraining
2 жыл бұрын
You're very welcome!
You're a legend!
@LearnitTraining
3 жыл бұрын
Thank you for the kind words!
Thank you for this tutorial!
@LearnitTraining
2 жыл бұрын
You are so welcome!
Thanks and appreciate !
@LearnitTraining
3 жыл бұрын
You are welcome!
PMT Data Table. Practices grid still needs to use the same order for Months and rates (apparently does not affect the switch between months and rates. I tried but i had to use the same order as Alternative in order to get the same result). Regards
Great video, thank you very much
@LearnitTraining
2 жыл бұрын
You are welcome!
Super Useful!
@LearnitTraining
2 жыл бұрын
Glad it was helpful!
Thank you very much!
@LearnitTraining
3 жыл бұрын
You're welcome!
I have completed Excel Advanced class... Amazing experience
@LearnitTraining
3 жыл бұрын
Great 👍
Thanks Faz. This is an awesome course
@LearnitTraining
Жыл бұрын
Glad you think so!
MUCHAS GRACIAS por adjuntar el archivo y poder seguirlo simultáneamente.
@LearnitTraining
2 ай бұрын
¡Usted es bienvenido!
best excel's tutorial ever
@LearnitTraining
3 жыл бұрын
Glad it was helpful!
Thanks a lot!
@LearnitTraining
3 жыл бұрын
You're welcome!
Was tremendously helpful
@LearnitTraining
2 жыл бұрын
You are very welcome!
Congratulations brother, I really appreciate your clear explanations, you give us what we needed it's really outstanding, I understand. Thanks
@LearnitTraining
Жыл бұрын
You are welcome!
@ahmednavivwala1707
8 ай бұрын
@@LearnitTraining 1:01:23
Thank you very much.
@LearnitTraining
3 жыл бұрын
You are welcome!
Thank you :)
@LearnitTraining
Жыл бұрын
You are welcome!
ini bener" lengkap dan komprehensif, matur nuwun kang learnit.. gusti ingkang bales
@LearnitTraining
Жыл бұрын
Sampeyan olèh!
Number one !!!!
@LearnitTraining
3 жыл бұрын
Thank you Hassan!
Awesome sir.. you made my life easy in my office...
@LearnitTraining
2 жыл бұрын
Happy to help!
Very good, thank you
@LearnitTraining
2 жыл бұрын
Our pleasure!
well explained and easy follow. with this i see no reason for me to start those paying courses. this is just straight forward.
@LearnitTraining
5 ай бұрын
Thanks!
this is the best news in Covid-19 year!
might not understand the PMT yet, but if i do, i think you swaped the rows with columns by mistake on the bigger data set. please let me know
i like ur hard work
@LearnitTraining
Жыл бұрын
Thank you!
Could you also do a video on managing stock using Excel
Can you make time nodes and directories?Please
that was really really great way of teaching. excellent. please start sql also.
@LearnitTraining
3 жыл бұрын
That's the plan!
Great video. I have a problem, when I click on the Visual Basic button, it shows me error;" 'VBE6EXT.OLB' could not be loaded". and when I click okay, it shows me another error; "out of memory"
amazing
@LearnitTraining
3 жыл бұрын
Thank you! Cheers!
thank u for ur guidance, and can you pls show how to enable the search box in excel recent file list view
@ianz9106
3 жыл бұрын
yea you just have to enable DN
Pivot table in advance video tutorial upload
Hi What version of Excel 2019 are you using? My ribbon in my Excel 2019 home version looks different than yours.
@ianz9106
3 жыл бұрын
Hes using Excel DN
how do you draw arrows and/or squares around certain areas of the spreadsheet, during your presentation? Is that an Excel add-in?
@LearnitTraining
3 жыл бұрын
HI Tywin! That is Zoomit!
Your Excel exercise spreadsheet has a Date Function tab, but the video does not cover that tab. How can I find your Date Function video discussion?
Thanx
@LearnitTraining
2 жыл бұрын
👍
Tomorrow is my last chance to pass my excel expert exam! I am studying right before so I’ll update you. If I pass I owe you the world!😅
@LearnitTraining
Жыл бұрын
Good luck!!!!
@StellarStrider
Жыл бұрын
@@LearnitTrainingUpdate: I passed !! Thank you for the knowledge !😄
@ahmednavivwala1707
8 ай бұрын
@@StellarStrider 15:26
@richardparchment275
5 ай бұрын
Can you say more about that exam? How long have you been studying excel to get to that point? Levels, etc.
@StellarStrider
Ай бұрын
So the exam I took was the Certiport one, and it took a lot of functions and whatnot. I studied for I’d say 1 month for regular excel and 1 month for excel expert. It took a few tries, but I passed in the end. Hope this helps
should one focus on 2016 tutorials or 2019 ones? Im not sure how much has changed since 2016
@ianz9106
3 жыл бұрын
2019 ones, but only if you're on the version DN
Hello Faz! How do you draw those arrows with red marker while using the mouse simultaneously? Can you please help?
@LearnitTraining
2 жыл бұрын
Hi Rakib - that app is called Zoomit
@rakibahmedtonmoy3084
2 жыл бұрын
@@LearnitTraining Thanks Faz ! I appreciate your assistance 💙
How do make a title start in the middle of the row. For example, I’m on row b and I’m trying to make one cell start in the middle of row b. How do you do that?
@LearnitTraining
2 жыл бұрын
Hi Sierra! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
Where can I get the file used in the video?
@LearnitTraining
2 жыл бұрын
Hi Catherine - the link to the exercise files is in the video description!
Alrightyyyyyy!
@LearnitTraining
Жыл бұрын
Thank you for watching!
How do you grab the sample file for learning this tutorial?
@LearnitTraining
3 жыл бұрын
Hi Joe! The link to the exercise files is in the video description!
this is entry level excel
@bunkosquad2000
Жыл бұрын
Well, SOMEBODY understands. In no way, shape or form is this an EXPERT tutorial. DO NOT try to take the expert exam by doing this tutorial. If this is new information to you, you are NOT an expert. Keep studying other resources as well.
Where do I get the sample workbook to follow along?
@LearnitTraining
Жыл бұрын
Exercise Files: bit.ly/36ZPKzO
where do i get the F1 function?
@LearnitTraining
2 жыл бұрын
Hi Olushola - F1 is a key on your keyboard
I tryed to doenload files and it would not let me?
@LearnitTraining
8 ай бұрын
Hello Sam! We just tested the files and links. They are currently working
how do l get the sample file to work with as l study with u?
@LearnitTraining
2 жыл бұрын
Hi Adebola! The link to the exercise file is in the video description
Can you please teach me the ms word 2019
@sarthak_chandra
3 жыл бұрын
they do provide videos of it as well
Hi, Can you please check the below question & try to find the solution if possible. Definitions: Client: This is Exotel's client for the call made Call duration: Duration for the call made Vendor: Operator for the call made There are around 2000 random calls samples. Please calculate the following and share the excel: Total revenue from these calls Total cost from these calls Total Margin from these calls (Margin = (revenue - cost)/revenue ) Assumptions Selling rate for Quikr: 40 paise for 60 second pulse Selling rate for Snapdeal: 24 paise for 30 second pulse Selling rate for Flipkart: 10 paise for 15 second pulse Cost from Reliance: 6 paise for 15 second pulse Cost from Aircel: 2 paise for 5 second pulse Cost from Vodafone: .5 paise for 1 second pulse.
How, I get Certificate of completion any course
@LearnitTraining
3 жыл бұрын
HI Amit - you can join our Patreon and the Bronze level offers the ability to earn certificates of completion
hello , How I can get this sample file please
@LearnitTraining
3 жыл бұрын
Hi Saman - the link to the files is in the video description
how can i write a formula that only compares 2 cells in a given row that will have 4 values? For example, cell B1 has a value of 6 and C1 has a value of 2. the "Difference cell" will total C1-B1 = -4. then when i add a value of 3 into cell D1 of 3, the "difference cell" will total D1-C1 = 1. then when i add a value of 3 into cell E1, the "difference cell" will total E1-D1 = 0. Hope this makes sense lol
@LearnitTraining
Жыл бұрын
Hello Chad! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Ms word in master video upload
can u upload the exercise file again....?
@LearnitTraining
2 жыл бұрын
Hi Imran - we tested the link to the files and it is working
I notice there's no XLOOKUP?
@EnjoyTheSound2010
3 жыл бұрын
Excel 365 only
great tutorial but too many ads
@LearnitTraining
2 жыл бұрын
Noted
sir ek formula bta skte ho
Hi there, how are you doin? very good video!! Would like to ask if there's a way to import an .txt file in which the text is divided only by space? Some like: aaa aaa aaaa 12332
exercise file is missing
@LearnitTraining
2 жыл бұрын
Hi Ashraf! We just tested the link and the exercise files are working fine currently
11:26 28:15 44:44
I wonder why u hate using the formulas from the function library. Your approach to formulas makes it look more complicated especially for a beginner. You can make it more interesting if u demonstrate the formulas by typing and from the function library
@olivienecowan3515
4 жыл бұрын
If you watch the Advanced 2016 tutorial you will understand better, they use the functions library. I understood this because of the 2016 tutorial.
@kensimba7868
3 жыл бұрын
I can advise u'all to search for those tutorials done by Chelsea Dohnmann and will look for other eloquent ones. Unfortunately Faiz doesn't simplify it the best to a beginner