Excel Advanced

Course Description

Advanced Excel Training

excel_tipThe Advanced Excel class is designed for everyday users of Excel, who want to take their skills to the next level. Advanced Excel training 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 them with other functions.

Training Class Goal

In the Advanced Excel class students will come from this class feeling confident using many advanced features within Microsoft Excel, including nested IF statements, VLookups, Hlookups, Macros, and Validations. The largest focus of the Advanced Excel training is around 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 in your workbook.

PreRequisites

Understanding of Excel fundamentals including formatting, navigation, basic formulas, basic functions. Students should be comfortable with basic IF statements.

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 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
  • Other classes covering Lookups

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

The 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.

Upcoming Classes

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
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
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
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
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
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
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
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
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
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
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
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
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
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 250.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 250.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 250.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 250.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 250.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 250.00 11-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 250.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 250.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 250.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 250.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 250.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 250.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 250.00 19-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 250.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 250.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 250.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 250.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 250.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 250.00 10-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 250.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 250.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 250.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.