arrow_back
Introduction and overview of MS Excel Course
Module 1- Basic
Session 1- Interface
Session 2- Entering Data
Session 3- Formatting Data
Session 4- Create Basic Formulas
Session 5- References and Error Check in Formula
Session 6- Rows and Columns
Session 7- Protect the workbook
Session 8- Formatting the numeric values
Session 9- Insert Images and SmartArt
Session 10- Printing the sheet
Session 11- Bonus Module - 1
Session 12- Bonus Module - 2
Module 1- Practice Sheets
Practice Sheet 1- Module 1 (B)
Practice Sheet 2- Module 2 (B)
Practice Sheet 3- Module 3 (B)
Module 2- Intermediate
Session 1- Common Error Types
Session 2- Data Visualization (Charts – 1)
Session 3- Data Visualization (Charts – 2)
Session 4- Data Visualization (Charts – 3)
Session 5- Data Visualization (Charts – 4)
Session 6- Data Visualization (Charts – 5)
Session 7- Important 2019 Updates
Session 8- Sort and Filter your data
Session 9- Important Tools
Session 10- Database Function
Session 11- Database Function (Part – 2)
Session 12- Other Important Tools
Session 13- Format Excel List as Table
Session 14- Understanding of Pivot Tables – Part 1
Session 15- Formatting Pivot Tables
Session 16- Pivot Charts
Module 2- Practice Sheets
Practice sheet 1- Common Error Types
Practice sheet 2- Data Visualization
Practice sheet 3- Important Tools
Practice sheet 4- Database Functions
Practice sheet 5- Other Important Tools
Practice sheet 6- Pivot Tables
Module 3- Advanced
Session 1- Advance Function Basics
Session 2- Formula Auditing Tools
Session 3- Role of Calculation Tools
Session 4- Text Functions - 1
Session 5- Text Functions - 2
Session 6- Date and Time Functions - 1
Session 7- Date and Time Functions - 2
Session 8- Information Functions - 1
Session 9- Information Functions - 2
Session 10- Statistical Functions -1
Session 11- Statistical Functions - 2
Session 12- Statistical Functions - 3
Session 13- Statistical Functions - 4
Session 14- Statistical Functions - 5
Session 15- Logical Functions - 1
Session 16- Logical Functions - 2
Session 17- Logical Functions - 3
Session 18- Lookup and Reference Functions - 1
Session 19- Lookup and Reference Functions - 2
Session 20- Lookup and Reference Functions - 3 (Especially for Microsoft 365 Users)
Session 21- Lookup and Reference Functions - 4
Session 22- Lookup and Reference Functions - 5
Session 23- Financial Functions - 1
Session 24- Financial Functions - 2
Session 25- Math and Trigonometry Functions - 1
Session 26- Math and Trigonometry Functions - 2
Session 27- Get and Transform Data
Session 28- PowerPivot Basics
Session 29- Advance PowerPivot
Session 30- Cube Functions - 1
Session 31- Cube Functions - 2
Session 32- What’s new in 2019
Module 3- Practice Sheets
Practice sheet 1- Advance Functions Basics
Practice sheet 2- Text Functions
Practice sheet 3- Date and Time Functions
Practice sheet 4- Statistical Functions
Practice sheet 5- Logical Functions
Practice sheet 6- Lookup_and References_ Functions
Practice sheet 7- Financial Functions
Practice Sheet 8 - Maths and Trignometry Functions
Practice sheet 9- Powerpivot
Practice sheet 10- Cube_Functions
Reference file- Export, Import
Reference file- Powerpivot-1
Reference file- Product details
Module 4- Expert
Session 1- Shortcut - 1
Session 2- Shortcut - 2
Session 3- Shortcut - 3
Session 4- What if Tools - 1
Session 5- What if Tools - 2
Session 6- Infographics -1
Session 7- Infographics - 2
Session 8- Infographics - 3
Session 9- Infographics - 4
Session 10- Multiple Dependent Dropdown List - 1
Session 11- Multiple Dependent Dropdown List - 2
Session 12- Dashboards - 1
Session 13- Dashboards - 2
Module 4- Practice Sheets
Practice sheet 1-Shortcuts
Practice sheet 2-What If Tools
Practice sheet 3-Infographics
Practice sheet 4-Infographics - 2
Practice sheet 5-Dropdown Lists
Practice sheet 6-Dashboards
Congratulations!
MS Excel Conclusion
MS Excel Project
MS Excel Final Project
Reference File for Project- GDP File
Reference File for Project- Global_Competitiveness_Report
Dummy Look for Project
MS Excel Final Exam