Professional Skill Development Course

Advance Excel

Master Advanced Excel, Formulas, Functions, Pivot Tables, Dashboards, Data Analysis, MIS Reporting and Professional Office Skills.

Apply Now Download Brochure
CCC Course

3 Months

Duration

10th Pass

Eligibility

Certificate

Course Completion

Offline/Online

Training Mode

What You Will Learn

Excel Basics
Advanced Formulas
Functions & Lookup
Conditional Formatting
Data Validation
Pivot Table
Pivot Chart
Dashboard Creation

Advance Excel Course Syllabus

Module 1

  • Excel Interface
  • Workbook & Worksheet
  • Rows & Columns
  • Cell Formatting
  • Data Entry

Module 2

  • Basic Formulas
  • SUM, AVERAGE
  • IF Function
  • COUNT & COUNTA
  • Date & Time

Module 3

  • VLOOKUP
  • HLOOKUP
  • XLOOKUP
  • INDEX
  • MATCH

Module 4

  • Conditional Formatting
  • Data Validation
  • Sort & Filter
  • Remove Duplicates
  • Flash Fill

Module 5

  • Pivot Table
  • Pivot Chart
  • Slicers
  • Dashboard
  • Charts

Module 6

  • Macros
  • Introduction to VBA
  • Excel Automation
  • Projects
  • Interview Preparation

Career Opportunities

MIS Executive
Data Analyst
Office Executive
Account Executive
Bank Executive
Data Entry Operator
Reporting Executive
Excel Trainer

Become an Advance Excel Expert

Admissions Open – Enroll Today & Upgrade Your Career

Apply Now