Program Overview
In today's data-driven world, Excel remains the most essential tool for business analysis. This intensive 3-day online program will transform you from an intermediate Excel user to a power user capable of handling complex data analysis tasks with efficiency and confidence.
Why Attend?
- Master advanced functions and formulas for complex analysis
- Learn to clean, transform, and visualize data effectively
- Automate repetitive tasks with macros and Power Query
- Hands-on exercises with real business datasets
Who Should Attend?
- Financial Analysts
- Business Intelligence Professionals
- Accountants & Auditors
- Data Analysts
- Managers & Team Leaders
- Students pursuing analytics
Key Highlights
- Advanced Formulas - INDEX-MATCH, array formulas, dynamic named ranges
- Data Cleaning - Power Query, text functions, error handling
- Pivot Tables Mastery - Calculated fields, grouping, slicers
- Data Visualization - Advanced charts, conditional formatting, dashboards
- Automation - Macros, Power Pivot, VBA basics
- Real-world Case Studies - Financial, sales, and operational data
- Certificate of Completion - Validates your advanced skills
- Resource Kit - Templates, cheat sheets, practice files
Program Schedule
Day 1: 1st September 2025 - Excel Fundamentals & Data Preparation
- 09:30 AM – 11:00 AM: Advanced Formulas (INDEX-MATCH, XLOOKUP, Array Formulas)
- 11:00 AM – 11:15 AM: Coffee Break
- 11:15 AM – 12:45 PM: Data Cleaning Techniques (Text Functions, Data Validation)
- 12:45 PM – 01:45 PM: Lunch Break
- 01:45 PM – 03:15 PM: Power Query for Data Transformation
- 03:15 PM – 03:30 PM: Short Break
- 03:30 PM – 05:00 PM: Hands-on Case Study: Preparing Business Data
Day 2: 2nd September 2025 - Data Analysis & Visualization
- 09:30 AM – 11:00 AM: Advanced PivotTables (Calculated Fields, Grouping, Slicers)
- 11:00 AM – 11:15 AM: Coffee Break
- 11:15 AM – 12:45 PM: Data Analysis with Power Pivot (Data Models, DAX Basics)
- 12:45 PM – 01:45 PM: Lunch Break
- 01:45 PM – 03:15 PM: Advanced Charts & Conditional Formatting
- 03:15 PM – 03:30 PM: Short Break
- 03:30 PM – 05:00 PM: Interactive Dashboard Development
Day 3: 3rd September 2025 - Automation & Real-world Applications
- 09:30 AM – 11:00 AM: Macro Recording & VBA Fundamentals
- 11:00 AM – 11:15 AM: Coffee Break
- 11:15 AM – 12:45 PM: Automating Reports & Data Processes
- 12:45 PM – 01:45 PM: Lunch Break
- 01:45 PM – 03:15 PM: Capstone Project: End-to-End Data Analysis
- 03:15 PM – 03:30 PM: Short Break
- 03:30 PM – 05:00 PM: Project Presentations & Certification
All sessions include hands-on exercises with real business datasets. Participants should bring laptops with Microsoft Excel (2019 or later) installed.
Meet Your Program Director
Prof. (Dr.) Brajesh Kumar
Professor of Economics | Data Scientist | GST Expert | Program Director, MBA (Financial Management) | Data Scientist | Machine Learning Architect | Computational Econometrician | Chief Editor, NIFM Journal of Public Financial ManagementProf. (Dr.) Brajesh Kumar, a distinguished academician with ~28 years of experience, serves as Professor of Economics and Program Director (MBA-FM) at AJNIFM. He holds advanced degrees in Economics, Business Analytics, and Computer Applications, and is a certified Lean Six Sigma Black Belt. His expertise spans GST, data science, machine learning, and computational econometrics.
A prolific trainer and consultant, Dr. Kumar has led 220+ MDPs, advised government bodies on taxation and finance, and contributed to national and international research projects. He has represented India at global academic forums and developed digital governance tools using PHP, MySQL, and AI-based analytics.
"This Excel training transformed how I work with data. The advanced techniques I learned saved me 10+ hours per week in reporting. The dashboard skills alone were worth the course fee!"
Program Details
Dates: 1st September 2025 – 3rd September 2025
Duration: 3 Days | 18 Hours of Hands-on Training
Mode: Online (Live Interactive Sessions)
Program Director: Prof. (Dr.) Brajesh Kumar
Fees: ₹15,000 per participant
Includes all training materials, exercise files, and certificate
Group discounts available for 3+ participants from same organization
Technical Requirements: Excel 2016 or later (Windows)
Register Now
Contact Information
Scan to Pay Fees
Fee: ₹15,000
Registration Form
Complete the form below to register for the program