education & meetings

Microsoft® Office Excel®: More Formulas and Functions

Microsoft® Office Excel®: More Formulas and Functions
  • Wednesday, November 2, 2022 | 1:00 pm - 4:00 pm (ET)

Do you want to become more efficient with formulas and functions in MS Excel? Have you inherited workbooks and need to understand the functions that run the reports? This may be the class for you. We explore advanced functions, work with named ranges, use database functions and resolve errors. This class is a terrific lead-in to the more advanced Data Analysis classes as well.

Upon successful completion of this course, you will gain practice using functions and formulas, creating range names and perform advanced database analysis taking advantage of Excel functionality. As a prerequisite, attendees should be familiar with MS Excel basics, such as creating formulas and using Excel Sum and Average functions.

You will

  • Consolidate Information
  • Use Data Validation
  • Create Advanced Formulas
  • Create and Use Range Names
  • Use Advanced Functions
  • Resolve Formula Errors
  • Use Excel Database Functions

Member Price: $119.00
Non-member Price: $139.00