No New Notifications

Excel Advanced 2: Advanced Formulas

Accelerate Computer Training

Limited time remaining!
23 ratings
Select Option

Highlights

In this half-day session, you will learn to write complex formulas using Excel’s built-in functions and array formulas. You will expand your

Customer Reviews


This deal doesn't have any written reviews yet.

What You'll Get

In this half-day session, you will learn to write complex formulas using Excel's built-in functions and array formulas. You will expand your library of functions to include financial, text parsing, logical, lookup and database functions. You will also learn to write array formulas, which are capable of performing multiple calculations in a single result. Finally, you will gain essential formula auditing and troubleshooting skills.

Outline:

Advanced Formulas using Functions

  • PMT and PV financial calculations
  • LEFT, MID and RIGHT to extract text
  • nesting functions inside functions
  • VALUE to convert strings to values
  • IF to construct conditional logic
  • SEARCH to aid in parsing text strings
  • VLOOKUP to retrieve values from a table
  • INDEX and MATCH for more dynamic lookups
  • creating in-cell drop-down menus
  • DSUM to sum table data filtered by criteria
  • TRIM to clean up text
Array Formulas
  • understand array formulas
  • write array formulas that perform multiple calculations to generate a single result
  • write array formulas that calculate multiple results
Troubleshooting Advanced Formulas
  • editing formulas
  • auditing your formulas
  • tracing precedents and dependents
  • inserting comments
  • using the Watch window
Prerequisites: This class is ideally suited for those who have attended the Simple Functions class or who are already comfortable creating basic formulas like SUM, AVERAGE and COUNT.

The class identified is made available through CourseHorse, a 3rd party marketplace for Excel classes and more. Groupon is not affiliated with or sponsored by the merchant, Accelerate Computer Training, in connection with this offer. Please contact Groupon customer service for all inquiries related to this offer. Inquiries placed to CourseHorse will be directed back to Groupon.

The Fine Print

Expiration varies.

  • ALL SALES FINAL.
  • Must be 18 or older to attend
  • Voucher valid only for date and time listed; may not be exchanged, altered, or redeemed for other dates, but may send a friend in place.
  • Must present CourseHorse confirmation email upon arrival.
  • Purchaser name must be provided at checkout; this information will be shared with CourseHorse and course provider for purposes of order fulfillment.
  • Groupon voucher Terms of Sale and Extraordinary Event Policy do not apply.
  • Merchant is solely responsible to purchasers for the care and quality of the advertised goods and services.
  • Offer is not eligible for our promo codes or other discounts.
  • Note, additional equipment or materials may be required or included in purchase price, see course description for details.
  • Merchant is solely responsible to purchasers for the care and quality of the advertised goods and services. Offer is not eligible for our promo codes or other discounts.

Accelerate Computer Training

Class, Academic Course
By purchasing this deal you'll unlock points which can be spent on discounts and rewards. Every 5,000 points can be redeemed for $5 Off your next purchase.