Power Session Outlines
Microsoft Excel 2000
All courses below
are 90 Minute Workouts®. Click a course title for a complete
outline. (Note: Excel 97 and 2002 courses are also available.)
Objective:
Learn the terminology and capabilities of Excel 2000. 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.
Objective:
Learn features new to Excel 97 and 2000.
Prerequisite
Skills:
- Comfortable
with the Windows environment.
- Comfortable
with Microsoft Excel 5.0
Course
Description:
Have you recently upgraded from Excel 95 to Excel 97 or 2000? This course covers
the most significant changes in Excel 97 and 2000, with an emphasis on the
features of Excel 2000.
Attend this
course if you want to:
- Learn about
Excel 2000's "adaptive" menus and toolbars.
- Learn to use
the Office Assistant and to access Help.
- Understand the
new components of the Open and Save As dialog boxes.
- Use the Office
2000 Clipboard to copy and paste multiple items.
- Make
formatting changes in a worksheet.
- Use
conditional formatting.
- Automate tasks
using AutoCalculate, AutoCorrect, and AutoComplete.
- Use range
references in dialog boxes.
- Use data
validation tools to ensure users enter appropriate data.
- Preview and
adjust page breaks in a spreadsheet.
- Create and use
hyperlinks in Excel spreadsheets.
- Work with cell
comments.
Excel 2000 Formatting
Spreadsheets
Objective:
Learn the formatting techniques necessary to enhance the way data displays on a
worksheet and in print.
Prerequisite
Skills:
Comfortable with basic Excel capabilities.
(Suggested Course: Excel 2000 Overview)
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.
Excel 2000 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 2000 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.
Excel 2000
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:
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.
Excel 2000
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 2000 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.
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:
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.
Excel 2000 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 2000 Overview)
Course
Description:
Are you using the fastest methods to accomplish tasks in Excel 2000? 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.
Excel 2000 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:
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.
- 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.
Excel 2000
Automating Tasks with Macros
Objective:
Learn to write macros to automate various Excel tasks.
Prerequisite
Skills:
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.
Excel
2000 Analyzing & Summarizing Data with Pivot Tables
Objective:
Learn to analyze and summarize worksheet data using pivot tables and pivot
charts.
Prerequisite
Skills:
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.
| 