merger merger

Welcome to your new course portal!

On October 15th, moved to - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show as: Mobile

How does COVID-19 impact education? See what we're doing to help our learners.

Certified Budget Analyst - Advanced Budgeting & Financial Forecasting using Advanced Excel (In-House)

LEORON Professional Development Institute
Course summary
5 days
4,190 USD excl. VAT
Next available date: Enquire for details - Worldwide
Corporate Training for Teams

Course Description

Certified Budget Analyst - Advanced Budgeting & Financial Forecasting w/ Advanced Excel (In-house)

This in-house Certified Budget Analyst - Advanced Budgeting & Financial Forecasting Using Advanced Excel course helps participants understand that in our rapidly developing markets, the need for companies to react promptly to the changing environment is crucial. Historical accounting records are essential but are not enough for managers to make informed strategic operational and financial decisions.

Over the duration of this in-house course, participants will learn how to develop PowerPivots that can handle data of up to 200 million rows on a standard desktop or laptop computers knowing that normal pivot tables in Excel usually fail to operate after about 30,000 rows of data. In addition, they will become familiar with numerous other features in PowerPivot that enrich the analysis of their data. For example, a PowerPivot can read data from different ranges, which is something a normal pivot table cannot accomplish.

Suitability - Who should attend?

This Certified Budget Analyst - Advanced Budgeting & Financial Forecasting w/ Advanced Excel in-house course is ideal for professionals in the following roles: 

  • Budgeting and planning personnel
  • Capital and resource planning
  • Finance managers
  • Senior and mid-level management
  • Department managers
  • Strategists
  • Data analysts
  • Riskcontrollers
  • Board members
  • Compliance officers
  • Financial modellers

Outcome / Qualification etc.

In addition to receiving 35 NASBA CPE credits, partcipants will 

1. Master advanced Excel tips in building dynamic financial models
2. Apply the various forecasting and smoothing techniques
3. Create dynamic and professional budgets in Excel and use the consolidate command
4. Start using the Monte Carlo Simulation in Excel
5. Change your data handling to the extremely powerful Pivot Tables

Training Course Content

The training content for this in-house course includes the following:

  • Excel Modelling Tools
  • Forecasting
  • Budgeting
  • Consolidating data
  • Forecasting Using Monte Carlo Simulation
  • PowerPivot

For the complete course outline, please send an enquiry.


LEORON delivers this course on an in-house basis, helping meet your company's specific training needs. Their customised training solutions are available worldwide and can be delivered at your offices or at conveniently located training facilities.

Get Inspired! Watch the Video

The Partners for Quality Award recognizes an Employer providing support to an individual where there was a significant benefit to the Division or Society. LEORON institute was granted the prestigious award for their continued promotion of Organizational Excellence through training courses that are directly related to quality improvement techniques and methodologies they provide while promoting the values and mission of ASQ Quality Management Division.


Provider: LEORON Professional Development Institute


Built upon the strong experience in the manufacturing sector, which its founders developed in Sweden during the 90’s global expansion, LEORON evolved into the dominant training institute that offers a comprehensive set of training and development solutions. All across the...

Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Certified Budget Analyst - Advanced Budgeting & Financial Forecasting using Advanced Excel (In-House).

  Contact the provider

  Get more information

  Register your interest

Contact information for LEORON Professional Development Institute

LEORON Professional Development Institute


 Show phone number

Request Information

Find out more about this Certified Budget Analyst - Advanced Budgeting & Financial Forecasting using Advanced Excel (In-House) course - simply fill out your details:


There are no reviews available yet.

U.K. L&D Report: 2019 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in's second annual U.K. L&D Report!


Learn more

Be Inspired - watch the videos
Case Study
LEORON Accredited by ANSI

LEORON Institute is accredited by ANSI as, ANSI-Accredited Certificate Issuer.

Read more

Similar Courses