Analysing Data using Excel, 20th May 2008

Date : 20th May 2008

Duration : 1

Start Time :
End Time :

Venue : Tharstern Training Academy

Introduction

Many people have now become dependent upon Microsoft Excel to help access, process, analyse, share and display information they work with. However, the latest features of Microsoft Excel Office 2007, if used correctly, can help to speed up workbook creation and enhance the presentation of data.

The aim of the course

This course will build on your existing skills of creating, editing, formatting and printing spreadsheets.

Benefits to you:

This course will teach you how to streamline repetitive tasks and display spreadsheet data in more visually effective ways using templates, charts, graphics and formulas. You will also learn how to speed up workbook creation with the latest productivity and timesaving features Microsoft Excel has to offer.

Benefits to your organisation:

An effective user of Microsoft Excel will be able to quickly access, process, analyse and clearly present data that is required to make key business decisions with.

Who should attend:

Users who already have an understanding of creating, editing, formatting, saving, and printing basic spreadsheets in Excel and now want to consolidate and expand on their knowledge of the basic features in a short space of time.

What you will learn:

• Analysing data using the following methods:
• Using Sub totals
• Custom Lists
• Worksheet Functions
• Autofilter
• Conditional formatting
• Linking and Embedding between applications
• Advanced Filtering
• Data Validation
• Scenarios
• Charts
• Pivot Tables

Price:

1 Delegate: £150 + VAT
Additional Delegates: £125 + VAT each

For tailored or bespoke training solutions contact us on +44 (0) 8707 20 20 80 or

• Each delegate is provided with a hands-on learning approach enabled through individual access to a computer throughout the duration of the course.
• Course notes and materials on a USB Memory stick provided.
• Refreshments and lunch included.

Other information:

This course is based on Microsoft Excel from the Microsoft Office 2007 Suite

Alternative dates:

• Analysing Data using Excel, 23rd September 2008