| 1. | Introduction to this course |
Welcome Introduction and objectives Getting help with the course How the course is structured About the model job The modelling process Summary |
2. | Introducing Microsoft Excel 97 |
Objectives Overview Starting and exiting Excel 97 Excel terms explained The Excel user interface Getting help on Excel 97 Exercise Review questions Summary |
| 3. | Creating and Saving Workbooks |
Objectives Overview Creating a new workbook Naming the worksheets Saving and closing a workbook Opening existing workbooks Entering text Entering numbers Entering dates Exercise Review questions Summary |
4. | Editing Workbooks |
Objectives Overview Using the Zoom tool Moving around the worksheet Selecting ranges of cells Inserting columns and rows Deleting columns and rows Editing existing cells Copying data Moving data Clearing cell contents Creating templates Exercise Review questions Summary |
| 5. | Performing Calculations |
Objectives Overview Doing simple arithmetic Totalling columns and rows Relative vs Absolute references Calculating averages Find minimum & maximum values Other Excel functions Naming cells and ranges Common worksheet errors Linking workbooks Exercise Review questions Summary |
6. | Formatting Your Work |
Objectives Overview Adjusting column widths Formatting column headings Changing character styles Formatting values Changing alignment Changing font and colour Using AutoFormats Outlining worksheets Exercise Review questions Summary |
| 7. | Printing the Worksheet |
Objectives Overview Setting up the pages Previewing the worksheet Preparing for printing Exercise Review questions Summary |
8. | Graphing Data |
Objectives Overview Creating graphs Changing the chart type Changing the series Formatting the titles Formatting the legend Formatting the graph area Moving and resizing graphs Updating the graph values Previewing and printing graphs Exercise Review questions Summary |
| 9. | Automating Your Work |
Objectives Overview Recording a macro Replaying a macro Exercise Review questions Summary |
10. | Importing and Exporting Data |
Objectives Overview Importing a trial balance Importing from Microsoft Access Exporting to Excel Exercise Review questions Summary |
| 11. | Contacting Us |
Contacting Us About Courses on Disk Contacting Courses on Disk The Knowledge Base Other courses for accountants Credits and acknowledgements Summary |
12. | Module Summary |
Congratulations Your quiz score Good luck |
