Excel Power Modeling
|
Summary
|
|
|||||||||||
Excel Power Modeling
Excel Power Modeling - 1 Day training course in London
This one day training course is part of the Advanced Modeling Curriculum training offered by AMT Training.
The course aims to introduce participants to a range of tools and techniques in Excel designed to improve effectiveness and efficiency.
The course covers building scenarios into models using a variety of functions, together with adding in on-sheet controls, sensitivity analyses and flexible output tables. The topics in this menu can be chosen according to participants’ needs.
Interested in finding out more about this Excel Power Modeling training course? Contact AMT Training here
If you want to find out more about Excel Power Modeling, you can make an information request below and the school will contact you with further information.
Suitability and application
This Excel Power Modeling training course is part of the Advanced Modeling Curriculum, and as with all our public courses, is suitable for those who:
- have joined the firm late and missed the full time in-house program
- are looking to fill a knowledge gap
- are looking to refresh their technical skill
- are employed in financial strategy roles from non-banking Corporations
- are preparing to interview for a role in the finance sector
- are at business school and looking for a career in finance
Find out if this Excel Power Modeling training course is suitable for you - Request Information here
Excel Power Modeling - Course Content
This 1 day Excel Power Modeling training course is made up of three parts and is designed to cover the following topics:
- Modeling with speed and style (1 - 2 hours 2003 stds)
- Setting up toolbars so that Excel can be used as efficiently as possible
- Setting up formatting styles
- Custom number formats
- Keeping circularities under control (1 - 2 hours 2003 stds)
- Working with intentional circular references
- Debugging a model with non-intentional circular references
- Avoiding intentional circular references with a circular reference macro
- Flexible output tables (1 - 2 hours 2003 stds)
- Use functions to extract information from a model
- VLOOKUP
- HLOOKUP
- OFFSET
- INDEX
- MATCH
- Data validation
- INDIRECT
- Scenarios (1 - 2 hours 2003 stds)
- Building scenarios into the model
- CHOOSE
- OFFSET
- INDEX
- MATCH
- On sheet controls
- Conditional Formatting
- Working with Text and Dates (1 - 2 hours 2003 stds)
- Creating dynamic headings and footnotes in the model
- Working with dates
- Concatenation
- TEXT function
- UPPER, LOWER, PROPER functions
- TRIM and CLEAN functions
- RIGHT, LEFT & MID functions
- DATE, DAY, MONTH, YEAR functions
- Sensitivity analysis (1 - 2 hours 2003 stds)
- Run sensitivities on model outputs
- One-input data tables
- Two-input data tables
- Three-input data tables
- Data table secrets
- Lists (1 - 2 hours 2003 stds)
- Creating lists
- Sorting
- Basic and advanced filtering
- SUMIF and COUNTIF
- Calculate with advanced criteria with database functions
- Pivot tables
- Other functionality (1 - 2 hours 2003 stds)
- Printing with views
- Print macro
- Print macro with a form for easy print selection
- User defined functions
- Beauty save macro
- Protecting your work
- Charts
- Arrays
- Range names
- Shortcuts
Expenses
The cost of this Excel Power Modeling training course is £450 + VAT per delegate.
What To Bring: It is important that you bring a laptop (preferably Windows based) with Microsoft Excel, Word and PowerPoint, and Adobe Reader installed.
In House Training: AMT Training offer this training as an in-house option, or we can create a bespoke course tailored to your company. Please contact us here to find out more.
Adkins Matchett & Toy (AMT Training) - A Wilmington Company
Adkins Matchett & Toy (AMT) - Financial Training Courses in London
Adkins Matchett & Toy (AMT) have more than 30 years experience in building a reputation as one of the corporate world’s most trusted learning partners for financial training. AMT Training are specialists in equipping analysts and associates with the core skills required in banking and related sectors, including corporate finance training. With a training centre in the heart of London, AMT Training deliver innovative yet practical learning solutions that achieve measurable results for clients.
Open Public Financial Courses
All AMT courses are accredited by the Securities and Investment Institute and can be logged as 6 hours of CPD for institutions including ACA, ACCA, CFA. AMT Training have scheduled a series of open enrolment public financial courses that run throughout the year, and also run tailored in-house programs for firms looking to train staff on their premises. AMT regularly deliver training for all the top investment banks, as well as private equity firms, boutique shops and business schools.
AMT Training's financial training public courses are considered world class - and they have just been revamped! AMT Training's courses focus on relevancy and practical skills that are immediately applicable in the world of investment banking.
In House Financial Training
AMT Training also offer a complete library of in-house financial training, which can be tailored to fit your company's exact needs. Training can be completely bespoke in-house training, tailored for finance, banking and corporate requirements. Please contact us here to find out more and learn how we can help your organisation.
Request Information to find out more about AMT Training and their Financial Training Courses
Show all courses with
Adkins Matchett & Toy (AMT Training) - A Wilmington Company
Request information - obligation free
Contact information for Adkins Matchett & Toy (AMT Training) - A Wi...
Adkins Matchett & Toy (AMT Training) - A Wilmington Company
Phone no: +44 (0)20 7324 2385 
Contact Adkins Matchett & Toy (AMT Training) - A Wilmington Company
To request information from Excel Power Modeling, please fill out the following details:
A Wilmington Company
We are part of the Wilmington group of companies.
Wilmington Group is a specialist provider of professional training services for the legal, corporate, financial, accountancy, regulatory, property, human resource and other professional sectors.
