-
Ziele
- 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.
-
Anforderungen
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.
-
Titel
Kurs 74031 - Microsoft Excel 2002 Proficient User
-
Inhalt
Course Overview
This 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.
Deployment Options
Self-Study
Total Learning Time
6 to 8 hours
Objectives
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.
Course Access
Each student has access to the course for a period of 6 months from the day of enrollment in the course.
