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

Related Courses

Programming with Big Data in R

  21 hours

Neural Network in R

  14 hours

Introduction to R

  21 hours

Marketing Analytics using R

  21 hours

Advanced R Programming

  7 hours

Forecasting with R

  14 hours

R for Data Analysis and Research

  7 hours

Data Mining with R

  14 hours

Machine Learning Fundamentals with R

  14 hours

HR Analytics for Public Organisations

  14 hours

Talent Acquisition Analytics

  14 hours

Statistical Analysis using SPSS

  21 hours

Statistical and Econometric Modelling

  21 hours

Econometrics: Eviews and Risk Simulator

  21 hours

Introduction to Data Visualization with Tidyverse and R

  7 hours