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

Requirements

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

 14 Hours

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

R Fundamentals

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

Related Categories