Microsoft Excel-In-A-Day
Four Seminar Workshops
A series of short seminar workshops over one day for new or existing users of Microsoft Excel who want to get more from the program. You can attend one or more sessions. You do not need to attend earlier sessions to attend the later ones. Bring your own laptop.
Session 1 – 09:00 to 10:30 – Formulas and Linking Spreadsheets
- Learn to reference other cells in formulas
- See how to simplify complex formulas using names
- Look at working with multiple sheets in a file
- See how to use formulas to extract data from multiple spreadsheets
Session 2 – 10:45 to 12:15 – Using Lists Effectively
- Working with lists and filtering
- See how to filter out unnecessary entries from long lists
- Easily create sub-totals on list entries
- See how to view different sections of large lists and compare entries
- Learn how to easily remove duplicate entries, and split up columns of data
Session 3 – 13:15 to 14:45 – Charts and Pivot Tables
- See how to easily create and update charts
- Use different chart types to show figures better
- Establish trends in your data
- Create Pivot Tables and Pivot Charts to analyse your data
Session 4 – 15:00 to 16:30 – Built-In Functions and Controlling Data
- Using the IF Function to control cell contents
- See how to selectively count and sum data
- How LOOKUP functions search for you
- Learn how data validation is used to control data entry
- See how to set up spreadsheets for non-Excel users to fill in
Date: Thursday 24th November 2011
Venue: Shropshire Chamber of Commerce, Trevithick House, Stafford Park 4, Telford, Shropshire TF3 3BA
Price: £35 + VAT per session for Chamber Members. £40 + VAT per session for Non-Chamber Members
Complimentary Tea/Coffee. Buffet Lunch £5+VAT (Booking required)
