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 £2050
(55)
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 £2050
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

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 £2050 £2050 £1750
2 £1315 £1300 £1150
3 £1070 £1050 £950
4 £948 £925 £850
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories


Course Discounts

Course Venue Course Date Course Price [Remote/Classroom]
Drupal 7 for Developers Bristol, Temple Gate Wed, 2016-08-31 09:30 N/A / £2333
XQuery Leicester - St. Georges House Mon, 2016-09-05 09:30 £1733 / £2233
Introduction to Semantic MediaWiki London, Barbican Wed, 2016-09-14 09:30 £980 / £1330
Solr for Developers Oxford Wed, 2016-10-12 09:30 £2723 / £3648

Upcoming Courses

VenueCourse DateCourse Price [Remote/Classroom]
Belfast City CentreMon, 2016-09-12 09:30£1750 / £2250
Aberdeen - Berry StreetMon, 2016-09-19 09:30£1750 / £2410
Coventry - The QuadrantWed, 2016-09-21 09:30£1750 / £2250
London, BarbicanThu, 2016-09-22 09:30£1750 / £2350
Bradford - Carlisle Business CentreMon, 2016-09-26 09:30£1750 / £2250

Some of our clients