Excel 2002 Getting Started

Objective:
Learn the terminology and capabilities of Excel 2002. Understand how Excel can facilitate effective data manipulation and presentation.

Prerequisite Skills:
Comfortable with the Windows environment.

Course Description:
Do you want to learn the basics of using an electronic spreadsheet? Do you want to learn to input data and add rows and columns? Do you want to do simple calculations? Do you want to be able to create, edit, print, save, and open spreadsheets?

Attend this course if you want to:

• Understand how Excel can save you time.
• Understand Excel terminology.
• Move around in an Excel worksheet.
• Enter information into cells.
• Insert/delete rows and columns.
• Perform calculations.
• Automatically sum a range of cells.
• Open, save, and close workbooks.
• Create a new workbook.
• Print a worksheet.
• Sort information alphabetically or numerically.
• Move and copy data.
• Undo an action.
• Zoom in on worksheet data.
• Use on-line Help to quickly answer your Excel questions.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Excel 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Excel 2002 Functions & Formulas

Objective:
Learn the fundamentals of creating and working with formulas and functions. Start by building a simple formula and move to more advanced functions such as IF statements and 3-D references.

Prerequisite Skills:
Comfortable with basic Excel capabilities.
(Suggested Course: Excel 2002 Getting Started)

Course Description:
Do you want to perform calculations in your Excel spreadsheets? Do you want to use any of the 300+ built-in Excel functions? Do you want to learn how to efficiently create worksheets that update automatically?

Attend this course if you want to:

• Learn how to use cell references.
• Create and/or edit a formula.
• Use a built-in function.
• Use the AutoSum button to automatically sum data.
• Use AutoSum to create a grand total by summing subtotals.
• Use ScreenTips to enter function arguments.
• Copy formulas to other cells.
• Understand the difference and implications of relative and absolute references.
• Create logical (if/then) statements.
• Create formulas that span across multiple workbook pages.
• Use column headings in formulas.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Excel 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Excel 2002 Formatting Spreadsheets

Objective:
Learn the formatting techniques necessary to enhance the way data displays on a worksheet and in print.

Prerequisite Skills:
Comfortable with general Excel capabilities. Familiarity with basic functions and formulas is helpful, though not required.
(Suggested Course: Excel 2002 Getting Started and Excel 2002 Functions & Formulas)

Course Description:
Do you want your worksheets to look more professional? Do you want to call special attention to certain areas of your spreadsheet?

Attend this course if you want to:

• Change column width and row height.
• Adjust the position of contents within a cell.
• Make text display vertically or at an angle, rather than horizontally.
• Enhance your worksheet with borders and shading.
• Change the font including type, size, and color.
• Copy formatting from one area to another.
• Format numbers with percent symbols, commas, and dollar signs.
• Adjust date and numeric formats.
• Conditionally format data to automatically apply different formatting to cells that meet specific criteria.
• Use ready-made formats to enhance your spreadsheets.
• Automatically correct spelling errors.
• Hide or display gridlines.
• Change the page orientation.
• Force the worksheet to fit on a specific number of pages.
• Center the worksheet on the page.
• Add headers and footers to display when you print the worksheet.
• Preview the worksheet in final form before printing and, if necessary, adjust page breaks.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Excel 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Excel 2002 Working with Workbooks

Objective:
Learn to organize your worksheets effectively by storing them in workbooks. Also learn to share data within a workbook, from workbook to workbook, and with other users.

Prerequisite Skills:

• Comfortable with general Excel capabilities.
  (Suggested Course: Excel 2002 Getting Started)

• Comfortable with basic functions, formulas, and formatting in Excel.
  (Suggested Courses: Excel 2002 Functions & Formulas and Excel 2002 Formatting Spreadsheets)

Course Description:
Are you currently saving every Excel spreadsheet in a separate file? Did you know you can have multiple pages in a one Excel file called a "workbook?" Did you know you could create formulas that span multiple worksheets? Did you know you could share workbooks with other users?

Attend this course if you want to:

