Excel Intermediate

Course Description

Excel Intermediate Training in Denver & Phoenix

excel_tip

Are you ready to go beyond the basics in Excel? Our intermediate Excel training in Denver & Phoenix course covers more complex Excel functions, charting, and data tools. Build upon your basic knowledge of this essential application to learn more formatting, more formulas, and more functionality. You will learn to work with functions such as IF, Proper, Roundup, and Date and Time functions, as well as how to create visual impact with your data by creating charts. It also looks at how to create formulas across multiple spreadsheets in the same document. Our instructors will be available to answer your questions and make sure you have a firm understanding of Excel at a deeper level.

Class Price: $235

Training Class Goal

In the Intermediate Excel training course, we will begin to explore how to utilize more complex functions, including date and time functions and IF statements, as well as AutoSum. We will also look at organizing data, working with multiple worksheets, and basic charting. The Intermediate Excel training builds on things learned in the Basic class. Students will 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

Intermediate Excel training covers things beyond the basics, to give you more developed skills in building your spreadsheets, creating formulas to automate them, and adding visual impact with formatting and charts. Mission Critical Training’s Intermediate Excel class will give you a confident level of proficiency in this important business application.

Upcoming Classes

Excel Intermediate
Oct 2 8:00 am - 12:00 pm Excel Intermediate Tech Center 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 02-10-2018T08:00 02-10-2018T12:00 Active
Active 02-10-2018 Active 235.00 02-10-2018
Register Now
Excel Intermediate
Oct 10 8:00 am - 12:00 pm Excel Intermediate Phoenix 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 10-10-2018T08:00 10-10-2018T12:00 Active
Active 10-10-2018 Active 235.00 10-10-2018
Register Now
Excel Intermediate
Oct 18 8:00 am - 12: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 18-10-2018T08:00 18-10-2018T12:00 Active
Active 18-10-2018 Active 235.00 18-10-2018
Register Now
Excel Intermediate
Oct 30 8:00 am - 12: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 30-10-2018T08:00 30-10-2018T12:00 Active
Active 30-10-2018 Active 235.00 30-10-2018
Register Now
Excel Intermediate
Nov 7 1:00 pm - 5:00 pm Excel Intermediate Phoenix 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 07-11-2018T13:00 07-11-2018T17:00 Active
Active 07-11-2018 Active 235.00 07-11-2018
Register Now
Excel Intermediate
Nov 8 1:00 pm - 5:00 pm Excel Intermediate Tech Center 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 08-11-2018T13:00 08-11-2018T17:00 Active
Active 08-11-2018 Active 235.00 08-11-2018
Register Now
Excel Intermediate
Nov 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-11-2018T13:00 19-11-2018T17:00 Active
Active 19-11-2018 Active 235.00 19-11-2018
Register Now
Excel Intermediate
Dec 4 1:00 pm - 5:00 pm Excel Intermediate Tech Center 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 04-12-2018T13:00 04-12-2018T17:00 Active
Active 04-12-2018 Active 235.00 04-12-2018
Register Now
Excel Intermediate
Dec 12 1:00 pm - 5:00 pm Excel Intermediate Phoenix 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 12-12-2018T13:00 12-12-2018T17:00 Active
Active 12-12-2018 Active 235.00 12-12-2018
Register Now
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.