 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel 97 Expert User
Course Aims
MS Excel 97 is a spreadsheet from Microsoft designed specifically for a graphical environment. This course is designed to give you an understanding of some of the major features and functions within Excel and the advantages of using a powerfully integrated spreadsheet running under Windows 95. The course is entirely 'hands on' and those reading will gain a good basic understanding of how to create and manage spreadsheets, graphics and databases. This Excel 97 course meets Microsoft's standard of Year 2000 compliance. |
Assumed Knowledge
A working knowledge of PCs, a keyboard and mouse plus Windows 95 is assumed, gained from the workplace or by prior attendance on a "Windows 95 User Introduction" course. |
Course Audience
Intending, new or recent users of MS Excel 97 Windows 95 who want to gain a good understanding of the software in a short space of time. |
|
Table of Contents
|
Introduction
|
Advanced Spreadsheet Functions and Features
|
|
|
|
Year 2000 Formatting Spreadsheets
|
Custom Number Format Sections and Codes
|
|
Using Conditional Formats
|
|
|
|
Using Lists
|
Setting Up, Sorting and Filtering Lists
|
|
|
|
|
Printing
|
|
|
Auditing a Worksheet
|
Using Worksheet Auditing Tools
|
|
Validating the Whole Worksheet
|
|
Finding and Replacing Data
|
|
Adding Comments to the Worksheet
|
|
|
|
Data Management
|
Searching for Data with Advanced Filters
|
|
Analysing Data with PivotTables
|
|
Creating and Modifying a PivotTable
|
|
Creating Data Map Charts Using Macros
|
|
|
|
Importing and Exporting Data
|
|
|
Using Templates
|
Creating Workbook Templates
|
|
|
|
Working with Multiple Workbooks
|
Opening a Second Workbook
|
|
Working with Large Sheets
|
|
Linking Workbooks using Formulae
|
|
|
|
|
Workgroup Functions
|
|
|
|
Year 2000 Best Practices
|
|
|
|
|
