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.

You have been using Excel 2013 for a while and either in training or through self-development you have a solid foundation in the basic and intermediate skills for working in Excel.

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 sharing and tracking workbooks
  • Use advanced techniques to analyse data
  • Create and manipulate PivotTables and PivotCharts
  • Import and export data

Outline

Module 1: Creating Macros

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

Module 2: Collaborating with Others

  • Protected Views
  • Tracking Changes

Module 3: Analysing Data

  • Creating Scenarios
  • Using Goal Seek

Module 4: Data Validation

  • Number Validation
  • Data List Validation

Module 5: Creating PivotTables, Pivot Charts and Slicers

  • Creating a PivotTable
  • Updating and Amending Fields
  • Adding Calculations to a PivotTable
  • Add Grouping to a PivotTable
  • Creating a Pivot Chart
  • Using Slicers and Timelines

Module 6: Import and Export Data

  • Exporting Excel Data
  • Importing Delimited Text
Performance

1 Day

Duration
Microsoft Office
Delivery Method

Delivery method

Virtual learning

Recreates a classroom experience online, enabling full interactions with the learning professional leading the course.

Find dates and prices

Sorry, we don't have any public dates scheduled for this course, but it can be run as a closed event for your company.
Please contact us for details on alternative ways we can help you 0845 757 3888 or email us at info@qa.com.

Trusted, awarded and accredited

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

All third party trademark rights acknowledged.