Course Outline

• Getting Started with Excel

  • Navigate the Excel User Interface

  • Use Excel Commands

  • Create and Save a Basic Workbook

  • Navigate in Excel for the Web

  • Enter Cell Data

• Performing Calculations

  • Create Worksheet Formulas

  • Insert Functions

  • Reuse Formulas and Functions

• Modifying a Worksheet

  • Adjust Cells, Columns, and Rows

  • Search for and Replace Data

  • Use Proofing and Research Tools

• Formatting a Worksheet

  • Apply Text Formats

  • Apply Number Formats

  • Align Cell Contents

  • Apply Colors, Borders, and Styles

  • Apply Basic Conditional Formatting

• Printing Workbooks

  • Preview and Print a Workbook

  • Set Up the Page Layout

  • Configure Headers and Footers

• Managing Workbooks

  • Manage Worksheets

  • Manage Workbook and Worksheet Views

  • Manage Workbook Properties

Course Objectives

• Familiarize yourself with Excel's layout, its various parts, its commands, and its terminology.

• Outline Excel's abilities to quickly, efficiently, and accurately calculate data.

• Update worksheets without throwing away all of the valuable work you've already done.

• Format a worksheet and organize your data.

• Print workbooks.

• Manage the overall structure of your workbooks.