|
12 Month Subscription - $35
|
Summary:
This series is designed to help users prepare for the MOS Excel Core examination. The series begins with basic Excel tasks, such as entering and editing data, using Find, Replace, and AutoFill, and creating hyperlinks. It also covers locating, opening, and saving files, and using the help function, Office Assistant. Formatting worksheets is covered in detail, including cell and number formatting, adjusting rows and columns, and the use of AutoFormat, styles, and Format Painter. More advanced topics covered include page setup, managing worksheets and data, and creating formulas and functions. An overview of charts and objects, including the Chart Wizard, is also provided.
Certification:
MOS
Audience:
This series is for anyone preparing for the MOS Excel 2000 Core certification exam.
Features:
● Exercises that allow users to practice the application
● A file containing the text of the exercises
● Simulations that allow users to practice course skills, even if they don't have access to the application
● A glossary
● A Skill Assessment
Topics included in the course:
Excel 2000 : Working with Cells
Excel 2000 : Working with Files
Excel 2000 : Formatting Worksheets
Excel 2000 : Page Setup and Printing
Excel 2000 : Worksheets and Workbooks
Excel 2000 : Formulas and Functions
Excel 2000 : Charts and Objects
Excel 2000 : Working with Cells
Summary: Time: 4.0 hour(s)
This course shows how to enter and edit data in Excel 2000 worksheet cells and how to create hyperlinks.
Objectives:
After completing this course, students will be able to:
Enter data
Edit one or more cells
Find and replace values
Use the AutoFill feature to create series
Create and edit hyperlinks
Topics:
Entering Data
Editing a Cell
Editing Multiple Cells
Replacing Values and AutoFilling
Creating Hyperlinks
top
Excel 2000 : Working with Files
Summary: Time: 3.0 hour(s)
This course shows how to locate, open, and save files in Excel 2000.
Objectives:
After completing this course, students will be able to:
Open files
Save files
Send a workbook via e-mail
Save a worksheet or workbook as a Web page
Use the Office Assistant
Topics:
Opening Files
Saving Files
Files and the Internet
Using the Office Assistant
top
Excel 2000 : Formatting Worksheets
Summary: Time: 4.0 hour(s)
This course shows how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2000 worksheet.
Objectives:
After completing this course, students will be able to:
Format cells
Adjust alignment and indentation of text in cells
Adjust rows and columns
Format numbers
Use the AutoFormatting feature
Define, apply, and remove a style
Topics:
Formatting Cells
Adjusting Cells
Adjusting Rows and Columns
Formatting Numbers
Using AutoFormatting and Styles
top
Excel 2000 : Page Setup and Printing
Summary: Time: 2.0 hour(s)
This course shows how to preview and print worksheets and workbooks; add headers, footers, and titles, and adjust page settings in Excel 2000 worksheets.
Objectives:
After completing this course, students will be able to:
Preview worksheets, workbooks and Web pages
Change page setup
Set up headers and footers
Set print options
Print worksheets, workbooks, and selections
Topics:
Previewing
Page Setup
Headers, Footers, and Titles
Printing
top
Excel 2000 : Worksheets and Workbooks
Summary: Time: 3.0 hour(s)
This course shows how to work with worksheet rows and columns, manage worksheets, and consolidate data in Excel 2000 worksheets.
Objectives:
After completing this course, students will be able to:
Insert and delete rows and columns
Hide and unhide rows and columns
Freeze and unfreeze rows and columns
Move between worksheets in a workbook
Rename, insert, delete, move, and copy worksheets
Link worksheets, consolidate data, and check spelling
Topics:
Working with Rows and Columns
Working with Worksheets
Linking Worksheets and Consolidating Data
Zooming and Spell-Checking
top
Excel 2000 : Formulas and Functions
Summary: Time: 3.0 hour(s)
This course shows how to work with formulas and functions in Excel 2000 worksheets.
Objectives:
After completing this course, students will be able to:
Enter and revise formulas
Use absolute and relative references
Use the AutoSum feature
Enter and use basic functions
Enter and use date functions, financial functions, and logical functions
Topics:
Working with Formulas
Using References and AutoSum
Entering Functions
Using Basic and Date Functions
Using Financial and Logical Functions
top
Excel 2000 : Charts and Objects
Summary: Time: 2.0 hour(s)
This course shows how to create, modify, and print charts; insert, move and delete pictures, and draw lines and shapes in Excel 2000 worksheets.
Objectives:
After completing this course, students will be able to:
Use the Chart Wizard to create a chart
Modify charts
Preview and print charts
Insert, move, and delete an object (picture)
Create and modify lines and objects
Topics:
Creating Charts
Modifying and Printing Charts
Working with Objects
Drawing Lines and Shapes
top
|
12 Month Subscription - $35
|
