Business and IT training from QA

Microsoft Excel 2016 Advanced - Virtual Class

About this course

Course type Performance
Course code VCEX16ADV
Duration 1 Day
Special Notices

Shorter bite-size virtual sessions are available on key topics from this course. Please contact us for further details.

In this course you will you will extend your knowledge using some of the more specialised and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets such as PivotTables and collaborating on worksheets with others.

Target audience
This course is aimed at end users who want to develop their skills so they can use advanced techniques to manipulate Excel data. Delegates should have attended QA's Excel 2016 Intermediate course or have equivalent knowledge.

Show more Show less

Prerequisites

  • Create, edit and format spreadsheets
  • Navigate within worksheets and books
  • Use Insert Function to create built-in functions
  • Work with absolute references
  • Create named ranges
  • Create Tables within Excel
  • Sort and filter data

Show more Show less

Delegates will learn how to

  • Create macros to automate common tasks
  • Collaborate with others by tracking changes in workbooks
  • Create and manipulate PivotTables and Pivot Charts
  • Use advanced techniques to analyse data
  • Work with data validation tools

Show more Show less

Outline

Module 1: Creating a Macro

  • Creating a Macro
  • Comparing Relative and Absolute Macros
  • Running a Macro
  • Editing a Macro
  • Assigning Shortcuts to Macros

Module 2 - Collaborating With Others

  • Protection
  • Track Changes

Module 3 - Creating PivotTables, PivotCharts and Slicers

  • Creating a PivotTable
  • Amending and Updating Fields
  • Adding Calculations and Grouping
  • Creating a PivotChart
  • Using Slicers and Timelines

Module 4 - Analysing Data

  • Creating Scenarios
  • Using Goal Seek
  • Linking to External Workbooks

Module 5 - Data Validation

  • Number Validation
  • Message Prompts and Alerts
Show more Show less
Performance

1 Day

Duration
Microsoft Excel
Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0113 220 7150 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.