Course not currently available

Analysing Financial Data in Excel

Training

In Manchester ()

Price on request

Description

  • Type

    Training

  • Class hours

    14h

Facilitate and automate all kinds of financial analysis with Microsoft Excel. Suitable for: Financial or market analysts, managers, accountants. Good Excel, Math knowledge, basic finance knowledge may be beneficial.

About this course

Good Excel, Math knowledge, basic finance knowledge may be beneficial.

Questions & Answers

Add your question

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

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Microsoft Excel
  • Spreadsheet
  • Database
  • Graphics
  • Finance
  • Financial
  • Accountants
  • Financial Training
  • MS Excel

Course programme

Course review:

Advanced functions

Logical functions

Math and statistical functions

Financial functions

Lookups and data tables

Using lookup functions
Using MATCH and INDEX

Advanced list management
Validating cell entries
Exploring database functions

PivotTables and PivotCharts

Creating Pivot Tables

Calculated Item and Calculated Field

Working with External Data

Exporting and importing
Exporting and importing XML data
Querying external databases

Linking to a database

Linking to a XML data source

Analysing online data (Web Queries)

Analytical options

Goal Seek

Solver
The Analysis ToolPack

Scenarios

Macros and custom functions
Running and recording a macro
Working with VBA code
Creating functions

Conditional formatting and SmartArt

Conditional formatting with graphics

SmartArt graphics

Analysing Financial Data in Excel

Price on request