Excel Advanced

Course Description

Excel Advanced Training in Denver & Phoenix

excel_tip

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 if you need a refresher within 6 months
  • Workshop – get 1on1 help from an instructor on your own work projects to help you apply what you learned, up to 6 months after the class
  • Lunch & Learn session – choose from different topics to learn something new in the future
  • Hard copy training manual – to take notes and take with you for future reference
  • Quick Tip sheet – color reference card with the top tips from class
  • Just Tips Newsletter subscription – for ongoing monthly tips to help you learn even more!

This Advanced Excel class is designed for everyday users of Excel, who want to take their skills to the next level. Advanced Excel training in Denver & Phoenix covers more intricate formulas, creating validations, writing macros, embedding other documents, and protecting your data in Excel. The class includes useful functions for various business applications, as well as how to combine these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level, and you will learn in the comfort of one of our state of the art training centers.

Training Class Goal

In the Advanced Excel class students will come from this class feeling confident using many of the advanced features within Microsoft Excel, including nested IF statements, VLookups, HLookups, macros, and validations. The primary focus of the Advanced Excel training course is on formulas, specifically functions, and how to nest them with other functions for more advanced automation. Tools for making your spreadsheets easier for others to use and view are also included. These include validations, custom views, protecting worksheets, and embedding other documents or spreadsheets within your workbook.

PreRequisites

Students should have a firm understanding of Excel fundamentals, including formatting, navigation, basic formulas, and basic functions. Students should be comfortable with basic IF statements. This Advanced Excel class builds upon knowledge gained in the Basic and Intermediate Excel courses. Students should have a reasonable comfort level working in Excel at an intermediate proficiency before taking this course.

Topics Covered

Advanced Formulas

  • Viewing available Excel functions
  • Basic text functions
  • Basic “IF” conditional formulas
  • Nesting “IF” statements
  • Concatenate and “IF” statements with concatenate
  • ISBLANK Function
  • COUNTBLANK Function
  • Arrays
  • Using name ranges in formulas
  • Other classes covering Excel Formulas and Functions

Look Ups and Other Functions

  • Lookups and Lookup functions
  • HLookup
  • VLookup
  • Calculating days of the week
  • Calculating number of weekdays from a date
  • Calculating months between 2 dates
  • SUMIF Function

Data Views, Layouts, and Rules

  • Transposing Data
  • Validations for length and drop-down lists
  • Custom Views

Introduction to Macros

  • Developer Tools
  • Saving Macros
  • Absolute vs Relative Macros
  • Recording Macros
  • Creating Macro buttons

Additional Tools in Advanced Excel

  • Embedding and linking
  • Editing and embedded object
  • Editing a linked object
  • Linking as an icon
  • Protecting worksheets
  • Locking cells
  • Protecting a workbook

Advanced Excel training helps students learn new functions to enhance their spreadsheets, as well as tools to make their spreadsheets easier to share, with added automation. Mission Critical Training’s Advanced Excel class will give you a mastery of the functions of this important business application.

Upcoming Classes

