Course Registration

General Inquiries & Appointments:

ODLC Listserv



215 Huron Street, 6th floor

Toastmasters (SALUT)

  Print help
Previous month Previous day Next day Next month
See by year See by month See by week Search Jump to month

Excel 2016 Functions & Formulas Part 3

Friday, August 09, 2019, 01:00pm - 04:00pm




· Adding Comments in Formulas

· Using Array Formulas

· Substituting Text Strings

· Summing Values That Meet Certain Conditions

· Summing Values That Fall between a Given Date Range

· Getting a Count of Values That Meet Two or More Conditions

· Looking Up an Exact Value Based on Lookup Columns

· Hiding Errors Returned by Lookup Functions

· Looking Up Values Horizontally

· Looking Up a Value Based on a Two-Way Matrix

· Finding a Value Based on Multiple Criteria

· Performing a Case-Sensitive Lookup

· Selecting How to Aggregate Data

· Returning the Largest or Smallest Value

· Highlighting Cells that Meet Certain Criteria

· Highlight Cells Based on the Value of Another Cell

· Highlighting Values that Exist in Lists



Prerequisite -  attendees must have experience creating formulas.

To Cancel and Check Fees click here

Location: 256 McCaul Street , Room 109
Presenter: Simone Lee Huber