Excel — Beginning Level Seminar

Full Day

In this course you will learn how to create a basic worksheet, perform calculations, modify a worksheet and print workbook contents.

Creating a Basic Worksheet

  • Explore the user Interface and the Ribbon
  • Navigate and Select in Excel
  • Obtain Help
  • Enter Data and Save a Workbook
  • Customize the Quick Access Toolbar

Performing Calculations

  • Create Basic Formulas
  • Calculate with Functions
  • Copy Formulas and Functions

Modifying a Worksheet

  • Manipulate Data
  • Insert and Delete Cells, Columns, and Rows
  • Search for Data in a Worksheet
  • Spell Check a Worksheet

Formatting a Worksheet

  • Modify Fonts
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Apply Number Formats
  • Position Cell Contents
  • Apply Cell Styles

Printing Workbook Contents

  • Print Workbook Contents Using Default Print Options
  • Set Print Options
  • Set Page Breaks

Managing Large Workbooks

  • Format Worksheet Tabs
  • Manage Worksheets in a Workbook
  • Manage the View of Large Worksheets