Microsoft Excel 2003 Expert Curriculum Outline

Basic Features of Excel 2003

Overview/Description
To provide an overview of the basic features of Excel 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent

Prerequisites Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
3 Hours

Lesson Objectives:

Basic Features of Excel 2003

• Outline the basic features of a spreadsheet and identify the main interface and Help features of Excel 2003
• Create a workbook and navigate through the worksheets in it
• Enter data and text in a worksheet in Excel 2003
• Save a new workbook and distinguish between the different file formats used to save workbooks in Excel 2003
• Enter data in a workbook and save it
• Edit data and filter cells in an Excel 2003 worksheet
• Copy and move a cell and a range of cells in Excel 2003
• Insert, edit, copy, and move worksheets
• Insert a worksheet, move data between worksheets, and copy a worksheet to another workbook
• Add and modify data and a worksheet in Excel 2003

Back to List

Printing and Collaborating in Excel 2003

Overview/Description
To demonstrate how to format worksheets in Excel 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent

Prerequisites Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
2 Hours

Lesson Objectives:

Formatting Data in Excel 2003

• Apply and adapt a range of Excel cell formats
• Use visual design techniques to apply formatting to an Excel 2003 workbook
• Manipulate rows and columns in an Excel 2003 worksheet
• Apply various types of formatting to an Excel 2003 workbook
• Apply number formatting to cells in Excel 2003
• Apply a number format to cell content in Excel 2003
• Format text and cells and apply number formats to data in Excel 2003

Back to List

Excel 2003 Formulas and Functions

Overview/Description
To demonstrate the printing and collaboration features in Excel 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent

Prerequisites Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
3 Hours

Lesson Objectives:

Printing and Collaborating in Excel 2003

• Run a spell check, and use the previewing features in Excel 2003
• Adjust the Page Setup options and print a document in Excel 2003
• Use a range of printing option features in Excel 2003
• Adjust printing options and preview and print a document in Excel 2003
• Create and edit comments and send a workbook for review in Excel 2003
• Insert comments and send a workbook for review in Excel 2003

Back to List

Formatting Data in Excel 2003

Overview/Description
To provide an overview of the calculation features in Excel 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent

Prerequisites Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
2 Hours

Lesson Objectives:

Excel 2003 Formulas and Functions

• Use formulas to perform basic calculations in Excel 2003
• Create a formula in Excel 2003
• Use references and names in Excel 2003 formulas
• Enter a formula that uses cell references in Excel 2003
• Use functions to perform calculations in Excel 2003
• Use logical, financial, and date functions in Excel 2003
• Use the Insert Function feature to insert basic and advanced functions
• Use formulas and functions to perform calculations in Excel 2003

Back to List

Excel 2003 Chart and Multimedia Features

Overview/Description
To demonstrate the chart, graphical, and web features in Excel 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent

Prerequisites Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
3 Hours

Lesson Objectives:

Excel 2003 Chart and Multimedia Features

• Create charts to display data in Excel 2003
• Create a chart using the Chart wizard in Excel 2003
• Edit chart source data and change chart type in Excel 2003
• Format, move, and resize a chart in Excel 2003
• Change a data series and chart type in Excel 2003
• Insert graphics in Excel 2003
• Modify graphics in Excel 2003
• Insert a picture into an Excel 2003 worksheet
• Save a worksheet as a web page and work with hyperlinks in Excel 2003
• Create an HTML spreadsheet in Excel 2003

Back to List

Advanced Customization in Excel 2003

Overview/Description
To demonstrate how to customize Excel workbooks and the Excel 2003 application

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent

Prerequisites Familiarity with the Windows 2000 or XP user environments

Expected Duration
2.75 Hours

Lesson Objectives:

Advanced Customization in Excel 2003

• Create and customize templates in Excel 2003
• Create and apply styles in Excel 2003
• Create styles and templates in Excel 2003
• Customize Excel 2003 workbooks by changing their settings and properties
• Use macros in Excel 2003
• Customize an Excel 2003 toolbar
• Record a macro and assign it to a custom button in Excel 2003
• Customize a document using templates, formatting, and macros in Excel 2003

Back to List

Advanced formatting in Excel 2003

Overview/Description
To demonstrate how to apply advanced formatting in Excel 2003

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent

Prerequisites Familiarity with the Windows 2000 or XP user environments

Expected Duration
2 Hours

Lesson Objectives:

Advanced formatting in Excel 2003

• Create and use advanced number formats in Excel 2003
• Apply advanced custom number formats in Excel 2003
• Create and apply custom number formats in Excel 2003
• Apply conditional formatting to a worksheet in Excel 2003
• Create a conditional format and apply it to another cell in Excel 2003
• Apply advanced number and conditional formatting in Excel 2003

Back to List

Advanced Data Management in Excel 2003

Overview/Description
To provide an overview of the advanced data management and organizational features in Excel 2003

Target Audience
EEnd users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent

Prerequisites Familiarity with the Windows 2000 or XP user environments

Expected Duration
2.25 Hours

Lesson Objectives:

Advanced Data Management in Excel 2003

