Excel Training
Also Available Microsoft Office XP Training
Microsoft Excel 2000 Training Courses on Videos or CDs Detailed Descriptions
 Microsoft Excel is a powerful spreadsheet program that you
can use to efficiently store and work with lists of data, calculate numbers, and create reports and charts. MS Excel enables you to:
- Enter and format your data, and write formulas
- Create a template to speed up your work
- make your worksheets available over the internet or intranets with Microsoft Frontpage™.
- Manage your tasks with the help of Microsoft Outlook ™.
- Consolidate data from several worksheets into one.
- Find and organize information by filtering, sorting, and subtotaling.
- Summarize and analyze data using PivotTable ® dynamic views.
- Use charting to visualize trends and relationships.
- Print the reports you require.
- Find the optimum answer by using Goal Seek and Scenario Manager to compare alternatives.
- Work simultaneously with others by sharing a workbook via your company intranet.
- plus much more . . .
Try a Free Excel 2000 Demo
Please note *Demo requires Cable or DSL bandwidth. With 56k connection you may find pauses in the demo. The
actual training CD videos will be sharper than the demo which requires video streaming over the internet.
|
All Three MS Excel Training Videos
Beginning/Intermediate/Advanced with Reference Guide
|
kyex2a
|
$99.95
|
|
|
All Three Microsoft Excel Training CDs
Beginning/Intermediate/Advanced with Reference Guide Tutorial
|
kyexm2a
|
$99.95
|
|
MS Excel 2000 Training Videos and CD-ROM Tutorial
Microsoft Excel 2000 Tutorial
Excel is the premiere spreadsheet software program and we are proud to offer our three Level
Training series on Interactive CD-ROM's. Creating and Implementing Spreadsheets is a must have skill for any successful business, and MS Office 2000 contains more options and
benefits than the prior versions. Our training gives you the skills necessary to get the most out of your Excel projects.
Level I Training: Level one of our Excel Office training will answer your most fundamental questions beginning with a definition of MS Excel. Level one then proceeds to cover
navigation, creation, modification, and printing of workbooks, formatting values and rangers, drawing functions, data sorting, and the creation and use of templates.
Introduction
What is Excel
Navigation
Cells
Sheets
Rows
Columns
Creating a Workbook/Spreadsheet
Copying Data
Moving Data
Undo
Cutting Data
Series
Saving
Using Online Help
Formatting Values & Ranges
Opening a Workbook
Deleting Cell Contents & Worksheets
Revising Text and Numbers
Level II Microsoft Office Training: Level Two advances into the more in-depth applications of Excel. Our training covers auto and custom formatting, applications of formulas, use of IF
functions, and importing data and lists from outside sources.
Using Drawing Tools
Using Functions
Using Charts
Inserting & Deleting Rows & Columns
Using & Creating Templates
Auto Formatting
Creating &Working with Formulas
Formula Basics
Mathematical Operators
Order of Operation
Copying Formulas Using Relative Reference
Copying Formulas Using Absolute Reference
Using IF and Nested IF Functions
Working with Dates
Importing Data from Other Sources
Importing Lists
Conclusion
Level III Training: Level Three covers the most comprehensive topics of the Excel program. It contains information on advanced charts, hyperlinks and macros, filters and sorts, data
analysis, conditional formatting and styles, sharing workbooks and workgroups and their functions, and pivot tables.
Advanced Charts
Linking Spreadsheets & Workbooks
Hyperlinks and Saving as HTML
Creating & Using Macros
Using Fields & Sorts
Data Analysis
Conditional Formatting
Styles
Auditing a Workbook
Sharing Workbooks & Workgroup Functions
Pivot
Meet our Expert
Shawn Oliver is a training specialist in the Microsoft Office applications. He is a MCP, MCT
and MOUS Certified Instructor. Oliver's straightforward approach and easy to understand deliveries present the viewer with a relaxed approach to the complex information contained within the Office Training.
|
