Lancaster University

The links below provide access to step by step handouts for the IT Training courses run in the Library Training Suites. They are useful for reference purposes. On this page:

• Word 2007 hourly handouts
• Excel 2007 hourly handouts
• PowerPoint 2007 hourly handouts
• Outlook 2007 hourly handouts
• Guidebooks and practice files for Office 2007

Hourly Word 2007 handouts

• Session 1: Introducing Word
• Session 2: Page Setup, Headers and Footers, Breaks and Sections
• Session 3: Referencing using Table of Contents, Captions and Indexes
• Session 4: Tables, Smart Art and Quick Parts
• Session 5: Inserting Objects inc. cover pages, pictures, clip art, shapes and symbols
• Session 6: Tracking Changes, Protection
• Session 7: Mail Merge

Hourly Excel 2007 handouts

• Session 1: Introducing Excel
• Session 2: Setting up a Spreadsheet, Basic Formula and Charts
• Session 3: Formula and Functions
• Session 4: Sorting, Filtering and Subtotals
• Session 5: Page Setup, Validation and Scenarios
• Session 6: Pivot tables and Pivot Charts
• Session 7: Conditional formatting, Error tracing and Protection

Hourly PowerPoint 2007 handouts

• Introduction to PowerPoint
• Design Themes
• Charts, Tables and Shapes
• Animation
• Page Setup, Printing and Saving
• Masters and Templates

Hourly Outlook 2007 handouts

• Using Email (inc. signatures, email options and quick parts)
• Using the Calendar (inc. appointments, meetings, sharing calendars)
• Using Tasks
• Mailbox Organisation (inc. personal folders and archiving)
• Link to Microsoft's PST backup Add in
• Shared Mailboxes
• Recovering Deleted Items

IT guides

Downloadable study guides and workbooks accompany ISS IT training courses for Office 2007. They can be used for self-study and can be accessed from campus machines only.

Last updated: 04.10.12