Advanced Excel Syllabus (60–80 तास)

Module 1 – File Tab (2 तास)

Advanced Workbook Management

• Password Protection
• Encrypt Workbook
• Protect Workbook
• Check for Issues
• Version History (Microsoft 365)
• Export PDF
• Share Workbook
• Recover Unsaved Files

Project

• Secure Company Salary File

Module 2 – Home Tab (8–10 तास)

Clipboard

• Paste Special
• Values
• Formula
• Format
• Transpose
• Format Painter

Font

Advanced Formatting

• Custom Fonts
• Cell Styles
• Theme Colors

Alignment

• Merge Alternatives
• Center Across Selection
• Wrap Text
• Orientation

Number Format

Custom Number Format

उदाहरण

00001

INV-0001

₹#,##0

dd-mm-yyyy

mmm-yyyy

Styles

• Conditional Formatting

शिकवावे

• Highlight Cells
• Top Bottom Rules
• Data Bars
• Color Scale
• Icon Set
• Formula Based Formatting

Cells

• Insert Cells
• Delete Cells
• Hide
• Group
• Ungroup

Editing

• Flash Fill
• Fill Series
• Find
• Replace
• Go To Special

Module 3 – Insert Tab (8 तास)

Tables

• Excel Table
• Structured References

Pivot Table

• Create Pivot
• Refresh
• Grouping
• Calculated Field
• Multiple Pivot

Pivot Chart

Slicer

Timeline

Charts

• Combo Chart
• Secondary Axis
• Dynamic Chart

Sparklines

Project

Sales Dashboard

Module 4 – Page Layout Tab (2 तास)

• Print Titles
• Print Area
• Background
• Themes
• Scaling
• Page Break

Module 5 – Formulas Tab (18–20 तास)

Logical

• IF
• Nested IF
• IFS
• AND
• OR
• NOT
• IFERROR

Lookup

• VLOOKUP
• HLOOKUP
• XLOOKUP
• INDEX
• MATCH

Text

• LEFT
• RIGHT
• MID
• LEN
• TRIM
• SUBSTITUTE
• REPLACE
• TEXT
• CONCAT
• TEXTJOIN

Date

• TODAY
• NOW
• DATE
• YEAR
• MONTH
• DAY
• EDATE
• EOMONTH
• NETWORKDAYS
• WORKDAY

Statistical

• COUNTIF
• COUNTIFS
• SUMIF
• SUMIFS
• AVERAGEIF
• AVERAGEIFS

Math

• ROUND
• ROUNDUP
• ROUNDDOWN
• ABS
• MOD
• INT

Financial

• PMT
• PV
• FV

Named Range

Formula Auditing

• Trace Precedent
• Trace Dependent
• Evaluate Formula

Module 6 – Data Tab (10 तास)

Sort

Advanced Filter

Remove Duplicate

Text to Column

Flash Fill

Consolidate

Subtotal

Group

Outline

Data Validation

Dependent Drop Down

What If Analysis

Goal Seek

Scenario Manager

Data Table

Module 7 – Review Tab (2 तास)

Protect Sheet

Protect Workbook

Allow Edit Range

Comments

Track Changes (Introduction)

Module 8 – View Tab (2 तास)

Freeze Panes

Split

Custom View

New Window

Arrange All

Hide Window

Zoom

Module 9 – Developer Tab (10 तास)

Macro

Record Macro

Run Macro

Assign Button

Introduction VBA

MsgBox

Variables

Simple Automation

Module 10 – Power Query (8 तास)

Import

CSV

Excel

Folder

Merge

Append

Transform

Clean Data

Refresh

Module 11 – Dashboard Project (8 तास)

Create Dashboard

Sales Dashboard

HR Dashboard

Inventory Dashboard

Accounts Dashboard

MIS Dashboard

Live Projects (15–20)

विद्यार्थ्यांना खालील प्रोजेक्ट्स करून घ्या:

1. Payroll System
2. Employee Attendance
3. Inventory Management
4. GST Sales Register
5. Purchase Register
6. Sales Analysis Dashboard
7. Profit & Loss Report
8. Expense Tracker
9. Fee Collection Software (Excel)
10. Stock Management
11. Customer Database
12. Invoice Generator
13. Loan EMI Calculator
14. Budget Planner
15. MIS Reporting Dashboard

Course Duration

• Theory : 15 तास
• Practical : 45 तास
• Projects : 20 तास

एकूण: 80 तास