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.
Duration
2 days
Schedule
9h to 16h
Regular fee
$965
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$870
Objectives of the training
To provide the knowledge and skills required to master the advanced features of Excel and pair these with a rigorous methodology in order to build superior accounting and financial models, according to best business practices.Targeted audience
All management positions.Prerequisite
Experience using MS Excel (Course CH271).Trainers
Course architecture
- 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.
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quoteDuration
2 days
Schedule
9h to 16h
Regular fee
$965
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$870
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote