Get in Touch

Course Outline

Advanced Functions

  • Logical functions
  • Mathematical and statistical functions
  • Financial functions

Lookups and Data Tables

  • Utilizing lookup functions
  • Mastering MATCH and INDEX
  • Advanced list management
  • Validating cell entries
  • Exploring database functions

PivotTables and PivotCharts

  • Creating Pivot Tables
  • Calculated Items and Calculated Fields

Working with External Data

  • Exporting and importing data
  • Exporting and importing XML data
  • Querying external databases
  • Linking to a database
  • Linking to an XML data source
  • Analyzing online data (Web Queries)

Analytical Tools

  • Goal Seek
  • Solver
  • The Analysis ToolPak
  • Scenarios
  • Macros and custom functions
  • Running and recording macros
  • Working with VBA code
  • Creating functions

Conditional Formatting and SmartArt

  • Conditional formatting with graphics
  • SmartArt graphics

Requirements

Proficiency in Excel, mathematics, and fundamental financial knowledge is advantageous.

Audience

Financial analysts, market analysts, managers, and accountants

Course Objectives

To facilitate and automate all types of financial analysis using Microsoft Excel

 14 Hours

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories