Module 1- Preparing Data For Analysis (Standard Duration : 25 Hours)

1. Basic Operators and Formula Calculations.
2. Working with Ranges, Worksheets, and Workbooks, Named Ranges.
3. Common Errors in calculation, Evaluating formulas
4. Applying basic formatting in data, Creating Templates.
5. Applying Data Validation
6. Import data from different sources
7. Data Cleaning Techniques
8. Complete Data by Lookup Values from different Tables and Workbooks.
DATA MODELING WITH EXCEL (Only for student enrolled with POWER BI)
9. Transform and Cleaning Data Using Power Query.
10. Data Modeling, Creating relationships among tables, RDBMS

Module 2 - Creating Reports (Standard Duration : 10 Hours)

1. Creating and Filtering Pivot Report with Cleaned Data.
2. Convert data into Table Format.
3. Slicers and Timeline in Pivot Reports.
4. Creating Reports using Advance Functions.
5. Connecting Multiple Reports using Slicers and Timeline
6. Creating Dashboards.
7. Developer Tools.
DAX MEASURES FOR CREATING REPORTS (Only for student enrolled with POWER BI)
8. Iterative DAX Functions.
9. DAX Measures Simple to Advance.

Module 3 - Data Visualization (Standard Duration : 25 Hours)

1. Creating Basic Excel Charts.
2. Creating Advance Charts.
3. Creating charts using Developer Tools.
4. Pivot Charts.
5. Shapes, SmartArt and Themes.
6. Sparklines, Advance Conditional Formatting.

Module 4 - Data Security & Sharing (Standard Duration : 2 Hours)

1. Saving workbook using different excel formats.
2. Protect workbook, Worksheet, Locking & unlocking cells