Autoplay
Autocomplete
Previous Lesson
Complete and Continue
EXCEL MASTERY COURSE
CHAPTER 1
Introduction (1:10)
Basics: Workbook,Titlebar,Ribbon,Tab,Formula Bar,Row,Column, Save,Save as (5:17)
Basics: Heading,Merge & Centre,Wrap Text,Format Cells,Border,Cell Colour,Font Changing,Allignment,Cut,Copy,Paste (8:23)
Basics: Number formatting,Percentage,Comma,Decimal Increase & Decrease,Short Date,Long Date,Time (6:20)
Basics: Basic Formulas, Sum, Relative referencing, Absolute referencing (5:09)
Quiz
Practice Sheets
CHAPTER 2
Auto sum, Fill, Clear Function (8:06)
Sort Function (3:01)
Navigation (2:18)
Quiz
Practice Sheets
CHAPTER 3
Flash Fill Command with Examples (3:38)
Page Layout, Printing Functions (6:45)
Date (2:42)
Concatenate (4:36)
Quiz
Practice Sheets
CHAPTER 4
Conditional Formatting (5:28)
Filter Function with Shortcut key (3:19)
Freeze panes with Shortcut key (2:20)
Advance Filter (5:15)
Quiz
Practice Sheet
Text Functions (6:23)
Right Tick and Cross Tick with Conditional Formatting (3:50)
CHAPTER 5
Count, CountA, Countif, Countifs (10:00)
IF,IFAND,IFOR Function (9:05)
IFS with IFSERROR Function (5:56)
SUMIF and SUMIFS (8:49)
Quiz
Practice Sheets
CHAPTER 6
VLOOKUP_Exact Match (6:09)
VLOOKUP_Approx Match (4:04)
VLOOKUP With IFERROR (4:04)
VLOOKUP With Subtotal, Average, Min, Max, Data Validation (4:40)
Use of Double VLOOKUP (5:39)
Quiz
Practice Sheets
CHAPTER 7
PIVOT Table (5:23)
PIVOT Chart (3:57)
PIVOT Slicer (3:24)
PIVOT Table with IF Function (4:06)
Quiz
Practice Sheets
Page Layout in PIVOT Table (3:59)
Other Functions of Pivot Table (2:47)
Create Group in Pivot Table (2:52)
CHAPTER 8
Charts 1 (5:10)
Charts 2 (4:54)
Charts 3 (2:51)
Quiz
Practice Sheets
CHAPTER 9
PMT,IPMT,PPMT Formula (6:47)
Round, Roundup, Rounddown, MRound (5:13)
INDEX and MATCH (7:50)
HLOOKUP Function (2:22)
Quiz
Practice Sheets
XLOOKUP Function (8:44)
CHAPTER 10
MACRO_Example 1 (4:40)
MACRO_Example 2 (3:00)
How to use BUTTON in Macro (1:28)
Quiz
Practice Sheet
CHAPTER 11
DGET Function (6:03)
Five Important Excel Shortcuts (7:44)
Five most usable Excel Shortcuts (6:07)
Quiz
Practice Sheets
MS EXCEL Shortcut Keys (8:07)
How to find duplicate values-Three Tricks (6:56)
INDEX and MATCH
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock