Excel Full Course Tutorial (4+ Hours)
117,197
Published 2024-04-26
Get Ad-Free Training by becoming a member today!
youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Exercise Files: learnitanytime.com/p/exercise-files-excel-full-cou…
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:
www.learnitanytime.com/
For Private Group Trainings please visit:
www.learnit.com/private-group-classes-workshops
Manuals: bit.ly/30xZb59
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.
All Comments (21)
-
Exercise Files: learnitanytime.com/p/exercise-files-excel-full-cou…
-
This is the only video so far on the internet for excel where I didn't get bored.
-
Returning to finish the course, this is really good and detailed information.
-
Thank you. i learned a lot❤❤❤ about this course
-
Great tutorial for Excel, thanks Joe!
-
Thank God for this class.. even though my autofill is not working ugggh.. But this is a God sent
-
i enjoyed the class, you really are God sent
-
waiting for this
-
Amazing tutorial,thank you a million times.
-
Waiting 😊
-
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 ❤
-
Thank you learnit
-
3:34:49 great vid, quick Q, why was it necessary to use absolute for rep and region? What would happen if it was omitted?
-
Good thanks
-
Really helpful lecture A humble request: Can you please improve audio quality
-
good stuff here, thanks
-
Waiting for This
-
@LearnitTraining man, upgrade your mic. Its an excellent tutorial but the audio quality sucks.
-
To anyone watching ×1.25 is the perfect speed.
-
Hi, I have an Excel workbook with multiple worksheets. On worksheet One, I want to add buttons to click that will take me to the other worksheets. How can I do that? Thanks