Courses and resources

Excel 2007: Data Lists and Charts

Description

What is it about?

.

This course focuses on using Excel to organize and manage data in a list form.

This includes Sorting and Filtering data and also using Data Validation to ensure the accuracy of data that is input.

You will also create different types of charts to compare and analyze your data.

Course Content.

1/ Using lists in Excel: Sorting, Autofilter and Subtotals.

2/Custom Lists.

3/ Custom Views.

4/Using the Autoform.

5/ Format as a Table.

6/Conditional Formatting.

7/ Data Validation.

6/ Charts including; creating and modifying charts, bar charts, pie charts, line graphs and printing charts.

Is there anything I need to do before attending?

You will have attended 'Excel 2007:Simple Worksheets' course or be familiar with the content.

Learning provider:

This course is administered by Staff Learning & Development, please contact C.L.Fal@exeter.ac.uk for any queries.

This course occurs on the following dates
DateLocationStartFinishCostTrainer(s)Places
19/02/2013 TBC 13:00 16:00 Free, but on late cancellation your department will be charged up to £50 7
18/04/2013 Streatham: Queen's, Room M (PC Cluster) 09:30 12:30 Free, but on late cancellation your department will be charged up to £50 Carol Fal 10
27/06/2013 Streatham: Queen's, Room M (PC Cluster) 13:00 16:00 Free, but on late cancellation your department will be charged up to £50 8
BookBook via Trent HR Self Service