Foundation Level Excel training: Sorting, Filtering and Formatting Data

Sorting, Filtering and Formatting Data

Session objectives

Correctly apply sorting and filtering to data

• Sort data in worksheets
• Filter data using AutoFilter

Format cell contents

• Change the number format of a cell
• Change number of decimal places of a number
• Add separators to make large numbers easier to read
• Change the format of dates and times

Format worksheets

• Add colour to worksheet tabs
• Turn off column and row headings
• Hide and display gridlines
• Change the worksheet background

Visualise data with conditional formatting

• Incorporate data visualisations such as bars, colour scales and icon sets into your worksheets