01
Excel Fundamentals & Professional Formatting
- Workbook & Worksheet Management
- Advanced Formatting
- Custom Number Formats
- Tables & Structured References
- Freeze Panes & View Options
- Page Setup & Printing
- Named Ranges
← Back to Computer Courses
02
COURSE SYLLABUSAdvanced Excel
Explore the complete course syllabus, topics and practical learning areas.
WHAT YOU WILL LEARN
Course Syllabus
A structured learning path covering the topics included in this course.
02
Advanced Excel Formulas & Functions
- Relative, Absolute & Mixed References
- IF, IFS, AND, OR, NOT
- SUMIF, SUMIFS
- COUNTIF, COUNTIFS
- AVERAGEIF, AVERAGEIFS
- IFERROR
- ROUND, ROUNDUP, ROUNDDOWN
- LEFT, RIGHT, MID
- LEN, TRIM, CLEAN
- CONCAT, TEXTJOIN
- TEXT, DATE & TIME Functions
03
Lookup & Reference Functions
- VLOOKUP
- HLOOKUP
- XLOOKUP
- INDEX & MATCH
- INDEX-MATCH with Multiple Criteria
- CHOOSE
- FILTER
- SORT & SORTBY
- UNIQUE
04
Data Management & Analysis
- Sorting & Advanced Filtering
- Advanced Filter
- Remove Duplicates
- Data Validation
- Drop-down Lists
- Text to Columns
- Flash Fill
- Find & Replace
- Subtotal
- Grouping & Outline
05
Conditional Formatting
- Formula-based Conditional Formatting
- Duplicate & Unique Values
- Data Bars
- Color Scales
- Icon Sets
- Dynamic Conditional Formatting
06
Pivot Tables & Pivot Charts
- Creating Pivot Tables
- Grouping Data
- Calculated Fields
- Slicers
- Timelines
- Pivot Charts
- Interactive Reports
- Dynamic Pivot Reports
07
Charts & Data Visualization
- Column & Bar Charts
- Line & Pie Charts
- Combo Charts
- Area Charts
- Dynamic Charts
- Sparklines
- Professional Report Formatting
08
Excel Dashboard
- Dashboard Planning
- KPI Creation
- Interactive Charts
- Slicers & Timelines
- Dynamic Reports
- Management Dashboards
- Sales Dashboard
- HR Dashboard
- Finance Dashboard
09
Data Cleaning & Preparation
- Cleaning Raw Data
- Handling Blank Cells
- Removing Duplicates
- Text Cleaning
- Date & Time Cleaning
- Data Standardization
- Error Handling
10
Power Query
- Introduction to Power Query
- Importing Data
- Cleaning & Transforming Data
- Merge Queries
- Append Queries
- Combining Multiple Files
- Refreshing Data
- Creating Automated Data Reports
11
What-If Analysis
- Goal Seek
- Scenario Manager
- Data Tables
- What-If Analysis
- Basic Forecasting
12
Practical Office Projects
- Employee Salary & Payroll System
- Attendance Management
- Sales & Purchase Report
- Inventory Management
- Invoice Management
- Employee Database
- MIS Report
- Sales Dashboard
- HR Dashboard
- Monthly Management Report
13
Automation — Optional Advanced Module
- Macro Basics
- Recording Macros
- Running & Editing Macros
- Introduction to VBA
- Simple VBA Automation