Excel Advanced
Nov 20 8:00 am - 12:00 pm Excel Advanced Westminster Excel Advanced Excel Advanced 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 20-11-2018T08:00 20-11-2018T12:00 Active
Active 20-11-2018 Active 235.00 20-11-2018
Register Now
Excel Advanced
Dec 5 8:00 am - 12:00 pm Excel Advanced Tech Center Excel Advanced Excel Advanced 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 05-12-2018T08:00 05-12-2018T12:00 Active
Active 05-12-2018 Active 235.00 05-12-2018
Register Now
Excel Advanced
Dec 13 8:00 am - 12:00 pm Excel Advanced Phoenix Excel Advanced Excel Advanced 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 13-12-2018T08:00 13-12-2018T12:00 Active
Active 13-12-2018 Active 235.00 13-12-2018
Register Now
Excel Advanced
Dec 20 8:00 am - 12:00 pm Excel Advanced Westminster Excel Advanced Excel Advanced 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 20-12-2018T08:00 20-12-2018T12:00 Active
Active 20-12-2018 Active 235.00 20-12-2018
Register Now
Excel Advanced
Jan 8 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 08-01-2019T08:00 08-01-2019T12:00 Active
Active 08-01-2019 Active 250.00 08-01-2019
Register Now
Excel Advanced
Jan 9 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 09-01-2019T08:00 09-01-2019T12:00 Active
Active 09-01-2019 Active 250.00 09-01-2019
Register Now
Excel Advanced
Jan 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-01-2019T08:00 24-01-2019T12:00 Active
Active 24-01-2019 Active 250.00 24-01-2019
Register Now
Excel Advanced
Feb 5 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 05-02-2019T08:00 05-02-2019T12:00 Active
Active 05-02-2019 Active 250.00 05-02-2019
Register Now
Excel Advanced
Feb 13 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 13-02-2019T08:00 13-02-2019T12:00 Active
Active 13-02-2019 Active 250.00 13-02-2019
Register Now
Excel Advanced
Feb 19 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 19-02-2019T13:00 19-02-2019T17:00 Active
Active 19-02-2019 Active 250.00 19-02-2019
Register Now
Excel Advanced
Mar 7 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 07-03-2019T08:00 07-03-2019T12:00 Active
Active 07-03-2019 Active 250.00 07-03-2019
Register Now
Excel Advanced
Mar 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-03-2019T08:00 19-03-2019T12:00 Active
Active 19-03-2019 Active 250.00 19-03-2019
Register Now
Excel Advanced
Mar 20 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 20-03-2019T08:00 20-03-2019T12:00 Active
Active 20-03-2019 Active 250.00 20-03-2019
Register Now
Excel Advanced
Apr 2 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 02-04-2019T08:00 02-04-2019T12:00 Active
Active 02-04-2019 Active 250.00 02-04-2019
Register Now
Excel Advanced
Apr 18 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 18-04-2019T08:00 18-04-2019T12:00 Active
Active 18-04-2019 Active 250.00 18-04-2019
Register Now
Excel Advanced
Apr 18 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 18-04-2019T08:00 18-04-2019T12:00 Active
Active 18-04-2019 Active 250.00 18-04-2019
Register Now
Excel Advanced
May 1 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 01-05-2019T13:00 01-05-2019T17:00 Active
Active 01-05-2019 Active 250.00 01-05-2019
Register Now
Excel Advanced
May 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-05-2019T08:00 15-05-2019T12:00 Active
Active 15-05-2019 Active 250.00 15-05-2019
Register Now
Excel Advanced
May 21 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 21-05-2019T08:00 21-05-2019T12:00 Active
Active 21-05-2019 Active 250.00 21-05-2019
Register Now
Excel Advanced
Jun 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-06-2019T08:00 04-06-2019T12:00 Active
Active 04-06-2019 Active 250.00 04-06-2019
Register Now
Excel Advanced
Jun 17 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 17-06-2019T13:00 17-06-2019T17:00 Active
Active 17-06-2019 Active 250.00 17-06-2019
Register Now
Excel Advanced
Jun 25 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 25-06-2019T08:00 25-06-2019T12:00 Active
Active 25-06-2019 Active 250.00 25-06-2019
Register Now
Excel Advanced
Jul 2 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 02-07-2019T08:00 02-07-2019T12:00 Active
Active 02-07-2019 Active 250.00 02-07-2019
Register Now
Excel Advanced
Jul 17 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 17-07-2019T08:00 17-07-2019T12:00 Active
Active 17-07-2019 Active 250.00 17-07-2019
Register Now
Excel Advanced
Jul 23 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 23-07-2019T08:00 23-07-2019T12:00 Active
Active 23-07-2019 Active 250.00 23-07-2019
Register Now
Excel Advanced
Jul 29 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 29-07-2019T08:00 29-07-2019T12:00 Active
Active 29-07-2019 Active 250.00 29-07-2019
Register Now
Excel Advanced
Aug 14 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 14-08-2019T08:00 14-08-2019T12:00 Active
Active 14-08-2019 Active 250.00 14-08-2019
Register Now
Excel Advanced
Aug 20 1:00 pm - 5: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 20-08-2019T13:00 20-08-2019T17:00 Active
Active 20-08-2019 Active 250.00 20-08-2019
Register Now
Excel Advanced
Aug 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-08-2019T08:00 28-08-2019T12:00 Active
Active 28-08-2019 Active 250.00 28-08-2019
Register Now
Excel Advanced
Sep 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-09-2019T08:00 10-09-2019T12:00 Active
Active 10-09-2019 Active 250.00 10-09-2019
Register Now
Excel Advanced
Sep 27 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 27-09-2019T08:00 27-09-2019T12:00 Active
Active 27-09-2019 Active 250.00 27-09-2019
Register Now
Excel Advanced
Sep 27 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 27-09-2019T13:00 27-09-2019T17:00 Active
Active 27-09-2019 Active 250.00 27-09-2019
Register Now
Excel Advanced
Oct 8 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 08-10-2019T08:00 08-10-2019T12:00 Active
Active 08-10-2019 Active 250.00 08-10-2019
Register Now
Excel Advanced
Oct 22 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 22-10-2019T08:00 22-10-2019T12:00 Active
Active 22-10-2019 Active 250.00 22-10-2019
Register Now
Excel Advanced
Oct 24 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 24-10-2019T08:00 24-10-2019T12:00 Active
Active 24-10-2019 Active 250.00 24-10-2019
Register Now
Excel Advanced
Nov 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-11-2019T08:00 07-11-2019T12:00 Active
Active 07-11-2019 Active 250.00 07-11-2019
Register Now
Excel Advanced
Nov 14 1:00 pm - 5: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 14-11-2019T13:00 14-11-2019T17:00 Active
Active 14-11-2019 Active 250.00 14-11-2019
Register Now
Excel Advanced
Nov 19 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 19-11-2019T08:00 19-11-2019T12:00 Active
Active 19-11-2019 Active 250.00 19-11-2019
Register Now
Excel Advanced
Dec 5 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 05-12-2019T08:00 05-12-2019T12:00 Active
Active 05-12-2019 Active 250.00 05-12-2019
Register Now
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
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
Active 17-12-2019 Active 250.00 17-12-2019
Register Now
Excel Advanced Westminster Dec 20  8:00 am - 12:00 pm

235.00

Attendee 1


Live & In-Person

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