|
12 Month Subscription - $35
|
Summary:
This series is intended as preparation for the Excel 2002 Microsoft Office User Specialist (MOUS) Core Proficiency exam. It introduces Excel's newest enhancements such as task panes for New Documents, Clipboard, Search, and Insert Clip Art; the Ask a Question box; enhancements to Find and Replace; and additional options for pasting and for inserting columns and rows. These new features, along with the productivity tools of previous versions, are taught within the context of working with cells and files, page setup and printing, worksheets and workbooks, formulas and functions, and charts and objects.
Certification:
MOS
Audience:
This series is for anyone preparing for the MOS Excel 2002 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 this course:
Excel 2002 Series: Working with Cells
Excel 2002 Series: Working with Files
Excel 2002 Series: Formatting Worksheets
Excel 2002 Series: Page Setup and Printing
Excel 2002 Series: Worksheets and Workbooks
Excel 2002 Series: Formulas and Functions
Excel 2002 Series: Charts and Objects
Excel 2002 Series: Working with Cells
Summary: Time: 4.0 hour(s)
This course shows users how to enter and edit data in Excel 2002 worksheet cells and create hyperlinks.
Objectives:
After completing this course, students will be able to:
Enter cell data including text, numbers, and formulas
Edit cell data
Insert, delete, and move cells
Find and replace cell data and formats
Create hyperlinks
Topics:
Entering Data
Editing a Cell
Editing Multiple Cells
Replacing Values and AutoFilling
Creating Hyperlinks
top
Excel 2002 Series: Working with Files
Summary: Time: 3.0 hour(s)
This course shows users how to locate, open, and save files in Excel 2002.
Objectives:
After completing this course, students will be able to:
Manage workbook files and folders
Create workbooks using templates
Save workbooks using different names and file formats
Convert worksheets to Web pages
View and edit comments
Topics:
Opening Files
Saving Files
Files and the Internet
Working with Comments
Using the Office Assistant
top
Excel 2002 Series: Formatting Worksheets
Summary: Time: 4.0 hour(s)
This course shows users how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2002 worksheet.
Objectives:
After completing this course, students will be able to:
Apply and modify cell formats
Modify row and column settings
Use automated tools to format worksheets
Apply styles
Topics:
Formatting Cells
Adjusting Cells
Formatting Numbers
Adjusting Rows and Columns
Using AutoFormatting and Styles
top
Excel 2002 Series: Page Setup and Printing
Summary: Time: 2.0 hour(s)
This course shows users how to preview and print worksheets and workbooks, add headers, footers, and titles, and adjust page settings in Excel 2002 worksheets.
Objectives:
After completing this course, students will be able to:
Preview and print worksheets and workbooks
Modify Page Setup options for worksheets
Topics:
Previewing
Printing
Page Setup
Headers, Footers, and Titles
top
Excel 2002 Series: Worksheets and Workbooks
Summary: Time: 4.0 hour(s)
This course shows users how to work with worksheet rows and columns, move between worksheets in a workbook, consolidate data, change the zoom setting, and check spelling in Excel 2002 worksheets.
Objectives:
After completing this course, students will be able to:
Modify row and column formats
Modify worksheet names and positions
Insert and delete worksheets
Use 3-D references
Check spelling
Work with a subset of data by filtering lists
Topics:
Working with Rows and Columns
Working with Worksheets
Linking Worksheets and Consolidating Data
Zooming and Spell-Checking
Using a Data Filter
top
Excel 2002 Series: Formulas and Functions
Summary: Time: 3.0 hour(s)
This course shows users how to work with formulas and functions in Excel 2002 worksheets.
Objectives:
After completing this course, students will be able to:
Work with formulas
Use references and AutoSum
Enter Functions
Use basic and date functions
Use financial 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 2002 Series: Charts and Objects
Summary: Time: 2.0 hour(s)
This course shows users how to create, modify, and print charts, insert, move and delete pictures, and draw lines and shapes in Excel 2002 worksheets.
Objectives:
After completing this course, students will be able to:
Create, modify, position, and print charts
Create, modify, and position objects
Topics:
Creating Charts
Modifying and Printing Charts
Working with Objects
Drawing Lines and Shapes
top
|
12 Month Subscription - $35
|
