TRANSFORMING EDUCATION
AN ISO CERTIFIED EDUCATIONAL INSTITUTE
+91-94257-01888

Advanced Excel Complete Course

Master Excel for Data Analysis, Reporting & Automation

Book Free Demo Class

Course Overview

Duration

6 Months

Mode

Online / Offline

Level

Professional

Certification

Course Certificate

Course Modules

Module 1 – Excel Fundamentals

  • Excel Interface
  • Workbook & Worksheet
  • Formatting
  • Sorting & Filtering
  • Basic Data Cleaning
Duration: 1 Week

Module 2 – Excel Functions

  • SUM, COUNT, AVERAGE
  • IF & Nested IF
  • Text Functions
  • Date Functions
  • Logical Functions
Duration: 3 Weeks

Module 3 – Lookup Functions

  • VLOOKUP
  • HLOOKUP
  • XLOOKUP
  • INDEX MATCH
Duration: 2 Weeks

Module 4 – Data Management

  • Data Validation
  • Conditional Formatting
  • Remove Duplicates
  • Text to Columns
Duration: 2 Weeks

Module 5 – Pivot Tables

  • Pivot Table Creation
  • Grouping Data
  • Slicers
  • Pivot Charts
Duration: 2 Weeks

Module 6 – Excel Dashboards

  • Charts & Graphs
  • Interactive Dashboard
  • KPI Indicators
Duration: 2 Weeks

Module 7 – Data Analysis Tools

  • What-if Analysis
  • Goal Seek
  • Scenario Manager
  • Forecasting
Duration: 2 Weeks

Module 8 – Excel Automation

  • Macro Recorder
  • Introduction to VBA
  • Automating Reports
Duration: 2 Weeks

Course Features

100% Practical Training

Live Projects

Interview Preparation

Industry Certification

Start Your Career with Advanced Excel

Join the most practical Excel course and become job ready

Enroll Now
© Viva Technologies, All Right Reserved.
Designed By Viva Technologies