* Friday July 31st
* At Our Offices
* 1530-1730
* £45
* 6 Spaces only
* Bring your laptop with Office 2007 installed (Rentals available with 48 hours notice) and a fresh brain
Course overview
The aim of this module is to enable you to create, manage and analyse lists of data, allowing you to quickly sort, filter, total, and publish the data contained in the list.
At the end of the module, you will be able to:
• Create data lists in keeping with Excel layout guidelines to analyse and manage data effectively
• Design a data form to input and navigate data, using time-saving features for input and retrieval
• Arrange data alphabetically and numerically, from left to right, and by colour, using sort options on the ribbon to display data in desired order
• Choose simple criteria using top 10 and other filter options to present data meeting specific conditions
• Arrange data lists with hidden rows/columns and grouped, to display detailed or summarized results
• Use subtotals with automated outlining and grouping, to investigate the most effective method of presenting data lists
Who should attend
You know Excel basics, are using or upgrading to Excel 2007 and need to analyse relevant data more effectively
Who is running the course?
We are extremely pleased to have Anne Harkness from Alpha Training. Anne is Trainer to the Stars! From top editors at Vogue to the BBC, where clients included former BBC One Controller Peter Salmon and comedienne/presenter Ruby Wax. Get the benefit of her hands-on approach and more than 20 years experience.
Call Dan on 08456 447758 or email dan@theengineroom.co.uk to book