Linking and Working with Large Spreadsheets - SS04

General Description

Single spreadsheets are all well and good, but really powerful spreadsheets make use of linking data across many different sheets.

Target Audience

This session is intended for participants with some knowledge of and skill in the use of Microsoft Excel.

Pre-requisites

Participants should be competent in the learning outcomes of sessions SS01 and SS02. They should also be competent in the use of relative and absolute referencing, editing formulae and using the AVERAGE function.

Duration

3 hours

Learning Outcomes

• Identify and navigate between sheets within a workbook
• Name a sheet
• Select a group of sheets
• Enter data into multiple sheets simultaneously
• Copy and move sheets
• Create formulae across multiple sheets
• Create references to sheets in other workbooks
• Name a cell and a range
• Create a formula using a range name
• Freeze panes
• Create and use a custom view
• Publish spreadsheets as web pages
• Share a workbook
• Track changes to a workbook
• Add, Edit and Delete worksheet comments
• Create hyperlinks in a workbook
• Save a workbook in different formats