Basic Excel Training Classes in Denver Colorado

Our basic Excel training class covers fundamental concepts in Microsoft Excel.  Get started on the right foot with essential skills for understanding and using Excel spreadsheets.

Training Class Goal

Students will exit this class with a basic knowledge of Microsoft Excel and confidence to build simple worksheets that use the basic functionality of the program.

Prerequisites

Ability to use a mouse (click, double-click, right-click, click-and-drag) and ability to type on a keyboard.

Excel Basic Training Topics

• Navigating to accomplish tasks
  • Using the Ribbon, Office Button, menus (depending on software version)
  • Cells, columns, and rows
  • Keyboard shortcuts
  • Freezing and splitting panes
  • Zooming
  • Hiding columns & rows
  • Other classes covering Excel navigation
• Entering basic data into Excel
  • Formatting dates and times
  • Spell check
  • Undo and redo buttons
  • Creating and modifying tables
  • Sorting and filtering tables
• Creating basic Excel formulas
  • Subtraction, division, multiplication
  • Cell references
  • Other classes covering Excel formulas
• Using functions
  • Manually typing functions
  • AutoSum and AutoCalculate
  • Other classes covering Excel functions
• Moving and copying data
  • Cut, copy & paste
  • Fill handle
  • AutoFill
  • Smart Tags
• Working with worksheets
  • Renaming and coloring tabs
  • Moving, copying, and inserting worksheets
• Basic Excel Formatting
  • Adjusting width & alignment
  • Formatting text in cells
  • Formatting numbers
  • Other classes covering Excel Formatting