Financial analysis in Excel Training Course

Primary tabs

Course Language

This course is delivered in English.

Course Code

excelfin

Duration Duration

14 hours (usually 2 days including breaks)

Requirements Requirements

Requires good knowledge of Microsoft Excel. Basic knowledge of finance is also indicated.

Overview Overview

During the training, will present the issues of financial analysis using the advanced features of Excel.

This course is intended for financial analysts, accountants and all those who want to expand their skills spreadsheet with issues of financial analysis.

Course Outline Course Outline

Advanced functions

  • The logic functions
  • Mathematical and statistical functions
  • Financial functions

Search and data

  • Search and matching
  • Functions MATCH (MATCH) and INDEX (INDEX)
  • Advanced management of lists of values
  • Validate the value entered in the cell
  • Database Functions
  • Summary data by using the histogram
  • Circular references - Practical Aspects

Tables and Pivot Charts

  • The dynamic description of the data using PivotTables
  • Elements and calculated fields
  • Visualize data using pivot chart

Working with external data

  • Exporting and importing data
  • Exporting and importing XML file
  • Importing data from databases
  • Connections to a database or an XML file
  • Analyzing data online - Web Query

Analytical issues

  • Option Goal Seek
  • The Analysis ToolPack addition
  • Scenarios, Scenario Manager
  • Solver and optimization data
  • Macros and create your own functions
  • Starting and recording macros
  • Working with VBA code

Conditional Formatting

  • Advanced conditional formatting using formulas and form elements (eg box - checkbox)

Time value of money

  • The current and future value of capital
  • Capitalization and discounting
  • Interest made ​​simple
  • Nominal and effective interest procetowa
  • Cash flows
  • Depreciation

Trends and financial forecasts

  • Types (functions) trend.
  • Forecasts

Securities

  • The rate of profit
  • Profitability
  • Investing in securities and risk measures

Guaranteed to run even with a single delegate!
Public Classroom Public Classroom
Participants from multiple organisations. Topics usually cannot be customised
From £2350
(23)
Private Classroom Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
From £2350
Request quote
Private Remote Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet
From £1750
Request quote
SelfStudy SelfStudy
Self-study courses allow you to learn at your own pace on your own time. There is no live instructor involved. The participants use recorded video, quizzes and reading at their own convenience.
Price not set yet
Register Interest

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom Private Classroom Private Remote
1 £2350 £2350 £1750
2 £1465 £1450 £1150
3 £1170 £1150 £950
4 £1023 £1000 £850
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories


Course Discounts

Upcoming Courses

VenueCourse DateCourse Price [Remote/Classroom]
OxfordThu, 2016-08-11 09:30£1750 / £2400
London, BarbicanMon, 2016-08-15 09:30£1750 / £2350
Birmingham Thu, 2016-08-18 09:30£1750 / £2375
Bristol, Temple GateThu, 2016-08-18 09:30£1750 / £2350
Manchester, King StreetThu, 2016-08-18 09:30£1750 / £2500

Some of our clients