Excel Intermediate

Course Description

excel_tipAre you new to Excel? This class is designed for students who need Excel training for beginners. This course will teach you how to get started on the right foot with essential skills for using Excel spreadsheets. You will learn how navigate within Excel, easily enter information into spreadsheets, learn tricks to best view and manipulate data, format data, and you will even learn how to create simple formulas. With basic Excel training, you will learn how to work in pre-created spreadsheets as well as create your own simple spreadsheets from scratch.

Training Class Goal

In this Basic Excel training, students will exit this class with a basic knowledge of Microsoft Excel and have the confidence to build simple worksheets that use the basic functionality of the program. You will understand how Excel works and functions to give you the foundation from which to grow from.

PreRequisites

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

Topics Covered

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
  • Flash Fill
  • Smart Tags

Organizing and Working with Multiple worksheets

  • Renaming and coloring tabs
  • Moving, copying, and inserting worksheets
  • Margins
  • Headers and Footers
  • Printing Options

Basic Excel Formatting

  • Adjusting width and alignment
  • Formatting text in cells
  • Wrapping and merging
  • Formatting numbers
  • Other classes covering Excel Formatting

The Intermediate Excel training covers things beyond the basics, to give you more confidence in building your spreadsheets and creating formulas to automate them.

Upcoming Classes

