MOS MOS Excel Certification Training XP
|
MOS Access 2002 CBT CD
|
$99.00
|
n74050d
|
|
|
MOS Word 2002 CBT CD
|
$99.00
|
n74020d
|
|
|
Excel 2002 includes fundamentals, proficient and expert training levels
|
$99.00
|
n74030d
|
|
|
MOS Outlook 2002 CBT CD
|
$99.00
|
n74070d
|
|
|
MOS Frontpage 2002 CBT CD
|
$99.00
|
n74091d
|
|
|
MOS PowerPoint 2002 CBT CD
|
$99.00
|
n74041d
|
|
|
Complete MS Office XP Curriculum CBT CDs (MOS XP)
(includes Access 2002, Excel 2002, FrontPage 2002, Outlook 2002, PowerPoint 2002, Word 2002)
|
$299.00
|
n74011d
|
|
Microsoft Excel 2002 Training CD MOS MOUS XP Certification
 This MOS Certification Training course presents learners with the
fundamental elements of Excel 2002. The course covers the Excel interface and navigation, how to create and format worksheets. Topics such as creating formulas, copying, inserting and deleting a range of
cells are covered in the course.
Learn To
• Start Excel 2002.
• Identify elements of the Excel 2002 interface.
• Open a workbook.
• Match the different types of data that can be entered into a worksheet with their definitions.
• Edit worksheet data.
• Identify the methods for clearing the contents of a cell in a worksheet.
• Insert a row and column in a worksheet.
• Delete a row and column from a worksheet.
• Hide a row and column in a worksheet.
Audience
The intended audience for this course includes end users and power users who may or may not be familiar with previous
versions of Microsoft Excel. Their relevant duties may include office or managerial duties. They may be involved in
working with accounting and financial data. The audience will include end users, help desk/support personnel, and other
network designers. It is expected that learners should have a working knowledge of Microsoft Windows 9x or later
operating systems. Some learners may have a basic knowledge of either Microsoft Office 97 or 2000 programs.
Total Learning Time
6 to 8 hours
Unit 1: Basics of Excel 2002
2 - 3 hours
• Start Excel 2002.
• Identify elements of the Excel 2002 interface.
• Open a workbook.
• Search for a workbook.
• Open an existing template to create a workbook.
• Save a modified workbook.
• Insert a new worksheet.
• Format a worksheet tab.
• Move a worksheet within a workbook.
• Delete a worksheet.
• Match worksheet navigation methods with their functions.
• Get Help by using the Office Assistant.
• Identify features of the Help Window.
Unit 2: Working with Data
2 - 3 hours
• Match the different types of data that can be entered into a worksheet with their definitions.
• Edit worksheet data.
• Identify the methods for clearing the contents of a cell in a worksheet.
• Insert cells in a worksheet.
• Check the spelling of data in a worksheet.
• Replace text in a worksheet.
• Enter a formula in a worksheet cell.
• Edit a formula in a worksheet.
• Match types of cell references with their functionality.
• Use a worksheet link in a formula.
• Sort a list in descending and ascending order.
• Apply a standard filter to a list.
• Copy a range of cells.
• Use the Fill command on a range of cells.
• Identify features of the Print Preview page.
• Set a page break in a worksheet.
• Modify page settings for printing.
• Align a page for printing.
• Add a header and a footer.
• Set an area to be printed.
• Set the print display.
• Select nonadjacent cell ranges for printing.
Unit 3: Formatting Worksheets
2 hours
• Hide a row and column in a worksheet.
• Modify the size of a row and column.
• Freeze a row and column.
• Merge cells in a worksheet.
• Split merged cells.
• Change font properties.
• Change the alignment of text.
• Add a border and a pattern.
• Apply different number formats.
• Apply automatic formatting to a range of cells.
• Apply conditional formatting to a range of cells.
• Create a new formatting style.
• Apply a formatting style to a range of cells.
• Insert a row and column in a worksheet.
• Delete a row and column from a worksheet.
top
MS Excel 2002 Proficient MOS Certification XP
This MOS Certification Training course covers the advanced skills of working with worksheets in Excel 2002, and
teaches how to manage display properties, advanced calculation techniques and worksheet data manipulation. The
Outline and Web Integration section covers outlining worksheets and publishing a workbook as a Web page. Finally, the Charts and Drawing Objects section teaches creating and modifying a chart and drawing objects.
Learn To
• Add a button on a toolbar.
• Customize a menu by creating commands.
• Identify built-in formats for numbers.
• Identify the features of functions.
• Create a formula by using a basic function.
• Include a range in a function.
• Consolidate data by category.
• Consolidate data by using a three-dimensional (3-D) reference.
• Set up data validation.
• Identify the functions of Outline symbols.
• Outline a worksheet automatically.
• Outline a worksheet manually.
• Create a chart.
• Modify the location of a chart.
• Modify the appearance of a chart.
Audience
The target audience for this course will be End Users and Power Users who may or may not be familiar with previous
versions of Microsoft Excel. Their relevant duties may include office or managerial duties. They may be involved in
working with accounting and financial data. The audience will include end users, help desk/support personnel, and other
network designers. It is expected that learners should have a working knowledge of Microsoft Windows 9x or later
operating systems. Some learners may have a basic knowledge of either Microsoft Office 97 or 2000 programs and should have taken Microsoft Excel 2002 Fundamentals course 74030.
Total Learning Time
6 to 8 hours
Unit 1: Managing Display Properties
1.5 - 2 hours
• Add a button on a toolbar.
• Customize a menu by creating commands.
• Identify built-in formats for numbers.
• Identify custom number formats.
• Add a cell comment.
• Edit a cell comment.
• Create a Web comment.
• Reply to a Web comment.
Unit 2: Advanced Calculation Techniques
1.5 - 2 hours
• Identify the features of functions.
• Create a formula by using a basic function.
• Include a range in a function.
• Include a date function in a formula.
• Include an IF logical function in a formula.
• Include a financial function in a formula.
• Include a lookup function in a formula.
• Create a named range.
• Include a named range in a formula.
Unit 3: Worksheet Data Manipulation
1 - 2 hours
• Consolidate data by category.
• Consolidate data by using a three-dimensional (3-D) reference.
• Set up data validation.
• Trace a dependent and precedent cell in a formula.
• Match each formula error value with its description.
• Protect a selected area in a worksheet.
• Protect an entire workbook.
Unit 4: Outlining and Web Integration
1 hour
• Identify the functions of Outline symbols.
• Outline a worksheet automatically.
• Outline a worksheet manually.
• Create a hyperlink to a Web site from a workbook.
• Preview a workbook as a Web page.
• Save a workbook as a Web page.
• Publish a workbook on the Web.
Unit 5: Charts and Drawing Objects
1 hour
• Create a chart.
• Modify the location of a chart.
• Modify the appearance of a chart.
• Modify chart options.
• Add a trendline to a chart.
• Set up a chart for printing.
• Insert a drawing object.
• Modify the appearance of a drawing object.
top
MS Excel 2002 Expert MOS Certification XP
This MOS Certication Training course covers skills particular to the expert user of Excel 2002. The course teaches template and database integration, shared workbooks, and consolidating data across workbooks. This course also
teaches, Data Analysis and Automation, data importing and querying, pivot tables, macros, and data analysis tools.
Learn To
• Create a new template file.
• Modify an existing template file.
• Create a new workbook by using a user-defined template.
• Create a shared workbook.
• Highlight changes in a shared workbook.
• Accept a change in a shared workbook.
• Import a delimited text file.
• Import data from a fixed-width text file.
• Import data from a database.
Audience
The intended audiences for this course are End Users and Power Users who may or may not be familiar with previous
versions of Microsoft Excel. Their relevant duties may include office or managerial duties. They may be involved in
working with accounting and financial data. The audience will include end users, help desk/support personnel, and other
network designers. It is expected that learners should have a working knowledge of Microsoft Windows 9x or later
operating systems, and basic knowledge of either Microsoft Office 97 or 2000 programs. Learners should have also completed courses 74030 and 74031 or have equivalent knowledge.
Total Learning Time
7 to 8 hours
Unit 1: Template and Database Integration
2 - 3 hours
• Create a new template file.
• Modify an existing template file.
• Create a new workbook by using a user-defined template.
• Open a spreadsheet solutions template.
• Enter data in a list by using the data form.
• Sort a row in a list by using multiple columns.
• Sort a column in a list by using multiple rows.
• Create a custom sort order.
• Apply a custom filter to a list.
• Summarize data in a list by using subtotals.
Unit 2: Workbook Capabilities
2 - 3 hours
• Create a shared workbook.
• Highlight changes in a shared workbook.
• Accept a change in a shared workbook.
• Merge multiple workbooks.
• Create a workspace file.
Unit 3: Data Analysis and Automation
2 hours
• Import a delimited text file.
• Import data from a fixed-width text file.
• Import data from a database.
• Create an Extensible Markup Language (XML) query.
• Identify the features of the real-time data (RTD) function.
• Export data in text file format.
• Save a workbook in XML spreadsheet format.
• Create a PivotTable.
• Identify different formats to apply to a PivotTable report.
• Change the summary functions in a PivotTable.
• Hide data in a PivotTable.
• Manipulate a field in a PivotTable.
• Identify features of a PivotChart.
• Record a macro.
• Run a macro.
• Edit a macro.
• Assign a macro to a Custom Button.
• Create a scenario.
• View a scenario.
• Create a scenario report.
• Forecast using the Goal Seek command.
• Generate the optimal solution under set constraints by using Solver.
Testing Information
Tests are administered through
Microsoft
top
|
