Excel 97 Overview

Objective:
Learn the terminology and capabilities of Excel 97. 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 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 - 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 97 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 97 Overview)

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.
• 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 - 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 97 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 97 Overview and Excel 97 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:

• 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.
• Align the contents of a cell.
• Make text display vertically rather than horizontally.
• Make columns wider or narrower and rows thinner or thicker.
• Adjust date and numeric formats.
• Create and apply styles to consistently format data.
• 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.
• 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 - 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 97 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 97 Overview)

• Comfortable with basic functions, formulas, and formatting in Excel.
  (Suggested Courses: Excel 97 Functions & Formulas and Excel 97 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.
• Insert, delete, and move worksheets to where you want them.
• Copy a worksheet within a workbook or to another workbook and use it 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.
• 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 - 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 97 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 97 Overview)

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 trend lines.
• 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 chart.

Class Length: 90 minutes

Delivery Options:

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

• 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 97 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 97 Overview)

• Comfortable with basic functions, formulas, and formatting in Excel.
  (Suggested Courses: Excel 97 Functions & Formulas and Excel 97 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 your 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 and create a chart based on the subtotals.
• 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 - 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 97 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 97 Overview)

Course Description:
Are you using the fastest methods to accomplish tasks in Excel 97? 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:

• Display non-adjacent areas of your worksheet by temporarily splitting the screen.
• Freeze a split so it displays each time you open a worksheet.
• 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.
• Save time by using Excel's shortcut menus.
• Use the AutoCalculate functions to quickly sum, average, or count.
• Save multiple workbooks in a workspace.
• Collapse dialog boxes to easily display and select worksheet data.
• Quickly enter a series of data (i.e. days of the week, years, numbers).
• Change the default location in which Excel files are stored.
• Create and use hyperlinks to easily go to other cells or worksheets.
• Learn tips to quickly enter data.
• Learn tips to quickly sum data.
• Discover several "solutions templates" available from Microsoft.

Class Length: 90 minutes

Delivery Options:

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

• 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 97 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 97 Overview and Excel 97 Formatting Spreadsheets)

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

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

Course Description:
Are you ready to move beyond basic formulas? This class includes how to create formulas with multiple conditions, create and nest IF statements, look up and merge data from one worksheet to another, and work with 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.
• Lookup 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 - 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 97 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 97 Overview and Excel 97 Formatting Spreadsheets)

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

• Comfortable working with Excel worksheets and workbooks.
  (Suggested Course: Excel 97 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 - 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 97 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 97 Overview and Excel 97 Formatting Spreadsheets)

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

• Comfortable working with Excel worksheets and workbooks.
  (Suggested Course: Excel 97 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.

Class Length: 90 minutes

Delivery Options:

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

• 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)