|
Screenbooks Table of Contents
Excel 2000
A Sample Application
Formatting
Using Formulas
More on Formulas
Filtering and Sorting
Pivot Tables
Excel Basics
Start Excel
Creating a File in Excel
Saving a File
Open a Workbook
Finding a Work Book
Switching between WorkBooks
Email a Workbook
Edit or Delete Data
Move or Copy Data
Finding Data
Spelling Check in Excel
Inserting Rows or Columns
Deleting Rows or Columns
Hiding Columns
Naming Cells
Undo
Zooming In or Out
Splitting Worksheets
Entering a Formula
Entering Functions
Adding Numbers
Copying a Formula
Inserting a Worksheet
Switching between Worksheets
Renaming a Worksheet
Moving a Worksheet
Formatting
Changing Column Width or Row Height
Font Face and Size
Bold Italic or Underline
Colors
Cell Alignment
More on Cell Formatting
Number Formats
Data Formats
Adding Borders
Copy Formatting
Clear Formatting
Autoformat in Excel
Printing
Print Preview
Print
Page Orientation
More Print Options
Changing Margins
Page Breaks
Specifying Number of Pages
Add Page Labels
Adding a Header or Footer
Lists and Macros
Creating a List
Filtering Data in a list
Sorting Data in a list
Adding Subtotals to a List
Macros
Charts
Creating a Chart Part I
Creating a Chart Part II
Changing Chart Type
Moving Resizing or Deleting A chart
Adding Data to a Chart
Printing a Chart
|