Excel Basics
-
Welcome and Important Information
-
All about getting Started with Excel (12:12)
-
All About Working With Worksheets (8:43)
-
All About Copy and Paste Functions (11:12)
-
All About Free Excel Templates (5:16)
-
[Excel Trick] Set Up Quick Access Toolbar (7:23)
-
[Excel Trick] Create Your Own Tab (7:19)
-
Quiz to Review Excel Basics
-
Important Update for Customers Only
Formatting Cells
Control Worksheet View
-
How to Freeze Split Or Hide Rows & Columns (9:28)
-
View 2 Excel Worksheets From the Same File (4:47)
-
Arrange or View 2 Files Side by Side (5:18)
-
[Excel Trick] Custom View in Excel (4:29)
-
How to Hyperlink To Another Sheet (7:48)
-
[Excel Trick] Create Table of Contents Fast (5:00)
-
Quiz on Control Worksheet View
Working with Cells and Ranges
-
Understanding Cell Reference In Excel (12:55)
-
How to Use Autofill in Excel (14:29)
-
4 Things To Know About Flash Fill (12:42)
-
Creating and Working with Named Ranges (12:51)
-
How to Insert Cell Comments And Notes (7:01)
-
Adding Excel Tooltip for Cells (3:57)
-
Excel Speak Cells Feature (5:28)
-
[Excel Trick] How to Remove Numbers from Text Strings (4:39)
-
Quiz on Cells and Ranges
Working with Data Tools
-
Basics of Data Sorting (12:18)
-
Data Sorting with Custom Lists (4:58)
-
Filters in Excel 2016 (Basic & Advanced) (9:30)
-
How to Filter Blank Cells in Excel (6:03)
-
How to do Advanced Filter (10:58)
-
How To Delete Duplicates (6:04)
-
How to Extract Unique Values From A Column (2:30)
-
[Excel Trick] Converting Text To Columns (7:59)
-
[Excel Trick] Add Subtotals to Cells (5:22)
-
[Excel Trick] Insert Blank Rows After Each Customer Automatically (4:08)
-
How to Convert Text to Numbers (7:02)
-
3 Quick Tips to Save Time ( Filter | Find & Replace | Paste) (4:58)
-
Quiz on Data Tools
Mastering Tables
[FORMULAS] Formulas for Logical Tests
[FORMULAS] Formulas for Text and Dates
[FORMULAS] Count and Sum Functions
[FORMULAS] Functions to Lookup Values
-
VLOOKUP with Exact Match (13:41)
-
Vlookup with Approximate Match (4:52)
-
VLOOKUP function Best Practices and Issues (11:51)
-
HLOOKUP for Horizontal Lookup (3:14)
-
LOOKUP Function (Backward Compatible function) (9:07)
-
MATCH Function (8:27)
-
Combining Vlookup And Match Functions (8:56)
-
INDEX Function (7:56)
-
Combining Index And Match Functions (10:35)
-
INDIRECT Function (6:13)
-
INDIRECT And VLOOKUP Functions (6:12)
-
[Microsoft 365] Super Useful Xlookup Function (16:02)
-
[Microsoft 365] New Xmatch Function (8:30)
[FORMULAS] *Special* CHOOSE Function for Lookup
[FORMULAS] Functions to Audit Errors
[FORMULAS] Ranking & Randomization
Data Validation Tools
-
How to Restrict Data Entered with Data Validation Tool (12:22)
-
2 Create Drop Down List with Color (6:21)
-
How To Set Up Custom Data Validation (14:06)
-
Avoid Duplicate Entries using Data Validation (4:31)
-
Create Dynamic List with Tables in Data Validation (9:57)
-
[Advanced] Create Dependent Dropdown list (10:26)
-
[Advanced] How to Circle Invalid Data (4:24)
-
Quiz on Data Validation Tools
[PIVOT TABLES] Basics to Advanced
-
Pivot Table Design Tricks (5:32)
-
Basics of Pivot Tables (15:09)
-
How to Group by Dates (for Reports) (6:59)
-
How to Group by Numbers (for Reports) (5:45)
-
Create a Calculated Field in Pivot Table (3:48)
-
Auto-generate Report Filter Pages (7:07)
-
[Tips] 9 Useful Excel Pivot Table Tips (15:18)
-
[Advanced] Generate Smarter Serial Numbers (4:23)
-
[Advanced] Slicers to Filter Tables Conveniently (13:04)
-
[Advanced] PivotTable Timeline to Filter Dates (4:02)
-
How to create Interactive Pivot Charts in Excel (9:33)
-
Quiz on Pivot Tables
Conditional Formatting
-
Basics of Conditional Formatting (9:53)
-
Conditional Formatting : With Formulas (8:20)
-
[Advanced] How to Highlight Rows or Columns (6:59)
-
Conditional Formatting : Data Bars (10:21)
-
Conditional Formatting with Icon Sets (10:43)
-
[Advanced] Create Interactive Highlight (7:13)
-
How to Highlight Alternate Rows (6:13)
-
Quiz on Conditional Formatting
[CHARTS] Data Charts & InCell Charts in Excel
-
All About Excel Chart Basics (12:41)
-
How to copy Chart Formatting in Excel (2:15)
-
Working with Line Charts in Excel (10:25)
-
Working with Column Charts (8:55)
-
7 Tips for Pie Charts (9:16)
-
[Incell Charts] Create Sparklines (8:43)
-
[InCell Charts] Bar Charts with Formula (4:44)
-
[InCell Charts] Surplus Deficit Charts (2:56)
-
Quiz on Charts
Data Consolidation Tools
How to Protect Your Content
How to Print Excel Files like a PRO
-
Repeat Row Column Titles On Every Printed Page (4:24)
-
How To Set Print Area In Excel Like A Pro (3:47)
-
How To Print Gridlines In Excel (1:59)
-
How To Insert Header And Footer In Excel (11:42)
-
How To Center Print Area (5:57)
-
How To Insert Page Breaks in Worksheet (5:43)
-
How To Fit An Excel Sheet On One Page (7:29)
BONUS: Excel Tricks & Shortcuts
