Excel Intermediate Tutorial

Get ad-free training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join

Practice files: https://learnitanytime.com/p/exercise-files-excel-intermediate-tutorial-2024

Who it's for: Beginners as well as experienced, everyday users who want 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'll start with the basics and show you Excel's interface and the best ways to navigate. Once you're comfortable with the layout of the software, we'll quickly move on to calculating data with basic formulas and functions. In the Intermediate section, we will show you the different tools and ways to sort and filter data in a timely manner. Next, we'll cover Charts and Sparklines, along with some tips for presenting data in Excel. Next, we'll dive into one of Excel's most popular features; the pivot table. Our advanced training begins with an overview of XLOOKUP, an essential feature for modern Excel users. Then we'll explore complex database functions, give you an introduction to macros, and show you 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 training, please visit:
https://www.learnit.com/private-group-classes-workshops

Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password

Start 0:00 am
Introduction 0:09
Creating Tables 0:54
Flash Fill 7:54
Introduction to data sorting 12:01
SORT Function 18:45
SORTBY Function 21:32
UNIQUE Function 23:21
Filters 25:44
Cutters 31:11
Subtotals 34:53
Quick Analysis Tool 40:01
Insert Graphs 41:11
Format Graphs 43:33
Create chart templates 49:30
Print Graphs 51:15
Using Sparklines 52:29
Introduction to PivotTables 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.

Please take the opportunity to connect and share this video with your friends and family if you find it helpful.