Finance (Budget Modeling And Forecasting With Excel)

by Technologia IT Group Inc Claim Listing

This training allows you to create a budget model adapted to your business, while respecting good practices. Modeling well also means avoiding the most common errors and using the right functions, depending on the intended forecasting purpose.

$965

Contact the Institutes

Fill this form

Advertisement

Technologia IT Group Inc Logo

img Duration

2 Days

Course Details

This training allows you to create a budget model adapted to your business, while respecting good practices. Modeling well also means avoiding the most common errors and using the right functions, depending on the intended forecasting purpose.

 

Training Aims:

Be able to master the advanced features of Excel and combine this new knowledge with a rigorous working methodology to produce accounting and financial models according to best business practices.

 

Training Architecture:

  • Discovering Excel's Underutilized Features: Shortcuts, Tips, and Tricks from Experts
  • Use of tools: sensitivity analysis and possible scenarios, examination of data using pivot tables and refinement of graphs
  • Creating macro commands
  • Raising the level of mastery of functions: integration of several functions and creation of formulas supporting complex calculations
  • Applying best practices in financial modeling: planning a model and learning proven methods
  • Organization and rigorous control of data: optimization, simplification and standardization of models and reduction of operational risks
  • Combination of functionalities and tools in the development of accounting and financial models
  • Formula audit: spy windows, track antecedents, track dependents, etc.
  • Cell naming: name manager, set a name, apply names, etc.
  • Learning with Excel: exercises and carrying out a case on Excel
  • Montreal Branch

    1626, boulevard St-Laurent, Montreal

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy