Course not currently available
Analysing Financial Data in Excel Training Course
Course
Online
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
Reviews
Subjects
- Excel
- Market
- Options
- XML
- Database training
- Financial
- Accountants
- Financial Training
- Microsoft excel training
- MS Excel
Course programme
- 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 a 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
Additional information
Analysing Financial Data in Excel Training Course