Excel Intermediate
Dec 19 1:00 pm - 5:00 pm Excel Intermediate Westminster Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 19-12-2018T13:00 19-12-2018T17:00 Active
Active 19-12-2018 Active 235.00 19-12-2018
Register Now
Excel Intermediate
Jan 7 1:00 pm - 5:00 pm Excel Intermediate Tech Center Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 07-01-2019T13:00 07-01-2019T17:00 Active
Active 07-01-2019 Active 250.00 07-01-2019
Register Now
Excel Intermediate
Jan 8 1:00 pm - 5:00 pm Excel Intermediate Phoenix Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 08-01-2019T13:00 08-01-2019T17:00 Active
Active 08-01-2019 Active 250.00 08-01-2019
Register Now
Excel Intermediate
Jan 23 1:00 pm - 5:00 pm Excel Intermediate Westminster Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 23-01-2019T13:00 23-01-2019T17:00 Active
Active 23-01-2019 Active 250.00 23-01-2019
Register Now
Excel Intermediate
Feb 6 8:00 am - 12:00 pm Excel Intermediate Tech Center Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 06-02-2019T08:00 06-02-2019T12:00 Active
Active 06-02-2019 Active 250.00 06-02-2019
Register Now
Excel Intermediate
Feb 12 8:00 am - 12:00 pm Excel Intermediate Phoenix Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 12-02-2019T08:00 12-02-2019T12:00 Active
Active 12-02-2019 Active 250.00 12-02-2019
Register Now
Excel Intermediate
Feb 20 8:00 am - 12:00 pm Excel Intermediate Westminster Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 20-02-2019T08:00 20-02-2019T12:00 Active
Active 20-02-2019 Active 250.00 20-02-2019
Register Now
Excel Intermediate
Mar 6 1:00 pm - 5:00 pm Excel Intermediate Tech Center Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 06-03-2019T13:00 06-03-2019T17:00 Active
Active 06-03-2019 Active 250.00 06-03-2019
Register Now
Excel Intermediate
Mar 18 1:00 pm - 5:00 pm Excel Intermediate Phoenix Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 18-03-2019T13:00 18-03-2019T17:00 Active
Active 18-03-2019 Active 250.00 18-03-2019
Register Now
Excel Intermediate
Mar 18 1:00 pm - 5:00 pm Excel Intermediate Westminster Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 18-03-2019T13:00 18-03-2019T17:00 Active
Active 18-03-2019 Active 250.00 18-03-2019
Register Now
Excel Intermediate
Apr 1 1:00 pm - 5:00 pm Excel Intermediate Tech Center Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 01-04-2019T13:00 01-04-2019T17:00 Active
Active 01-04-2019 Active 250.00 01-04-2019
Register Now
Excel Intermediate
Apr 17 8:00 am - 12:00 pm Excel Intermediate Westminster Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 17-04-2019T08:00 17-04-2019T12:00 Active
Active 17-04-2019 Active 250.00 17-04-2019
Register Now
Excel Intermediate
Apr 17 1:00 pm - 5:00 pm Excel Intermediate Phoenix Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 17-04-2019T13:00 17-04-2019T17:00 Active
Active 17-04-2019 Active 250.00 17-04-2019
Register Now
Excel Intermediate
May 1 8:00 am - 12:00 pm Excel Intermediate Tech Center Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 01-05-2019T08:00 01-05-2019T12:00 Active
Active 01-05-2019 Active 250.00 01-05-2019
Register Now
Excel Intermediate
May 14 8:00 am - 12:00 pm Excel Intermediate Westminster Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 14-05-2019T08:00 14-05-2019T12:00 Active
Active 14-05-2019 Active 250.00 14-05-2019
Register Now
Excel Intermediate
May 20 1:00 pm - 5:00 pm Excel Intermediate Phoenix Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 20-05-2019T13:00 20-05-2019T17:00 Active
Active 20-05-2019 Active 250.00 20-05-2019
Register Now
Excel Intermediate
Jun 3 1:00 pm - 5:00 pm Excel Intermediate Tech Center Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 03-06-2019T13:00 03-06-2019T17:00 Active
Active 03-06-2019 Active 250.00 03-06-2019
Register Now
Excel Intermediate
Jun 17 8:00 am - 12:00 pm Excel Intermediate Westminster Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 17-06-2019T08:00 17-06-2019T12:00 Active
Active 17-06-2019 Active 250.00 17-06-2019
Register Now
Excel Intermediate
Jun 24 1:00 pm - 5:00 pm Excel Intermediate Phoenix Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 24-06-2019T13:00 24-06-2019T17:00 Active
Active 24-06-2019 Active 250.00 24-06-2019
Register Now
Excel Intermediate
Jul 1 1:00 pm - 5:00 pm Excel Intermediate Tech Center Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 01-07-2019T13:00 01-07-2019T17:00 Active
Active 01-07-2019 Active 250.00 01-07-2019
Register Now
Excel Intermediate
Jul 16 1:00 pm - 5:00 pm Excel Intermediate Westminster Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 16-07-2019T13:00 16-07-2019T17:00 Active
Active 16-07-2019 Active 250.00 16-07-2019
Register Now
Excel Intermediate
Jul 22 1:00 pm - 5:00 pm Excel Intermediate Phoenix Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 22-07-2019T13:00 22-07-2019T17:00 Active
Active 22-07-2019 Active 250.00 22-07-2019
Register Now
Excel Intermediate
Jul 30 8:00 am - 12:00 pm Excel Intermediate Tech Center Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 30-07-2019T08:00 30-07-2019T12:00 Active
Active 30-07-2019 Active 250.00 30-07-2019
Register Now
Excel Intermediate
Aug 13 8:00 am - 12:00 pm Excel Intermediate Westminster Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 13-08-2019T08:00 13-08-2019T12:00 Active
Active 13-08-2019 Active 250.00 13-08-2019
Register Now
Excel Intermediate
Aug 20 8:00 am - 12:00 pm Excel Intermediate Phoenix Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 20-08-2019T08:00 20-08-2019T12:00 Active
Active 20-08-2019 Active 250.00 20-08-2019
Register Now
Excel Intermediate
Aug 27 1:00 pm - 5:00 pm Excel Intermediate Tech Center Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 27-08-2019T13:00 27-08-2019T17:00 Active
Active 27-08-2019 Active 250.00 27-08-2019
Register Now
Excel Intermediate
Sep 9 1:00 pm - 5:00 pm Excel Intermediate Westminster Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 09-09-2019T13:00 09-09-2019T17:00 Active
Active 09-09-2019 Active 250.00 09-09-2019
Register Now
Excel Intermediate
Sep 26 1:00 pm - 5:00 pm Excel Intermediate Phoenix Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 26-09-2019T13:00 26-09-2019T17:00 Active
Active 26-09-2019 Active 250.00 26-09-2019
Register Now
Excel Intermediate
Sep 27 8:00 am - 12:00 pm Excel Intermediate Tech Center Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 27-09-2019T08:00 27-09-2019T12:00 Active
Active 27-09-2019 Active 250.00 27-09-2019
Register Now
Excel Intermediate
Oct 7 1:00 pm - 5:00 pm Excel Intermediate Westminster Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 07-10-2019T13:00 07-10-2019T17:00 Active
Active 07-10-2019 Active 250.00 07-10-2019
Register Now
Excel Intermediate
Oct 21 1:00 pm - 5:00 pm Excel Intermediate Phoenix Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 21-10-2019T13:00 21-10-2019T17:00 Active
Active 21-10-2019 Active 250.00 21-10-2019
Register Now
Excel Intermediate
Oct 23 8:00 am - 12:00 pm Excel Intermediate Tech Center Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 23-10-2019T08:00 23-10-2019T12:00 Active
Active 23-10-2019 Active 250.00 23-10-2019
Register Now
Excel Intermediate
Nov 6 1:00 pm - 5:00 pm Excel Intermediate Westminster Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 06-11-2019T13:00 06-11-2019T17:00 Active
Active 06-11-2019 Active 250.00 06-11-2019
Register Now
Excel Intermediate
Nov 14 8:00 am - 12:00 pm Excel Intermediate Phoenix Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 14-11-2019T08:00 14-11-2019T12:00 Active
Active 14-11-2019 Active 250.00 14-11-2019
Register Now
Excel Intermediate
Nov 18 1:00 pm - 5:00 pm Excel Intermediate Tech Center Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 18-11-2019T13:00 18-11-2019T17:00 Active
Active 18-11-2019 Active 250.00 18-11-2019
Register Now
Excel Intermediate
Dec 4 1:00 pm - 5:00 pm Excel Intermediate Westminster Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 04-12-2019T13:00 04-12-2019T17:00 Active
Active 04-12-2019 Active 250.00 04-12-2019
Register Now
Excel Intermediate
Dec 16 1:00 pm - 5:00 pm Excel Intermediate Tech Center Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 16-12-2019T13:00 16-12-2019T17:00 Active
Active 16-12-2019 Active 250.00 16-12-2019
Register Now
Excel Intermediate
Dec 16 1:00 pm - 5:00 pm Excel Intermediate Phoenix Excel Intermediate Excel Intermediate Training in Denver & Phoenix Class Price: $250 What’s included – a $1,180 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 16-12-2019T13:00 16-12-2019T17:00 Active
Active 16-12-2019 Active 250.00 16-12-2019
Register Now

Bookings are closed for this class.

Live & In-Person

All of the classes on this page are taught by live instructors who are present in the classroom.