Excel 2000 Expert
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
Excel 2000 Expert

Overall Aim:
This course will cover all of the listed examination topics for the MOUS Expert Level for Excel 2000.

Target Group:
Any PC user who wishes to attain MOUS certification, or who wishes to develop advanced spreadsheet skills using Microsoft Excel 2000.

Pre-requisites:
Delegates must have previously attended the MOUS Excel 2000 Core Level course of be familiar with all of the elements of the Core course objectives.

Course Outline:
Importing and Exporting Data
- Import data from text files (insert, drag and drop)
- Import from other applications
- Import a table from an HTML file (insert, drag and drop - including HTML round tripping)
- Export to other applications

Using Templates
- Apply templates
- Edit templates
- Create templates

Using Multiple Workbooks
- Using a Workspace
- Linking Workbooks

Formatting Numbers
- Apply number formats (accounting, currency, number)
- Create custom number formats
- Use conditional formatting

Printing Workbooks
- Print and preview multiple worksheets
- Use the Report Manager

Working with Named Ranges
- Add and delete a named range
- Use a named range in a formula
- Use Lookup Functions (Hlookup or Vlookup)

Working with Toolbars
- Hide and display toolbars
- Customise a toolbar
- Assign a macro to a command button

Using Macros
- Record macros
- Run macros
- Edit macros

Auditing a Worksheet
- Work with the Auditing Toolbar
- Trace errors (find and fix errors)
- Trace precedents (find cells referred to in a specific formula)
- Trace dependants (find formulas that refer to a specific cell)

Displaying and Formatting Data
- Apply conditional formats
- Perform single and multi-level sorts
- Use grouping and outlines
- Use data forms
- Use subtotaling
- Apply data filters
- Extract data
- Query databases
- Use data validation 

Using Analysis Tools
- Use PivotTable autoformat
- Use Goal Seek
- Create pivot chart reports
- Work with Scenarios
- Use Solver
- Use data analysis and PivotTables
- Create interactive PivotTables for the Web
- Add fields to a PivotTable using the Web browser

Collaborating with Workgroups
- Create, edit and remove a comment
- Apply and remove worksheet and workbook protection
- Change workbook properties
- Apply and remove file passwords
- Track changes (highlight, accept, and reject)
- Create a shared workbook
- Merge workbooks
 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Duration2 days
 
£351
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).