Microsoft Excel (XP)

Help Center Microsoft Excel (XP)

About Excel

Microsoft Excel

Microsoft Excel is a spreadsheet program. It makes it easy to enter formulas and figures and have the entire sheet update instantly. You can also display the data you entered graphically, using the chart wizard. Excel's natural ability to display tables of data quickly is what sets it aside from the other products in Microsoft's Office Suite.

Spreadsheet Basics

  • Screen elements
  • Adding and renaming worksheets
  • The standard toolbar - opening, closing, saving, and more

Customizing Excel

  • Menus
  • Customizing toolbars
  • Recording a macro
  • Running a macro

Modifying A Worksheet

  • Moving through cells
  • Adding worksheets, rows, and columns
  • Resizing rows and columns
  • Selecting cells
  • Moving and copying cells
  • Freeze panes

Formatting Cells

  • Formatting toolbar
  • Formatting individual cells
  • Dates and times
  • Styles
  • Creating a new style
  • Format Painter
  • AutoFormat

Formulas and Functions

  • Formulas
  • Linking worksheets
  • Relative, absolute, and mixed referencing
  • Basic functions
  • Function Wizard
  • Autosum

Sorting and Filling

  • Basic ascending and descending sorts
  • Complex sorts
  • Autofill
  • Alternating text and numbers with Autofill
  • Autofilling functions

Charts

  • Chart Wizard
  • Resizing a chart
  • Moving a chart
  • Chart formatting toolbar
  • Copying a chart to Microsoft Word

Keyboard Shortcuts

  • Shortcut references
  • Finding shortcuts
Share this page Share