About this course

Course type Performance
Course code VCEX16ITM
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 use Microsoft Office Excel 2016 to streamline and enhance your spreadsheets with templates, charts, and formulas.

Target audience
This course was designed for delegates who need to learn how to create, modify and manage complex data in Microsoft Excel 2016.

Prerequisites

  • Create basic spreadsheets
  • Select and edit data
  • Perform basic formatting
  • Open, close and save files
  • Create basic formulas – AutoSum
  • Use Insert Function to create built-in functions
  • Work with absolute references
  • Use the AutoFill feature

Delegates will learn how to

  • Calculate with advanced formulas
  • Organise worksheet and table data
  • Create and modify charts
  • Applying Conditional Formatting
  • Create a basic PivotTable

Outline

Module 1: Calculating Data with Advanced Formulas

  • Using Excel’s Quick Analysis Tool
  • Apply Cell Range Names
  • Calculate Data across Worksheets
  • Use Specialised Functions (Text and Date Functions)
  • Analyse Data with IF and VLOOKUP Functions

Module 2: Presenting Data

  • Create, Modify and Format a Chart
  • Using Recommended Charts
  • Creating Sparklines

Module 3: Creating Excel Tables

  • Sort or Filter Excel Table Data
  • Create, Modify and Format Excel Tables
  • Summarise Data with SubTotals

Module 4: Creating a Basic PivotTable

  • Using Recommended PivotTables

Module 5: Applying Conditional Formatting

  • Apply Conditional Formatting
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.