Get in Touch

Course Outline

Advanced functions

  • Logical functions
  • Mathematical and statistical functions
  • Financial functions

Search and data

  • Searching and matching data
  • MATCH and INDEX functions
  • Advanced management of value lists
  • Validating cell input values
  • Database functions
  • Summarising data using histograms
  • Circular references – practical aspects

Tables and Pivot Charts

  • Dynamic data representation using PivotTables
  • Items and calculated fields
  • Visualising data with PivotCharts

Working with external data

  • Importing and exporting data
  • Importing and exporting XML files
  • Importing data from databases
  • Establishing connections to databases or XML files
  • Analysing online data – Web Query

Analytical tools

  • Goal Seek option
  • Analysis ToolPak add-in
  • Scenarios and the Scenario Manager
  • Solver and data optimisation
  • Macros and creating custom functions
  • Recording and running macros
  • Working with VBA code

Conditional formatting

  • Advanced conditional formatting using formulas and form controls (e.g., check boxes)

Time value of money

  • Present and future value of capital
  • Capitalisation and discounting
  • Simple interest calculations
  • Nominal and effective interest rates
  • Cash flows
  • Depreciation

Trends and financial forecasts

  • Trend types (functions)
  • Forecasting

Securities

  • Rate of return
  • Profitability
  • Investing in securities and risk measurement

Requirements

A solid understanding of Microsoft Excel is required. Basic knowledge of finance is also recommended.

 14 Hours

Number of participants


Price per participant

Testimonials (1)

Provisional Upcoming Courses (Require 5+ participants)

Related Categories