Hand Emojji ImagesISO 9001:2015 Certified Computer Training Institute
Student
Student Login

Advance Excel
Certificate Course in Advance Excel

Course Duration : 60 days

Join Now
Contact


Advance Excel Course Overview

The Advanced Excel course is designed for students and professionals who already know the basics of Excel and want to develop professional-level skills. This course focuses on data analysis, reporting, automation, and dashboard creation.

Show More

Advance Excel Course Syllabus

Course Outline

  • Nested IF, IFS, SWITCH
  • VLOOKUP, HLOOKUP, XLOOKUP
  • INDEX + MATCH
  • SUMIFS, COUNTIFS, AVERAGEIFS
  • IFERROR, ISBLANK, ISNUMBER
  • TEXT functions (LEFT, RIGHT, MID, CONCAT, TEXTJOIN)
  • Date & Time functions
  • Logical & Statistical functions

  • Advanced Formulas & Functions
  • What-If Analysis (Goal Seek, Scenario Manager)
  • Data Tables

  • Flash Fill
  • Remove Duplicates
  • Text-to-Columns
  • Power Query basics

  • Conditional Formatting
  • Interactive Charts
  • Dashboard Design Principles



Copyright © 2026, Powered By : Web Infomax IT Solutions