Excel Basic to Advanced Level
Mastering Basics of Excel
Day 1 : Introduction to Excel and Basic Excel Shortcut Part 1
Day 1 : Excel Shortcuts – Speed Booster – Part 2
Day 1 : Excel Shortcuts – Speed Booster – Part 3
Day 2 : Excel Basic Formulas Part 1
Day 2 : Excel Basic Formulas Part 2
Day 2 : Excel Basic Formulas Part 3
Day 2 : Excel Basic Formulas Part 4
Day 2 : EXCEL CHALLENGE EXERCISE
Day 3 : Sorting (Arranging Data in Proper Order)
Day 3 : Filtering Data
Day 3 : SubTotal (Creating Basic Summary Report)
Day 3 : Conditional Formatting (Coloring Data on the basic of Conditions)
Day 4 : Adding Comment in Cell
Day 4 : Text to Column
Day 4 : PageSetup
Day 4 : Left Right & Mid Formulas
Day 4 : Freeze UnFreeze Row and Column
Excel Intermediate to Advanced Level Topics
Day 1 : Summarize Data using Pivot Table
6 Topics
Pivot Part 1
Pivot Part 2
Pivot Part 3
Pivot Part 4
Pivot Part 5 Slicer
Pivot Part 6 Refresh
Day 2 : Creating Beautiful Charts
7 Topics
Creating Column Chart Part 1
Column Chart Part 2
3) Line Chart
4) Pie Chart
5) Funnel & Treemap Chart
6) Combo Chart (Sales vs Target)
7) Creating Secondary Axis Chart
Day 3 : Conditional Formatting with Formulas
7 Topics
Conditional Formatting Part 1
Conditional Formatting Part 2
Conditional Formatting Part 3
Conditional Formatting Part 4
Conditional Formatting Part 5
Conditional Formatting Part 6
Conditional Formatting Part 7
1 of 2
Previous Lesson
Next Lesson
Day 2 : Excel Basic Formulas Part 1
Excel Basic to Advanced Level
Day 2 : Excel Basic Formulas Part 1
Previous Lesson
Back to Course
Next Lesson
