Skip to content
Home
Trainings
MS Office
Excel Basic to Advanced
Excel Dashboard Training
Power Query Course
Powerpoint
MS Word Training
Excel Macros VBA Programming
Complete MS Office Suite
Power BI Training
HR Metrics & Dashboard
Excel Tips & Tricks Complimentary
LIVE Trainings
30 Days Excel Mini Course
Excel Formulas LIVE Training
Power BI LIVE 5 Days Level 1
Cyber Security
Cyber Security Awareness
Identify Spam and Phishing Emails
About Us
Partner with us
Contact Us
Menu
Home
Trainings
MS Office
Excel Basic to Advanced
Excel Dashboard Training
Power Query Course
Powerpoint
MS Word Training
Excel Macros VBA Programming
Complete MS Office Suite
Power BI Training
HR Metrics & Dashboard
Excel Tips & Tricks Complimentary
LIVE Trainings
30 Days Excel Mini Course
Excel Formulas LIVE Training
Power BI LIVE 5 Days Level 1
Cyber Security
Cyber Security Awareness
Identify Spam and Phishing Emails
About Us
Partner with us
Contact Us
Login
My Workshops
30 Days Mini 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
