Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Ultimate Supercharged Journey To Transform from Novice to Microsoft Excel Champions in Just 3 Hours!
Quick Start with MS Excel
Be familiar with Excel navigation
Simple Navigation in Excel
Enter and Update Data in Excel
Enter Data
Quickly select cell range
Insert delete rows/columns
Shortcut to fill up blank cells in a minute
Data Validation
Essential Aesthetic Formatting
Cell formatting
Conditional Formatting
Sorting
Freezing
Filtering
Grouping
Essential Must Know Formula for each Data Type
Understand Cell Reference
Must Know Formula for Text Data Type
Must Know Formula for Numeric Data Type
Must Know Formula for DateTime Data Type
Powered by these Excel Functions
Lookup with VLOOKUP
Lookup with HLOOKUP
Fast lookup with Index and Match
Conditional IF
Be Powered with Excel Functions
Functions for String data type
Functions for Numeric
Functions for Date Time
Power Analysis with Excel Table
Problem in numeric calculation without Table Formatting
Powerful analysis formula with Table Formatting
Working with Pivot Table and Pivot Chart
Pivot Table
Pivot Chart
Freezing
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock