About this course

Course type Performance
Course code VCEX13ITM
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 2013 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 2013.

What’s included

QA offers more benefits. Here is what's included with this course:

Tutor Support

Prerequisites

Before attending this course, students must be able to:

  • 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 using various techniques
  • Create and modify charts
  • Create a basic PivotTable
  • Create an Excel Templates

Outline

Module 1: Calculating Data with Advanced Formulas

  • 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 using Charts

  • Create, Modify and Format a Chart
  • Use Recommended Charts

Module 3: Creating Excel Tables

  • Create, Modify and Format Excel Tables
  • Sort or Filter Excel Table Data
  • Calculate Data in an Excel Table

Module 4: Creating a Basic PivotTable

  • Use Recommended PivotTables

Module 5: Applying Conditional Formatting

  • Apply Conditional Formatting

Module 6: Excel Templates

  • Create an Excel Template

Performance

1 Day

Duration
Microsoft Office
Delivery Method

Delivery method

Blended learning

Combining different learning methods into a single, seamless programme that exploits the best of each approach.

Trusted, awarded and accredited

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

All third party trademark rights acknowledged.