Microsoft Excel 2003 Level 2

1 Day

Description

In Microsoft Office Excel Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft® Excel to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Upon successful completion of this course, students will be able to:

  • create and apply templates.
  • create and modify charts.
  • work with graphic objects.
  • calculate with advanced formulas.
  • sort and filter data.
  • use Excel with the Web.

Course Objective: You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Target Student: The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel, Excel 2000, Excel XP or Excel 2003 on the Web. In addition, this course helps prepare students who desire to prepare for the Microsoft Office Specialist exam in Excel or Module 2 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

Certification: This course is one of a series of Knowledge Transfer courses that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsofts business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification. To learn more about the Microsoft Office Specialist Program visit our certifications section.

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Microsoft Excel 2003 Level 2 class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

Managing Workbooks and Preparing Them for the Web

  • Freezing Columns and Preparing Them for the Web
  • Inserting and Deleting Worksheets
  • Consolidating Data with 3-D References
  • Hiding and Protecting Worksheet Areas
  • Saving Custom Views of a Worksheet
  • Controlling Page Breaks and Page Numbering
  • Creating a Hyperlink Between Excel Files
  • Saving an Excel File as a Web Page

Automating Worksheet Tasks

  • Planning a Macro
  • Recording a Marco
  • Running a Macro
  • Editing a Macro
  • Using Shortcut Keys with Macros
  • Using the Personal Macro Workbook
  • Adding a Macro as a Menu Item
  • Creating a Toolbar for Macros

Using Lists

  • Planning a List
  • Creating a List
  • Adding Records with the Data Form
  • Finding Records
  • Deleting Records
  • Sorting a List on One Field
  • Sorting a List on Multiple Fields
  • Printing a List

Using Lists

  • Retrieve Records with AutoFilter
  • Create a Custom Filter
  • Filter a List with the Advanced Filter
  • Extract List Data
  • Create Subtotals Using Grouping and Outlines
  • Look up Values in a List
  • Summarize List Data
  • Use Data Validation for List Entries

Enhancing Charts and Worksheets

  • Select a Custom Chart Type
  • Customize a Data Series
  • Format a Chart Axis
  • Add a Data Table to a Chart
  • Rotate a Chart
  • Enhance a Chart with WordArt
  • Rotate Text
  • Add a Picture to a Chart

Sharing Excel Files and Incorporating Web Information

  • Sharing Excel Files
  • Setting up a Shared Workbook for Multiple Users
  • Tracking Revisions in a Shared Workbook
  • Applying and Modifying Passwords
  • Creating an Interactive Worksheet for the Web
  • Creating a PivotTable List for the Web
  • Working with XML Data
  • Running Web Queries to Retrieve External Data

 

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Microsoft Excel 2003 Level 2 class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Microsoft® Excel. Students can obtain this level of skill by taking the following course:

In addition, Web browsing experience is strongly recommended.

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Microsoft Excel 2003 Level 2 class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Comments

PLEASE CONTACT US TO REQUEST A CLASS DATE.

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Microsoft Excel 2003 Level 2 class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date