Expand your knowledge and integrate modeling standards.
This training allows you to create a budget model adapted to your company, while respecting good practices. Good modeling also means avoiding the most common mistakes and using the right functions, depending on the forecasting objective.
Is it for you ?
All management positions.
Prerequisites
Experience using MS Excel (Course CH271).
Training content
- Discover little-known features of Excel: shortcuts, expert tips and tricks
- Using tools: sensitivity analysis and possible scenarios, data analysis with dynamic pivot tables, polished graphics
- Creating macros
- Improving the mastery of functions: integrating multiple functions and creating formulas to handle complex calculations
- Best practices in financial modeling: planning a model, incorporating proven methods
- Rigorously controlling and organizing data: optimizing, simplifying and standardizing models, reducing operational risks
- Combining features and tools in building accounting and financial models
- Formula auditing tools: watch windows, tracing precedents, tracing dependents, etc.
- Naming cells: managing names, defining names, applying names, etc.
- Mastering Excel: exercises and completion of a case study.
See more
📌 Practical information
Our training sessions are offered in Montreal or Quebec City, in person or in a virtual classroom. Dates and locations are specified when you select your session below. If you have any questions, check out our FAQ.
