Excel & Power BI Mastery
A beginner-to-advanced, job-oriented course in Excel and Power BI. You learn formulas, data cleaning, tables and PivotTables, then Power Query, Power Pivot and DAX, and build interactive Power BI dashboards. You also learn MIS reporting, refresh workflows and data accuracy. You finish with four portfolio projects, an integrated capstone and interview preparation. All business data is simulated. You need desktop Excel and Power BI Desktop on a Windows computer.
- Duration: 16 weeks
- Modules: 12
- Fee: Rs 12,999 (about Rs 2,166 a month on EMI)
- Field: Data & Analytics
Roles this track prepares you for
- MIS Executive
- Business Analyst
- Data Analyst
- BI Developer
- Power BI Developer
- Junior Data Analyst
- MIS Analyst
- Reporting Analyst
- Business Intelligence Analyst
- Excel Analyst
Curriculum
- Excel Fundamentals, Data Entry and Workbook Management - Learn to enter, format and organize data correctly, write basic formulas and manage workbooks the way a professional does.
- The Excel interface and correct data entry
- Cell formatting, number types and dates
- Basic formulas and cell references
- Worksheets and workbook management
- Charts basics and printing
- Shortcuts and good practice
- Advanced Formulas, Logical Functions and Lookup Functions - Write reliable formulas using logic, text, dates, conditional sums and lookups, and know why a formula fails.
- IF, AND, OR and nested logic
- Text and date functions
- SUMIFS, COUNTIFS and AVERAGEIFS
- VLOOKUP and HLOOKUP
- XLOOKUP, INDEX and MATCH
- Audit Formulas and Read Errors
- Data Cleaning, Validation and Error Handling - Find and fix dirty data, remove duplicates and bad types, prevent bad entries with validation and handle errors cleanly.
- Spot Dirty Data and Its Business Cost
- Clean Text with TRIM, SUBSTITUTE and PROPER
- Duplicates, Blanks and Wrong Data Types
- Data validation and dropdown lists
- Error handling with IFERROR and checks
- A complete cleaning workflow case
- Sorting, Filtering, Tables and Advanced Excel Analysis - Organize and explore data with sorting, filters, Excel Tables, conditional formatting and what-if tools.
- Sorting data, including multi-level and custom sorts
- Filters and advanced filter
- Excel Tables and structured references
- Conditional formatting for insight
- What-if analysis, Goal Seek and scenarios
- An inventory analysis case
- PivotTables, PivotCharts and Interactive Reports - Summarize large data with PivotTables, group and calculate, add PivotCharts and slicers, and build an interactive sales dashboard in Excel. This module includes portfolio project 1.
- PivotTable basics
- Grouping, calculated fields and value settings
- PivotCharts
- Slicers and timelines
- Build an interactive Excel dashboard
- Refresh, check and reconcile your numbers
- Power Query for ETL and Data Transformation - Use Power Query to connect, clean, reshape, merge and refresh data, and build an MIS reporting system that updates in a few clicks. This module includes portfolio project 2.
- Power Query interface and applied steps
- Clean and transform data
- Merge and append queries
- Unpivot and reshape data
- Parameters and loading from a folder
- Design a repeatable MIS refresh workflow
- Power Pivot, Relationships and Data Modeling - Build a proper data model with fact and dimension tables, relationships, a date table and clean hierarchies, and report from it.
- Fact tables, dimension tables and the star schema
- Power Pivot and relationships
- Build and use a date table
- Keys, cardinality and common model problems
- Hierarchies and keeping a model clean
- Report from the data model
- Power BI Desktop and Data Connectivity - Connect Power BI Desktop to files and databases, transform and model data, build visuals and filters and understand how reports are published and shared.
- Power BI Desktop tour and setup
- Connect to Excel, CSV and database sources
- Transform and model data in Power BI
- Build visuals
- Filters, slicers and visual interactions
- Publishing and sharing basics and their requirements
- DAX Fundamentals, Measures and Calculated Columns - Learn DAX syntax, filter and row context, measures versus calculated columns, CALCULATE, time intelligence and iterators, and write measures that are correct. This module includes portfolio project 3.
- DAX syntax, row context and filter context
- Measures versus calculated columns
- CALCULATE, FILTER and ALL
- Time intelligence for year to date and growth
- Iterators, ranking and top N
- Debug measures and common DAX mistakes
- Interactive Dashboards, KPIs and Business Storytelling - Choose the right KPIs, design a clear dashboard, pick effective visuals, add drill-through and tooltips and tell the business story behind the numbers.
- Choose KPIs that match decisions
- Dashboard layout and design principles
- Choose the right visual and use color well
- Drill-through, tooltips and bookmarks
- Business storytelling with data
- Review a dashboard for clarity and accessibility
- Real-World Business Reporting, Automation and Performance Optimization - Turn business requests into reports, set up reliable refresh workflows, automate repeat work, speed up slow files, reconcile data and hand over a report pack.
- From a business request to a report
- Refresh workflows and what they require
- Automate repeat work with recorded macros
- Find and fix slow workbooks and reports
- Reconciliation and data quality checks
- Documentation and handover of a report pack
- Integrated Capstone, Portfolio and Interview Preparation - Combine everything in one integrated Power BI project from raw data to a finished dashboard, then prepare your portfolio, an Excel test and interview answers. This module includes portfolio project 4.
- Capstone brief, questions and plan
- Capstone data preparation and model
- Capstone measures and validation
- Capstone dashboard and story
- Portfolio case study and resume bullets
- Excel test practice and interview questions
Frequently asked questions
How long is the Excel & Power BI Mastery course?
It runs for 16 weeks, with 12 modules. It is self-paced online learning from EasySkill Career Academy, Surat.
How much does the Excel & Power BI Mastery course cost?
The fee is Rs 12,999, or about Rs 2,166 a month on EMI.
What will I build in Excel & Power BI Mastery?
Every module ends in a graded practical task that AI checks in about 30 seconds, so you finish with a portfolio you can show to employers or clients.
Which roles does Excel & Power BI Mastery prepare me for?
It prepares you to apply for roles such as MIS Executive, Business Analyst, Data Analyst, BI Developer, Power BI Developer. It does not guarantee a job or income.
Can I learn online, or do I have to visit a centre?
You can learn fully online. EasySkill also has centres in Adajan, Vesu and Bhestan, Surat, if you prefer to visit.
All career tracks