Microsoft Excel Training Course
 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 . . .
Now Available Microsoft Office XP, 2003 and 2007 Training
|
All Three Microsoft Excel Training CDs
Beginning/Intermediate/Advanced
|
kyexm2a
|
$99.95
|
|
MS Excel 2000 Training 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
|
