Everything Desktop Training

VIEW DEMO To view a demo please visit our website link. To view a demo you need to visit our website and click the link. If you do not have a shockwave player it will ask you to download it. You only need the shockwave player for the online demos only, although they are the same as the product for web purposes we have configured them to play in shockwave. Shockwave is similar to a flash player and can be downloaded free from Macromedia shockwave.com

Investing in employee training today means success tomorrow. Take advantage of our best-of-breed training for Microsoft Office applications, operating systems and basic PC skills and improve workforce performance.

Our curriculum combines proven instructional design techniques, realistic simulation and unparalleled interactivity with challenges, tests and feedback. Master the world's leading productivity tools today

Microsoft Excel 2000 Training

This sequence of Learning Objects provides the user with the core skills necessary to efficiently use Microsoft Excel 2000, Microsoft's popular spreadsheet program. It is also excellent preparation for the Microsoft Office User Specialist (MOUS) certification exam.

Microsoft Excel 2000 Training covers topics such as

Entering and editing cell content
Formatting numbers
Linking worksheets
Using basic functions
Working with charts

Demystify the world's leading spreadsheet application, Microsoft Excel 2000. Our in-depth, easy-to-follow courses lead you through common tasks using a clear, step-by-step approach. Microsoft Excel 2000 Training takes the guesswork out of using Excel 2000.

Learn exactly what you need to know with our interactive multimedia courseware. Our animations and simulations teach fundamental techniques and let you apply what you have learned in a realistic application environment. Microsoft Excel 2000 Training prepares you for the Microsoft Office User Specialist (MOUS) certification exam.

Working with objects Microsoft Excel 2000 Training includes both basic and advanced Excel 2000 courses.

Excel 2000 Training

Course Objectives
After completing these Learning Objects, the learner will be able to perform tasks such as:
» Working with cells » Working with files
» Formatting and printing worksheets » Working with worksheets and workbooks
» Working with formulas and functions » Using charts and objects
» Collaborating with work groups
Media Selection
Contextual Simulations: 60 Audio: Yes
Graphics display the user interface and key concepts
Rollovers let users interact with and view supplemental information
Animations illustrate processes
Advanced simulation technology allows users to practice skills and gauge
their proficiency
Course Description
This sequence of Learning Objects will provide the user with the core skills necessary to
efficiently use Microsoft Excel 2000, Microsoft's popular spreadsheet program. It is also
excellent preparation for the Microsoft Office User Specialist (MOUS) certification exam.
Audience Definition
Designed for learners who currently use or are beginning to use Microsoft Excel 2000.
Prerequisites
Familiarity with the Microsoft Windows environment, and ability to use a keyboard and mouse.
Estimated Length
Each Learning Object is approximately 15-20 minutes in duration with a total
approximate time of 6.5 hours.
Course Outline
Getting Started
Entering and Editing Cell Content
Clearing Cells
Navigating in a Workbook
Inserting and Copying Cells
Working with Files
Opening and Saving Workbooks
Formatting Text
Formatting Numbers
Formatting Cells
Printing
Setting up Pages
Working with Rows and Columns
Working with Worksheets
Linking Worksheets
Using Formulas
Using Basic Functions
Using Date, Financial, and Logical Functions
Working with Charts
Working with Objects

Assessment Description
Pre-assessment Challenge
(3-4 standard questions and a performance-based simulation)
Lesson Review
(2 standard questions)
Final Test
(3-4 standard questions and a performance-based simulation)
Detailed Course Outline and Objectives
The objectives in the following Learning Objects cover the Microsoft Office User Specialist
(MOUS) Core requirements.
Getting Started
» Use the Menu bar, the Standard toolbar and the Formatting toolbar
» Use the Name box, the Formula bar, cell referencing, and sheet tabs
» Choose options in a dialog box
» Save and close a workbook
» Close Excel
Entering and Editing Cell Content
» Enter text, dates, and numbers
» Edit cell content
» Work with series
Clearing Cells
» Use Undo and Redo
» Clear cell content
» Clear cell formats
Navigating in a Workbook
» Go to a specific cell in a worksheet
» Use Find and Replace to locate and change cell content
» Create Hyperlinks to other locations
Inserting and Copying Cells
» Insert and delete cells in a worksheet
» Use the Office Clipboard in Excel
» Copy and paste cells in a worksheet
» Use the Paste Special feature to link or embed copied cells
Working with Files
» Save an Excel workbook
» Use a template to create a new workbook
» Use the Office Assistant to get help
» Check the spelling of text in cells
Opening and Saving Workbooks
» Use Save As to save a file with a different name or file format, or in a different location
» Locate and open an existing workbook
» Create a folder while in Excel
» Save a workbook or worksheet as a Web page
» Preview a workbook and worksheet as a Web page
» Use e-mail to send a workbook
Formatting Text
» Apply font styles to text, such as typeface, size, and color
» Define, apply, and remove a predefined style
» Use the Format Painter to copy formats
» Rotate text and change indents
Formatting Numbers
» Apply predefined number formats such as currency, percent, dates, and commas
» Adjust the decimal places
» Modify cell content alignment
Formatting Cells
» Modify the size of rows and columns
» Apply cell borders and shading
» Merge cells
» Apply an AutoFormat to cells
Printing
» Preview and print worksheets and workbooks
» Print a selection from a worksheet
» Set, print, and clear a print area
Setting up Pages
» Change the orientation and scale of a page
» Set page margins and center worksheet data
» Insert and remove page breaks
» Set up headers and footers
» Set print options such as print titles, gridlines, print quality, and row and column headings
Working with Rows and Columns
» Insert and delete rows and columns
» Hide and unhide rows and columns
» Freeze and unfreeze rows and columns
» Change the zoom setting
Working with Worksheets
» Move between worksheets in a workbook
» Rename a worksheet
» Insert and delete worksheets
» Move and copy worksheets
Linking Worksheets
» Link worksheets and consolidate data using 3D references
Using Formulas
» Enter a range within a formula by dragging
» Enter formulas in a cell and using the formula bar
» Revise formulas
» Use absolute and relative cell references
Using Basic Functions
» Use AutoSum to add the values in a group of cells
» Enter Excel functions using the Formula bar
» Use Paste Function to insert a function
» Use the basic functions, AVERAGE, SUM, COUNT, MIN, and MAX
Using Date, Financial, and Logical Functions
» Use date functions - NOW and DATE
» Use financial functions - FV and PMT
» Use logical functions - IF
Working with Charts
» Preview and print charts
» Use the Chart Wizard to create a chart
» Modify charts
Working with Objects
» Insert, move and delete and object
» Create and modify lines and objects