Course Name: Advanced Microsoft Excel

Duration: 1 to 2 Months

Suitable For: Students, Office Staff, Accountants, Data Entry Operators, Business Professionals

1. Excel Basics Revision

Introduction to Excel interface

Workbook, worksheet, rows and columns

Cell formatting and number formatting

Page setup and printing options

2. Advanced Formulas and Functions

SUM, AVERAGE, COUNT, COUNTA

IF, Nested IF

SUMIF, SUMIFS

COUNTIF, COUNTIFS

VLOOKUP, HLOOKUP

XLOOKUP

INDEX and MATCH

LEFT, RIGHT, MID

CONCAT, TEXTJOIN

TRIM, LEN, UPPER, LOWER

TODAY, NOW, DATE, DATEDIF

3. Data Sorting and Filtering

Sort data ascending and descending

Custom sorting

Auto Filter

Advanced Filter

Remove duplicates

Data validation

4. Conditional Formatting

Highlight cells rules

Top and bottom rules

Data bars

Color scales

Icon sets

Formula-based conditional formatting

5. Charts and Graphs

Column chart

Bar chart

Pie chart

Line chart

Combo chart

Chart formatting

Dynamic charts

6. Pivot Table and Pivot Chart

Create Pivot Table

Group data in Pivot Table

Calculated fields

Slicers

Timeline filter

Pivot Chart

Report formatting

7. Data Analysis Tools

What-If Analysis

Goal Seek

Scenario Manager

Data Tables

Flash Fill

Text to Columns

8. Excel for Accounts and Office Work

Salary sheet

Attendance sheet

Marksheet

Invoice format

GST calculation sheet

Stock management sheet

Sales report

Expense report

9. Excel Dashboard

Dashboard introduction

KPI cards

Charts with slicers

Interactive reports

Professional dashboard design

10. Macros and VBA Basics

Introduction to Macros

Record Macro

Run Macro

Assign Macro to button

Basic VBA editor introduction

Simple automation tasks

11. Final Project

Student will create one complete Excel project, such as:

Business Sales Dashboard

Employee Attendance System

GST Invoice Sheet

Stock Management Report

Salary Sheet with Formulas

Certificate

After completion, students can receive an Advanced Excel Course Certificate.