₹6,500 ₹8,000

Course Includes

Duration3 Months
Enrolled10
Lectures1
Videos0
Notes0
CertificateYes

What you'll learn

The Advance Excel Course is designed to train students and professionals in data analysis, business reporting, MIS preparation, and automation using advanced Excel tools. This course covers powerful formulas, data cleaning techniques, Pivot Tables, dashboards, and professional reporting skills used in offices, finance, HR, accounting, and corporate environments.

Students learn how to manage large datasets, analyze trends, create automated sheets, and build insightful dashboards. By the end of the course, learners can prepare smart business reports, MIS sheets, and solve complex office problems with accuracy and speed.

This course is ideal for job seekers, accountants, HR executives, office staff, managers, and anyone who wants to upgrade their Excel skills for better career growth.

Course Syllabus

(ADVANCE EXCEL)

1. Excel Basics

Excel Interface
Workbook/Worksheet
Rows, Columns, Cells
Basic Formatting
Number Formatting (Date, Currency, %, etc.)
Basic Formulas:
SUM, AVERAGE, MIN, MAX
COUNT, COUNTA
Percentage formulas

2. Data Handling Tools

AutoFill & Flash Fill
Sorting (Single & Multi-Level)
Filtering (Auto, Custom)
Remove Duplicates
Text to Columns
Data Cleaning Techniques
TRIM, PROPER, UPPER, LOWER

3. Intermediate Formulas

IF, AND, OR, NOT
Text Functions: LEFT, RIGHT, MID, LEN, CONCAT
Date Functions: TODAY, NOW, DATEDIF, MONTH, YEAR
Lookup Functions:
VLOOKUP
HLOOKUP
XLOOKUP (if needed)

4. Advanced Excel

INDEX + MATCH
Nested IF
SUMIF, SUMIFS
COUNTIF, COUNTIFS
FILTER, UNIQUE, SORT
INDIRECT
Error Handling Functions:
IFERROR, ISBLANK, ISNUMBER

5. Data Analysis Tools

Pivot Table
Pivot Chart
Grouping
Slicers
Data Consolidation
What-If Analysis
Goal Seek
Scenario Manager

6. Charts & Dashboards

Column, Line, Pie Charts
Combo Charts
Trendlines
Sparklines
KPI Charts
Creating Professional Dashboards

7. Data Validation & Protection

Drop-down lists
Restrict data entries
Protect Sheet
Protect Workbook
Lock & unlock cells

8. Reporting & MIS

Sales Report
Purchase Report
Attendance Sheet
Stock & Inventory Sheet
Expense & Profit Sheet
Bank Reconciliation Format
Automated Business Templates

9. Productivity & Automation (Non-Macro)

Keyboard Shortcuts
Dynamic Ranges
Template Creation
Time-saving techniques

10. Practical Projects

Full MIS Project
Dashboard Creation
Lookup-based project
Data cleaning & analysis project
Monthly Report preparation project

Course Fees

₹8000/-

Discounted Fees

₹ 6500/-

Course Duration

3 Months

Review

0.0

Course Rating (0 reviews)

Featured review

No reviews yet. Be the first to review this course!

Certification In Advance Excel(S-AE-1475)