Autoplay
Autocomplete
Previous Section
Complete and continue
Complete Excel Foundation Course
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
Text Formatting Options In Excel (14:19)
How to Wrap Text in Cell (6:03)
Number Formatting Tools (13:57)
[Excel Trick] Convert Numbers To Percentages (3:56)
Quiz on 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
All About Using Tables (12:01)
6 Hidden Capabilities of Tables (13:25)
Quiz on Tables
[FORMULAS] Formulas for Logical Tests
What is a Logical Test in Excel (6:23)
IF Function (8:48)
[Advanced] Nested IF Function (8:31)
AND Function (5:43)
OR Function (4:31)
[Advanced] Using IF, AND, OR Functions Together (5:10)
Using NOT Function (3:37)
[FORMULAS] Formulas for Text and Dates
[Text Function] 14 Different Text Functions (17:56)
[Text Function] EXACT Function (3:58)
[Date Function] Different Date Functions in Excel (18:12)
[Date Function] Calculate Exact Age in Excel (7:16)
[Date Function] Calculate Workdays (9:10)
[FORMULAS] Count and Sum Functions
5 Different COUNT Related Functions (8:52)
COUNTIFS Functions (11:51)
How to ADD with Conditions using SUMIFS (10:53)
Useful SUMPRODUCT Function (2:22)
[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
How to use CHOOSE Function (8:06)
[Advanced] How to Dynamic Chart With Choose Function (4:35)
CHOOSE function as Better Alternative to Nested IF function (11:09)
[Microsoft 365] IFS instead of Nested IFs OR Choose Function (7:19)
[FORMULAS] Functions to Audit Errors
Trap errors with IFERROR Function (3:57)
How to Show Formulas & Troubleshoot Errors (10:40)
[FORMULAS] Ranking & Randomization
All About Generating Random Numbers (RAND & RANDBETWEEN) (7:08)
Generate Random Dates (3:31)
How to Randomize a List (2:03)
How to Reverse a List (1:42)
How to Rank Values from Lowest to Highest (7:24)
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 Consolidate Data from Multiple Sheets (5:45)
Consolidate Data from Multiple Worksheets with Pivot Table (8:03)
How to Protect Your Content
Protect Sheet and Workbook from Viewing (3:55)
Protect Some Cells in Excel (7:05)
Add or Remove Passwords in Excel (5:36)
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
Excel keyboard shortcuts for Mac
Excel keyboard shortcuts for Windows
Consolidate Data from Multiple Worksheets with Pivot Table
Section content locked
If you're already signed up,
you'll need to login
.
Sign Up for Product to Unlock