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.

[@PatriziaValMadiona]

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]

Thank you for watching and thank you for subscribing!

[@ahmednavivwala1707]

@@LearnitTraining 1:01:36

[@malts100]

Thank you so much, really appreciate the time and effort for completing this useful tutorials for us. :)

[@thinzartheinttheintthu9410]

I do appreciate your time and effort in creating this fruitful tutorial. You rock!

[@LearnitTraining]

We appreciate that!

[@ahmednavivwala1707]

@@LearnitTraining 1:01:14

[@danblas1071]

Are you kidding!!!! This is FANTASTIC! The samples are PHENOMINAL & dude is crystal clear! Thanks so much!!

[@LearnitTraining]

Wow, thank you!

[@hollydunne2687]

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]

Glad it was helpful!

[@ahmednavivwala1707]

@@LearnitTraining 1:00:36

[@thisissyedbasim]

Thank you sooo much for this wonderful course. Really enjoyed learning it!

[@LearnitTraining]

You're very welcome!

[@habibsicttutorials6684]

Another effective tutorial on Microsoft Excel. Being an ICT tutor myself, I believe alot of us will benefit from this. Thank you

[@jasmine1370]

Great teacher and educational chennel. Please upload pivote table master and expert lever.👏🏽👏🏽👏🏽👍🏾👍🏾👍🏾

[@huongphan1278]

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]

Thank for the kind words Huong! We are glad you learned a lot!

[@ahmednavivwala1707]

@@LearnitTraining 1:08:24

[@Ruru-zp3ol]

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]

You are very welcome!

[@ahmednavivwala1707]

@@LearnitTraining 1:00:57

[@ernestosabatercalvet]

Thank you for the detailed and easy to understand module, It really kept me active all the time!!!

[@LearnitTraining]

Thank you for watching!

[@MehmetAliMD]

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.

[@rubyshoukat5753]

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]

You are welcome!

[@miks65]

Thanks a lot for putting together such a comprehensive training

[@LearnitTraining]

Glad it was helpful!

[@jonathanowen9917]

This was a very helpful Excel course. The instruction is clear and the practice assignments reinforce the concepts. I learned a lot!

[@LearnitTraining]

We are glad you learned so much! Thank you for watching!

[@ahmednavivwala1707]

@@LearnitTraining 1:01:06

[@THAONGUYEN-hx2kj]

You guys are amazing. Thank you so much for the free lesson

[@LearnitTraining]

Our pleasure and thanks for watching!

[@chamathwickramasinghe6613]

Watched all three videos and learned many things. Thank you very much Faz

[@LearnitTraining]

Thank you so much for watching Chamath!

[@yuniol1116]

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]

1:12:37

[@hpourmamih]

Hi Faz, thank you very much for this beautiful corse . in one word you are awesome!!!

[@LearnitTraining]

Thank you too!

[@crudesplash5583]

I love how you can keep my adhd brain focused with your voice

[@LearnitTraining]

Thank you for watching CrudeSplash 55!

[@daniel_960_]

yeah it's great. But I also watch it at 1.75 speed 😂

[@kafamyanmar1758]

Thank you so much for caring and sharing of excel learning for your learner!

[@LearnitTraining]

My pleasure!

[@liptonmckain190]

Excellent tutorial! Nicely paced and easy to follow.

[@LearnitTraining]

Glad it was helpful!

[@ahmednavivwala1707]

@@LearnitTraining 1:08:12

[@tui_la_dua]

This is soooo helpful!!! Thank you so much!!!

[@LearnitTraining]

You are very welcome!

[@kevincooper3469]

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]

You're very welcome!

[@MrGiallogrigio]

Incredibile Course. Easy to understand. Hope to find some other Expert Videos about Excel (Macro&Pivot Tables)! Thanks Faz. From Italy

[@LearnitTraining]

Glad you liked it!

[@Magnenat13]

Thank you for these amazing videos!

[@LearnitTraining]

Glad you like them!

[@inigoromeromoreno2127]

Thanks a lot! Incredibly helpful for me

[@LearnitTraining]

You are welcome!

[@chutatipwattana399]

