Course Overview

Manipulating data using Microsoft Excel

Helping you quickly and easily manipulate information makes Excel a powerful tool for analysing evidence. This in-depth course looks at the tools and techniques it offers.

What you will gain

Understanding of Excel formulas, their structure and operation.
Details of key Excel functions and their use for manipulating data.
Time-saving techniques for working with data.
How to use logical tests to extract and identify key information.
Getting started with Excel macros.

Who should attend

This course is suitable for with a solid understanding of the basics of Excel formulas and who want to manipulate and analyse information such as case evidence.

Course overview

Formula fundamentals.
Extracting, joining and analysing text in cells.
Using logical tests to identify information.
Cross-referencing information from different worksheets.
Using the Count, Sum and Conversion functions.
Dealing with formula errors.
Advanced copy & paste functions.
Macro recording and playback.

Details

Duration: 90 minutes
Cost: £50+VAT for partners, £75+VAT for non-partners
Location: 15 New Bridge Street

Schedule

Thursday 3 December 2006, 5.30pm-7.00pm
Thursday 23 January 2007, 5.30pm-7.00pm

Booking information

Important - These are not public courses and are only available to barristers and associated legal professionals. If you are not certain about your eligibility, please contact us.

To book your place either complete the online booking form or E-mail training@ctsltd.net stating the course title and preferred dates.

QuickLinks

Top of page | Home | About Us | Contact Us