| 1. | About this Course |
Welcome Introduction and objectives Getting help with the course How the course is structured About the model worksheet About the exercises The modelling process Good spreadsheet design Summary |
2. | Introducing Microsoft Excel |
Objectives Overview Starting Microsoft Excel Understanding spreadsheets Understanding the Excel window Getting help on Microsoft Excel Exiting Microsoft Excel Exercise Review questions Summary |
| 3. | Creating and Saving Workbooks |
Objectives Overview Creating a new workbook Saving a workbook Auto-saving your work Closing a workbook Opening a workbook Moving the cell pointer Moving around a worksheet Entering text Entering numbers Entering dates Using the Zoom tool Exercise Review questions Summary |
4. | Editing Workbooks |
Objectives Overview Selecting ranges of cells Editing cell contents Clearing cell contents Copying cell contents Moving cell contents Inserting and deleting cells Inserting columns and rows Deleting columns and rows Copying cells with AutoFill Inserting cell comments Checking your spelling Finding and replacing data Exercise Review questions Summary |
| 5. | Performing Simple Calculations |
Objectives Overview Introducing formulae Totalling columns and rows Calculating with formulae Calculating averages Find the highest & lowest values Understanding cell referencing Using explicit values in formulae Exercise Review questions Summary |
6. | Formatting Worksheets |
Objectives Overview Formatting with font and colour Formatting values Formatting dates and times Copying and pasting formatting Adjusting column widths and row heights Aligning cell contents Indenting and rotating cell contents Merging cells Adding borders, colour and shading Using styles Using AutoFormats Exercise Review questions Summary |
| 7. | Previewing and Printing Worksheets |
Objectives Overview Previewing the worksheet Preparing pages for printing Creating headers and footers Specifying the print area and titles Printing a worksheet Exercise Review questions Summary |
8. | Managing Workbooks |
Objectives Overview Switching between worksheets Renaming worksheets Moving and copying worksheets Inserting and deleting worksheets Referencing external data Exercise Review questions Summary |
| 9. | Creating Charts |
Objectives Overview Creating charts Moving and resizing a chart Changing the chart type Adding another data series Adding and formatting titles Adding borders and colours Working with 3-D charts Moving and resizing graphs Updating the data series Previewing and printing charts Exercise Review questions Summary |
10. | More Functions and Formulae |
Objectives Overview Naming cells and ranges Common worksheet errors Displaying and printing formulae Using the COUNT function Using the IF function Exercise Review questions Summary |
| 11. | Automating Your Work with Macros |
Objectives Overview Recording a macro Replaying a macro Exercise Review questions Summary |
12. | Importing Data |
Objectives Overview Importing from text files Importing from Microsoft Access Exercise Review questions Summary |
| 13. | Working with Lists |
Sorting a list of records Filtering a list of records Sub-totalling a list of records Exercise Review questions Summary |
14. | Module Summary |
Congratulations Your quiz score Good luck |
