General Information

Course Duration: 4 hours

Audience: First-time users of Excel ; those aiming to become certified as Proficient Users of Excel

Prerequisites: Basic familiarity with the Windows 98, 2000 or XP user environments

Topics Covered

• Starting Excel

• Worksheets and workbooks

• Hands-on: Saving a workbook

• Previewing and printing

• Hands-on: Printing a worksheet

• The Help facility

• Entering and changing data

• Hands-on: Entering data

• Working with rows and columns

• Hands-on: Inserting a column

• Copying and moving data

• Hands-on: Copying a column

• Adjusting column widths and row heights

• Formatting numbers

• Hands-on: Formatting numbers

• Formatting text

• Hands-on: Formatting text

• Creating formulas

• Hands-on: Entering a formula

• Automatic features and filling formulas

• Hands-on: Using AutoSum

• Date formulas

• Hands-on: Using a date formula

Course Aim

To familiarize users with the Excel environment and to enable them to perform basic spreadsheet operations

Learning Objectives

General Information

Course Duration: 5 hours

Audience: First-time users of Excel; those aiming to become certified as Proficient Users of Excel

 

Prerequisites: Basic familiarity with the Windows 98, 2000 or XP user environments and thorough understanding of the content of the preceding course Microsoft Office: Beginning Excel

Topics Covered

• Using ranges

• Defining names

• Hands-on: Naming a range

• Using functions

• Hands-on: Using the Max functions

• Sorting

• Hands-on: Sorting data

• Chart basics

• Modifying charts

• Hands-on: Changing a chart type

• Formatting and printing charts

• Hands-on: Formatting a chart

• Working with maps

• Creating lines and objects

• Hands-on: Annotating a chart

• Creating 3-D shapes

• Hands-on: Changing a 3-D shape

• Customizing toolbars

• Hands-on: Removing a toolbar

• Using styles

• Customizing headers and footers

• Hands-on: Customizing a header

• Navigating the Internet

• Creating an HTML spreadsheet

• Hands-on: Saving an HTML spreadsheet

• Using hyperlinks

• Hands-on: Creating a hyperlink

Course Aim

To equip users with the knowledge and skills required to accomplish common Excel  tasks efficiently, and to prepare users for certification as Proficient Users of Excel 

Learning Objectives

General Information

Course Duration: 3 hours

Audience: Users already proficient in the use of Excel; users aiming for Expert User certification

Prerequisites: Proficiency in the use of Excel and comprehensive understanding of all the topics covered in the preceding course Microsoft Office: Intermediate Excel

Topics Covered

• Using templates

• Hands-on: Creating a template

• Group editing

• Hands-on: Editing a group

• Editing shared workbooks

• Hands-on: Sharing a workbook

• Protecting worksheets

• Hands-on: Protecting a worksheet

• Protecting workbooks

• Tracing dependents

• Hands-on: Tracing dependents

• Tracing and correcting precedents

• Hands-on: Precedents

• Creating and modifying outlines

• Consolidating data

• Hands-on: Consolidating data

• Managing large sheets

• Filters

• Pivot Tables

Course Aim

To prepare users to maximize their usage of all Excel 's functionality, and to partially prepare users for certification as Expert Users of Excel

Learning Objectives