Spreadsheet Basics

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

Customizing Excel

• Menus
• Customize 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
• Format Cells dialog box
• Dates and times
• Styles
• Style dialog box
• Create 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

Graphics

• Adding clip art
• Add an image from a file
• Editing a graphic
• AutoShapes

Charts

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

Page Properties

• Page breaks
• Page orientation
• Margins
• Headers, footers, and page numbers
• Print Preview
• Print

Printing

Keyboard Shortcuts