Analysing Financial Data in Excel Training Course
Course
In City Of London
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
Start date
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
- Using lookup functions
- Using MATCH and INDEX
- Advanced list management
- Validating cell entries
- Exploring database functions
- Creating Pivot Tables
- Calculated Item and Calculated Field
- 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)
- Goal Seek
- Solver
- The Analysis ToolPack
- Scenarios
- Macros and custom functions
- Running and recording a macro
- Working with VBA code
- Creating functions
- Conditional formatting with graphics
- SmartArt graphics
Analysing Financial Data in Excel Training Course