Excel Advanced

Course Description

Course Description

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 GoalPreRequisites

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

    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 Macro
  • s

  • 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

Upcoming Classes

Excel Advanced
Jun 29 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 29-06-2018T08:00 29-06-2018T12:00 Active
Active 29-06-2018 Active 235.00 29-06-2018
Register Now
Excel Advanced
Jul 10 1:00 pm - 5: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 10-07-2018T13:00 10-07-2018T17:00 Active
Active 10-07-2018 Active 235.00 10-07-2018
Register Now
Excel Advanced
Jul 26 1:00 pm - 5: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 26-07-2018T13:00 26-07-2018T17:00 Active
Active 26-07-2018 Active 235.00 26-07-2018
Register Now
Excel Advanced
Jul 26 1:00 pm - 5: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 26-07-2018T13:00 26-07-2018T17:00 Active
Active 26-07-2018 Active 235.00 26-07-2018
Register Now
Excel Advanced
Aug 8 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 08-08-2018T08:00 08-08-2018T12:00 Active
Active 08-08-2018 Active 235.00 08-08-2018
Register Now
Excel Advanced
Aug 14 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 14-08-2018T08:00 14-08-2018T12:00 Active
Active 14-08-2018 Active 235.00 14-08-2018
Register Now
Excel Advanced
Aug 23 1:00 pm - 5: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 23-08-2018T13:00 23-08-2018T17:00 Active
Active 23-08-2018 Active 235.00 23-08-2018
Register Now
Excel Advanced
Sep 6 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 06-09-2018T08:00 06-09-2018T12:00 Active
Active 06-09-2018 Active 235.00 06-09-2018
Register Now
Excel Advanced
Sep 12 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 12-09-2018T08:00 12-09-2018T12:00 Active
Active 12-09-2018 Active 235.00 12-09-2018
Register Now
Excel Advanced
Sep 19 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 19-09-2018T08:00 19-09-2018T12:00 Active
Active 19-09-2018 Active 235.00 19-09-2018
Register Now
Excel Advanced
Oct 2 1:00 pm - 5: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 02-10-2018T13:00 02-10-2018T17:00 Active
Active 02-10-2018 Active 235.00 02-10-2018
Register Now
Excel Advanced
Oct 10 1:00 pm - 5: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 10-10-2018T13:00 10-10-2018T17:00 Active
Active 10-10-2018 Active 235.00 10-10-2018
Register Now
Excel Advanced
Oct 18 1:00 pm - 5: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 18-10-2018T13:00 18-10-2018T17:00 Active
Active 18-10-2018 Active 235.00 18-10-2018
Register Now
Excel Advanced
Nov 8 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 08-11-2018T08:00 08-11-2018T12:00 Active
Active 08-11-2018 Active 235.00 08-11-2018
Register Now
Excel Advanced
Nov 9 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 09-11-2018T08:00 09-11-2018T12:00 Active
Active 09-11-2018 Active 235.00 09-11-2018
Register Now
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

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.