Office & Productivity

Advance Excel – Course Modules

Master advanced Excel skills from formulas and pivot tables to macros and MIS reporting, with real project work like expense trackers, to-do lists and salary records.

3 Months
₹5,000
EMI: ₹3,000 + ₹3,000 = ₹6,000
25 Topics
5 Sections
Enroll via WhatsApp Browse All Courses
3 Months
Duration
5
Sections
25
Topics Covered
Certificate
On Completion
ISO Certified
Govt. Recognised
About this Course

Master advanced Excel skills from formulas and pivot tables to macros and MIS reporting, with real project work like expense trackers, to-do lists and salary records.

Course Curriculum

What You'll Learn

5 sections  ·  25 topics
01
Spreadsheet Fundamentals
3 topics
  • Getting Started
  • Formatting a Spreadsheet
  • Working with Large Worksheets
02
Formulas & Functions
6 topics
  • Formulas and Functions
  • SUMIF, COUNTIF (Conditional Functions)
  • Lookup, HLookup, VLookup
  • Finance Formulas
  • IF, Date, Math Formulas
  • Goal Seek & Hyperlink
03
Data Management
6 topics
  • Data Validation
  • Sorting and Filtering Data
  • Advance Filter Condition
  • Conditional Formatting
  • Pivot Table
  • Database Operations
04
Advanced Features
6 topics
  • Working with Charts
  • Working with MIS Reports
  • Macros
  • Scenario Manager
  • Grouping & Ungrouping
  • Page Setup, Previewing and Printing
05
Project Work Examples
4 topics
  • Pay Slip of Employee
  • Monthly Expenses Record
  • To Do List
  • Phone List & Salary Records
Course Fees
₹5,000
One Time Pay
EMI: ₹3,000 + ₹3,000 = ₹6,000
Enroll via WhatsApp
Duration 3 Months
Sections 5
Topics 25
Certificate Yes
Mode Online + Offline
Rs. 200/- Admission Form Fees (extra). Contact Noor Sir: 9833806642 or Ayaan Sir: 8779661238
View All Courses