Financial analysis in Excel Training Course

Primary tabs

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

Bookings, Prices and Enquiries

Guaranteed to run even with a single delegate!
Public Classroom Public Classroom
From CA$6600
(96)
Public Classroom
Participants from multiple organisations. Topics usually cannot be customised
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.
Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet. More Information

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 Remote
1 CA$6600 CA$4300
2 CA$3750 CA$2525
3 CA$2800 CA$1933
4 CA$2325 CA$1638
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories

Related Courses


Upcoming Courses

VenueCourse DateCourse Price [Remote / Classroom]
NB, Saint JohnTue, Jun 13 2017, 9:30 amCA$4300 / CA$7300
AB, Edmonton - First Edmonton PlaceWed, Jun 14 2017, 9:30 amCA$4300 / CA$7000
ON, Scarborough – 10 Milner Business CourtThu, Jun 15 2017, 9:30 amCA$4300 / CA$6660
ON, Brampton - Brampton County CourtMon, Jun 19 2017, 9:30 amCA$4300 / CA$6700
ON, Toronto - University & DundasThu, Jun 29 2017, 9:30 amCA$4300 / CA$7001

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients