 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel 2000 Advanced
Course Aims
MS Excel 2000 is the popular version of the spreadsheet from Microsoft, designed specifically for the networked office environment. This course is designed to give users an understanding of some of the more advanced features and functions within Excel and the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those reading will get practice in using advanced features of Excel 2000 to manage, automate and customise workbooks. This Excel 2000 course also instructs users in Year 2000 best practice. |
Assumed Knowledge
A good working knowledge of Excel, plus Windows 95/98/NT is assumed, gained from the workplace or by reading our "MS Excel 2000 Intermediate" course. |
Course Audience
Existing users of MS Excel who want to gain further in-depth knowledge in a short space of time. |
|
Table of Contents
|
|
Excel 2000 Advanced
|
|
|
Custom formatting
|
Custom number format sections
|
|
Custom number format codes
|
|
Using conditional formats
|
|
|
|
Working with named ranges
|
Range names in calculations
|
|
|
|
Importing and exporting data
|
Object linking and embedding
|
|
Sharing data with other applications
|
|
Importing a text file into Excel
|
|
Importing data from Web pages
|
|
|
|
Templates and Add-Ins
|
Creating workbook templates
|
|
|
|
Working with multiple workbooks
|
Creating a workspace file
|
|
Creating formulae to link data
|
|
|
Printing workbooks and reports
|
Printing multiple worksheets
|
|
Printing multiple workbooks
|
|
|
|
Lookup and reference functions
|
Using the LOOKUP function
|
|
Using the VLOOKUP function
|
|
Using the HLOOKUP function
|
|
|
|
Working with Toolbars
|
Displaying hidden Toolbars
|
|
Floating and docking Toolbars
|
|
|
|
Using Macros
|
Assigning a Macro to a Toolbar
|
|
|
|
|
Creating map charts
|
|
|
|
|
