Course Overview
This comprehensive course is tailored for students, accountants, financial analysts, and corporate professionals seeking to streamline data operations. You will learn hands-on with real corporate datasets and business case studies.
Key Learning Highlights
- Advanced Formulas: XLOOKUP, VLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS
- Data Cleansing & Transformation using Power Query
- Dynamic Pivot Tables, Slicers, and Interactive Charts
- Automated MIS Reports & Financial Dashboards
- Intro to Power BI & Data Visualization
Curriculum & Key Modules
Module 110 Hours
Excel Fundamentals & Key Shortcuts
- •Ribbon Navigation, Worksheets, Cell Formatting
- •Mathematical & Statistical Formulas
- •Absolute & Relative Referencing
Module 215 Hours
Logical, Text & Lookup Functions
- •Nested IF, IFS, AND, OR functions
- •VLOOKUP, HLOOKUP, INDEX & MATCH, XLOOKUP
- •TEXT, CONCAT, TRIM, LEFT, RIGHT functions
Module 310 Hours
Data Cleaning, Validation & Conditional Formatting
- •Data Validation rules & Dropdown lists
- •Advanced Conditional Formatting rules
- •Removing duplicates & Text to Columns
Module 415 Hours
Pivot Tables, Pivot Charts & Slicers
- •Creating dynamic Pivot Tables & Calculated Fields
- •Interactive Slicers and Timelines
- •Pivot Charts & Summary Reports
Module 520 Hours
Power Query Automation & MIS Dashboard Creation
- •Power Query ETL: Extract, Transform, Load
- •Connecting Multiple Data Sources
- •Building Interactive Corporate MIS Dashboards
- •Intro to Power BI Dashboards
Prerequisites & Eligibility
Basic knowledge of operating computers. No prior programming required.