Microsoft Excel features for Financial Management | Kaplan Financial
Skip to main content

Excel for Financial Management & Modelling

My Basket | 0 items
Go Search
Training and Qualifications > Financial Markets > Excel for Financial Management & Modelling > Pages > Excel-features-for-Financial-Management-1.aspx  

Kaplan Financial - Home > Training and Qualifications > Financial Markets > Excel for Financial Management & Modelling > Microsoft Excel features for Financial Management

Excel Features for Financial Management

This course provides a good grounding in Excel techniques that can be used to selectively manipulate large datasets. Anyone who has to deal with lists of information will benefit from the material that we cover here.

Excel Features for Financial Management  

Price: £600.00
Price: £600.00
Price: £600.00
Price: £600.00

What’s Included?

  • Some more advanced functions: including COUNTIF(), SUMIF(), and SUMPRODUCT()
  • Lookup techniques, including:
    • VLOOKUP(), HLOOKUP() and the trapping of errors via IFERROR()
    • MATCH() and INDEX()
  • Functions for manipulating sequences of characters (text strings)
  • Excel feature for managing lists and tables, including Sorting, Filtering, Grouping & Subtotals
  • An introduction to PivotTables & PivotCharts

Click to see a more detailed course content.

Prerequisite: Candidates on this course should have familiarity with the techniques covered on Introduction to Excel Functionality.

Excel for Financial Management - Save up to £445*

Book more than one course in order to get discounts:

  • Order any two courses, save 5%
  • Order any three courses, save 10%
  • Order any four courses, save 15%
  • Order all five courses and save 20%

If you're interested in other uses for Excel, please check our additional Excel for Financial Management courses:

* T&Cs of discount: Discount will be applied in the basket and the courses must be booked together for the discount to apply. This offer is not applicable with any other offers. Cancellation terms and conditions apply and your discount will be altered in the event of any cancellations.

Items: 0Total: £0.00

  020 3468 2122

  Email Us


Key info

Available on these dates:

26th January 2017
28th March 2017
6th July 2017
10th October 2017

Course length:
1 day (9am to 5pm)

Study options:
Classroom, using provided laptops

Location:
London
or
In-house by arrangement.

Microsoft Excel features for Financial Management