Preview Microsoft Excel- Basic to Expert

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

Preview - Microsoft Excel- Basic to Expert