• Sort and filter data lists in Excel 2003
• Group and outline a data list in Excel 2003
• Subtotal data in Excel 2003
• Subtotal, filter, and group a data list in Excel 2003
• Use advanced mathematical, text, and database functions, and consolidate data in Excel 2003
• Use lookup functions in Excel 2003
• Use lookup, mathematical, and database functions in Excel 2003

Back to List

Advanced Data Analysis in Excel 2003

Overview/Description
To provide an overview of the advanced data manipulation and analysis features in Excel 2003

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent

Prerequisites Familiarity with the Windows 2000 or XP user environments

Expected Duration
3 Hours

Lesson Objectives:

Advanced Data Analysis in Excel 2003

• Create and modify PivotTable reports in Excel 2003
• Perform calculations on PivotTable reports in Excel 2003
• Create and modify a PivotTable report in Excel 2003
• Create and modify PivotChart reports in Excel 2003
• Create and edit a PivotChart report in Excel 2003
• Use the Goal Seek and Solver tools in Excel 2003
• Employ scenarios to analyze data in Excel 2003
• Create data tables and outline their uses in Excel 2003
• Use data-analysis tools in Excel 2003 to forecast values in a workbook

Back to List

Advanced Validation and Collaboration in Excel 2003

Overview/Description
To identify the advanced data validation and collaboration features in Excel 2003

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent

Prerequisites Familiarity with the Windows 2000 or XP user environments

Expected Duration
3 Hours

Lesson Objectives:

Advanced Validation and Collaboration in Excel 2003

• Validate data in Excel 2003
• Audit data in Excel 2003
• Validate data in an Excel worksheet
• Apply worksheet protection in Excel 2003
• Use passwords, encryption, and digital signatures to protect Excel 2003 workbooks
• Apply protection to a range, a worksheet, and a workbook in Excel 2003
• Share and merge workbooks in Excel 2003
• Track changes to data using a range of tools in Excel 2003
• Use Excel 2003 collaboration features to track changes and merge a workbook
• Apply data validation, protect, and share a workbook in Excel 2003

Back to List

Advanced Data Exchange in Excel 2003

Overview/Description
To describe how to use Excel 2003 to share data between people, applications, and on the Web

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent

Prerequisites Familiarity with the Windows 2000 or XP user environments

Expected Duration
4 Hours

Lesson Objectives:

Advanced Data Exchange in Excel 2003

• Link worksheets and workbooks and embed files in Excel 2003
• Link and embed data in a workbook in Excel 2003
• Import data from text files into an Excel 2003 workbook
• Create a query in Excel 2003
• Import data from Excel 2003 into other applications
• Import external data into Excel 2003 and import Excel data into another application
• Import data from the Web into Excel 2003
• Create a web query in Excel 2003
• Outline core XML concepts and work with XML files in Excel 2003
• Create an XML document in Excel 2003
• Create a simple XML document in Excel 2003

Back to List

Microsoft Word 2003 Expert Curriculum Outline

Getting Started with Word 2003

Overview/Description
To provide a basic introduction to Word 2003 and the features and tools used for creating and navigating documents in Word

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent

Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment

Expected Duration
1 Hour

Lesson Objectives:

Getting Started with Word 2003

• Perform the basic tasks necessary to start work in Word
• Identify the main features of the Word 2003 screen
• Use the Word navigation tools to search through documents
• Open Word, display a toolbar, and find text

Back to List

Working with text and paragraphs in Word 2003

Overview/Description
To provide an overview of the document formatting, navigation, and recovery features in Word 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent

Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment

Expected Duration
2 Hours

Lesson Objectives:

Working with Documents in Word 2003

• Insert headers, footers, and page numbers into a Word document
• Navigate Word documents using various views
• Use advanced navigation features
• Add a header and footer to a document and use the Reading Layout view
• Use document collaboration features in Word 2003
• Use the document recovery features in Word 2003
• Open and repair a corrupted document, merge two Word documents, and insert a comment

Back to List

Structuring, editing, saving, and opening documents in Word 2003

Overview/Description
To demonstrate how to structure, edit, save, and open documents in Word

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent

Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment

Expected Duration
2 Hours

Lesson Objectives:

Structuring, editing, saving, and opening documents in Word 2003

• Insert page and section breaks into a document
• Adjust the spacing and insert columns
• Correct and customize spelling and grammar, and use the Find and Replace tool in Word
• Correct a spelling error, adjust line and character spacing, and organize text into columns
• Save and open Word documents
• Save documents as web pages, text (TXT) files, or rich text format (RTF) files
• Save a Word document to a new folder, save a Word document as a web page, and modify the document saving options

Back to List

Printing, Help, and Automated Formatting in Word 2003

Overview/Description
To describe how to use the Print, Help, and automated formatting features in Word

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent

Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment

Expected Duration
3 Hours

Lesson Objectives:

Printing, Help, and Automated Formatting in Word 2003

