Excel Advanced Tutorial

Excel Advanced Tutorial

Get Ad-Free Training by becoming a member today!

Who it's for: Beginners, as well as experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.

What it is: Microsoft’s spreadsheet application used to organize and analyze data.

What you'll learn: We start with the basics, showing you Excel’s interface and the best 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 Intermediate section, we show you the various tools and ways to sort and filter data in a timely manner. Next, we cover Charts and Sparklines, along with some tips on presenting data in Excel. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Advanced training starts with an overview of XLOOKUP, a vital function for modern-day Excel users. After that, we explore complex Database functions, provide you with an introduction to Macros, and demonstrate how to save time by automating common Excel tasks.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:

For Private Group Trainings please visit:

Username: manuals
Password: password

Start 0:00
Introduction 0:09
Named Ranges 0:51
Multiple Named Ranges 5:30
XLOOKUP 8:01
Data Mining with XLOOKUP 16:08
IF Function 24:01
Database Functions 31:15
Goal Seek 39:39
PMT Data Tables 44:01
Macros 49:01
IF-THEN Statements 55:38
Do Until Loops 1:03:25
Creating Games with Excel VBA Code 1:09:50
Conclusion 1:16:41

#excel #exceltutorial #exceltips #exceltricks

(C) 2024 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.

[iamferdico]

One of the best video tutorials for Excel, from their beginner, intermediate, advanced and expert... Very detailed and highly skilled

[FelixAbloh]

Great video, i still can't believe that this content is free. Thank u so much

[musicdaisukii]

I learned a lot from this! Thank you so much

[leandraeden]

I can only imagine how many have been able to secure jobs because of your excel videos. I know I'm one of them. Thank you Joe.

[broinator]

One of the first youtube videos I was actually excitedly waiting for! Been very grateful for this tutorial, my skills have improved in such a short period of time.

[emmanouilkalafatis]

Introduction to code is awesome. A whole new world...

[belovedsoniathewriter]

This was a very helpful tutorial. Thank you! 👍🏼

[rasmia]

In the Macros section, it is needed to go to Tools - Options and uncheck Require Variable Declaration if the "Option Explicit" is activated, otherwise you have an error.

[mohammadvaziri]

Thank you so much for your informative and excellent presentation.

[Kwintessential]

For x lookup what if you want to see all instances of the notebook listed?

[yosaherak]

35:50 why don't we use absolute reference just like in the xlookup? what's the difference?

[lyubomirhristov]

Mate how you autofill all this 4300 columns which buttons you have been using?

[ianfarnsworth]

I would suggest rather than doing multiple if functions you could have demonstrated ifs function

[deepakmishra]

Start using a better mic. Great quality content though. ❤

[IbrahimAhmed-uv]

in XLOOKUP data mining you forget to add units to price

[nickmak]

The f4 function is not working for me not sure why?! Any idea about it please! Thank you🙏🏻

[dude-vhvz]

why you guys are skipping vlookup in all your videos? plus please get a new mic while you're at it.

[moletetefo]

Please do the freak off party where there are other rappers🤭...

[swoop-in]

already beginner excel tutorial waş too much and now this is way too much