Better Spread Sheets with StarOffice Calc or MS-Excel
Target Audience: Existing users who want to unlock the power of their spreadsheets
Duration: 1 day
What’s Covered:-
- review of good spreadsheet design concepts and techniques
- applying formula to textural data, (e.g. convert to uppercase)
- using logical functions and nested IF's to carry out complex tests
- using SUMIF and COUNTIF to selectively sum and count
- using dates within formula, (e.g. to calculate due date on an invoice)
- working with named ranges and multiple worksheets
- when to use absolute, relative and mixed cell addressing
- hiding and protecting data, (including security considerations)
- creating hierarchical data structures with Outlines
- overview of list handling, (including sorting and use of AutoFilters)
- using data validation to control user input, (including drop-down lists)
- using Lookup functions to find data values in a table
- customising the Toolbars
How Much Does it Cost?
£125 + VAT per person, (including a course guide, lunch and refreshments)
Dates – 24th April, 8th May, 21st May, 4th June and 17th June 2008
(Note that additional dates may be offered if demand is high – call us for details)
Venue – Create Centre, Bristol
Please Note – there will be a maximum group size of 6 attendees allowing for individual attention from the tutor and the opportunity to practise your skills during the day. Feel free to bring along a spreadsheet of your own to work on.
Call John Bainbridge on 0117 9022845 or e-mail solutions@ttsweb.co.uk
|
