Course Content

Sorting & Filtering Data

• Apply and use a filter
• Clear a filter
• Create a compound filter
• Filter for multiple values
• Create custom filters

Conditional Formatting with Filters

• Conditionally format cells containing specific values
• Clear conditional formatting
• How to use more of the cell formatting options
• Top ten items in a range and the various top/bottom rules
• Work with data bars
• Work with colour scales when formatting conditionally
• Icon sets to conditionally format range
• Filter by colour

Using Subtotals to Create Summary Information

• Summarise data by creating subtotals

Working with Table Data

• Create a table in Excel
• Insert and delete rows in a table
• Remove duplicates from a table
• Sort data in a table
• Filter a table

Group and Outlining