Formatting Spreadsheets - SS02

General Description

Make spreadsheets more engaging and easier to use by employing Excel's numerous formatting and design options. Change the look of cells, text and numbers, use the AutoFill feature to complete lists of data and prepare spreadsheets for printing.

Target Audience

This session is intended for participants with little knowledge of Microsoft Excel.

Pre-requisites

Participants should be competent in the learning outcomes of session SS01.

Duration

3 hours

Learning Outcomes

• Apply font and alignment formatting to text and numbers
• Format the appearance of numbers
• Create and use custom number formats
• Apply borders and shading to cells and ranges
• Generate cell entries using the AutoFill feature
• Create a customised AutoFill list
• Adjust the margin and page layout
• Preview the spreadsheet prior to printing
• Create and modify headers and footers
• Print a document
• Print row and column titles
• Search for data
• Replace values in a workbook