Bestseller
Bestseller
Advance Excel:
1.Excel Basics & Formatting
2.Formulas & Functions
3.IF, SUMIF, COUNTIF
4.VLOOKUP, HLOOKUP, XLOOKUP
5.Data Sorting, Filtering & Validation
6.Conditional Formatting
7.Pivot Table & Pivot Chart
8.Charts & Dashboard
9.Data Analysis & What-If Analysis
Macros & VBA Basics
Advanced Excel – Syllabus
Unit 1: Excel Basics & Data Management
Excel Interface & Workbook Management
Data Entry & Formatting
Sort & Filter
Tables
Data Validation
Conditional Formatting
Find & Replace
Freeze Panes
Unit 2: Advanced Formulas & Functions
SUM, AVERAGE, COUNT, MAX, MIN
IF, AND, OR, NOT
SUMIF, SUMIFS
COUNTIF, COUNTIFS
AVERAGEIF, AVERAGEIFS
VLOOKUP, HLOOKUP
XLOOKUP
INDEX & MATCH
IFERROR
Text Functions
Date & Time Functions
Unit 3: Data Analysis
Pivot Table
Pivot Chart
Slicers
Subtotal
Advanced Filter
What-If Analysis
Goal Seek
Scenario Manager
Unit 4: Charts & Dashboard
Column, Bar, Line & Pie Charts
Combo Charts
Advanced Charts
Interactive Dashboard
KPI & Summary Reports
Data Visualization
Unit 5: Advanced Excel Tools
Power Query – Basics
Data Cleaning & Transformation
Importing Data
Removing Duplicates
Flash Fill
Named Ranges
Protect Sheet & Workbook
Unit 6: Macros & VBA – Basics
Introduction to Macro
Record Macro
Run & Edit Macro
VBA Introduction
Variables & Data Types
Basic VBA Programming
Simple Automation
Practical Projects
Sales Report
Employee Salary Sheet
Attendance Report
Monthly Expense Tracker
Student Marksheet
Sales Dashboard
Inventory Management Report
Who can apply for this course
SSC / HSC / ANY GRADUATION / ANY POST GRADUATION /WORKING PROFESSIONALS IN IT AND SALES MARKETING
Copyright © 2026 AMOSOFT TECH WORLD. All Rights Reserved
