Course Title:- Advanced Microsoft Excel – Gmind InstituteSpecial Offer: 50% OFF! Now Only ₹2,000 (Original Price: ₹4,000)

Course Duration: 3 Months (36 Hours)

Batch Timing:** Morning/Evening – Flexible

Course Overview:

Become an Excel Expert** with Gmind Institute! This course is designed to teach you advanced Excel skills for data analysis, reporting, dashboards, and automation. Learn practical, job-ready skills with hands-on exercises.

Why Join This Course:

Master advanced Excel formulas and functions

Create professional dashboards and reports

 Automate tasks with macros

 Real-life project-based learning

 Certificate of Completion from Gmind Institute

Course Content / Syllabus (₹2,000 Offer Content Focus)

Module 1: Excel Basics Refresher

 Interface, ribbons, shortcuts

 Formatting and data validation

 Conditional formatti

Module 2: Advanced Formulas & Functions

Logical Functions: IF, IFERROR, AND, OR

Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH

 Text Functions: CONCAT, LEFT, RIGHT, TEXTJOIN

 Date & Time Functions

Module 3: Data Analysis & Management

Sorting, filtering, and advanced filtering

Goal Seek and Scenario Manager  Removing duplicates and Flash Fill

Module 4: Pivot Tables & Charts and customizing pivot tables Using slicers and timelines                    Pivot charts and visualization

Module 5: Advanced Visualization & Dashboards

Dynamic charts: Combo, Waterfall, Histogram                                                                                       Sparklines and conditional charts                                                                                                             Simple dashboards for reporting                                                                                                               Module 6: Excel Automation (Basics)                                                                                                            Recording and running macros                                                                                                                     Introduction to VBA basics                                                                                                                              Learning Outcomes:                                                                                                                                 Handle complex data efficiently

* Analyze and visualize data professionally

* Automate repetitive tasks in Excel

* Build dashboards and reports for business needs