Courses and resources

Course Description:

This course will extend your knowledge of Excel by working with larger data sets, using formulae in multiple-sheet workbooks, creating Range Names to navigate around your worksheets and protecting workbooks from modification.

Course Content.

1/ Revision of basic formulae and functions.

2/ Other functions; CountIF, CountA, Now and Today.

3/ Working with large worksheets including; navigation, freeze panes and hide columns/rows.

4/ Customising the status bar.

5/ Printing large worksheets including; page setup, headers/footer, print titles, setting a print area.

6/ Protecting; protecting sheets and protecting ranges.

7/ Range Names; creating named ranges and modifying/deleting a range.

Is there anything I need to do before attending?

?.

You will have attended the 'Excel 2007: Simple Worksheets (with Formulae and Basic Functions)' course, or be familiar with the content.

Learning provider:

This course is administered by Staff Learning & Development, please contact Carol Fal (C.L.Fal@exeter.ac.uk) for any queries.