Master data handling, reporting, and dashboard creation with Advanced Excel and Power BI. This course is ideal for anyone aspiring to become an MIS Analyst or Reporting Executive.

 

Duration

 

• Option 1: 2 Hours/Day for 2 Months

• Option 2: 2.5 Hours/Day for 2.5 Months

 

Career Paths

 

• MIS Analyst

• Excel Analyst

• Report Developer

• Data Entry Executive with Reporting Skills

• Junior Data Analyst

 

Topics Covered

 

Module 1: Advanced Excel

 

• Excel Interface and Functions

• Logical & Lookup Functions (IF, VLOOKUP, XLOOKUP)

• Conditional Formatting

• Data Validation & Data Cleaning

• Charts, Graphs & Sparklines

• Pivot Tables and Pivot Charts

• Dynamic Dashboards using Excel

 

Module 2: Power BI

 

• Introduction to Power BI Interface

• Connecting Excel Data to Power BI

• Power Query for Data Cleaning

• Data Modeling & Relationships

• DAX (Data Analysis Expressions)

• Interactive Reports & Dashboards

• Publishing & Sharing Dashboards

 

Add-Ons

 

• Resume Preparation Support

• Interview Q&A Guidance

• Hands-on Mini Projects

• Certificate of Completion

• Placement Guidance