• Learn how to keep related spreadsheets in one workbook file.
• Name worksheet pages for easy retrieval.
• Change the color of worksheet tabs.
• Insert, delete, and move worksheets to where you want them.
• Change the default number of worksheets in new workbooks.
• Copy a worksheet within a workbook or to another workbook (to use as a template for new data).
• Group worksheets and simultaneously edit or format the data on all the worksheets at the same time.
• Create formulas that span multiple worksheets.
• Hide worksheets to reduce the number of worksheet tabs and prevent undesired viewing.
• Print workbooks or selected sheets within the workbook.
• Share workbooks with other users for simultaneous updates.
• Assign a password to prevent reading and/or editing the workbook.
• Protect specific cells in a worksheet so they can't be modified until unprotected.
• Hide formulas from others using the workbook.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Excel 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Excel 2002 Creating Charts

Objective:
Learn to create several types of professional-looking charts. Identify chart objects and learn to modify, add, and format charts to enhance the presentation of your data.

Prerequisite Skills:
Comfortable with basic Excel capabilities.
(Suggested Course: Excel 2002 Getting Started)

Course Description:
Could your statistical information be presented more clearly in a graph or chart? Would a chart spice up an upcoming presentation? Would you like to clearly show comparisons such as forecasted to actual, last year to this year, etc.?

Attend this course if you want to:

• Take existing Excel data and display it as a chart directly in the worksheet or on a separate worksheet page.
• Move and size charts to display exactly as you want them.
• Select from several chart types to best present your data.
• Add titles and legends to your charts.
• Display a data table containing your raw data along with the chart.
• Format your charts by adding/customizing gridlines and trendlines.
• Add labels to your chart data.
• Create customized chart types and save them for future charts.
• Place two charts on top of one another to create an overlay or combination chart.
• Print charts.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Excel 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Excel 2002 Databases

Objective:
Learn to manage database files effectively with Excel. Learn database design and data entry techniques as well as procedures to sort, filter, subtotal, and validate data.

Prerequisite Skills:

• Comfortable with general Excel capabilities.
  (Suggested Course: Excel 2002 Getting Started)

• Comfortable with basic functions, formulas, and formatting in Excel.
  (Suggested Courses: Excel 2002 Functions & Formulas and Excel 2002 Formatting Spreadsheets)

Course Description:
Do you spend a lot of time searching for data in large spreadsheets? Would you like to perform database functions such as filtering, subtotaling, and sorting directly in your Excel spreadsheet? Would you like to enter your data into a form rather than directly into rows and columns? Would you like to set up an easy-to-use data input form to be used by non-Excel-experts?

Attend this course if you want to:

• Learn the "rules" of designing a database.
• Create a form for data input.
• Add, edit, and delete records in your database.
• Easily find records in the database.
• Freeze row or column titles so they don't disappear as you scroll.
• Sort data alphabetically or numerically.
• Filter data to display a subset of the data.
• Subtotal data in a list.
• Quickly display certain levels or sections of a database with an outline.
• Set up data validation criteria to prevent data entry errors.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Excel 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Excel 2002 Tips & Shortcuts

Objective:
Learn various tips and shortcuts that will make you more efficient when working with Excel.

Prerequisite Skills:
Comfortable with basic Excel capabilities.
(Suggested Course: Excel 2002 Getting Started)

Course Description:
Are you using the fastest methods to accomplish tasks in Excel 2002? Could you use some of Excel's advanced features to automate certain tasks? Would you like your spreadsheets to look more professional?

Attend this course if you want to:

• Save time by using Excel's shortcut menus.
• "Freeze" a portion of your worksheet so that it remains visible as you scroll.
• Split the screen to display non-adjacent areas of your worksheet simultaneously.
• Name a cell or range of cells that you use often.
• Add a "comment" to a cell to make a note to yourself or other users.
• Collapse dialog boxes to easily display and select worksheet data.
• "Float" menu options and formatting palettes for quick access to common tools.
• Use the AutoCalculate functions to quickly sum, average, or count.
• View the formulas in a worksheet, rather than formula results.
• Quickly enter a series of data (i.e. days of the week, years, numbers).
• Find and replace specific data in a worksheet.
• Learn how to enter fractions in a cell, display cell contents on more than one line, and enter the current date or time.
• Automatically sum the data in a column, row, or table.
• Use hyperlinks to jump to another cell, file, or Web page.
• Use Smart Tag Actions to send a message to a recent Outlook mail recipient or to find stock quotes and company information.
• Change the default location in which Excel files are stored.
• Recover worksheet data after a crash.
• Save multiple workbooks in a workspace.
• Discover several "solutions templates" available from Microsoft.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Excel 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Excel 2002 More Functions & Formulas

