|
|
|
MS Excel 2000 (MOS) CD Training (CBT) Course (Prices exclude VAT)
|
|
|
[to previous page]
[other products in "MS Office 2000 Courses"]
|
|
|
| Product: |
MS Excel 2000 (MOS) CD Training (CBT) Course
Levels I, II & III.
|
|
|
| Description: |
|
Microsoft Excel 2000 lets you take advantage of comprehensive
tools to create spreadsheets and share them on the Web for
universal viewing and collaboration. You'll be able to easily
analyze data with charts, Microsoft PivotTable views and graphs.
And, use automatic formatting to create data-rich spreadsheets.
Our dynamic series will show you how to utilize all of the
tools contained within the most popular spreadsheet program
on the market!
|
|
Level One:
- What is Microsoft Excel 2000?
- Navigation
- Creating a workbook
- Using spreadsheets and on-line help
- Formatting values and ranges
- Opening and modifying a workbook
- Deleting cell contents and worksheets
- Revising text and numbers
- Sorting data
- Printing workbooks
- Printing screens and ranges
- Using drawing tools, functions & charts
- Inserting and deleting rows/columns
- Using and creating templates
Level Two:
- Auto and custom formatting
- Creating and working with formulas
- Formula order of operations
- Copying formulas using relative and absolute reference
- Using IF and nested IF functions
- Working with dates
- Importing data from other sources
- Importing lists
Level
Three:
- Advanced charts
- Hyperlinks and macros
- Using filters and sorts
- Data analysis
- Conditional formatting and styles
- Sharing workbooks and workgroups
- Functions of sharing
- Pivot tables
|
|
|
Meet
The Expert
Shawn Oliver is a training specialist for the
entire Microsoft Office family of products. He is an MCP,
MCT and MOUS Certified Instructor. Shawn's easy-to-understand
format and straight-forward, hands-on delivery make him one
of the most effective technical application trainers in the
industry.
|
 |
| Shawn Oliver |
|