Course not currently available

Analysing Financial Data in Excel Training Course

Course

Online

£ 1,750 VAT inc.

Description

  • Type

    Course

  • Methodology

    Online

Audience
Financial or market analysts, managers, accountants
Course Objectives
Facilitate and automate all kinds of financial analysis with Microsoft Excel

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
  • Market
  • Options
  • XML
  • Database training
  • Financial
  • Accountants
  • Financial Training
  • Microsoft excel training
  • MS Excel

Course programme

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

Additional information

14 hours (usually 2 days including breaks)

Analysing Financial Data in Excel Training Course

£ 1,750 VAT inc.