What you'll learn
📘 Certificate in Advance Excel – Course Description
Certificate in Advance Excel एक practical-based course है, जिसे इस तरह design किया गया है कि students को Excel के advanced tools, formulas, data analysis और reporting skills में expert बनाया जा सके। इस course में students को VLOOKUP, XLOOKUP, Pivot Table, Charts, Dashboard, Conditional Formatting और Real-life projects पर काम करना सिखाया जाता है।
यह course office work, accounts, data entry, MIS executive, banking, business reporting और private/government jobs के लिए बहुत उपयोगी है। Course पूरा होने के बाद students professional reports, salary sheets, sales analysis और dynamic dashboards आसानी से बना सकते हैं।
🎯 Career Benefits
- Office & Corporate Job Ready Skills
- Data Analysis & Reporting Expertise
- Time-Saving Excel Techniques
- Industry-Based Practical Training
Show More
Course Syllabus
📜 Certificate in Advance Excel – Syllabus
🔹 Course Duration
1.5 से 3 महीने (Theory + Practical)
🔹 Eligibility
Basic Computer Knowledge / MS Excel Basic
📘 Module 1: Excel Basics (Revision)
- Excel Interface & Workbook Structure
- Rows, Columns, Cells
- Data Types (Text, Number, Date)
- Cell Referencing (Relative, Absolute, Mixed)
- Formatting Cells (Font, Alignment, Number Format)
📗 Module 2: Formulas & Functions
- Arithmetic Formulas
- AutoSum & AutoFill
- Logical Functions:
- IF, AND, OR, NOT
- Statistical Functions:
- COUNT, COUNTA, COUNTIF
- Mathematical Functions:
- SUM, SUMIF, ROUND
- Text Functions:
- LEFT, RIGHT, MID, LEN, TRIM
- Date & Time Functions:
- TODAY, NOW, DATEDIF
📙 Module 3: Data Management
- Sorting (Single & Multiple Level)
- Filtering (Auto Filter, Advanced Filter)
- Data Validation
- Remove Duplicates
- Find & Replace
📕 Module 4: Charts & Visualization
- Types of Charts
- Column, Bar, Line, Pie
- Chart Formatting
- Dynamic Charts
- Sparklines
📓 Module 5: Conditional Formatting
- Highlight Cell Rules
- Data Bars, Color Scales
- Icon Sets
- Custom Conditional Formatting (Formulas)
📔 Module 6: Pivot Table & Pivot Chart
- Create Pivot Table
- Pivot Table Fields
- Grouping Data
- Calculated Fields
- Pivot Charts
- Slicers & Timelines
📒 Module 7: Advanced Excel Tools
- What-If Analysis
- Goal Seek
- Scenario Manager
- Lookup Functions:
- VLOOKUP, HLOOKUP
- XLOOKUP
- INDEX & MATCH
- Subtotal & Consolidation
📐 Module 8: Excel Dashboard
- Dashboard Planning
- Use of Pivot Table & Charts
- Interactive Dashboard
- KPI Indicators
🛡️ Module 9: Excel Security & Automation
- Protect Workbook & Worksheet
- Lock / Unlock Cells
- Freeze Panes
- Print Setup & Page Layout
- Introduction to Macros (Basic)
📝 Module 10: Practical & Project
- Real-Life Data Entry Project
- Salary Sheet
- Sales Report
- Result Sheet
- Certificate & Viva
Bestseller
