Excel Full Course Tutorial (4+ Hours)

Excel Full Course Tutorial (4+ Hours)

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
What is Excel? 1:16
Excel Interface Overview 2:40
Search and Help 9:06
Navigating and Selecting Cells 11:48
Entering, Replacing, and Deleting Data 16:05
Adjusting Cells 25:56
Calculations, Formulas, and Functions 30:29
Basic Functions 43:31
AutoFill 50:39
Relative and Absolute Cell Reference 55:05
Saving and Sharing Workbooks 1:01:13
Comments 1:05:11
Inserting Rows and Columns 1:07:39
Cut, Copy, and Paste 1:10:33
Formatting Data with Cell Styles 1:14:35
Managing Worksheets 1:20:28
Hiding Row and Columns 1:25:04
Creating Custom Views 1:26:57
Reviewing Worksheets 1:30:24
Printing Worksheets 1:33:37
Conclusion 1:38:19
Introduction 1:38:27
Creating Tables 1:38:43
Flash Fill 1:45:43
Introduction to Sorting Data 1:49:50
SORT Function 1:56:35
SORTBY Function 1:59:21
UNIQUE Function 2:01:10
Filters 2:03:33
Slicers 2:09:00
Subtotals 2:12:42
Quick Analysis Tool 2:17:51
Inserting Charts 2:19:00
Formatting Charts 2:21:22
Creating Chart Templates 2:27:19
Printing Charts 2:29:04
Using Sparklines 2:30:18
Introduction to Pivot Tables 2:34:17
Pivot Charts 2:42:32
Using Slicers with Pivot Tables 2:45:29
Data Validation 2:49:42
Conditional Formatting 3:01:25
Custom Conditional Formatting 3:05:05
Linking Data 3:09:40
Conclusion 3:11:28
Introduction 3:12:00
Named Ranges 3:12:14
Multiple Named Ranges 3:16:53
XLOOKUP 3:19:23
Data Mining with XLOOKUP 3:27:30
IF Function 3:35:23
Database Functions 3:42:37
Goal Seek 3:51:01
PMT Data Tables 3:55:23
Macros 4:00:24
IF-THEN Statements 4:07:00
Do Until Loops 4:14:48
Creating Games with Excel VBA Code 4:21:12
Conclusion 4:28:04

#excel #exceltutorial #exceltips #exceltricks

(C) 2024 Learnit, Inc.

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

[mysterio]

This is the only video so far on the internet for excel where I didn't get bored.

[learningtogetheredu]

Who is here 2024 learning. Thank you for a well explained video. Let's keep learning

[mirza]

one of the best video right now for new learners, amazing

[zz-]

You're the absolute best Excel teacher for beginners, I can't thank you enough💙

Give Joe Patti a raise @LearnitTraining

[stevensalas]

If you want a quick refresh of intermediate and beginner excel skills... this is your video. You just need patience and willingness to learn

[mr.o.]

Thank you so much. The best video out there for leveling up real quick

[Kwintessential]

Returning to finish the course, this is really good and detailed information.

[johnrafimbi]

i enjoyed the class, you really are God sent

[janikiawoods]

Thank God for this class.. even though my autofill is not working ugggh.. But this is a God sent

[RCSMgmt]

You're like the Bob Ross of Excel. Thank you.

[bolvictor]

Iam so glade to have attended this course, I have benefited a lot

[Iliketosaynish]

Excellent video. Great teaching style.
Dr. Hussain

[Nooriya-osod]

Really helpful lecture
A humble request: Can you please improve audio quality

[homelander]

This video was definitely awesome & I learned the beginner level very well without any doubt.. Still halfway to go.. Will reply on this comment after completing the whole video ❤

[power-reconcile]

Great tutorial for Excel, thanks Joe!

[CelestinaRichard]

Amazing tutorial, thank you a million times.

[imiiab]

Thank you. i learned a lot❤❤❤ about this course

[kmyst]

To anyone watching ×1.25 is the perfect speed.

[alliance]

9:08
25:58
43:31
1:01:15
1:25:05
1:45:45

[KhalidKhalil-ze]

It is a very good program, the caption is coming up on screen, I mean whatever Mr. Kevin says it shows up at the bottom of screen that covers many things. How do we turn off the caption?