Course Outline

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


Good Excel, maths and basic finance knowledge may be beneficial.

 14 Hours

Number of participants

Price per participant

Testimonials (2)

Related Courses

Introduction to Data Visualization with Tidyverse and R

7 Hours

Econometrics: Eviews and Risk Simulator

21 Hours

HR Analytics for Public Organisations

14 Hours

Statistical Analysis using SPSS

21 Hours

Talent Acquisition Analytics

14 Hours

Advanced R

7 Hours

Algorithmic Trading with Python and R

14 Hours

Anomaly Detection with Python and R

14 Hours

Programming with Big Data in R

21 Hours

Cluster Analysis with R and SAS

14 Hours

Data and Analytics - from the ground up

42 Hours

Data Analytics With R

21 Hours

Data Mining with R

14 Hours

Deep Learning for Finance (with R)

28 Hours

Deep Learning for Banking (with R)

28 Hours

Related Categories