₹3,000 ₹4,000

Course Includes

Duration1 Months
Enrolled0
Lectures25
Videos0
Notes0
CertificateYes

What you'll learn

This course focuses on advanced Excel skills used for data analysis, reporting, and automation. Learners will work with advanced formulas, pivot tables, charts, conditional formatting, data validation, and basic macros. By the end of the course, students will be able to create professional dashboards, MIS reports, and automate routine Excel tasks efficiently.

Course Syllabus

Advanced Excel Certificate Course

Module 1: Excel Review

Excel interface & worksheet basics
Revision of basic formulas

Module 2: Advanced Formulas & Functions

Logical functions: IF, AND, OR
Lookup functions: VLOOKUP, HLOOKUP
INDEX & MATCH
Text, date & mathematical functions

Module 3: Data Cleaning & Management

Remove duplicates & errors
Text to Columns, Find & Replace
TRIM, UPPER, LOWER, PROPER

Module 4: Charts & Data Visualization

Column, bar, line & pie charts
Chart formatting

Module 5: Pivot Tables

Creating Pivot Tables
Filtering, grouping & summarization

Module 6: Conditional Formatting

Highlight rules
Data bars & color scales

Module 7: Data Validation

Dropdown lists
Input restrictions & error alerts

Module 8: Macros & Automation

Introduction to Macros
Record & run macros

Module 9: Dashboard & MIS Reporting

Excel dashboards
Management reports (MIS)

Module 10: Final Project

Real-world Excel project
Reporting & automation

Course Fees

₹4000/-

Discounted Fees

₹ 3000/-

Course Duration

1 Months

Review

0.0

Course Rating (0 reviews)

Featured review

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

Certificate In ADVANCE EXCEL(S-CIAE-7732)