Thank you! Appreciated! This help me so much

[@LearnitTraining]

You are welcome!

[@abuzakariyo6906]

Thank you so much I had no idea about using excel, and now I can do many things independently)))

[@LearnitTraining]

You are very welcome!

[@10maxnyc]

You can do Xlookup instead of either Vlookup or Hlookup as Xlookup can look up vertically or horizontally.

[@davidnathanael3814]

One of the best class on Excel!!!

[@LearnitTraining]

Wow, thanks!

[@Nipy1]

Let take a moment of appreciation to the guy who makes our jobs easier.

[@LearnitTraining]

Thank you David!

[@sindicindy325]

It is just perfect and clear!! Thanks a lot 😀

[@LearnitTraining]

You're welcome 😊

[@despoinapp]

thank you so much, this was very educational!

[@LearnitTraining]

Glad it was helpful!

[@miodragivanovic3973]

Thank you so much for this tutorial!

[@LearnitTraining]

You are very welcome!

[@tommynugraha7593]

very incredible video, thank you very much!

[@LearnitTraining]

You're very welcome!

[@jen-lichen8163]

This is really helpful!! Thanks!

[@LearnitTraining]

You're so welcome!

[@dionwebiaswara7810]

ini bener" lengkap dan komprehensif, matur nuwun kang learnit.. gusti ingkang bales

[@LearnitTraining]

Sampeyan olèh!

[@tetocaloscojones8229]

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

[@user-zv1jr5fj5s]

well explained and easy follow. with this i see no reason for me to start those paying courses. this is just straight forward.

[@LearnitTraining]

Thanks!

[@pasindunimshan3708]

Really helpful... Thank you so much :)

[@LearnitTraining]

Glad it was helpful!

[@rushinwe]

Fantastic! Thank you!

[@LearnitTraining]

You're very welcome!

[@ciroadolfo01]

MUCHAS GRACIAS por adjuntar el archivo y poder seguirlo simultáneamente.

[@LearnitTraining]

¡Usted es bienvenido!

[@amitduttabanik7675]

I have completed Excel Advanced class... Amazing experience

[@LearnitTraining]

Great 👍

[@TheEllieBug]

Thank you for this tutorial!

[@LearnitTraining]

You are so welcome!

[@faisalym]

Thanks Faz. This is an awesome course

[@LearnitTraining]

Glad you think so!

[@chowa3686]

Thanks and appreciate !

[@LearnitTraining]

You are welcome!

[@modestekitenge5004]

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]

@@LearnitTraining 1:01:23

[@miosz9504]

best excel's tutorial ever

[@LearnitTraining]

Glad it was helpful!

[@monicachau4416]

Thank you very much!

[@LearnitTraining]

You're welcome!

[@Silas832]

Great video, thank you very much

[@LearnitTraining]

You are welcome!

[@nanogaminghd4286]

Could you also do a video on managing stock using Excel

[@KVKKarthikeyan]

Awesome sir.. you made my life easy in my office...

[@LearnitTraining]

Happy to help!

[@hakanaltintas1]

Super Useful!

[@LearnitTraining]

Glad it was helpful!

[@tman054]

You're a legend!

[@LearnitTraining]

Thank you for the kind words!

[@Vortex__24]

Was tremendously helpful

[@LearnitTraining]

You are very welcome!

[@auroradsouza8927]

Thank you very much.

[@LearnitTraining]

You are welcome!

[@diegojulio994]

Can you make time nodes and directories?Please

[@aiahaj7]

Thanks a lot!

[@LearnitTraining]

You're welcome!

[@googleuser5299]

Very good, thank you

[@LearnitTraining]

Our pleasure!

[@norberthubapeter4650]

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

[@ryansarwar6814]

that was really really great way of teaching. excellent. please start sql also.

[@LearnitTraining]

That's the plan!

[@ikrambariqadrishazli4889]

i like ur hard work

[@LearnitTraining]

Thank you!

[@alexjaviertirado]

Thank you :)

[@LearnitTraining]

You are welcome!

[@josephm.6453]

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"

[@relaxplaning7755]

