About this course

Course type Performance
Course code VCEX13ADV
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 extend your knowledge into 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, collaborating on worksheets with others, importing and exporting data.

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 2013 Intermediate course or have equivalent knowledge.

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

Delegates will learn how to

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

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 and List Validation
  • Conditional Data Validation
Performance

1 Day

Duration
Microsoft Office
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 0345 074 7998 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.