Course
Length: One Day
Fees: Training at Client Offices: One delegate: £395 per-day + VAT
Additional delegates attending: £75 each per-day + VAT
Overview: Excel 2002
includes an assortment of new features. When upgrading from Excel 97 or 2000,
the first feature you notice is the new interface. The Excel 2002 interface has
a new look and feel. By default, the Standard and Formatting toolbar share a
single row, with only the most commonly used buttons on each toolbar displayed.
Menus appear in both short and full versions. Excel 2002 toolbars and menus
adapt to your usage; frequently used menu items and buttons become readily
available. To the right of the worksheet area is the task pane. The New Workbook
task pane provides links for opening new or existing workbooks.Excel 2002 now includes an
Office Clipboard that can hold multiple items. You no longer
have to complete the copy and paste operation before copying
another item.
When working with multiple
workbooks, the taskbar displays a button for each open workbook,
simplifying the task of switching between open workbooks.
Excel 2002 has added several
features that make it easier to work with formulas and
functions. The AutoSum button now provides a list with the most
commonly used functions, such as Average, Max, and Min.
Inserting and editing functions has become a much more intuitive
process. The Evaluate Formula tool lets you observe the
expressions in a formula before and after they are calculated,
and the Watch Window allows you to view a range of cells
containing formulas in one convenient location.
The Paste Options button
allows you to decide how formatting differences should be
applied to pasted cells. It also allows you to link pasted data
to its source cell. You can also use the Paste list to select
other options for pasting text and formulas.
New graphical enhancements
allow you to insert and format preset diagrams into a worksheet.
The Insert Clip Art task pane provides numerous categories of
clip art and AutoShapes that can also be inserted into a
worksheet.
Increased Web features have
been added to Excel 2002. You can easily preview how a worksheet
will appear on the Web. The procedures to create and edit
hyperlinks and to publish a workbook as a Web page have been
enhanced.
Excel 2002 now provides many
new features for reviewing and sharing workbooks. Additionally,
you can easily import and export data from other applications or
from a Web page. New PivotTable features include creating
PivotTable reports by dragging fields into a blank PivotTable
report, hiding field items, creating PivotChart reports, and
creating interactive PivotTable lists for the Web.
This course is for those already familiar with Microsoft Excel
and wish to learn about, and how to use the new features.
Getting Started
 | Creating a PivotTable Report |
| Adding PivotTable Report Fields |
| Selecting a Page Field Item |
| Adding New Fields to a PivotTable Report |
| Hiding and Unhiding Items |
| Creating a Page Field Report |
| Formatting a PivotTable Report |
| Creating a PivotChart Report |
| Creating a PivotTable List for the Web |
| Adding Fields in a Browser |
| Using a PivotTable List in a Browser |
