0345 4506120

Microsoft Excel 2013 Intermediate - Virtual Class

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.

Included

Tutor support

Reset

Learning Objectives

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

Pre-Requisites

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

Course Content

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

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Virtual Classroom

Virtual classrooms provide all the benefits of attending a classroom course without the need to arrange travel and accomodation. Please note that virtual courses are attended in real-time, commencing on a specified date.

Virtual Course Dates

Our Customers Include