MS Excel 2000 (MOS) CD Training (CBT) Course

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.