Excel Intermediate

Course Description

excel_tipOur intermediate Excel training courses cover more complex Excel functions, charting, and data tools. Go beyond the basics to learn more formatting, more formulas, and more functionality. The intermediate Excel training starts working with functions such as IF, Proper, Roundup and Date and Time functions. It also looks at how to create formulas across multiple spreadsheets in the same document.

Training Class Goal

In the Intermediate Excel training, we will begin to explore how to utilize more complex functions, including date & time functions and IF statements. We will also look at organizing data, working with multiple worksheets and basic charting. The Intermediate Excel training courses builds on things learned in the basic class. Students learn how to do more with copying and pasting such as creating custom lists. They will learn more advanced formatting techniques like Conditional formatting.

PreRequisites

Before taking this class, students should have an understanding of basic Excel formulas and functions, experience entering data into Microsoft Excel, familiarity with Windows, and basic computer skills.

Topics Covered

Formulas & Functions

  • Typing formulas and functions
  • Cell references and reference formulas
  • AutoSum
  • The Functions Library
  • Average, date, and time functions
  • IF statements
  • Nested IF Statements
  • Other classes covering Formulas & Functions

Moving and Copying Data in Excel

  • Cut, copy, and paste data
  • The Fill Handle
  • Absolute and relative references
  • AutoFill and custom Lists

Working with More Functions

  • Date and Time Functions
  • Calculating dates in years
  • IF Statements in Date Functions
  • The Proper Function
  • The Roundup Function

Working with Multiple Worksheets

  • Renaming worksheets
  • Color coding tabs
  • Moving and copying worksheets
  • 3D reference formulas
  • Hyperlinks
  • ScreenTips

Formatting Cells and Appearance

  • Formatting text and numbers in cells
  • Merging cells
  • Wrapping text within a cell
  • Custom number formats
  • Conditional formatting
  • Copying formatting
  • Other classes covering Excel formatting

Viewing Worksheets

  • Showing formulas and references
  • Tracing precedents and dependents
  • Grouping rows and columns
  • Cell comments
  • Headers and footers
  • Other classes covering Navigation and Views

