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

Advance Excel
Certificate Course in Advance Excel

Join Now
Contact


What you'll learn

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

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