Objective:
Learn to use some of Excel's logical, text, lookup & reference, and date & time functions to process worksheet data more efficiently.

Prerequisite Skills:

• Comfortable with Excel and its formatting capabilities.
  (Suggested Courses: Excel 2002 Getting Started and Excel 2002 Formatting Spreadsheets)

• Comfortable with basic functions and formulas.
  (Suggested Course: Excel 2002 Functions & Formulas)

• Comfortable working with Excel worksheets and workbooks.
  (Suggested Course: Excel 2002 Working with Workbooks)

Course Description:
Do you need to do more advanced calculations? Do you want to learn to use more of the 300+ built-in Excel functions? This class covers four groups of common functions: logical functions, text functions, lookup and reference functions, and date and time functions.

Attend this course if you want to:

• Identify portions of an IF statement.
• Create a simple IF statement.
• Create a nested IF statement.
• Work with text functions.
• Eliminate extra spaces.
• Change text to proper case.
• Merge cells.
• Extract a portion of text from a field.
• Change a formula to a value.
• Separate text into columns.
• Look up and merge data.
• Work with Date & Time functions.
• Enter today’s date.
• Enter the current date & time.
• Extract a portion of a date.
• Enter formulas directly into cells.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Excel 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Excel 2002 Automating Tasks with Macros

Objective:
Learn to write macros to automate various Excel tasks.

Prerequisite Skills:

• Comfortable with Excel and its formatting capabilities.
  (Suggested Courses: Excel 2002 Getting Started and Excel 2002 Formatting Spreadsheets)

• Comfortable with basic functions and formulas.
  (Suggested Course: Excel 2002 Functions & Formulas)

• Comfortable working with Excel worksheets and workbooks.
  (Suggested Course: Excel 2002 Working with Workbooks)

Course Description:
Do you frequently perform the same tasks in Excel? Learn various ways to save time and steps by recording macros. This class covers recording and modifying macros, assigning a shortcut key, and creating macro buttons.

Attend this course if you want to:

• Learn various ways that macros can be used.
• Record a macro using the macro recorder.
• Run a macro from the menu or a shortcut key.
• View a macro.
• Modify a macro.
• Understand absolute vs. relative recording.
• Assign existing macros to shortcut keys.
• Make macros available to all workbooks.
• Create a macro button.
• Delete macros.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Excel 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Excel 2002 Analyzing & Summarizing Data with Pivot Tables

Objective:
Learn to analyze and summarize worksheet data using pivot tables and pivot charts.

Prerequisite Skills:

• Comfortable with Excel and its formatting capabilities.
  (Suggested Courses: Excel 2002 Getting Started and Excel 2002 Formatting Spreadsheets)

• Comfortable with basic functions and formulas.
  (Suggested Course: Excel 2002 Functions & Formulas)

• Comfortable working with Excel worksheets and workbooks.
  (Suggested Course: Excel 2002 Working with Workbooks)

Course Description:
Do you need to analyze data? Learn why and when you can use a pivot table or pivot chart to analyze and summarize data. This workout covers creating and modifying pivot tables, filtering and formatting data, customizing pivot table options, and creating pivot charts.

Attend this course if you want to:

• Learn why and when you might want to use a pivot table or pivot chart.
• Create a pivot table.
• Modify the pivot table.
• Filter data in a pivot table.
• Format data in a pivot table.
• Group pivot table items.
• Drill down to view details.
• Create calculated fields and items.
• Customize pivot table options.
• Create and modify a pivot chart.
• Save and work with a pivot table in HTML format.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Excel 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)