Lesson 1:
Getting to Know Excel

Starting Excel, The Excel Screen, Using The Ribbon, Using KeyTip Badges, Minimising The Ribbon, Using Shortcut Menus, Launching Dialog Boxes, Customising The Quick Access Toolbar, The Office Button, Using The Office Button, The Status Bar, Customising The Status Bar, Exiting Safely From Excel

Lesson 2:
Creating a New Workbook

Understanding Workbooks, Using The Blank Workbook Template, Typing Text Into a Worksheet, The Save As Dialog Box, Saving a New Workbook, Typing Numbers Into a Worksheet, Typing Simple Formulas In a Worksheet, Easy Formulas, Typing Dates In a Worksheet, Easy Formatting, Checking Spelling In a Worksheet, Making And Saving Changes, Printing a Worksheet, Safely Closing a Workbook

Lesson 3:
Working with Workbooks

Opening An Existing Workbook, Moving About a Worksheet, Moving About a Workbook, Going To a Specific Location, The Open Dialog Box

Lesson 4:
Editing in a Workbook

Understanding Data Editing, Overwriting Cells Contents, Editing Longer Cell Entries, Editing Formulas, Editing Functions, Clearing a Cell, Deleting In a Worksheet, Undoing And Redoing Operations

Lesson 5:
Formulas and Functions

Understanding Formulas, Creating Formulas That Add, Creating Formulas That Subtract, Formulas That Multiply And Divide, Understanding Functions, Using The SUM Function To Add, Summing Non-Contiguous Ranges, Calculating An Average, Finding a Maximum Value, Finding a Minimum Value, More Complex Formulas, What If Formulas

Lesson 6:
Formula Referencing

Absolute Versus Relative Referencing, Relative Formulas, Problems With Relative Formulas, Creating Absolute References, Creating Mixed References

Lesson 7:
Selecting Ranges

Understanding Ranges, Selecting Ranges, Selecting Non-Contiguous Ranges, Using Special Selection Techniques, Selecting Larger Ranges, Selecting Rows, Selecting Columns, Viewing Range Calculations, Creating An Input Range

Lesson 8:
Copying Excel Data

Understanding Copying In Excel, Using Fill For Quick Copying, Copying From Cell To Another, Copying From One Cell To a Range, Copying From One Range To Another, Copying Relative Formulas, Copying To a Non-Contiguous Range, Copying To Another Worksheet, Copying To Another Workbook

Lesson 9:
Font Formatting

Approximating Column Widths, Setting Precise Column Widths, Setting The Default Column Width, Approximating Row Height, Setting Precise Row Heights, Hiding Rows And Columns, Unhiding Rows And Columns

Lesson 10:
Cell Alignment

Understanding Cell Alignment, Aligning Right, Aligning To The Centre, Aligning Left, Aligning Top, Aligning Bottom, Aligning To The Middle, Rotating Text, Indenting Cells, Wrapping And Merging Text, Merging And Centring, Merging Cells, Unmerging Cells

Lesson 11:
Row and Column Formatting

Approximating Column Widths, Setting Precise Column Widths, Setting The Default Column Width, Approximating Row Height, Setting Precise Row Heights, Hiding Rows And Columns, Unhiding Rows And Columns

Lesson 12:
Number Formatting

Understanding Number Formatting, Applying General Formatting, Formatting As Currency, Formatting Percentages, Formatting As Fractions, Formatting As Dates, Using The Thousands Separator, Increasing And Decreasing Decimals

Lesson 13:
Printing

Understanding Printing, Previewing Before You Print, Performing a Quick Print, Selecting a Printer, Printing a Range, Printing An Entire Workbook, Specifying The Number Of Copies, The Print Dialog Box

Lesson 14:
Creating Charts

Understanding The Charting Process, Choosing The Chart Type, Creating a New Chart, Working With An Embedded Chart, Resizing a Chart, Dragging a Chart, Printing An Embedded Chart, Creating a Chart Sheet, Changing The Chart Type, Changing The Chart Layout, Changing The Chart Style, Printing a Chart Sheet, Embedding a Chart Into a Worksheet, Deleting a Chart