Lesson 1:
Filling Data

Filling a Series, Filling a Growth Series, Filling a Series Backwards, Filling Using Options, Creating a Custom Fill List, Modifying a Custom Fill List, Deleting a Custom Fill List

Lesson 2:
Moving Data

Understanding Moving In Excel, Moving Cells And Ranges, Moving Data To Other Worksheets, Moving Data To Other Workbooks

Lesson 3:
Formula Techniques

Scoping a Formula, Developing a Nested Function, Creating Nested Functions, Editing Nested Functions, Copying Nested Functions, Using Concatenation, Switching To Manual Recalculation, Forcing a Recalculation, Pasting Values From Formulas, Pasting Formulas As Pictures

Lesson 4:
Logical Functions

Using IF To Display Text, Using IF To Calculate Values, Nesting IF Functions, Using IFERROR, Using TRUE And FALSE, Using AND, Using OR, Using NOT

Lesson 5:
Number Formatting Techniques

Using Alternate Currencies, Formatting Dates, Formatting Time, Creating Custom Formats

Lesson 6:
Conditional Formatting

Formatting Cells Containing Values, Clearing Conditional Formatting, More Cell Formatting Options, Top Ten Items, More Top And Bottom Formatting Options, Working With Data Bars, Working With Colour Scales, Working With Icon Sets

Lesson 7:
Applying Borders

Applying a Border To a Cell, Applying a Border To a Range, Applying a Bottom Border, Applying Top And Bottom Borders, Removing Borders, The More Borders Option, Using The More Borders Option

Lesson 8:
Working with a Worksheet

Changing Worksheet Views, Worksheet Zooming, Viewing The Formula Bar, Viewing The Gridlines, Viewing The Ruler, Inserting Cells, Deleting Cells, Inserting Columns, Inserting Rows, Deleting Rows And Columns, Switching Between Worksheets

Lesson 9:
Worksheet Techniques

Inserting And Deleting Worksheets, Copying a Worksheet, Renaming a Worksheet, Moving a Worksheet, Hiding a Worksheet, Unhiding a Worksheet, Copying a Worksheet To Another Workbook, Moving a Worksheet To Another Workbook, Changing Worksheet Tab Colours, Grouping Worksheets, Hiding Rows And Columns, Unhiding Rows And Columns, Freezing Rows And Columns, Splitting Windows

Lesson 10:
Finding and Replacing

Finding Text, Finding Cell References In Formulas, Replacing Values, Using Replace To Change Formulas, Replacing Within a Range, Finding Formats, Finding Constants Using Go To Special, Finding Formulas Using Go To Special, Finding The Current Region, Finding The Last Cell

Lesson 11:
Page Setup

Using Built In Margins, Setting Custom Margins, Changing Margins By Dragging, Centring On a Page, Changing Orientation, Specifying The Paper Size, Setting The Print Area, Clearing The Print Area, Inserting Page Breaks, Using Page Break Preview, Removing Page Breaks, Setting a Background, Clearing The Background, Settings Rows As Repeating Print Titles, Clearing Print Titles, Printing Gridlines, Printing Headings, Scaling To a Percentage, Fit To a Specific Number Of Pages, Strategies For Printing Larger Worksheets

Lesson 12:
Sorting Data

Performing An Alphabetical Sort, Sorting On More Than One Column, Sorting By Rows, Sorting Numbered Lists

Lesson 13:
Filtering Data

Applying And Using a Filter, Clearing a Filter, Creating Compound Filters, Multiple Value Filters, Creating Custom Filters, Using Wildcards

Lesson 14:
Charting Techniques

Adding a Chart Title, Adding Axes Titles, Positioning The Legend, Showing Data Labels, Showing a Data Table, Modifying The Axes, Showing Gridlines, Formatting The Plot Area, Showing The Plot Area, Adding  a Trendline, Adding Error Bars, Adding a Text Box To a Chart, Drawing Shapes In a Chart

Lesson 15:
Chart Text Formatting

Using Font Formatting And Alignment, Using WordArt Styles, Changing Text Fill, Changing Text Outline, Changing Text Effects