Detailed Curriculum

Module : Introduction to Excel
Chapter 1: Why Excel is vital for everyone?
Chapter 2: Excel UI overview: Workbook vs Worksheet
Chapter 3: Ribbon walkthrough (Home, Insert, Data, Formulas)
Chapter 4: Cell types: General, Number, Currency, Date.
Chapter 5: Formatting techniques: alignment, borders, conditional fills, number formatting.
Chapter 6: Navigation: Freeze Panes, Split View, Hide/Unhide rows/columns/sheets
Chapter 7: Shortcuts everone must know:

Module : Explore the Excel Ribbon
Chapter 8: Understand the legacy tools available in the ribbon
Chapter 9: Sort
Chapter 10: Filter/Advanced Filters
Chapter 11: Remove duplicates
Chapter 12: Text to columns
Chapter 13: Data Validation

Module : Formulas & Functions in Excel
Chapter 13: Introduction: Why formulas matter?
Chapter 14: How to do arithmetic calculations, including constants in calculations
Chapter 15: Referencing explained: Relative, Absolute ($A$1), Mixed.
Chapter 16: SUM: row totals, conditional ranges.
Chapter 17: AVERAGE: handling blanks vs zeros.
Chapter 18: MIN & MAX for data analysis.
Chapter 19: COUNT vs COUNTA difference.
Chapter 20: Common mistakes & error handling

Module: Logical Functions
Chapter 21: IF function syntax.
Chapter 22: Simple conditions
Chapter 23: Compound conditions with AND & OR.
Chapter 24: Nesting functions (SUM inside IF).
Chapter 25: Introduce IFS for multi-level outcomes.
Chapter 26: IFERROR to handle invalid data.

Module: Meet the New Excel Engine
Chapter 27: Introduce the new Excel engine
Chapter 28: Understand the power of this new tool with examples
Chapter 29: Why lookups are essential
Chapter 30: Explain lookup with a simple example
Chapter 31: Quick review of VLOOKUP and why it is not a great function
Chapter 32: The modern replacement XLOOKUP explained

Module: Text Functions
Chapter 33: Quick overview of LEFT, RIGHT, MID, LEN → extracting substrings.
Chapter 34: TRIM & CLEAN → removing unwanted spaces/special characters.
Chapter 35: Use the ‘&’ to merge texts, TEXTJOIN & TEXTSPLIT

Module: Conditional Formatting & Date/Time Functions
Chapter 36: Conditional formatting basics:
Chapter 37: Highlight duplicates.
Chapter 38: Highlight values above/below average.
Chapter 39: Apply color scales & icon sets
Chapter 40: TODAY & NOW, NETWORKDAYS, DATEDIF, EOMONTH

Module: Charts
Chapter 41: Why visuals matter in analytics (storytelling).
Chapter 42: Choosing the right chart for the right data.
Chapter 43: Bar & Column charts → comparisons.
Chapter 44: Line charts → trends over time.
Chapter 45: Combo charts → show 2 metrics (e.g., Sales vs Profit).
Chapter 46: Trendlines & forecasting basics.
Chpater 47: Formatting charts → axis, legends, labels, colors.

Module: Pivot Tables Basics
Chapter 48: What is a Pivot Table? Why analysts use it.
Chapter 49: Structure: Rows, Columns, Values, Filters.
Chapter 50: Aggregations: SUM, COUNT, AVERAGE.
Chapter 51: Refreshing pivots when source data updates.

Module: Pivot Charts & Advanced Pivot Tables
Chapter 52: Pivot charts basics: bar, line, pie.
Chapter 53: Grouping data: months, quarters, years.
Chapter 54: Calculated fields inside pivot tables.
Chapter 55: Adding slicers for interactivity.

Module: Power Query Basics
Chapter 56: What is Power Query? Why people use it.
Chapter 57: Importing datasets into Power Query.
Chapter 58: Splitting columns (e.g., First Name / Last Name).
Chapter 59: Removing duplicates.
Chapter 60: Replacing null/missing values.
Chapter 61: Trimming spaces.
Chapter 62: Applied Steps panel → how every step is recorded automatically.

Module: Power Query Advanced Features
Chapter 63: Merge Queries (joining datasets).
Chapter 64: Append Queries (stacking datasets).
Chapter 65: Unpivot data (convert columns → rows).
Chapter 66: Replacing entire tables with transformations.

Module: Power Pivot
Chapter 67: Why merging of tables may not be the best scenario all the time
Chapter 68: Working with relational datasets
Chapter 69: Creating connections between tables

Module: Dashboard Design Principles
Chapter 70: What is a dashboard? Purpose in business.
Chapter 71: Good dashboard principles:
Chapter 72: Clarity & simplicity.
Chapter 73: Choosing the right visuals (KPIs at top, trends in middle, details below).
Chapter 74: Consistent color scheme.
Chapter 75: Linking visuals with slicers.

