Course Registration
416-978-5462


General Inquiries & Appointments:
416-978-2066



SUBSCRIBE
ODLC Listserv

 

accessibility
Directions

215 Huron Street, 6th floor
odlc@utoronto.ca


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

 

Topics:

 

· 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

 

Register

Prerequisite -  attendees must have experience creating formulas.


To Cancel and Check Fees click here


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

 

Back