Our Basic Excel Syllabus — Click to View Modules
Our Basic Excel Syllabus — Click to View Modules
Build a Strong Foundation in Microsoft Excel
This beginner-friendly course is designed for learners with little or no prior Excel experience. It focuses on practical skills required for everyday office work, academic tasks, data organization, basic analysis, and reporting.
Understanding the Excel interface and Ribbon
Workbooks, worksheets, rows, columns, and cells
Entering, editing, copying, and moving data
Selecting cells and ranges
Managing multiple worksheets
Saving, opening, and organizing Excel files
Understanding relative and absolute cell references
Font, alignment, borders, and fill colors
Number, currency, percentage, and date formatting
Row height and column width
Merge and Center
Wrap Text
Format Painter
Cell Styles
Freeze Panes
Hide and unhide rows, columns, and worksheets
Page setup, margins, orientation, and printing
Creating simple formulas
Addition, subtraction, multiplication, and division
Order of operations
SUM
AVERAGE
COUNT
COUNTA
MIN
MAX
ROUND
Basic IF function
AutoSum and formula copying
Understanding common formula errors
Sorting data
Multi-level sorting
Filtering data
Find and Replace
Flash Fill
Remove Duplicates
Creating and formatting Excel Tables
Using table headers and Total Row
Basic Data Validation
Creating drop-down lists
Introduction to Excel charts
Column charts
Bar charts
Line charts
Pie charts
Selecting the right chart
Adding chart titles and data labels
Formatting chart elements
Moving and resizing charts
Creating simple business reports
Basic Conditional Formatting
Highlighting values and duplicates
Top/Bottom Rules
Data Bars, Color Scales, and Icon Sets
Creating simple summaries
Introduction to Pivot Tables
Arranging fields in a Pivot Table
Basic filtering in Pivot Tables
Refreshing Pivot Table reports
Creating attendance trackers
Preparing expense statements
Building simple budgets
Creating sales and inventory lists
Preparing employee records
Designing basic schedules and task trackers
Creating simple monthly reports
Applying formulas and formatting to realistic datasets
Complete beginners
Students and fresh graduates
Entry-level job seekers
Administrative and office professionals
Small business owners
Professionals who want to strengthen their Excel foundation
Anyone preparing to learn Advanced Excel
By the end of the course, learners will be able to:
Navigate Excel confidently
Organize and format data professionally
Use essential formulas and functions
Sort, filter, and validate information
Create Excel Tables and basic charts
Apply Conditional Formatting
Build simple Pivot Table reports
Complete common personal and workplace tasks efficiently
Modern Excel is powered by advanced formulas. This module equips you with the logical, lookup, dynamic array, and text functions required to automate calculations, simplify reporting, and solve complex business problems.
Advanced IF
Nested IF
IFS
AND
OR
NOT
VLOOKUP
HLOOKUP
INDEX + MATCH
XLOOKUP
XMATCH
FILTER
SORT
SORTBY
UNIQUE
SEQUENCE
CHOOSECOLS
VSTACK
LEFT
RIGHT
MID
TRIM
SUBSTITUTE
TEXTJOIN
TEXTSPLIT
Employee Master Reports
Sales Analysis
Customer Database Management
Inventory Lookup
Automated MIS Reports
Dynamic Report Generation
HR Reporting
Financial Data Analysis
Microsoft Excel 365
Dynamic Arrays
Formula Auditing
Function Library
Create powerful formulas that automate calculations, retrieve data intelligently, clean text, and build dynamic business reports.
Learn how organizations summarize, analyze, and interpret large datasets using Excel's analytical capabilities.
Creating Pivot Tables
Value Field Settings
Calculated Fields
Grouping
Filtering
Sorting
Interactive Charts
Dynamic Reporting
KPI Reporting
Data Tables
Scenario Manager
Goal Seek
What-If Analysis
Grouping
Outlining
Drill Down Reports
Sales Dashboards
HR Analytics
Budget Analysis
Profitability Reports
Performance Tracking
Management Reporting
Monthly MIS
Pivot Tables
Pivot Charts
Scenario Manager
Goal Seek
Analyze large datasets and build professional business reports using Excel's analytical tools.
Accurate reporting begins with clean data. Learn industry-standard techniques to transform raw datasets into analysis-ready information.
Flash Fill
TRIM
CLEAN
SUBSTITUTE
Remove Duplicates
Text to Columns
Data Validation
Drop-down Lists
Error Checking
Matching Reports
Identifying Missing Data
Data Consistency Checks
Dashboard-ready datasets
Report-ready datasets
Payroll Data Cleaning
Customer Database Cleanup
ERP Data Preparation
Sales Data Validation
HR Master Cleaning
Inventory Data Management
Flash Fill
Data Validation
Excel Tables
Text Functions
Prepare clean, consistent and reliable data for reporting, dashboards and analysis.
Transform numbers into meaningful visual insights through interactive dashboards and professional business reports.
Dashboard Planning
Layout Design
KPI Cards
Navigation
Advanced Conditional Formatting
Pivot Table Formatting
Dynamic Charts
Professional Formatting
Slicers
Timelines
Dashboard Filters
Dashboard Design Principles
User Experience
Color Selection
Report Layout
Executive Dashboards
Sales Performance Dashboards
HR Dashboards
Finance Dashboards
Operations Dashboards
Management KPI Reports
Conditional Formatting
Pivot Charts
Slicers
Timelines
Dashboard Controls
Design interactive dashboards that effectively communicate business performance and support better decision-making.
Discover modern Excel features that automate repetitive tasks and improve productivity using Microsoft 365 capabilities and AI.
INDIRECT
NETWORKDAYS.INTL
RANDBETWEEN
Named Ranges
Dynamic Arrays
Modern Excel Features
Workbook Optimization
Excel Copilot
AI Prompting Techniques
AI Formula Generation
AI-assisted Data Analysis
Productivity Tips
Formula Optimization
Faster Reporting
Automated Reports
Project Planning
Leave Planning
Business Simulations
AI-assisted Analysis
Report Automation
Microsoft Excel 365
Excel Copilot
Named Ranges
Dynamic Arrays
Improve productivity by combining modern Excel features with AI-powered capabilities to automate reporting and streamline business workflows.
Learn the advanced technologies used by data analysts and business intelligence professionals to work with enterprise-scale data.
Import Data
Transform Data
Merge Queries
Append Queries
Remove Errors
Data Cleaning Automation
Refresh Queries
Creating Relationships
One-to-Many Relationships
Star Schema
Calendar Tables
DAX Measures
Calculated Columns
Pivot Reports
Pivot Charts from Data Model
Interactive Dashboards using Data Model
Enterprise Reporting
Multi-Table Analysis
Automated Data Preparation
Business Intelligence Dashboards
Corporate MIS
Executive Reporting
Power Query
Power Pivot
Data Model
DAX
Pivot Charts
Build scalable Excel solutions using Power Query, Power Pivot, and Data Models to analyze multiple data sources and create enterprise-grade dashboards.
Understanding Business Reporting
MIS Design Principles
Dynamic Report Layouts
Executive Reporting
Department-wise Reporting
Business KPIs
Dashboard Planning
Report Standardization
Goal Seek
Scenario Manager
One-variable Data Tables
Two-variable Data Tables
What-If Analysis
Business Simulations
Forecasting Basics
Decision Support Models
Data Reconciliation
Customer Reconciliation
Inventory Reconciliation
Sales Reconciliation
Exception Reporting
Duplicate Detection
Missing Record Analysis
Validation Techniques
ETL Concepts
Power Query Interface
Query Workflow
Query Refresh
Applied Steps
Excel
CSV
Folder
Web
SharePoint
Split
Merge
Append
Pivot
Unpivot
Group By
Replace Values
Fill Down
Fill Up
Conditional Columns
Column from Examples
Duplicate vs Reference
Query Parameters
M Language Basics
Load to Data Model
Understanding Data Models
Star Schema
Fact & Dimension Tables
Relationships
Active & Inactive Relationships
Calendar Tables
Hierarchies
xVelocity Engine
Model Optimization
Calculated Columns
Measures
CALCULATE
FILTER
RELATED
RELATEDTABLE
SUMX
COUNTROWS
DISTINCTCOUNT
DIVIDE
Variables (VAR)
Pivot Tables
Pivot Charts
Slicers
Timelines
Dashboard Development
Connecting Excel to Power BI
Importing the Data Model
Refresh Concepts
Publishing Reports
Excel vs Power BI Workflow
Best Practices
End-to-End Corporate Project