Prowise Logo
Home
InternshipsPlacementsMentors / TeamAbout UsContact
Intermediate

Advanced Excel for Finance

20 Hours7 ModulesSKILL ACCELERATION

Course Overview

Advanced Excel training covering complex formulas, macros, VBA basics, pivot tables and data modeling. Master VLOOKUP, HLOOKUP, INDEX-MATCH, array formulas, What-if analysis, Goal seek, Solver, complex pivots, calculated fields, Power Query, dynamic charts, interactive dashboards, recording macros, VBA introduction, automation, DCF models, and scenario analysis. Get hands-on exercises, template library, practice datasets, VBA code repository, lifetime access to materials, and certificate of completion. Perfect for finance professionals, data analysts, managers, and business analysts seeking to improve productivity 10x.

Outcome: Excel power user

What You'll Learn

Use complex Excel functions
Create automated reports
Build interactive dashboards
Write basic VBA code
Analyze large datasets
Improve productivity 10x

Complete Curriculum

Module 1: Advanced Formulas
3 Hrs
Module 2: Data Analysis Tools
3 Hrs
Module 3: Pivot Tables Mastery
3 Hrs
Module 4: Power Query
2 Hrs
Module 5: Charts & Dashboards
3 Hrs
Module 6: Macros & VBA Basics
4 Hrs
Module 7: Financial Modeling
2 Hrs

Course Features

Hands-on exercises
Practical exercises for each topic
Template library
Ready-to-use Excel templates
Practice datasets
Real-world datasets for practice
VBA code repository
Library of reusable VBA code
Lifetime access to materials
Permanent access to all resources
Certificate of completion
Industry-recognized certificate

Who Should Enroll

Suitable For:
  • Finance professionals
  • Enhancing analytical capabilities
  • Data analysts
  • Building advanced Excel skills
  • Managers
  • Automating reporting and analysis
  • Business analysts
  • Mastering data analysis tools
Prerequisites:
  • Intermediate Excel knowledge
Experience Level:

2-8 years

Career Goals:

Excel specialist, Financial analyst, Business intelligence roles