Excel 2003

Excel 2003: Working with Existing Workbooks
Excel 2003: Writing Formulas
Excel 2003: Analysing and Managing Data
Excel 2003: Formatting Excel
Excel 2003: Collaborating with Workbooks
Excel 2003: Manipulating Workbooks

Click the Book an Online Course link on the left to enrol in a course.

Excel 2003: Working with Existing Workbooks

• Getting Started with Excel
  • An Overview of Excel
  • Navigate in Excel
  • Select Data
  • Enter Data
  • Save a Workbook
  • Obtain Help
• Modifying a Worksheet
  • Move and Copy Data Between Cells
  • Fill Cells with Series of Data
  • Edit Cell Data
  • Insert and Delete Cells, Columns, and Rows
  • Find, Replace, and Go To Cell Data
  • Spell Check a Worksheet
• Printing Workbook Contents
  • Set a Print Title
  • Create a Header and a Footer
  • Set Page Margins
  • Change Page Orientation
  • Insert and Remove Page Breaks
  • Print a Range

Excel 2003: Writing Formulas

• Performing Calculations
  • Create Basic Formulas
  • Calculate with Functions
  • Copy Formulas and Functions
  • Create an Absolute Reference
• Calculating with Advanced Formulas
  • Create and Apply a Name for a Range of Cells
  • Calculate Across Worksheets
  • Calculate with Date & Time Functions
  • Calculate with Financial Functions
  • Calculate with Statistical Functions
  • Calculate with Lookup and Reference Functions
  • Calculate with Logical Functions

Excel 2003: Analysing and Managing Data

• Creating and Modifying Charts
  • Create a Chart
  • Format Chart Items
  • Change the Chart Type
  • Create a Diagram
• Sorting and Filtering Data
  • Sort Data Lists
  • Filter Data Lists
  • Create and Apply Advanced Filters
  • Calculate with Database Functions
  • Add Subtotals to a Worksheet
• Using Excel with the Web
  • Export Excel Data
  • Publish a Worksheet to the Web
  • Import Data from the Web
  • Create a Web Query

Excel 2003: Formatting Excel

• Developing a Workbook
  • Format Worksheet Tabs
  • Reposition Worksheets in a Workbook
  • Insert and Delete Worksheets
  • Copy and Paste Worksheets
  • Copy a Workbook
• Formatting a Worksheet
  • Change Font Size and Type
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Merge Cells
  • Apply Number Formats
  • Create a Custom Number Format
  • Align Cell Contents
  • Find and Replace Formats
  • Apply an AutoFormat
  • Apply Styles
• Customizing Layout
  • Split a Worksheet
  • Arrange Worksheets
  • Freeze and Unfreeze Rows and Columns
  • Hide and Unhide Worksheets
• Creating and Applying Templates
  • Create a Workbook from a Template
  • Create a Custom Template
  • Working with Comments
  • Create a Hyperlink
  • Use Web-based Research Tools
• Working with Graphic Objects
  • Insert Graphics
  • Create AutoShapes
  • Format Graphic Objects
  • Change the Order of Graphic Objects
  • Group Graphic Objects
  • Move, Copy, and Resize Graphic Objects

Excel 2003: Collaborating with Workbooks

• Streamlining Workflow
  • Create a Macro
  • Edit a Macro
  • Customize Access to Excel Commands
  • Apply Conditional Formatting
  • Add Data Validation Criteria
  • Update a Workbook's Properties
  • Modify Excel's Default Settings
• Collaborating with Others
  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks
  • Adjust Macro Settings
  • Administer Digital Signatures
• Auditing Worksheets
  • Trace Cell Precedents
  • Trace Cell Dependents
  • Locate Errors in Formulas
  • Locate Invalid Data and Formulas
  • Watch and Evaluate Formulas
  • Group and Outline Data
• Analyzing Data
  • Create a Trendline
  • Create Scenarios
  • Perform What-If Analysis
  • Develop a PivotTable© Report
  • Develop a PivotChart© Report
  • Perform Statistical Analysis with the Analysis ToolPak

Excel 2003: Manipulating Workbooks

• Working with Multiple Workbooks
  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links
• Importing and Exporting Data
  • Export to Microsoft Word
  • Import a Word Table
  • Import Text Files
• Structuring XML Workbooks
  • Develop XML Maps
  • Import, Add, and Export XML Data
  • Manage XML Workbooks
  • Apply XML View Options