Excel 2019 Expert Tutorial
HTML-код
- Опубликовано: 6 июл 2024
- 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.
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!
Thank you for watching and thank you for subscribing!
@@LearnitTraining 1:01:36
Thank you so much, really appreciate the time and effort for completing this useful tutorials for us. :)
Are you kidding!!!! This is FANTASTIC! The samples are PHENOMINAL & dude is crystal clear! Thanks so much!!
Wow, thank you!
Thank you sooo much for this wonderful course. Really enjoyed learning it!
You're very welcome!
I do appreciate your time and effort in creating this fruitful tutorial. You rock!
We appreciate that!
@@LearnitTraining 1:01:14
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.
Glad it was helpful!
@@LearnitTraining 1:00:36
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!
You are very welcome!
@@LearnitTraining 1:00:57
You guys are amazing. Thank you so much for the free lesson
Our pleasure and thanks for watching!
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!!!
Thank you for watching!
Thanks a lot for putting together such a comprehensive training
Glad it was helpful!
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
You are welcome!
Watched all three videos and learned many things. Thank you very much Faz
Thank you so much for watching Chamath!
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.
Thank for the kind words Huong! We are glad you learned a lot!
@@LearnitTraining 1:08:24
Thank you so much for caring and sharing of excel learning for your learner!
My pleasure!
This was a very helpful Excel course. The instruction is clear and the practice assignments reinforce the concepts. I learned a lot!
We are glad you learned so much! Thank you for watching!
@@LearnitTraining 1:01:06
Another effective tutorial on Microsoft Excel. Being an ICT tutor myself, I believe alot of us will benefit from this. Thank you
You're very welcome and thank you for your continued support CHITUS!
@@LearnitTraining 1:01:46
Hi Faz, thank you very much for this beautiful corse . in one word you are awesome!!!
Thank you too!
Thank you for these amazing videos!
Glad you like them!
Thanks a lot! Incredibly helpful for me
You are welcome!
Thank you! Appreciated! This help me so much
You are welcome!
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.
You're very 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.
Let take a moment of appreciation to the guy who makes our jobs easier.
Thank you David!
This is soooo helpful!!! Thank you so much!!!
You are very welcome!
thank you so much, this was very educational!
Glad it was helpful!
Incredibile Course. Easy to understand. Hope to find some other Expert Videos about Excel (Macro&Pivot Tables)! Thanks Faz. From Italy
Glad you liked it!
Thank you so much I had no idea about using excel, and now I can do many things independently)))
You are very welcome!
It is just perfect and clear!! Thanks a lot 😀
You're welcome 😊
Excellent tutorial! Nicely paced and easy to follow.
Glad it was helpful!
@@LearnitTraining 1:08:12
One of the best class on Excel!!!
Wow, thanks!
I love how you can keep my adhd brain focused with your voice
Thank you for watching CrudeSplash 55!
yeah it's great. But I also watch it at 1.75 speed 😂
very incredible video, thank you very much!
You're very welcome!
You can do Xlookup instead of either Vlookup or Hlookup as Xlookup can look up vertically or horizontally.
Thank you so much for this tutorial!
You are very welcome!
This is really helpful!! Thanks!
You're so 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
Really helpful... Thank you so much :)
Glad it was helpful!
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
1:12:37
Fantastic! Thank you!
You're very welcome!
Thanks and appreciate !
You are welcome!
Thank you for this tutorial!
You are so welcome!
Great video, thank you very much
You are welcome!
Can you make time nodes and directories?Please
Thanks Faz. This is an awesome course
Glad you think so!
best excel's tutorial ever
Glad it was helpful!
Thank you very much!
You're welcome!
I have completed Excel Advanced class... Amazing experience
Great 👍
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
You're a legend!
Thank you for the kind words!
Super Useful!
Glad it was helpful!
Could you also do a video on managing stock using Excel
Congratulations brother, I really appreciate your clear explanations, you give us what we needed it's really outstanding, I understand. Thanks
You are welcome!
@@LearnitTraining 1:01:23
Thanks a lot!
You're welcome!
Thank you very much.
You are welcome!
Was tremendously helpful
You are very welcome!
Awesome sir.. you made my life easy in my office...
Happy to help!
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"
MUCHAS GRACIAS por adjuntar el archivo y poder seguirlo simultáneamente.
¡Usted es bienvenido!
Very good, thank you
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.
Thanks!
Number one !!!!
Thank you Hassan!
that was really really great way of teaching. excellent. please start sql also.
That's the plan!
Thank you :)
You are welcome!
i like ur hard work
Thank you!
thank u for ur guidance, and can you pls show how to enable the search box in excel recent file list view
yea you just have to enable DN
Hi
What version of Excel 2019 are you using? My ribbon in my Excel 2019 home version looks different than yours.
Hes using Excel DN
ini bener" lengkap dan komprehensif, matur nuwun kang learnit.. gusti ingkang bales
Sampeyan olèh!
Pivot table in advance video tutorial upload
how do you draw arrows and/or squares around certain areas of the spreadsheet, during your presentation? Is that an Excel add-in?
HI Tywin! That is Zoomit!
this is the best news in Covid-19 year!
should one focus on 2016 tutorials or 2019 ones? Im not sure how much has changed since 2016
2019 ones, but only if you're on the version DN
amazing
Thank you! Cheers!
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?
Hello Faz! How do you draw those arrows with red marker while using the mouse simultaneously? Can you please help?
Hi Rakib - that app is called Zoomit
@@LearnitTraining Thanks Faz ! I appreciate your assistance 💙
How do you grab the sample file for learning this tutorial?
Hi Joe! The link to the exercise files is in the video description!
Thanx
👍
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?
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?
Hi Catherine - the link to the exercise files is in the video description!
Can you please teach me the ms word 2019
they do provide videos of it as well
Where do I get the sample workbook to follow along?
Exercise Files: bit.ly/36ZPKzO
Alrightyyyyyy!
Thank you for watching!
this is entry level excel
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.
hello , How I can get this sample file please
Hi Saman - the link to the files is in the video description
where do i get the F1 function?
Hi Olushola - F1 is a key on your keyboard
I notice there's no XLOOKUP?
Excel 365 only
how do l get the sample file to work with as l study with u?
Hi Adebola! The link to the exercise file is in the video description
How, I get Certificate of completion any course
HI Amit - you can join our Patreon and the Bronze level offers the ability to earn certificates of completion
can u upload the exercise file again....?
Hi Imran - we tested the link to the files and it is working
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
Hello Chad! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
I tryed to doenload files and it would not let me?
Hello Sam! We just tested the files and links. They are currently working
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!😅
Good luck!!!!
@@LearnitTrainingUpdate: I passed !! Thank you for the knowledge !😄
@@StellarStrider 15:26
Can you say more about that exam? How long have you been studying excel to get to that point? Levels, etc.
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
Ms word in master video upload
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
Hi Ashraf! We just tested the link and the exercise files are working fine currently
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.
great tutorial but too many ads
Noted
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
If you watch the Advanced 2016 tutorial you will understand better, they use the functions library. I understood this because of the 2016 tutorial.
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
hi dear team,,i found out some wrong calculation in the consolidate table,,,,total should be like 3,700..5,200...8,500...3,400.....for q1, q2, q3, q4, respectively please checek...
Thanks for letting us know! We'll look into this issue.