Excel Power Features for Financial Modelling

Adkins Matchett & Toy
Banbury, Oxfordshire, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' A CONCENTRATED DAY OF EXCEL POWER TIPS AND ADVANCED FEATURES FOR USE IN FINANCE

Excel Functions

Using the OFFSET function to pick up information from a model and document a model with scenarios
Using VLOOKUP and HLOOKUP in data analysis and multiples models
Using MAX functions to slim down IF statement formulae
Nested IF statements and IF statements with logical operators
Using SUMPRODUCT for calendarisation in multiples models
Date functions and date maths in Excel
Using text functions to manipulate data downloads
Databases and data sorting
Pivot tables
SUMIF, COUNTIF and D functions
Arrays, conditional arrays and the INDIRECT and TRANSPOSE functions

Presentation Tools in Excel

Building data tables and solving data table problems such as using data tables across sheets and calculation issues
How to ¡°plutonium burst¡± your model¡¯s calculation
Using graphs to present data. How to create a ¡°floating bar chart¡± for valuation presentations. How to save your graph formatting to help maintain consistency.
How to print and set print ranges effectively. Using macros to print an executive summary.
Printing and using headers & footers
Using concatenation to automate your labels
Using comments to document your model. Printing comments on the spreadsheet and ¡°moving¡± them so they don¡¯t cover used cells
Using Excel¡¯s grouping feature to set up a consistent look and format to your model
Creating user-defined styles to maintain and change formatting in a model
Using conditional formatting features

Advanced Features

Using macros to automate your model
Using action buttons for model options

Extreme Proofreading Techniques

Error checking a model; showing and printing formulae, referencing constants, searching for links and error messages
Solving problems with circular references and iterations
Using ¡°jump¡± to check formulae
The upside and downside of using named ranges in models
...''

Phone:+44 (0) 1295 817420

School Address:

Linden House, South Bar
Banbury, OX16 9AB
UK

Jobs & Resumes: Banbury
Houses & Roommates: Banbury

Basic Accounting for Finance Professionals
Building a Fully Integrated Financial Statement Forecast
Accounting for Valuation
DCF Valuation
Comparable Company Valuation
Leveraged Buyout Modelling
Merger Modelling
Bank Modelling and Valuation
Insurance Company Modelling and Valuation
Advanced financial analysis skills
Financial accounting
Capital markets math
Investment management analytics
Capital markets: debt & equity

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.