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.
