Computer and IT

Microsoft Excel 2010 - Managing Data

Working with large amounts of information in your spreadsheets can be difficult, time-consuming and make tasks more complex than necessary. This course will provide delegates with an understanding of the data management tools in Excel 2010 for managing and organising.

This course shows delegates how to efficiently sort data, work across multiple worksheets and import data into worksheets and pivot tables.

Course Dates

Locations Duration Course Dates Times Enquire
Glasgow 1 Day From 19 Feb 2019
  • 19 Feb 2019 09:00 - 16:00
09:00
1 Day From 25 Apr 2019
  • 25 Apr 2019 09:00 - 16:00
09:00
1 Day From 9 Jul 2019
  • 9 Jul 2019 09:00 - 16:00
09:00
1 Day From 12 Sep 2019
  • 12 Sep 2019 09:00 - 16:00
09:00
1 Day From 12 Nov 2019
  • 12 Nov 2019 09:00 - 16:00
09:00
Edinburgh 1 Day From 12 Mar 2019
  • 12 Mar 2019 09:00 - 16:00
09:00
1 Day From 13 Aug 2019
  • 13 Aug 2019 09:00 - 16:00
09:00
1 Day From 18 Nov 2019
  • 18 Nov 2019 09:00 - 16:00
09:00
West Midlands 1 Day From 29 Mar 2019
  • 29 Mar 2019 08:30 - 16:30
08:30
1 Day From 6 Jun 2019
  • 6 Jun 2019 09:00 - 16:00
09:00
1 Day From 11 Nov 2019
  • 11 Nov 2019 09:00 - 16:00
09:00

Key Benefits

  • Use a variety sort commands and work with named ranges
  • Work with multiple worksheets
  • Perform data validation
  • Work with Tables and PivotTables
  • Import data from external sources

Who Should Attend

Anyone who needs to use the Excel data management tools.

Prerequisites

In order to gain maximum benefit from this course, delegates should be able to demonstrate skills in the following areas:

  • Excel 2010: Introduction
  • Excel 2010: Presenting Information
Duration
1 Day
Locations
  • Glasgow
  • Edinburgh
  • West Midlands

Enquire About This Course