Excel 2000 Expert
Designed for: Those who wish to learn Excel 2000 to the Microsoft Office Specialist (MOS) Expert syllabus. Prerequisites: Proficient level knowledge of Excel 2000.
Objectives: To teach advanced spreadsheet skills using this current Microsoft program. Course Content
- Lesson One - Importing and exporting data. Object linking and embedding. Importing data from web files.
- Lesson Two – Using templates. Creating and applying custom templates. Editing and storing templates.
- Lesson Three – Using multiple workbooks. Linking workbooks. Linking workbooks. Creating and using workspace files.
- Lesson Four – Formatting numbers. Using custom formats. Using conditional formats.
- Lesson Five – Printing workbooks. Grouping worksheets. Printing multiple workbooks. Using the report manager.
- Lesson Six – Working with named ranges. Moving and deleting a named range. Range names in calculations. Adding and removing toolbar buttons. Creating toolbars.
- Lesson Seven – Working with Toolbars. Customising toolbars. Adding & removing buttons. Creating a new toolbar. Creating customised menus.
- Lesson Eight – Using Macros. Recording macros. Running and editing macros. Assigning a macro to a toolbar or menu.
- Lesson Nine - Auditing a worksheet. Data entry validation. Auditing data dependency. Showing cells containing ERROR values.
- Lesson Ten – Working with data lists. Filtering lists and using custom filters. Form option buttons. Criteria option buttons.
- Lesson Eleven – Data management. Searching for data with advanced filters. Summarising data with outlines. Querying a database. Controlling formatting and layout. Refreshing external data.
- Lesson Twelve – Pivot tables. Creating pivot tables. Modifying and grouping pivot tables. Creating Interactive Pivot tables for the web.
- Lesson Thirteen – Using Analysis Tools. Goal seeking. Using Solver. Scenario Manager.
- Lesson Fourteen – Workgroups. Applying worksheets protection. Password protecting a file. Adding comments to the worksheet. Working with shared workbooks. Merging workbooks. Tracking changes and resolving conflicts.
-
Benefits
- Know how to use Excel 2000 in order to sit the MOS Expert examination
- The flexibility and value of a self-study course designed to enable you to work at your own pace
- A personalised workbook to use and keep as a reference guide on completion
- The opportunity to gain the widely recognised Pitman Training Certificate
Course duration: 18-20 hours What next: Word 2000 Proficient
Access 2000 Proficient
Outlook 2000 Proficient
|