Introduction to Basic Charts

  • Creating and defining a chart
  • Positioning, rotating, and resizing charts
  • WordArt in charts
  • Editing charts in Excel
  • Changing types
  • Formatting a data series
  • Multiple series charts
  • Sparkline charts
  • Other classes covering Excel charts

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
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
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
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
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
16-12-2019 Active 250.00 16-12-2019
Register Now
Excel Intermediate
Jan 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-01-2020T13:00 06-01-2020T17:00 Active
06-01-2020 Active 250.00 06-01-2020
Register Now
Excel Intermediate
Jan 21 1:00 pm - 5:00 pm Excel Intermediate Phoenix – Tempe 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-01-2020T13:00 21-01-2020T17:00 Active
21-01-2020 Active 250.00 21-01-2020
Register Now
Excel Intermediate
Jan 22 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 22-01-2020T13:00 22-01-2020T17:00 Active
22-01-2020 Active 250.00 22-01-2020
Register Now
Excel Intermediate
Feb 3 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 03-02-2020T08:00 03-02-2020T12:00 Active
03-02-2020 Active 250.00 03-02-2020
Register Now
Excel Intermediate
Feb 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-02-2020T13:00 18-02-2020T17:00 Active
18-02-2020 Active 250.00 18-02-2020
Register Now
Excel Intermediate
Feb 25 1:00 pm - 5:00 pm Excel Intermediate Phoenix – Tempe 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 25-02-2020T13:00 25-02-2020T17:00 Active
25-02-2020 Active 250.00 25-02-2020
Register Now
Excel Intermediate
Mar 3 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 03-03-2020T13:00 03-03-2020T17:00 Active
03-03-2020 Active 250.00 03-03-2020
Register Now
Excel Intermediate
Mar 18 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 18-03-2020T08:00 18-03-2020T12:00 Active
18-03-2020 Active 250.00 18-03-2020
Register Now
Excel Intermediate
Mar 25 1:00 pm - 5:00 pm Excel Intermediate Phoenix – Tempe 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 25-03-2020T13:00 25-03-2020T17:00 Active
25-03-2020 Active 250.00 25-03-2020
Register Now
Excel Intermediate
Mar 31 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 31-03-2020T08:00 31-03-2020T12:00 Active
31-03-2020 Active 250.00 31-03-2020
Register Now
Excel Intermediate
Apr 14 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 14-04-2020T13:00 14-04-2020T17:00 Active
14-04-2020 Active 250.00 14-04-2020
Register Now
Excel Intermediate
Apr 28 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 28-04-2020T13:00 28-04-2020T17:00 Active
28-04-2020 Active 250.00 28-04-2020
Register Now
Excel Intermediate
Apr 30 1:00 pm - 5:00 pm Excel Intermediate Phoenix – Tempe 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-04-2020T13:00 30-04-2020T17:00 Active
30-04-2020 Active 250.00 30-04-2020
Register Now
Excel Intermediate
May 11 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 11-05-2020T08:00 11-05-2020T12:00 Active
11-05-2020 Active 250.00 11-05-2020
Register Now
Excel Intermediate
May 20 1:00 pm - 5:00 pm Excel Intermediate Phoenix – Tempe 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-2020T13:00 20-05-2020T17:00 Active
20-05-2020 Active 250.00 20-05-2020
Register Now
Excel Intermediate
May 27 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 27-05-2020T13:00 27-05-2020T17:00 Active
27-05-2020 Active 250.00 27-05-2020
Register Now
Excel Intermediate
Jun 9 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 09-06-2020T13:00 09-06-2020T17:00 Active
09-06-2020 Active 250.00 09-06-2020
Register Now
Excel Intermediate
Jun 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-06-2020T13:00 23-06-2020T17:00 Active
23-06-2020 Active 250.00 23-06-2020
Register Now
Excel Intermediate
Jun 25 1:00 pm - 5:00 pm Excel Intermediate Phoenix – Tempe 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 25-06-2020T13:00 25-06-2020T17:00 Active
25-06-2020 Active 250.00 25-06-2020
Register Now
Excel Intermediate
Jul 8 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 08-07-2020T13:00 08-07-2020T17:00 Active
08-07-2020 Active 250.00 08-07-2020
Register Now
Excel Intermediate
Jul 20 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 20-07-2020T13:00 20-07-2020T17:00 Active
20-07-2020 Active 250.00 20-07-2020
Register Now
Excel Intermediate
Jul 28 1:00 pm - 5:00 pm Excel Intermediate Phoenix – Tempe 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 28-07-2020T13:00 28-07-2020T17:00 Active
28-07-2020 Active 250.00 28-07-2020
Register Now
Excel Intermediate
Aug 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-08-2020T13:00 03-08-2020T17:00 Active
03-08-2020 Active 250.00 03-08-2020
Register Now
Excel Intermediate
Aug 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-08-2020T13:00 18-08-2020T17:00 Active
18-08-2020 Active 250.00 18-08-2020
Register Now
Excel Intermediate
Aug 25 1:00 pm - 5:00 pm Excel Intermediate Phoenix – Tempe 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 25-08-2020T13:00 25-08-2020T17:00 Active
25-08-2020 Active 250.00 25-08-2020
Register Now
Excel Intermediate
Aug 31 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 31-08-2020T13:00 31-08-2020T17:00 Active
31-08-2020 Active 250.00 31-08-2020
Register Now
Excel Intermediate
Sep 14 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 14-09-2020T13:00 14-09-2020T17:00 Active
14-09-2020 Active 250.00 14-09-2020
Register Now
Excel Intermediate
Sep 28 1:00 pm - 5:00 pm Excel Intermediate Phoenix – Tempe 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 28-09-2020T13:00 28-09-2020T17:00 Active
28-09-2020 Active 250.00 28-09-2020
Register Now
Excel Intermediate
Sep 29 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 29-09-2020T13:00 29-09-2020T17:00 Active
29-09-2020 Active 250.00 29-09-2020
Register Now
Excel Intermediate
Oct 12 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 12-10-2020T08:00 12-10-2020T12:00 Active
12-10-2020 Active 250.00 12-10-2020
Register Now
Excel Intermediate
Oct 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-10-2020T13:00 27-10-2020T17:00 Active
27-10-2020 Active 250.00 27-10-2020
Register Now
Excel Intermediate
Oct 28 1:00 pm - 5:00 pm Excel Intermediate Phoenix – Tempe 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 28-10-2020T13:00 28-10-2020T17:00 Active
28-10-2020 Active 250.00 28-10-2020
Register Now
Excel Intermediate
Nov 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-11-2020T13:00 09-11-2020T17:00 Active
09-11-2020 Active 250.00 09-11-2020
Register Now
Excel Intermediate
Nov 17 1:00 pm - 5:00 pm Excel Intermediate Phoenix – Tempe 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-11-2020T13:00 17-11-2020T17:00 Active
17-11-2020 Active 250.00 17-11-2020
Register Now
Excel Intermediate
Nov 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-11-2020T08:00 23-11-2020T12:00 Active
23-11-2020 Active 250.00 23-11-2020
Register Now
Excel Intermediate
Dec 3 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 03-12-2020T13:00 03-12-2020T17:00 Active
03-12-2020 Active 250.00 03-12-2020
Register Now
Excel Intermediate
Dec 14 1:00 pm - 5:00 pm Excel Intermediate Phoenix – Tempe 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-12-2020T13:00 14-12-2020T17:00 Active
14-12-2020 Active 250.00 14-12-2020
Register Now
Excel Intermediate
Dec 17 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 17-12-2020T13:00 17-12-2020T17:00 Active
17-12-2020 Active 250.00 17-12-2020
Register Now

This class is fully booked.

Live & In-Person

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