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
IF Function
Section content locked
If you're already signed up,
you'll need to login
.
Sign Up for Product to Unlock