Microsoft
Excel 2000 gives you the comprehensive tools to create spreadsheets
and share them on the Web for universal viewing and collaboration.
You'll be able to easily analyze data with charts, Microsoft
PivotTable views and graphs. And, use automatic formatting
to create data-rich spreadsheets. Our dynamic video series
will show you how to utilize all of the tools contained within
the most popular spreadsheet program on the market!
Level
One:
What is
Microsoft Excel 2000
Navigation
Creating
a workbook
Using spreadsheets
and on-line help
Formatting
values and ranges
Opening
and modifying a workbook
Deleting
cell contents and worksheets
Revising
text and numbers
Sorting
data
Printing
workbooks
Printing
screens and ranges
Using drawing
tools, functions & charts
Inserting
and deleting rows/columns
Using and
creating templates
Level
Two:
Auto
and custom formatting
Creating
and working with formulas
Formula
order of operations
Copying
formulas using relative and absolute reference
Using
IF and nested IF functions
Working
with dates
Importing
data from other sources
Importing
lists
Level
Three:
Advanced
charts
Hyperlinks
and macros
Using filters
and sorts
Data analysis
Conditional
formatting and styles
Sharing
workbooks and workgroups
Functions
of sharing
Pivot tables
>>Meet
the Expert
Shawn Oliver is a training specialist for the entire Microsoft
Office family of products. He is an MCP, MCT and MOUS Certified
Instructor. Shawn's easy-to-understand format and straight-forward,
hands-on delivery make him one of the most effective technical
application trainers in the industry.
