• What is Excel?

• What you need to know?

• Tell me more.

• Test Me.

Excel 2000 Core

Working with Cells

• Use Undo and Redo
• Clear cell content
• Enter text, dates, and numbers
• Edit cell content
• Go to a specific cell
• Insert and delete selected cells
• Cut, copy, paste, paste special, and move selected cells
• Use the Office Clipboard
• Use Find and Replace
• Clear cell formats
• Work with series (AutoFill)
• Create hyperlinks

Working with Files

• Use Save
• Use Save As (different name, location, and format)
• Locate and open an existing workbook
• Create a folder
• Use templates to create a new workbook
• Save a worksheet/workbook as a Web Page
• Send a workbook via e-mail
• Use the Microsoft Office Assistant

Formatting Worksheets

• Apply font styles (typeface, size, color, and styles)
• Apply number formats (currency, percent, dates, and commas)
• Modify row and column size
• Modify alignment of cell content
• Adjust decimal places
• Use the Format Painter
• Apply autoformat
• Apply cell borders and shading
• Merge cells
• Rotate text and change indents
• Define, apply, and remove a style

Page Setup and Printing

• Preview and print worksheets and workbooks
• Use Web Page Preview
• Print a selection
• Change page orientation and scaling
• Set page margins and centering
• Insert and remove a page break
• Set print, and clear a print area
• Set up headers and footers
• Set print titles and options (gridlines, print quality, and headings for rows and columns)

Working with Worksheets and Workbooks

• Insert and delete rows and columns
• Hide and unhide rows and columns
• Freeze and unfreeze rows and columns
• Change the zoom setting
• Move between worksheets in a workbook
• Check spelling
• Rename a worksheet
• Insert and delete worksheets
• Move and copy worksheets
• Link worksheets and consolidate data using 3-D references

Working with Formulas and Functions

• Enter a range within a formula in a drag-and-drop operation
• Enter formulas in a cell and use the formula bar
• Revise formulas
• Use references (absolute and relative)
• Use AutoSum
• Use the Paste Function to insert a function
• Use basic functions (AVERAGE, SUM, COUNT, MIN, and MAX)
• Enter functions using the Formula Palette
• Use date functions (NOW and DATE)
• Use financial functions (FV and PMT)
• Use logical functions (IF)

Using Charts and Objects

• Preview and print charts
• Use the Chart Wizard to create a chart
• Modify charts
• Insert, move, and delete an object (graphic)
• Create and modify lines and objects

Excel 2000 Expert

Importing and Exporting Data

• Import data from text files (insert, drag-and-drop) operations
• Import from other applications
• Import a table from an HTML file (insert and drag and drop operations, including HTML round tripping)
• Export to other applications

Using Templates

• Apply templates
• Edit templates
• Create templates

Using Multiple Workbooks

• Use a workspace
• Link workbooks

Formatting Numbers

• Apply number formats (accounting, currency, and number)
• Create custom number formats
• Use conditional formatting

Printing Workbooks

• Print and preview multiple worksheets
• Use the Report Manager

Working with Named Ranges

• Add and delete a named range
• Use a named range in a formula
• Use Lookup Functions (Hlookup or Vlookup)

Working with Toolbars

• Hide and display toolbars
• Customize a toolbar
• Assign a macro to a command button

Using Macros

• Record macros
• Run macros
• Edit macros

Auditing a Worksheet

• Work with the Auditing Toolbar
• Trace errors (find and fix errors)
• Trace precedents (find cells referred to in a specific formula)
• Trace dependents (find formulas that refer to a specific cell)

Displaying and Formatting Data

• Apply conditional formats
• Perform single and multilevel sorts
• Use grouping and outlines
• Use data forms
• Use subtotaling
• Apply data filters
• Extract data
• Query databases
• Use data validation

Using Analysis Tools

• Use the Microsoft PivotTable® autoformat
• Use Goal Seek
• Create Microsoft PivotChart® reports
• Work with Scenarios
• Use Solver
• Use data analysis and PivotTable
• Create interactive tables for the Web with PivotTable
• Add fields to a table using the Web browser

Collaborating with Workgroups

• Create, edit, and remove a comment
• Apply and remove worksheet and workbook protection
• Change workbook properties
• Apply and remove file passwords
• Track changes (highlight, accept, and reject)
• Create a shared workbook
• Merge workbooks