Course Name:
Course Name:
Microsoft Excel 2000 / 2003
Lesson 5 � Working With Excel
Lists
Introduction:
This course teaches you how to work with
lists in MS Excel. It is intended for those who already have a basic
understanding of how to use the most basic features of MS Excel (97-03).
We offer courses for first time users to advanced
users looking to get the most out of this powerful program. With a firm
understanding and skill using Microsoft Excel, you can improve the way you turn
data into information using powerful tools to analyze, communicate, and share
your results with others.
Topics for Discussion:
1. Elements
of an Excel list
2. Freeze
rows and columns
3. Change
zoom settings for displaying a worksheet
4. Find and
replace values in a worksheet
5. The Find
and Replace dialog box
6. Sort data
in a list using a single sort key and multiple sort keys.
7. Use a data
form to enter, search for, edit, and delete records
8. Filter
data in a list using AutoFilters
9. The
Conditional Formatting dialog box
10. Insert
subtotals into a list
11. Use the subtotals
outline view
12. Summarize
a list using a PivotTable and a PivotChart
13. An example
of a Pivot Table
14. Plan a
Pivot Table
15. A Pivot
Table plan
16. Sketch
your Pivot Table
17. Modify a
Pivot Table
18.
An example of a Pivot Chart
Pre-Requisites:
- �Lesson 1 - The Fundamentals� or equivalent knowledge from using MS
Excel.
- Any version of MS Excel from 2000-2003
Cost:
$50.00
References:
Course
material will be emailed at the time of the course.