Topics in this episode: Utilising the IF function; Utilising the SUMIF function; Utilising the COUNTIF function

Topics in this episode: Removing duplicates; Inserting subtotals; Creating outlines; collapsing groups of data in outlines; Utilising the SUBTOTAL function

Topics in this episode: More advanced filtering options; Using sort options; Sorting data on multiple columns; changing sort order

Topics in this episode: Inserting total rows; Adding and removing styles and Banding rows and columns; Setting up a filter and Filtering records

Topics in this episode: Changing text to WordArt; Applying conditional formatting - highlighting; Applying conditional formatting - Bars, Scales and Sets

Topics in this episode: Applying Number format; Applying borders; Applying cell styles; Using Format Painter

Topics in this episode: Wrapping text within cells; Merging cells and Shrink to Fit; Changing font and font styles; Applying highlighting

Topics in this episode: Copying and pasting data, including Paste Special; Cutting and moving cell data; Using AutoFill tool, and Expanding data across columns; Modifying cell alignment and indentation

Topics in this episode: Appending data to Excel worksheets; Setting data validation; Finding and replacing data

Topics in this episode: Inspecting your workbook prior to distribution; Copying and pasting basics, and Utilising references (relative, mixed, absolute); Practice Activity - multiplication table; Answer - multiplication table