ADVANCED EXCEL COURSE

Sr No Excel Module Topics

What Is Excel And Where It Is Used
Workbook Vs Worksheet, Rows, Columns, Cells, Range
1 Introduction To Excel Excel Interface, Ribbon & Tabs
Create And Save Files
Text / Number / Date Entry
2 Data Entry & Formatting
Cell Formatting, Number Formats, Wrap Text, Merge And Centre
Formulas, Operators & Functions
3 Basic Excel Formulas
Sum, Average, Min, Max
4 Cell Referencing Relative, Absolute, Mixed, Freeze Panes
5 Logical Functions ( Basic) If, Comparison Operators, Nested If
6 Excel Text Functions Left, Right, Mid, Length, Trim, Upper, Lower, Proper..
7 Date & Time Functions Today, Now, Date, Month,
8 Lookup Functions Vlookup, Hlookup, Exact Match Vs Approximate Match
9 Conditional Functions Countif, Sumif, Ifs And All
10 Data Tools Sorting, Filtering, Data Validation, Dropdown
11 Advanced Lookup Index , Match, Index-Match (Two Way)
12 Modern Loookup Xlookup & Xmatch
13 Dynamic Array Functions Filter, Sort, Unique, Rows With Filter
14 Advanced Logical Functions And, Or, Ifs, Switch
15 Error Handling & Auditing Iferror, Ifna, Trace Precedents, Evaluate Formula
16 Advanced Calculations Sumproduct, Aggregate And More
17 Pivot Tables Create Pivot Tables, Grouping Data, Pivot Charts
18 Dashboard Basics Kpis, Charts & Slicers, Dashboard Layout
19 Real World Excel Project Sales, Hr, Finance Dataset Analysis & Dashboard
20 Revision & Interview Preparation Revision, Test, Doubt Clearing, Interview Questions And Career Guidance

Google Sheet
Sr No Module Topics
Rows, Columns, Cells
Formatting & Number Formats
1 Basic
Basic Formulas (SUM, AVERAGE, COUNT, MIN, MAX)
Relative & Absolute Referencing
IF, IFS
AND, OR
SUMIF / COUNTIF / AVERAGEIF
2 Essential Functions
Basic Percentage Calculations
Text Functions (LEFT, RIGHT, MID, TRIM, LEN)
Date Functions (TODAY, NOW, DATEDIF)
Sorting & Filtering
Data Validation (Drop-downs)
3 Data handling Conditional Formatting
Remove Duplicates
Text to Columns
VLOOKUP
XLOOKUP
INDEX + MATCH
4 Lookup & Advanced fUNCTION Multiple Criteria Lookup
FILTER Function
UNIQUE
SORT
QUERY Function (SQL in Sheets)
ARRAYFORMULA
IMPORTRANGE
5 Advanced & Automation
Dynamic Ranges
Named Ranges
Error Handling (IFERROR)
Pivot Tables (Basic to Advanced)
Calculated Fields
6 Data Analysis Slicers
Charts (Bar, Line, Combo, Pie)
Interactive Dashboard
Sales Dashboard
HR Attendance Report
7 Real world project Marketing Campaign Analysis
Inventory Tracker
Monthly Business Performance Report

POWER BI (Business Intelligence)

Sr No Module Topics
What is Power BI?
1 Introduction Power BI Interface Overview
BI Concepts Basics
Connect to Excel & CSV
2 Data connection Import Data
Basic Data Refresh
Remove Duplicates
Change Data Types
3 Data Cleaning (Power Query)
Split & Merge Columns
Basic Transformations
Create Relationships
4 Data Modeling
Understanding Tables
Calculated Columns
Measures
5 DAX Calculations
SUM, COUNT, AVERAGE
IF Function
Bar, Line, Pie Charts
Table & Card
6 Data Visualization
Slicers & Filters
Basic Dashboard Design
Publish Report
7 Publishing
Share Dashboard (Overview)

SQL (Structured Query Language)

Sr No Module Topics
What is RDBMS?
Tables, Rows, Columns
1 Basic intro
Primary Key & Foreign Key
Understanding Business Data (Sales, Customers, Orders)
SELECT specific columns
WHERE Clause
AND, OR
2 Data Retrieval IN, BETWEEN
LIKE
ORDER BY
LIMIT
COUNT()
SUM()
AVG()
3 Calculations
MIN(), MAX()
Calculated Columns
Percentage Calculations
GROUP BY
HAVING
Creating Summary Reports
4 Grouping & Business Reporting
Sales by Month
Revenue by Product
Customer-wise Analysis
INNER JOIN
LEFT JOIN
5 Joins RIGHT JOIN (Overview)
Combining Multiple Tables
Real-world Data Merging
Handling NULL values
6 Data Cleaning IS NULL / IS NOT NULL
CASE WHEN (Basic Logic)
Sales Analysis
Monthly Performance Report
7 Real world Practice projects
Top 10 Customers
Product-wise Revenue Report