Financial modelling in Excel

Financial modelling in Excel

Designed for the business professional with a need to model a business situation (opportunity) or perform complex manipulations of financial data. You will create your own customised, user-friendly model that will transform business rules and project expectations into projected future performance. Cover the use of a structured modeling format and the strengths (and weaknesses) of various analytical techniques such as internal rate of return (IRR) and net present value (NPV). Implementation and use of the IRR and NPV functions in Excel as well as numerous other spreadsheet techniques (lookup functions, conditional sum and if formulas, autofilters, conditional formatting) will be explored in detail. Participants should be familiar with basic Excel functions including the creation of cell referenced formulas.

Microsoft Excel is the world’s most widely used spreadsheet application. Our easy-to-understand Excel courses are proven to deliver results and increase your workplace efficiency. With the most effective Excel courses in the Australian market, we provide people with the skills to confidently work with this popular computer programs. You will learn to work with existing spreadsheet data and design your own spreadsheet models to suit your business needs. You will also learn to use all the tools and features of the application to save time and increase your productivity.

Pages:- 1
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>