merger merger

Welcome to your new course portal!

On October 15th, hotcourses.com moved to findcourses.co.uk - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show findcourses.co.uk as: Mobile

Excel Power Modeling (1 day)

AMT Training
Course summary
1 day
650 GBP
Full time
Professional Training
Next available date: Online delivery option may be available - Please contact provider - Online courses
Course Dates
Online courses
650 GBP
Online delivery option may be available - Please contact provider

London
650 GBP
Enquire for more information

Course description

Excel Power Modeling (1 day)

This program covers a range of tools and techniques in Excel designed to improve effectiveness and efficiency. The program 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 delegates’ needs.

Suitability - Who should attend?

  • New hires who have joined the firm late and missed the in-house program
  • Individuals looking to fill a knowledge gap
  • Experienced bankers looking to refresh their technical skills
  • Teams employed in financial strategy roles from non-banking corporations
  • Graduates preparing to interview for a role in the finance sector
  • Students at business school and looking for a career in finance

Training Course Content

Learning Outcomes

  • Modeling with speed and style
    • Setting up toolbars so that Excel can be used as efficiently as possible
    • Setting up formatting styles
    • Custom number formats
  • Keeping circularities under control
    • 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
    • Use functions to extract information from a model
    • VLOOKUP
    • HLOOKUP
    • OFFSET
    • INDEX
    • MATCH
    • Data validation
    • INDIRECT
  • Scenarios
    • Building scenarios into the model
    • CHOOSE
    • OFFSET
    • INDEX
    • MATCH
    • On sheet controls
    • Conditional Formatting
  • Working with text and dates
    • 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
    • Run sensitivities on model outputs
    • One-input data tables
    • Two-input data tables
    • Three-input data tables
    • Data table secrets
  • Lists
    • Creating lists
    • Sorting
    • Basic and advanced filtering
    • SUMIF and COUNTIF
    • Calculate with advanced criteria with database functions
    • Pivot tables
  • Other functionality
    • 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

Course delivery details

While this is a face to face training course, a blended learning approach is taken and delegates will be provided with access to AMT Online. Our study materials contain both the knowledge and practice materials required to assist with the learning process and help you in your job role. Course materials include:

  • e-binder
  • laminated summary sheets
  • 24/7 access to DELTA online learning environment
  • class recordings
  • course notes
  • quizzes
  • electronic homework/study files

About provider

AMT Training - Financial Modeling Courses

For over 20 years we have been equipping analysts and associates with core skills for banking and finance. Our clients include the top ten investment banks and some of the biggest private equity firms in the world. With offices in...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Excel Power Modeling (1 day).

  Contact the provider

  Get more information

  Register your interest

Contact info

AMT Training

5th floor Whitechapel Building 10 Whitechapel High Street
E1 8QS London

 Show phone number
www.amttraining.com

Reviews

Average rating 4.8

Based on 9 reviews.

Dylan
They are the Phil Dunphy of the financial training world; top guy!!
Hilda
Wanda Flanagon
Excellent course, most i've ever learnt on EXCEL!
Request Information

Find out more about this Excel Power Modeling (1 day) course - simply fill out your details:

Reviews
Course rating
(4.8)
Based on 9 reviews.
Not sure where to start?