Microsoft Excel 2007

Help Center > Microsoft Excel 2007

About 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
last modified on 03/25/2008 11:25