Excel Advanced

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)
  • UCells, columns, and rows
  • UKeyboard shortcuts
  • UFreezing and splitting panes
  • UZooming
  • UHiding columns and rows
  • UOther classes covering Excel navigation

    Entering basic data into Excel/h3>

  • 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 Advanced
Dec 16 8:00 am - 12:00 pm Excel Advanced Phoenix Excel Advanced Excel Advanced 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-2019T08:00 16-12-2019T12:00 Active
16-12-2019 Active 250.00 16-12-2019
Register Now
Excel Advanced
Dec 17 8:00 am - 12:00 pm Excel Advanced Tech Center Excel Advanced Excel Advanced 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-12-2019T08:00 17-12-2019T12:00 Active
17-12-2019 Active 250.00 17-12-2019
Register Now
Excel Advanced
Jan 7 8:00 am - 12:00 pm Excel Advanced Westminster Excel Advanced Excel Advanced 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-2020T08:00 07-01-2020T12:00 Active
07-01-2020 Active 250.00 07-01-2020
Register Now
Excel Advanced
Jan 23 8:00 am - 12:00 pm Excel Advanced Tech Center Excel Advanced Excel Advanced 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-2020T08:00 23-01-2020T12:00 Active
23-01-2020 Active 250.00 23-01-2020
Register Now
Excel Advanced
Feb 3 1:00 pm - 5:00 pm Excel Advanced Westminster Excel Advanced Excel Advanced 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-02-2020T13:00 03-02-2020T17:00 Active
03-02-2020 Active 250.00 03-02-2020
Register Now
Excel Advanced
Feb 20 8:00 am - 12:00 pm Excel Advanced Tech Center Excel Advanced Excel Advanced 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-2020T08:00 20-02-2020T12:00 Active
20-02-2020 Active 250.00 20-02-2020
Register Now
Excel Advanced
Feb 26 8:00 am - 12:00 pm Excel Advanced Phoenix – Tempe Excel Advanced Excel Advanced 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-02-2020T08:00 26-02-2020T12:00 Active
26-02-2020 Active 250.00 26-02-2020
Register Now
Excel Advanced
Mar 4 8:00 am - 12:00 pm Excel Advanced Westminster Excel Advanced Excel Advanced 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-03-2020T08:00 04-03-2020T12:00 Active
04-03-2020 Active 0.00 04-03-2020
Register Now
Excel Advanced
Mar 18 1:00 pm - 5:00 pm Excel Advanced Tech Center Excel Advanced Excel Advanced 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-2020T13:00 18-03-2020T17:00 Active
18-03-2020 Active 0.00 18-03-2020
Register Now
Excel Advanced
Mar 30 8:00 am - 12:00 pm Excel Advanced Westminster Excel Advanced Excel Advanced 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-03-2020T08:00 30-03-2020T12:00 Active
30-03-2020 Active 0.00 30-03-2020
Register Now
Excel Advanced
Apr 15 8:00 am - 12:00 pm Excel Advanced Tech Center Excel Advanced Excel Advanced 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 15-04-2020T08:00 15-04-2020T12:00 Active
15-04-2020 Active 0.00 15-04-2020
Register Now
Excel Advanced
Apr 29 8:00 am - 12:00 pm Excel Advanced Westminster Excel Advanced Excel Advanced 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 29-04-2020T08:00 29-04-2020T12:00 Active
29-04-2020 Active 0.00 29-04-2020
Register Now
Excel Advanced
May 11 1:00 pm - 5:00 pm Excel Advanced Tech Center Excel Advanced Excel Advanced 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 11-05-2020T13:00 11-05-2020T17:00 Active
11-05-2020 Active 0.00 11-05-2020
Register Now
Excel Advanced
May 21 8:00 am - 12:00 pm Excel Advanced Phoenix – Tempe Excel Advanced Excel Advanced 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-05-2020T08:00 21-05-2020T12:00 Active
21-05-2020 Active 0.00 21-05-2020
Register Now
Excel Advanced
May 28 8:00 am - 12:00 pm Excel Advanced Westminster Excel Advanced Excel Advanced 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 28-05-2020T08:00 28-05-2020T12:00 Active
28-05-2020 Active 0.00 28-05-2020
Register Now
Excel Advanced
Jun 10 8:00 am - 12:00 pm Excel Advanced Tech Center Excel Advanced Excel Advanced 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 10-06-2020T08:00 10-06-2020T12:00 Active
10-06-2020 Active 0.00 10-06-2020
Register Now
Excel Advanced
Jun 24 8:00 am - 12:00 pm Excel Advanced Westminster Excel Advanced Excel Advanced 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-2020T08:00 24-06-2020T12:00 Active
24-06-2020 Active 0.00 24-06-2020
Register Now
Excel Advanced
Jul 9 8:00 am - 12:00 pm Excel Advanced Tech Center Excel Advanced Excel Advanced 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-07-2020T08:00 09-07-2020T12:00 Active
09-07-2020 Active 0.00 09-07-2020
Register Now
Excel Advanced
Jul 21 8:00 am - 12:00 pm Excel Advanced Westminster Excel Advanced Excel Advanced 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-07-2020T08:00 21-07-2020T12:00 Active
21-07-2020 Active 0.00 21-07-2020
Register Now
Excel Advanced
Aug 4 8:00 am - 12:00 pm Excel Advanced Tech Center Excel Advanced Excel Advanced 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-08-2020T08:00 04-08-2020T12:00 Active
04-08-2020 Active 0.00 04-08-2020
Register Now
Excel Advanced
Aug 19 8:00 am - 12:00 pm Excel Advanced Westminster Excel Advanced Excel Advanced 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 19-08-2020T08:00 19-08-2020T12:00 Active
19-08-2020 Active 0.00 19-08-2020
Register Now
Excel Advanced
Aug 26 8:00 am - 12:00 pm Excel Advanced Phoenix – Tempe Excel Advanced Excel Advanced 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-08-2020T08:00 26-08-2020T12:00 Active
26-08-2020 Active 0.00 26-08-2020
Register Now
Excel Advanced
Sep 1 8:00 am - 12:00 pm Excel Advanced Tech Center Excel Advanced Excel Advanced 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-09-2020T08:00 01-09-2020T12:00 Active
01-09-2020 Active 0.00 01-09-2020
Register Now
Excel Advanced
Sep 15 8:00 am - 12:00 pm Excel Advanced Westminster Excel Advanced Excel Advanced 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 15-09-2020T08:00 15-09-2020T12:00 Active
15-09-2020 Active 0.00 15-09-2020
Register Now
Excel Advanced
Sep 30 8:00 am - 12:00 pm Excel Advanced Tech Center Excel Advanced Excel Advanced 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-09-2020T08:00 30-09-2020T12:00 Active
30-09-2020 Active 0.00 30-09-2020
Register Now
Excel Advanced
Oct 12 1:00 pm - 5:00 pm Excel Advanced Westminster Excel Advanced Excel Advanced 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-10-2020T13:00 12-10-2020T17:00 Active
12-10-2020 Active 0.00 12-10-2020
Register Now
Excel Advanced
Oct 28 8:00 am - 12:00 pm Excel Advanced Tech Center Excel Advanced Excel Advanced 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 28-10-2020T08:00 28-10-2020T12:00 Active
28-10-2020 Active 0.00 28-10-2020
Register Now
Excel Advanced
Nov 10 8:00 am - 12:00 pm Excel Advanced Westminster Excel Advanced Excel Advanced 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 10-11-2020T08:00 10-11-2020T12:00 Active
10-11-2020 Active 0.00 10-11-2020
Register Now
Excel Advanced
Nov 18 8:00 am - 12:00 pm Excel Advanced Phoenix – Tempe Excel Advanced Excel Advanced 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-2020T08:00 18-11-2020T12:00 Active
18-11-2020 Active 0.00 18-11-2020
Register Now
Excel Advanced
Nov 23 1:00 pm - 5:00 pm Excel Advanced Tech Center Excel Advanced Excel Advanced 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-11-2020T13:00 23-11-2020T17:00 Active
23-11-2020 Active 0.00 23-11-2020
Register Now
Excel Advanced
Dec 4 8:00 am - 12:00 pm Excel Advanced Westminster Excel Advanced Excel Advanced 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-2020T08:00 04-12-2020T12:00 Active
04-12-2020 Active 0.00 04-12-2020
Register Now
Excel Advanced
Dec 18 8:00 am - 12:00 pm Excel Advanced Tech Center Excel Advanced Excel Advanced 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-12-2020T08:00 18-12-2020T12:00 Active
18-12-2020 Active 0.00 18-12-2020
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.