Excel Sensitivity Analyzer Course

We also have Free training videos on this site ( visit the Home page or the Training Page)

Miricle Solutions now offers an in-house course to help company employees in becoming power users of spreadsheets. The course includes financial modelling with specific reference to the Excel sensitivity analyzer.

The Excel sensitivity analyzer is a powerful tool for assessing what if scenarios and is an essential tool for assessing the impact of variables on a scenario. Users will also benefit from teachings about macros and will learn how to create a sensitivity graph.

Other useful features that are taught through our in-house courses are that of creating a table using the Excel sensitivity analyzer, alternative selection, and how to deal with possible changes.

Topics such as data tables, financial ratios, optimisation modelling, free cash flow valuation, basic forecasting, and probability checking are also covered in the third day of the course.

Day one of the course focuses on advanced spreadsheet techniques such as hyper linking, establishing the integrity of the model, and pivot tables, but a few of the topics covered. Day two of the course focuses on more advanced features such as the usage of masks, discounting cash flow and controls. Interest payments and scenarios are also taught through hands-on exercises.

Day three has the focus on the Excel sensitivity analyzer function. The course is presented by chartered accountants and financial analysts that work with the spreadsheet program daily and use it to perform complex functions. As such they have the practical experience required to ensure that course attendees will learn through hands-on exercises with everyday applications. Contact us to schedule an in-house course and empower your employees to ensure accurate projections.