This certification is designed to support Animated chart in Excel, how visualization happen in excel, and transpose the address data, to create dynamic charts in VBA, using of clock and timer using formulas.

About Certification

In this certification you will learn about VBA Charts Functions of Macros and VBA functions Forecasting using Monte Carlo Simulation.


This certification will help professionals to…

  • Providing 3D animated chart in excel
  • Creating Power point presentations using Excel, Extracting cell comments.
  • Implementing VBA charts, and sharing functions
  • Forecasting using Monte Carlo Simulation.

Target Audience

Associate VBA

VBA Analyst

Manager Business Analyst

VBA technical Developers

VBA Macros professionals


4+ Hrs Video Recording

Excels Workbook

Study Notes

In this certification you possibly determine how the project will be run and who will work on what task with clear view of what is expected and when.

Companies that hire Certified Candidate


Advanced Excel and VBA

Macros and VBA

Course Curriculum

  • Introduction VBA
  • Defining Events Using Macro
  • VBA Functions
  • VBA Coding
  • VBA Chart
  • Recording Macro Efficiently
  • Breaking Circular Reference using Macro
  • Importing Web Data using Macro
  • User Defined Function using Macro
  • Sharing Function
  • Forecasting using Monte Carlo Simulation