Home » Advanced Excel & Macros

📌 Introduction

This advanced Excel program equips professionals with powerful tools for data analysis, automation, and reporting. Learn to work with complex formulas, PivotTables, Power Query, and AI tools to streamline processes and make data-driven decisions.

🎯 Course Objectives –

  • Apply advanced formulas like XLOOKUP, IF-AND-OR, UNIQUE, and FILTER.
  • Build dynamic PivotTables, dashboards, and perform data modeling.
  • Clean and transform data using Power Query and automate tasks with Macros.
  • Use AI tools to simplify formula generation and enhance data analysis.
  • Perform scenario planning and forecasting for business insights.

Advanced Excel Formulas & Functions

Xlookup, Vlookup, Nested Lookups, Conditional formulas IF AND OR, Unique, SORT, FILTER & new office 365 formulas

Pivot Tables : Power Pivot – Advanced Pivot Techniques and Dashboards

  • Pivot Tables for Reporting & Summarization: Different reports & layouts, Automating & updating pivots on data modification
  • Data Modelling: Creating relationships between different data tables.
  • PivotTables with Power Pivot: Creating advanced PivotTables using the Power Pivot model.
  • Data visualization: Advanced charting techniques, Slicers, Sparklines and Timelines

Power Query – Advanced Data Cleaning & Automation

  • Data Import: Importing data from various sources (Excel, CSV, Folders, PDF, databases, web).
  • Data Transformation: Cleaning, reshaping, and preparing data with Power Query.
  • Merging and Appending Data: Combining & Consolidation data from different sources.
  • Use Case Example: Automating data preparation for monthly reports.

Data Analysis – Advanced Analysis & Forecasting techniques

Scenario Planning and Analysis

  • Creating Scenarios: creating and managing different scenarios.
  • Analyzing Scenarios: Techniques for comparing and analyzing multiple scenarios to understand potential outcomes.

Automation with Macros and VBA

  • Automating repetitive tasks and data processes.
  • Recording Macros
  • Automating Dashboard Creation

AI and Excel Automation

  • Different AI tools for complex formula generation, automation, advanced data Analysis

COURSE SCHEDULE & FEES

JUL
10
THU
Holiday Inn, Aerocity
Training Session
Delhi
In-Person Training
14750
Inclusive of all taxes
REGISTER NOW RESERVE A SEAT
JUL
11
FRI
The Lalit
Training Session
Mumbai
In-Person Training
14750
Inclusive of all taxes
REGISTER NOW RESERVE A SEAT
JUL
11
FRI
Holiday Inn
Training Session
Bangalore
In-Person Training
14750
Inclusive of all taxes
REGISTER NOW RESERVE A SEAT

DOWNLOAD COURSE CONTENTS

Please click the button below to download the course content. You'll need to provide your contact information to receive the document.

×

Download Course Content

Please fill out the form below to download the course content PDF.

INCOMPANY/GROUP TRAINING REQUEST

Why Choose Our Incompany Program?

  • 🎯 Tailored content specific to your business goals
  • đŸ‘„ Train entire teams together, saving time and cost
  • 📍 Delivered at your location or virtually
  • 📅 Flexible scheduling to suit your timelines
  • 📈 Increase retention and application of skills


    Current topic: [decoded_course_title]

    Any customisation Required