What You'll Learn

  • What's new/different in Excel 2019
  • Advanced charting and graphing in Excel
  • How to use detailed formatting tools
  • Lookup and advanced lookup functions
  • Financial functions including calculating interest and depreciation
  • Statistical functions
  • Connecting to other workbooks and datasets outside of Excel, e.g. MS Access and the web.
  • How to create impressive visualizations using sparklines and data bars
  • Mastery of PivotTables and Pivot Charts
  • Scenario Manager, Goal Seek and Solver
  • Advanced charts such as Surface, Radar, Bubble and Stock Charts

Course Format

  • This is a video-led course. You can preview some videos below.
  • This course includes practice exercises so you can practice as you learn.
  • This course is suitable for Windows users.
  • Course suitable for Office 365 Users.

Get beyond the basics and supercharge your current skill level in Excel. With this 9-hour, expert-led video training course, you'll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information.

Course curriculum

  • 1

    Introduction to Excel 2016 Advanced Course

    • Prerequisites of the Course and Version of Excel

    • Course Structure
  • 2

    Functions

    • Functions - Part 1

    • Functions - Part 2

    • Autosum
  • 3

    Date and Time Functions

    • How Date and Time Works

    • Basic Date and Time Functions

    • Complex Date and Time Functions
  • 4

    Text Functions

    • Using Text Functions - Part 1

    • Using Text Functions - Part 2
  • 5

    Logical Functions

    • Using Logical Functions

    • Exercise 01
  • 6

    Lookup Functions

    • HLOOKUP Function

    • VLOOKUP Function

    • Exercise 02
  • 7

    Financial Functions

    • Financial Functions and Terminology

    • Personal Financial Functions

    • Professional Financial Functions

    • Depreciation

    • Exercise 03
  • 8

    Statistical Functions

    • Statistical Functions for Description - Part 1

    • Statistical Functions for Description - Part 2

    • Statistical Functions for Forecasting - Part 1

    • Statistical Functions for Forecasting - Part 2

    • Exercise 04

    • One Click Forecasting

    • Statistical Functions for Inference
  • 9

    Connecting to External Data

    • Connecting to Other Workbooks

    • Connecting to Access Databases

    • Connecting to Web Data Sources

    • Get and Transform

    • Exercise 05
  • 10

    Tables

    • Introduction to Tables

    • Working with Tables

    • Table References

    • Table Styles

    • Exercise 06
  • 11

    Pivot Tables

    • Introduction to Pivot Tables

    • Working with Pivot Tables

    • Filters and Slicers

    • Pivot Charts

    • Exercise 07
  • 12

    Data Analysis

    • What If Analysis

    • Scenario Manager

    • Goal Seek

    • Solver

    • Exercise 08
  • 13

    Graphs and Charts

    • Area Charts

    • Surface Charts

    • Radar Charts

    • Bubble Charts

    • Sparklines

    • Stock Charts

    • Exercise 09
  • 14

    Excel Web App

    • Introduction to Excel Web App

    • Using the Excel Web App
  • 15

    Exercise and Demo Files

    • Exercise and Demo Files