Excel Advanced

Course Outline

This one-day course for people who need to analyse large data sets, manipulate data with a range of Excel functions, set up data models using What If scenarios and Excel tools.

Course Content

  • Dashboards
  • Use Excel Functions to manipulate and calculate with Dates and Times
  • Use Excel Functions to manipulate and clean text and numeric data
  • Use Excel Functions to look up data stored in other worksheets and workbooks
  • Carry out “What-Ifs” using Goal Seek, and Scenario Manager
  • Import data and Power Query for Load, Transform and Edit imported data
  • Create dashboard interfaces using multiple Pivot Tables and Charts
  • Introduction to recording Macros

Functions

  • Complex DATE, TIME, INFORMATION and TEXT functions
  • LOOKUP functions – Index, Match, Offset

Pivot Tables

  • Recap of Excel Tables and Pivot Tables & More advanced Pivot Tables
  • Calculation Fields and Calculated Items & Pivot Table Functions
  • Multiple Pivot Tables on worksheets & Creating related Pivot Tables with Primary and Foreign Keys

Using Goal Seek and Scenario

  • Using Goal Seek & Using the Scenario Manager
  • Displaying a Scenario & Creating a Scenario Summary Report
  • Data Tables and Break Even Charts

Importing data

  • Importing data from text files, Excel files & Power Query

Macros and Introduction to VBA

  • Introduction to automating processes
  • Macro Recorder & Recording with absolute and relative cell references & VBA Edit

Show the next months in

Location Dates Time Price exc. VAT   Status
Growtrain Ltd PO20 2BX 30 Jul 2020 09:00h – 16:00h £155.00 Registration Closes
Jul 30, 2020 10:00AM


Growtrain Ltd PO20 2BX

30 Jul 2020

09:00h – 16:00h

£155.00 exc. VAT

 

Register Now » 8 Places Available!
Register Now » 8 Places Available!
Growtrain Ltd PO20 2BX 30 Oct 2020 09:00h – 16:00h £155.00 Registration Closes
Oct 30, 2020 9:00AM


Growtrain Ltd PO20 2BX

30 Oct 2020

09:00h – 16:00h

£155.00 exc. VAT

 

Register Now » 8 Places Available!
Register Now » 8 Places Available!
Growtrain Ltd PO20 2BX 20 Nov 2020 09:00h – 16:00h £155.00 Registration Closes
Nov 20, 2020 9:00AM


Growtrain Ltd PO20 2BX

20 Nov 2020

09:00h – 16:00h

£155.00 exc. VAT

 

Register Now » 8 Places Available!
Register Now » 8 Places Available!
Contact Nina or Graham on 01243 216278 or email courses@growtrain.co.uk to book this course
Share This