thank u for ur guidance, and can you pls show how to enable the search box in excel recent file list view

[@ianz9106]

yea you just have to enable DN

[@oshogabriel5154]

this is the best news in Covid-19 year!

[@hpourmamih]

Number one !!!!

[@LearnitTraining]

Thank you Hassan!

[@j.o.deoliveira374]

how do you draw arrows and/or squares around certain areas of the spreadsheet, during your presentation? Is that an Excel add-in?

[@LearnitTraining]

HI Tywin! That is Zoomit!

[@dibyanshyadav281]

Pivot table in advance video tutorial upload

[@F3RMusic]

amazing

[@LearnitTraining]

Thank you! Cheers!

[@fmih]

Hi What version of Excel 2019 are you using? My ribbon in my Excel 2019 home version looks different than yours.

[@ianz9106]

Hes using Excel DN

[@joedeganahl9863]

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?

[@rakibahmedtonmoy3084]

Hello Faz! How do you draw those arrows with red marker while using the mouse simultaneously? Can you please help?

[@LearnitTraining]

Hi Rakib - that app is called Zoomit

[@rakibahmedtonmoy3084]

@@LearnitTraining Thanks Faz ! I appreciate your assistance 💙

[@a.alizadeh3240]

Thanx

[@LearnitTraining]

👍

[@StellarStrider]

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]

@@StellarStrider 15:26

[@richardparchment275]

Can you say more about that exam? How long have you been studying excel to get to that point? Levels, etc.

[@jacobm7026]

should one focus on 2016 tutorials or 2019 ones? Im not sure how much has changed since 2016

[@ianz9106]

2019 ones, but only if you're on the version DN

[@joeennin3835]

How do you grab the sample file for learning this tutorial?

[@LearnitTraining]

Hi Joe! The link to the exercise files is in the video description!

[@SierraSl]

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]

Hi Sierra! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com

[@catherinefisher2752]

Where can I get the file used in the video?

[@LearnitTraining]

Hi Catherine - the link to the exercise files is in the video description!

[@AI-ec2qb]

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.

[@enzofrancescoli1260]

Alrightyyyyyy!

[@LearnitTraining]

Thank you for watching!

[@allenwoods2290]

Where do I get the sample workbook to follow along?

[@LearnitTraining]

Exercise Files: bit.ly/36ZPKzO

[@olusholaoyelohunnu8549]

where do i get the F1 function?

[@LearnitTraining]

Hi Olushola - F1 is a key on your keyboard

[@kanchanjha4443]

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.

[@chadclemens3107]

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

[@mahmoodzadran9945]

Can you please teach me the ms word 2019

[@sarthak_chandra]

they do provide videos of it as well

[@samankumara2109]

hello , How I can get this sample file please

[@LearnitTraining]

Hi Saman - the link to the files is in the video description

[@adebolalawal8507]

how do l get the sample file to work with as l study with u?

[@LearnitTraining]

Hi Adebola! The link to the exercise file is in the video description

[@samshepherd6197]

I tryed to doenload files and it would not let me?

[@LearnitTraining]

Hello Sam! We just tested the files and links. They are currently working

[@amitduttabanik7675]

How, I get Certificate of completion any course

[@LearnitTraining]

HI Amit - you can join our Patreon and the Bronze level offers the ability to earn certificates of completion

[@ImranKhan-hj7oq]

can u upload the exercise file again....?

[@LearnitTraining]

Hi Imran - we tested the link to the files and it is working

[@rickys3507]

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

[@dibyanshyadav281]

Ms word in master video upload

[@neharani1444]

sir ek formula bta skte ho

[@medisagas]

I notice there's no XLOOKUP?

[@EnjoyTheSound2010]

Excel 365 only

[@ashrafuddin1441]

exercise file is missing

[@LearnitTraining]

Hi Ashraf! We just tested the link and the exercise files are working fine currently

[@csc3745]

great tutorial but too many ads

[@LearnitTraining]

Noted

[@likhithlicky2947]

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

[@LearnitTraining]

Thanks for letting us know! We'll look into this issue.

[@bhaimohsin]

11:26 28:15 44:44