Analysing Financial Data in Excel Training Course

Nobleprog Limited

Course

In City Of London

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Location

    City of london

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

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

  • Excel
  • Market
  • Options
  • XML
  • Database training
  • Graphics
  • Web
  • Financial
  • Financial 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 an 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

See related categories

Analysing Financial Data in Excel Training Course

Price on request

The best Excel courses

See all

See all