Financial analysis in Excel Training Course

Nobleprog Limited

Course

In City Of London

Price on request

The best Other Database courses

See all

See all

Description

  • Type

    Course

  • Location

    City of london

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.

Facilities

Location

Start date

City Of London (London)
See map
Token House, 11-12 Tokenhouse Yard, EC2R 7AS

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Risk
  • Excel
  • Forecasts
  • Securities
  • XML
  • Spreadsheet
  • Database
  • Financial
  • Financial Training
  • MS Excel

Course programme

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

See related categories

Financial analysis in Excel Training Course

Price on request

The best Other Database courses

See all

See all