Excel Intermediate Tutorial
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Exercise Files: https://learnitanytime.com/p/exercise-files-excel-intermediate-tutorial-2024
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:
https://www.learnitanytime.com
For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops
Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:09
Creating Tables 0:54
Flash Fill 7:54
Introduction to Sorting Data 12:01
SORT Function 18:45
SORTBY Function 21:32
UNIQUE Function 23:21
Filters 25:44
Slicers 31:11
Subtotals 34:53
Quick Analysis Tool 40:01
Inserting Charts 41:11
Formatting Charts 43:33
Creating Chart Templates 49:30
Printing Charts 51:15
Using Sparklines 52:29
Introduction to Pivot Tables 56:28
Pivot Charts 1:04:43
Using Slicers with Pivot Tables 1:07:40
Data Validation 1:11:53
Conditional Formatting 1:23:36
Custom Conditional Formatting 1:27:16
Linking Data 1:31:51
Conclusion 1:33:39
#excel #exceltutorial #exceltips #exceltricks
(C) 2024 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.