MS Excel Introductory—Level 1

Tutorial 1. Excel Basics
Topic 1: Introduction
Topic 2: Creating an Excel workbook
Topic 3: Examining the Excel environment
Topic 4: Opening an existing workbook
Topic 5: Navigating a worksheet
Topic 6: Creating a new workbook
Topic 7: Saving a new workbook
Topic 8: Moving between workbooks
Topic 9: Closing a workbook and exiting Excel

Tutorial 2. Working with Data
Topic 1: Entering text and numbers
Topic 2: Entering simple formulas
Topic 3: Changing and deleting data

Tutorial 3. Editing a Worksheet
Topic 1: Working with ranges
Topic 2: Copying and pasting data
Topic 3: Changing column width and row height
Topic 4: Inserting and removing rows and columns
Topic 5: Copying data and formulas with autofill

Tutorial 4. Formatting a Worksheet
Topic 1: Formatting text
Topic 2: Formatting cellsTopic 3: Using autoformat and styles
Topic 4: Rows, columns and page breaks

Tutorial 5. Page Setup and Printing
Topic 1: Page setup and print preview
Topic 2: Setting page options
Topic 3: Adjusting margins
Topic 4: Inserting headers and footers
Topic 5: Adjusting print options
Topic 6: Printing a document

Tutorial 6. Formulas and Functions
Topic 1: Relative references
Topic 2: Absolute references
Topic 3: Mixed references
Topic 4: Copying formulas
Topic 5: Min, max, count and average functions
Topic 6: The insert function button

Tutorial 7. Modifying Workbooks
Topic 1: Adding and deleting worksheets
Topic 2: Copying worksheets
Topic 3: Renaming worksheets
Topic 4: Repositioning worksheets
Topic 5: Grouping worksheets
Topic 6: Changing worksheet tab colours
Topic 7: Using 3-D formulas and references

MS Excel Introductory—Level 2

Tutorial 1. Working with Lists
Topic 1: Getting startedTopic 2: Creating a list
Topic 3: Using a data form
Topic 4: Adding records using a data form
Topic 5: Finding records using a data form
Topic 6: Deleting records using a data form
Topic 7: Sorting records in a list
Topic 8: Using autofilter in a list

Tutorial 2. Working with Charts
Topic 1: Creating a chart with the chart wizard
Topic 2: Moving a chartTopic 3: Resizing a chart
Topic 4: Changing a chart type
Topic 5: Editing chart text
Topic 6: Modifying chart options
Topic 7: Formatting category and value axis data
Topic 8: Formatting a data series
Topic 9: Changing a chart’s source data

Tutorial 3. Working With Graphics
Topic 1: Using the drawing toolbar
Topic 2: Formatting objects Topic 3: Inserting wordart
Topic 4: Inserting an organisation chart
Topic 5: Modifying an organisation chart

Tutorial 4. Workgroup Collaboration
Topic 1: Web page preview
Topic 2: Converting worksheets into web pages
Topic 3: Inserting hyperlinks
Topic 4: Viewing and editing comments

Tutorial 5. Financial and Logical Functions
Topic 1: Using the if function
Topic 2: Using nested functions
Topic 3: Using the PMT function
Topic 4: Using the FV function
Topic 5: Using autocalculate

Tutorial 6. Managing Workbooks
Topic 1: Understanding date/time functions
Topic 2: Calculating time intervals
Topic 3: Using templates
Topic 4: Creating a workspace
Topic 5: Comparing two workbooks side by side
Topic 6: Saving a workbook in a different file format
Topic 7: Using data consolidation

MS Excel Advanced—Level 3

Tutorial 1. Importing and Exporting Data
Topic 1: Getting started
Topic 2: Importing external data into Excel
Topic 3: Importing text data into Excel
Topic 4: Importing data from a database
Topic 5: Exporting data from Excel
Topic 6: Publishing worksheets and workbooks to the web

Tutorial 2. Working with Ranges
Topic 1: Creating custom number formats
Topic 2: Using conditional formatting
Topic 3: Removing conditional formatting
Topic 4: Naming a range
Topic 5: Using a named range
Topic 6: Deleting a named range
Topic 7: Using the VLookup function

Tutorial 3. Customising Excel
Topic 1: Creating a macro
Topic 2: Running a macro
Topic 3: Editing a macro
Topic 4: Adding a menu to the menu bar
Topic 5: Adding commands to a menu
Topic 6: Adding buttons to a toolbar

Tutorial 4. Data Analysis Tools
Topic 1: Tracing formula precedents
Topic 2: Tracing cell dependents
Topic 3: Tracing and fixing errors
Topic 4: Creating a pivottable
Topic 5: Rearranging a pivottable
Topic 6: Auto formatting a pivottable
Topic 7: Filtering pivottable data
Topic 8: Creating a pivotchart

Tutorial 5. Summarising Data
Topic 1: Adding subtotals to a list
Topic 2: Nesting subtotals
Topic 3: Applying advanced filters
Topic 4: Adding group and outline criteria to ranges
Topic 5: Using data validation
Topic 6: Creating XML web queries

Tutorial 6. What-If Data Analysis
Topic 1: Using goal seek
Topic 2: Using solver
Topic 3: Creating and displaying scenarios

Tutorial 7. Workgroup Collaboration
Topic 1: Locking/unlocking cells in a worksheet
Topic 2: Protecting a worksheet
Topic 3: Protecting a workbook
Topic 4: Creating a shared workbook
Topic 5: Tracking changes to a workbook
Topic 6: Accepting and rejecting changes to a workbook
Topic 7: Password protecting a workbook
Topic 8: Merging workbooks