Module: Google Sheets Basics & Collaboration
Chapter 76: Difference between Google Sheets vs Excel (cloud-based, auto-save, collaboration).
Chapter 77: Basic formulas: SUM, AVERAGE, IF.
Chapter 78: Sharing files: view, comment, edit permissions.
Chapter 79: Version history → restoring previous versions.
Chapter 80: Adding comments & assigning tasks to teammates.

Module: Google Sheets Advanced
Chapter 81: UNIQUE → extract unique values from a column.
Chapter 82: FILTER → extract filtered data dynamically.
Chapter 83: IMPORTRANGE → import data from another Google Sheet.
Chapter 84: Add-ons (installing, using third-party tools).

Module: Dashboard Integration (Excel + Sheets)**
Chapter 85: Why integrate Excel & Google Sheets (offline + cloud benefits).
Chapter 86: Import/export data between Excel & Sheets.
Chapter Linking Excel dashboards with Google Sheets data.

Module: Excel Project

The Language of Databases: The skill that connects you directly with company data

Turning numbers into Insights: Turn complex numbers into simple visuals — Power BI makes your work visible to managers, clients, and decision-makers

Modules Covered:

Master the world’s most universal business tool

Projects:

Projects:

Projects:

17 Mini Assignment
1 Excel Assignment (Dataset of your Industry Choice)

11 Mini Assignments
1 SQL Assignment (Same Dataset used in Excel Project)

16 Mini Assignments
1 Power BI Assignment (Same Dataset used in Excel+SQL Project)

Modules Covered:

45 Assignments/Mini Projects (after each live class).
1 Excel Dashboard Project (after finishing Excel Module).
1 SQL Project (After finishing SQL Module).
1 Power BI Project (After finishing PowerBI Module).
1 Capstone Project (End-to-End Analytics) : After finishing all Modules.
Resume + LinkedIn profile optimized.
Mock Interview experience.

Final Deliverables

Module : Introduction to SQL
Chapter 1: What is a RDBMS (Relational Database Management System)
Chapter 2: Types of SQL Databases
Chapter 3: Installation of SQL

Module : Database creation,updation & Deletion
Chapter 4: Create Database,drop database
Chapter 5: Create table,drop table
Chapter 6: Select, Alter
Chapter 7: Modify in SQL
Chapter 8: Insert statement
Chapter 9: Constraint in sql,not null,default

Module : Primary Key + Foregin Key
Chapter 10: Unique Key, Primary Key
Chapter 11: composite primary key
Chapter 12: Foreign key

Module: Filtering and updating Data
Chapter 13: Creating Database with SQL commands, Select distinct
Chapter 14: where , And , Or
Chapter 15: In, between, limit
Chapter 16: Null, Order by, Update, Delete

Module: Aggregrate Funcction
Chapter 17: SQL Aggregrate Function, Min, Max, Avg, Sum, Count
Chapter 18: Group by

Module: Pattern Matching
Chapter 19: Having
Chapter 20: Wildcard, Like
Chapter 21: Regex

Module: Subqueries
Chapter 22: Case statement
Chapter 23: Nested Queries

Module: Joins
Chapter 24: Joins and type of Joins SQL..

Module: Advanvce string,date function & views
Chapter 25: CONCAT(), LENGTH(), REPLACE().
Chapter 26: DATEDIFF(), CURRENT_DATE, DATE ADD()
Chapter 27: Views

Module: Store Procedure and Functions
Chapter 28: Stored Procedure
Chapter 29: WTH - SELECT, INSERT, UPDATE, DELETE
Chapter 30: Function

Module: Index and loading CSV file in SQL
Chapter 31: load CSV file project.
Chapter 32: Index in SQL
Chapter 33: Window Function
Chapter 34: Rank, Dense Rank

Module: SQL Project

Modules Covered:

Module : Power BI Introduction
Chapter 1: Introduction to Power BI
Chapter 2: Download & Installation
Chapter 3: How to use Power BI Desktop Application

Module : Introduction to Power Query Editor
Chapter 4: Introduction to Power Query Editor
Chapter 5: Remove Rows, Keeping Rows or Remove Column or Choose Column, Sorting Data
Chapter 6: Split Column
Chapter 7: Group By, Replace value, Shifting First Row as Column

Module : Date and Text Operation
Chapter 8: Table, Data Type Conversion
Chapter 9: Number, Date & Time, Column Operation
Chapter 10: Text Column Operation
Chapter 11: Any Column Operation

Module: Operation Multi Table
Chapter 12: Transpose & Reverse Rows
Chapter 13: Conditional, Index and Duplicate Column
Chapter 14: Combining Data
Chapter 15: Close and Apply

Module: Different Type of Analysis
Chapter 16: Creating Charts in Power BI
Chapter 17: Categorical vs Numerical Data
Chapter 18: Univariate Analysis
Chapter 19: Bivariate & Multivariate Analysis
Chapter 20: Stack Column, Bar, Clustered Column, Bar Chart

Module: Different Types of Charts
Chapter 21: Saving a File
Chapter 22: Formatting
Chapter 23: 100% Stack Column, Bar Chart
Chapter 24: Trend Analysis chart (Line, Area, Stack Area Chart)

