Class Outline

This one-day, instructor-led course provides the foundational skills to work in Microsoft® Excel comfortably and productively. After taking this course, you will be able to perform many foundational tasks like creating, formatting, and editing worksheets. You will be able to manipulate, protect and print data and use basic formulas and functions. These skills are a must for anyone who uses Excel in their job.

The training covers these topics:

Excel Basics

  • Opening Excel
  • Exploring the Excel Environment
  • Using the Microsoft Help Feature
  • Opening and Viewing a Workbook
  • Starting a New Worksheet and Entering Data
  • Saving a Workbook


  • Using Basic Formulas
  • Calculating Data
  • Using Basic Formulas
  • Updating Formula Results
  • Multiplying Cells
  • Adding More than Two Cells of Data
  • Dividing Cells
  • Calculating with Functions
  • Using other Functions
  • Using Relative Reference
  • Using Absolute Reference


  • Modifying Fonts
  • Adding Borders and Colors to Cells
  • Using the Format Painter
  • Formatting Totals and Percentages
  • Formatting Dates
  • Formatting Phone Numbers
  • Adjusting Cell Alignment
  • Using Cell Styles
  • Using Themes

Manipulating Data

  • Using Autofill
  • Cutting and Pasting Data
  • Copying and Pasting Data
  • Paste Transpose
  • Adding Rows and Columns
  • Deleting Rows and Columns

Protecting Data

  • Protecting the Worksheet
  • Protecting the Workbook

Basic Importing and Exporting

  • Importing a TXT file
  • Exporting to PDF
  • Exporting to CSV (Comma Separated Value)

Printing Options

  • Printing

Excel Keyboard Shortcuts