Date | Location | Price / Members Price | Places | Trainer | Book Online or Enquire |
---|
Overview
This course will introduce new and existing users of Microsoft Excel to the basic but fundamental features of Spreadsheets and their use. Delegates are guided through its use from setting up a simple spreadsheet with values, labels and formulae to displaying information in graphical format.
Objectives
The course will also be of great benefit to those who have been using Excel for some time but who feel that they are not making best use of its facilities. The course will undoubtedly introduce these users to many shortcuts which they may not have discovered for themselves.
Who Should Attend
- New, recent or intended users of Excel who want to gain a good overview of the product in a short space of time
- Existing users of Excel who feel that they are not making best use of its facilities
- Users who are converting from another Spreadsheet package to Excel or upgrading
Content:
- Using multiple worksheets and workbooks
- Using multiple workbooks
- Linking worksheets with 3-D formulas
- Linking workbooks
- Managing workbooks
Advanced Formatting
- Using special number formats
- Using functions to format text
- Working with styles
- Working with themes
- Other advanced formatting
Outlining and subtotals
- Outlining and consolidating data
- Creating subtotals
Cell and range names
- Creating and using names
- Managing names
- Lists and tables Saving workbooks as Web pages
- Using hyperlinks
- Distributing workbooks
Advanced charting
- Chart formatting options
- Combination charts
- Graphic elements
- Documenting and auditing
- Auditing features
- Comments in cells and workbooks
Protection
- Workgroup collaboration
- Templates and settings
- Application settings
- Built-in templates
- Creating and managing templates
Prerequisites
- A working knowledge of PCs and a mouse is assumed.
- It is also recommended that proposed delegates have attended a Windows 2000 or Windows 2002 course or have obtained comparable knowledge from the workplace.