About Excel

  • What is Excel?
<tool> A spreadsheet program from Microsoft, part of their Microsoft Office suite of productivity tools for Microsoft Windows and Macintosh. Excel is probably the most widely used spreadsheet in the world.
  • 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