Module: Univariate & Bivariate Analysis
Chapter 25: Pie, Donut, Funnel Chart
Chapter 26: Scatterplot (Univariate Analysis)
Chapter 27: Scatterplot (Bivariate Analysis)

Module: Multivariate Analysis
Chapter 28: Slicer
Chapter 29: Map, Filled Map, Tree Map

Module: Table
Chapter 30: Card With Numerical & Text column
Chapter 31: Table

Module: Matrix
Chapter 32: Card With Date Column
Chapter 33: Multi Row Card
Chapter 34: Matrix

Module: Filter Section, Q & A
Chapter 35: Filter Section
Chapter 36: More Visuals
Chapter 37: Q & A

Module: Data Modeling
Chapter 38: Data Modelling
Chapter 39: Data Modelling Implementation

Module: Dax Queries
Chapter 40: Dax, Calculated Column, Measures
Chapter 41: Aggregration Function

Module: Text & Logical Function
Chapter 42: Calculate & Filter Context
Chapter 43: Text Functions
Chapter 44: Logical Functions (If, And, Or, Not)
Chapter 45: Switch Function
Chapter 46: Gauge Chart

Module: Dashboard
Chapter 47: Dashboard

Module: Security and dashboard sharing
Chapter 48: Row Level Security
Chapter 49: Sharing Dashboard Report
Chapter 50: Kaggle (Real world Dataset Platform)
Chapter 51: Sharing Project Insight On Linkedin

Module: Power BI Project

Project Work: Learn by Doing. Showcase with Confidence.

• Short projects using 48 different datasets across industries (Banking, FMCG, E-commerce, HR, Healthcare, etc.).
  
  

• Each mini project focuses on one daily task — like reconciling accounts, analyzing sales, or tracking HR performance.
  
  

• Outcome: You understand the day-to-day processes of different industries.

Tool-Specific Projects (Excel, SQL, Power BI)

• Pick one industry dataset of your choice Do three separate projects on the same dataset:
  
  

• Excel → clean, organize, and analyze the dataset.

• SQL → query, join, and pull insights from the dataset.

• Power BI → create dashboards and visual stories from the same dataset.

Capstone Project

• A full end-to-end project combining Excel + SQL + Power BI.
  
  

• You will choose an industry of your interest (like BFSI, FMCG, E-commerce, Consulting).
  
  

• The capstone will simulate the actual workflow of a company team, from raw data collection → analysis → visualization.
  
  

• This project is your “job simulation” — the closest you can get to actual work before employment.

48+ Assignments

Project Portfolio

Certification

• On successful completion, you’ll receive a Certificate from UttamEducation.

• It validates your mastery of Excel, SQL, and Power BI with industry-relevant training.

• The certificate + portfolio together make your CV stand out in job applications.

Marksheet
(Gradesheet)

• On successful completion, you’ll receive a Certificate from UttamEducation.

• It validates your mastery of Excel, SQL, and Power BI with industry-relevant training.

• The certificate + portfolio together make your CV stand out in job applications.

Documents : Proof of Work

• Short projects using 48 different datasets across industries (Banking, FMCG, E-commerce, HR, Healthcare, etc.).

• Each mini project focuses on one daily task — like reconciling accounts, analyzing sales, or tracking HR performance.

• Outcome: You understand the day-to-day processes of different industries.

Career Preperation

CV & Profile Building

Interview Prepatation

Placement Guidance

• Learn how to build a professional CV tailored to industry roles.
  
  

• Get the right keywords, job titles, and skills added to pass recruiter and ATS (Applicant Tracking System) filters.
  
  

• Even Creative Roles need data discipline. You leave with a CV and LinkedIn Profile that clearly showcase your skills in Excel, SQL, Power BI, AND Industry Knowledge

• Training in communication skills to present your ideas clearly and confidently.
  
  

• A 1-day prep strategy before your interview to brush up on key concepts and projects.
  
  

• Mock interviews with personalized feedback to boost your confidence and address weak areas.
  
  

• You are interview-ready, with a clear way to explain your skills, projects, and value to companies.

• Training in communication skills to present your ideas clearly and confidently.
  
  

• A 1-day prep strategy before your interview to brush up on key concepts and projects.
  
  

• Mock interviews with personalized feedback to boost your confidence and address weak areas.
  
  

• You are interview-ready, with a clear way to explain your skills, projects, and value to companies.

Meet Industry Experts

Gain insider knowledge from professionals across Banking, Consulting, FMCG, IT, and more — understand how their teams work, what tools they use, and how they solve real business problems.

Banking & Finance Leader

Big 4 Consultant / Auditor

FMCG & Retail Specialist

Learn how analysts track loans, credit scores, and customer portfolios with Excel, SQL, and dashboards.

See how companies like HUL and Nestlé monitor product sales, channels, and marketing campaigns.

Discover how audits and financial compliance are done in real projects using ERP + BI tools.

Insights on handling large-scale data, reporting for decision-making, and building dashboards that matter.

Tech & Analytics Mentor

Your Career Growth Starts Here