About this course

Course type Essentials
Course code VCEX10L2
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 2010 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 2010

  • Calculate using a range of functions
  • Sort and filter data
  • Represent data using charts
  • Analyse data using Pivot Tables and Pivot Charts
  • Creating template

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

At the end of this course you will be able to:

  • Calculate with advanced formulas
  • Organise worksheet and table data using various techniques
  • Create and modify charts
  • Analyse data using Pivot Tables and Pivot Charts
  • Creating Excel Template

Outline

Lesson 1: Calculating Data with Advanced Formulas

  • Apply Cell Range Names
  • Calculate Data Across Worksheets
  • Use Specialised Functions
  • Analyse Data with Logical and Lookup Functions

Lesson 2: Presenting Data using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts

Lesson 3: Organising Worksheet and Table Data

  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Worksheet or Table Data
  • Calculate Data in a Table or Worksheet

Lesson 4: Analysing Data using PivotTables, Slicers and Pivot Charts

  • Create a PivotTable Report
  • Filter Data Using Slicers
  • Analyse Data Using PivotChart

Lesson 5: Customising and Enhancing Workbooks

  • Create and Use Templates

Essentials

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.