• Use the Edit menu, the Office Clipboard, and the Show/Hide button to move, copy, and paste text
• Preview documents, run a word count, and print documents, envelopes, and labels in Word
• Use the Help and Research options in Word
• Use the Office Clipboard and Research task pane, modify the page setup, and print a document
• Use style options to format text
• Use the AutoCorrect features in Word to correct errors, configure Word to recognize common errors and exceptions, and automate the completion and formatting of text
• Use templates and wizards to create and format documents
• Apply, find, and modify styles, modify the AutoCorrect settings, and create a document from a template
• Create a formal letter in Word 2003 and save it to a specific folder

Back to List

Working with Documents in Word 2003

Overview/Description
To describe tables and media features in Word 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent

Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment

Expected Duration
2 Hours

Lesson Objectives:

Working with Tables and Media Features in Word 2003

• Create and format tables in Word
• Modify the structure of a table in Word 2003
• Work with data in tables and create a table style
• Create, format, and modify a table
• Create and format a table in Word 2003
• Add text effects, shapes, and shape effects to a document
• Insert WordArt and a shape into a document
• Insert and modify picture files, clip art, and diagrams in a document
• Insert a picture and diagram into a document
• Use Office 2003s speech recognition function
• Use the handwriting features in Word 2003

Back to List

Working with Tables and Media Features in Word 2003

Overview/Description
To describe tables and media features in Word 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent

Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment

Expected Duration
4 Hours

Lesson Objectives:

Working with Tables and Media Features in Word 2003

• Create and format tables in Word
• Modify the structure of a table in Word 2003
• Work with data in tables and create a table style
• Create, format, and modify a table
• Create and format a table in Word 2003
• Add text effects, shapes, and shape effects to a document
• Insert WordArt and a shape into a document
• Insert and modify picture files, clip art, and diagrams in a document
• Insert a picture and diagram into a document
• Use Office 2003s speech recognition function
• Use the handwriting features in Word 2003

Back to List

Advanced Formatting in Word 2003

Overview/Description
To provide a detailed overview of the advanced page formatting features in Word 2003

Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent

Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
2 Hours

Lesson Objectives:

Advanced Formatting in Word 2003

• Use the advanced page formatting options in Word 2003
• Create and modify styles in Word 2003
• Apply themes and backgrounds and read document statistics in Word 2003 documents
• Apply page borders and themes and modify styles in a Word 2003 document
• Use footnotes and endnotes in Word 2003
• Create and revise endnotes using Word 2003

Back to List

Advanced Document Navigation in Word 2003

Overview/Description
To demonstrate the advanced document navigation features in Word 2003

Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent

Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
1 Hour

Lesson Objectives:

Advanced Document Navigation in Word 2003

• Use tables of contents in Word 2003
• Use hyperlinks, bookmarks, and frames in Word 2003
• Create indexes and cross-references in Word 2003
• Use advanced document navigation features in Word 2003

Back to List

Advanced Data Manipulation Features in Word 2003

Overview/Description
To provide a detailed overview of the tools available for advanced data manipulation in Word 2003

Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent

Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
2 Hours

Lesson Objectives:

Advanced Data Manipulation Features in Word 2003

• Use forms in Word 2003
• Use fields in Word 2003
• Insert a field into a form and into a standard Word 2003 document, and configure print options for fields
• Use mail merge in Word 2003
• Use advanced mail merge options in Word 2003
• Create and manipulate mail merge data in Word 2003

Back to List

Using Tables, Charts, and Graphs in Word 2003

Overview/Description
To provide a detailed overview of using tables, charts, and graphics

Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent

Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
2 Hours

Lesson Objectives:

Using Tables, Charts, and Graphics in Word 2003

• Create Word 2003 tables from Excel data
• Insert and use charts in Word 2003
• Insert Excel worksheets and charts in Word 2003
• Insert and use graphics in Word 2003
• Format drawings and insert picture watermarks in Word 2003

Back to List

Advanced Document Features in Word 2003

Overview/Description
To provide a detailed overview of the advanced document features available for use in Word 2003

Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent

Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
2 Hours

Lesson Objectives:

Advanced Document Features in Word 2003

• Create, edit, and use macros in Word 2003
• Customize toolbars and menus in Word 2003
• Create and record a macro in Word 2003
• Create a custom toolbar and menu in Word 2003
• Use master documents and subdocuments in Word 2003
• Modify and manage master documents in Word 2003
• Work with master documents in Word 2003

Back to List

Collaborative Features in Word 2003

Overview/Description
To provide a detailed overview of the collaborative features in Word 2003

Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent

Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
4 Hours

Lesson Objectives:

Collaborative Features in Word 2003

• Share documents and create document versions in Word 2003
• Configure security settings for a document in Word 2003
• Manage document versions and apply editing and style restrictions in Word 2003
• Use shared workspaces to collaborate in Word 2003
• Use a shared workspace to manage shared documents in Word 2003
• Work with document versions in Word 2003
• Use HTML in Word 2003 to create, modify, and optimize web pages
• Work with XML files in Word 2003 and recognize the function of smart documents
• Work with web pages and XML files in Word 2003
• Use the Track Changes feature and work with changes from multiple reviewers
• Review documents that have been edited by several users and send documents for review by e-mail

Back to List