 Why Are Selection Techniques Important?
 Selecting a Cell
 Selecting a Range of Connecting Cells
 Selecting a Range of Non-Connecting Cells
 Selecting the Entire Worksheet
 Selecting a Row
 Selecting a Range of Connecting Rows
 Selecting a Range of Non-Connected Rows
 Selecting a Column
 Selecting a Range of Connecting Columns
 Selecting a Range of Non-Connecting Columns
 Recommended Techniques When Creating or Editing Lists

 Inserting Rows into a Worksheet
 Inserting Columns into a Worksheet
 Deleting Rows within a Worksheet
 Deleting Columns within a Worksheet
 Modifying Column Widths
 Modifying Column Widths Using 'Drag and Drop'

 Automatically Resizing the Column Width to Fit Contents
 Modifying Row Heights

 Copying a Cell or Range Contents within a Workbook
 Deleting Cell Contents
 Moving the Contents of a Cell or Range within a Workbook
 Editing Cell Content
 Undo and Redo
 Copying Data between Worksheets (Within the Same Workbook)
 Moving Data between Worksheets (Within the Same Workbook)
 Moving Data Worksheets (Between Different Workbooks)
 Copying Data between Worksheets (In Different Workbooks)
 AutoFill
 Copying a Data Range Using AutoFill
 Sorting a Cell Range
 Searching and Replacing Data

 Switching between Worksheets
 Renaming a Worksheet
 Recommended Techniques with Naming Worksheets
 Inserting a New Worksheet
 Deleting a Worksheet
 Copying a Worksheet within a Workbook
 Moving a Worksheet within a Workbook
 Copying or Moving Worksheets between Workbooks

 Font Formatting Options
 Font Type
 Font Size
 Bold, Italic, Underline Formatting
 Cell Border Formatting
 Formatting the Background Colour
 Formatting the Font Colour

 Horizontally Aligning Contents in a Cell Range
 Centring a Title over a Cell Range
 Cell Orientation
 Text Wrapping within a Cell
 Aligning Cell Contents Vertically
 Format Painter

 Number Formatting
 Decimal Point Display
 Applying and Removing Comma Style Formatting (To Indicate Thousands)
 Currency Symbol
 Date Styles
 Percentages

 Freezing Row and Column Titles

 Creating Formulas
 The Easy Way to Create Formulas
 Copying Formulas
 Operators
 Using Operators in Formulas
 Formula Error Messages
 Relative Cell Referencing within Formulas
 Absolute Cell Referencing within Formulas

 What Are Functions?
 Common Functions
 Sum Function
 Average Function
 Max Function
 Min Function
 Count Function
 The Counta Function
 The Countblank Function
 What Are 'If Functions'?
 Using the If Function

 Inserting a Column Chart
 Inserting a Line Chart
 Inserting a Bar Chart
 Inserting a Pie Chart
 Resizing a Chart
 Deleting a Chart
 Chart Title or Labels
 Changing the Column, Bar, Line or Pie Slice Colours in a Chart
 Modifying the Legend Fill Colour
 Changing the Chart Type
 Modifying Charts Using the Layout Tab
 Copying and Moving Charts within a Worksheet
 Copying and Moving Charts between Worksheets
 Copying and Moving Charts between Workbooks

 Modifying Basic Excel Options