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.

Students will learn to build basic formulas and will start using common functions. The class also covers navigating, formatting, and printing.

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, and menus (depending on software version)
  • Cells, columns, and rows
  • Keyboard shortcuts
  • Freezing and splitting panes
  • Zooming
  • Hiding columns and 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 and alignment
  • Formatting text in cells
  • Formatting numbers
  • Other classes covering Excel Formatting