Skip to content
Home
Courses
MS Office
1) Excel Basic to Advanced
2) Excel Dashboard Training
3) Excel Power Query Course
4) Excel Macros VBA Programming
5) Power BI Training
6) Complete MS Office Suite
7) PowerPoint Mastery
8) HR Metrics & Dashboard
9) Microsoft Word Training
10) 30 Days Excel Course
LIVE Trainings
Excel Tips & Tricks Complimentary
Mastering Excel Formulas
Power BI Training – Level 1
About Us
Partner with us
Contact Us
Home
Courses
MS Office
1) Excel Basic to Advanced
2) Excel Dashboard Training
3) Excel Power Query Course
4) Excel Macros VBA Programming
5) Power BI Training
6) Complete MS Office Suite
7) PowerPoint Mastery
8) HR Metrics & Dashboard
9) Microsoft Word Training
10) 30 Days Excel Course
LIVE Trainings
Excel Tips & Tricks Complimentary
Mastering Excel Formulas
Power BI Training – Level 1
About Us
Partner with us
Contact Us
Login
My Workshops
30 Days Excel Course
Course Content
Day 1 Introduction to Excel & Formatting Data
Day 2 Basic Formulas
Day 3 Sorting Data
Day 4 Filtering Data
Day 5 Excel Shortcuts
Day 6 Merge and Freeze
Day 7 Conditional Formatting
Day 8 Text to Columns
Day 9 Remove Duplicates & Unique Formula
Day 10 Paste Special
Day 11 IF and Advanced IF Formula
Day 12 Adding $ Sign in Formula
Day 13 CountIF, SumIF & AverageIF
Day 14 Left, Right & Mid Formulas
Day 15 VLOOKUP
Day 16 HLOOKUP
Day 17 Data Cleaning Formulas
Day 18 Flash Fill
Day 19 Text Formula
Day 20 Pivot Tables
1 of 2
