Header Banner
Best Seller Icon Bestseller
0 rating

Certificate Course In Advance Excel(S-AE-8192)

  • Last updated Feb, 2026
  • Certified Course
₹3,500 ₹8,000
Enquire Now

Course Includes

  • Duration2 Months
  • Enrolled0
  • Lectures45
  • Videos0
  • Notes0
  • CertificateYes

What you'll learn

✅ Office Data Work Confidence

✅ Job Ready Excel Skills

✅ Professional Report Making

✅ Productivity Improvement

Show More

Course Syllabus

Basic to Advanced Topics (Recommended)

1. Introduction to Microsoft Excel

  • Excel Interface Understanding
  • Workbook vs Worksheet
  • Data Types & Formatting

2. Data Formatting & Presentation

  • Conditional Formatting
  • Cell Style & Number Formatting
  • Alignment & Table Design

3. Formulas & Functions (Most Important Section ⭐)

  • Basic Formula (+, -, *, /)
  • SUM, AVERAGE, COUNT
  • IF, Nested IF
  • VLOOKUP, HLOOKUP
  • INDEX & MATCH
  • TEXT Functions

4. Data Management Skills

  • Sort & Filter
  • Remove Duplicate
  • Data Validation
  • Flash Fill
  • Pivot Table Basics

5. Charts & Visualization

  • Column, Bar, Pie Chart
  • Dashboard Introduction
  • Report Presentation

6. Advanced Productivity Tools

  • Conditional Logic Functions
  • Error Handling (IFERROR)
  • Power Tools Overview
  • Keyboard Shortcuts

7. Job-Oriented Practical Training ⭐

  • Office Data Entry Work
  • Salary Sheet
  • Attendance Management
  • Invoice / Billing Format
  • Report Making

8. Project Work

  • Mini Office Project
  • Dashboard Creation


Course Fees

Course Fees
:
₹8000/-
Discounted Fees
:
₹ 3500/-
Course Duration
:
2 Months

Review

0.0
Course Rating (0 reviews)
0%
0%
0%
0%
0%

Featured review

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

Top Course

More Popular Courses

View All Course
-79% Off
(0 Reviews)

ADVANCE DIPLOMA In COMPUTER APPLICATION(M-CA-4538)

In Advance Diploma Related Course
₹12,500 ₹60,000
Learn More
-67% Off
(0 Reviews)

ADVANCE DIPLOMA In Graphics Design(M-GD-7083)

In Advance Diploma Related Course
₹15,000 ₹45,000
Learn More
More Similar Courses

Related Courses

-46% Off
(0 Reviews)

Certificate Course In Basic Computer(S-BC-5497)

In Office Work Related Courses
₹1,000 ₹1,850
Learn More
-36% Off
(0 Reviews)

Certificate Course In Microsoft Office(S-MO-9716)

In Office Work Related Courses
₹3,500 ₹5,500
Learn More
-47% Off
(0 Reviews)

Certificate Course In Office Receptionist Professional Course(S-ORPC-4259)

In Office Work Related Courses
₹5,000 ₹9,500
Learn More

Copyright © 2026 DITRP INDIA. All Rights Reserved

Call
Text Message
Review
Email
CHAT