Microsoft Excel 2003 Training - Level 1
This course is designed for the new or inexperienced user who has a need to use the programme on a regular basis, but who has had no formal or structured training and is likely to be self taught.
Delegates attending the course will gain the skills that will enable them to understand how to work with Excel on a day to day basis. Creating the most commonly used formulae, moving around the whole workbook in an efficient manner and designing the spreadsheets so that they can be printed in the most professional and easy to interpret format possible. The numerous shortcuts demonstrated, and the insight in to how to best use the day to day functions of Excel will ensure that the delegate is able to readily identify the benefits of attending the course immediately on returning to the workplace.
Course Outline:
Using Styles - Apply Existing Styles
- Create A New Style
- Modify A Style
- Styles By Example
- Copy Styles To Another Document
- The Style Gallery
Outlining A Document - Create A Document In Outline View
- Work With An Outline
- Outline Numbering
- Outline An Existing Document
- Using The Document Map
Master Documents - Create A Master Document
- Create Subdocuments
- Work With Master Documents
- Insert Subdocuments
- Format A Master Document
- Edit Subdocuments
- Merge Subdocuments
- Split Subdocuments
- Delete Subdocuments
- Build A Table Of Contents
- Print A Master Document
Work with Pictures - Insert a picture
- Move a picture
- Resize a picture
- Crop a picture
| Document Review - Insert Comments
- Print Comments
- Track Changes
- Review Tracked Changes
- Version Control
- Compare Documents
- Protect And Unprotect A Document
Longer Documents - Set And Use Bookmarks
- Create Footnotes
- Create Endnotes
- Convert Footnotes And Endnotes
- Modify Footnotes And Endnotes
- Delete Footnotes And Endnotes
- Create A Table Of Contents
- Create A Table Of Contents From User Styles
- Update A Table Of Contents
- Mark Index Entries
- Create A Concordance File
- Use A Concordance File
- Create An Index
Watermarks - Create A Text Watermark
- Edit A Watermark
- Add A Picture Watermark
- Remove A Watermark
|
