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.
From 25 Apr 2019
From 9 Jul 2019
From 12 Sep 2019
From 12 Nov 2019
From 13 Aug 2019
From 18 Nov 2019
|West Midlands||1 Day||
From 6 Jun 2019
From 11 Nov 2019
- 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.
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