Please note: a minimum of 5 bookings are needed for a session to run, otherwise they will be cancelled. If you are unsure if a course is running please email ISS Training (iss-training (at) lancaster.ac.uk).
You are required to gain the agreement of your line manager/supervisor before you book attendance on a course.
Session 1: Excel Essentials
Running again in the Michaelmas term 2013
- Introduction to Excel 2010 - Ribbon and Tabs layout, Live Preview, Quick Access toolbar, Dialog Box Launcher, Office Button
- Working with Data - Entering data, data types
- Basic Formula - referencing cells, replicating formula and filling cells
- Worksheets - add new worksheets, naming worksheets, moving between worksheets
- Saving - Look at saving Excel Spreadsheets as different versions of Excel and look at Compatibility Issues
Session handouts available from the Training Guide and Handout section
Session 2: Formulas and charts
Running again in the Michaelmas term 2013
- Working with Columns and Rows - adding, removing and freezing columns and rows
- Basic Formula and AutoSum - writing formula - sum, min, max, average, count
- Charts - Creating and formatting Charts
Session handouts available from the Training Guide and Handout section
Session 3: Referencing
Running again in the Michaelmas term
- Cell Referencing - relative, absolute, mixed
- If Function
Session handouts available from the Training Guide and Handout section
Session 4: Sorting and Filtering
Running again in the Michaelmas term 2013
- Sorting Data
- Filtering - searching for data matching a specified criteria
- Sub Totals
Session handouts available from the Training Guide and Handout section
Session 5: Page Setup, Data Validation and Scenarios
Running again in the Michaelmas term 2013
- Page Set Up - applying headers and footers to your datasheet
- Data Validation - data entry via lists of data, only accepting certain data into cells
- Named Ranges - referencing data, using named ranges in formula and charts
Session handouts available from the Training Guide and Handout section
Session 6: Pivot Tables and Charts
Friday 7 June, 11.30am – 12.30pm, Training Room 1, C Floor - Library
- Pivot Tables - analysing data, creating and editing, changing formula, 3D Pivot, using results and printing
- Pivot Charts - creating and editing
- Slicers
Session handouts available from the Training Guide and Handout section | Book Session
Session 7: Conditional Formatting, Error Tracing, Protection
Running again in the Michaelmas term 2013
- Conditional Formatting - making values 'stand out' in your document
- Error Tracing
- Protection - Protecting the datasheet and password protecting the file with encryption
Session handouts available from the Training Guide and Handout section
Booking Information
Please Note: Sessions will only run if enough people are booked on the course.
If you wish to book a place on a session please book online. If you have a query about the course please contact ISS Training (iss-training (at) lancaster.ac.uk).
You do not need to attend every session if you do not want to. These sessions will be available on a first come first served basis.
Last updated: 18.06.13