Excel Advanced

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.

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
Contact Graham on 01243 216278 or email courses@growtrain.co.uk to book this course
Share This