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 2

Tuesday, July 23, 2019, 01:00pm - 04:00pm


This half day course focuses on various Date & Time, Text, Logical, Math and Statistical Functions.


• Calculating a Running Total
• Rounding Numbers
• Counting Values or Blanks in a Range
• Checking to See if One or More Conditions are Met
• Calculating Mean, Median and Mode
• Working with Casing
• Cleaning Odd Characters from Text Strings
• Splitting First/Middle/Last Names
• Extracting Parts of a Text String
• Finding Specific Characters in a Text String
• Formatting Numbers in a Text String
• Formatting Numbers with the Dollar Function
• Extracting Parts of a Date or a Time
• Calculating the Number of Days/Work Days Between Two Dates
• Calculating the Number of Years and Months Between Dates
• Calculating Elapsed Time

Requirement: Must be experienced in creating Excel formulas.




You can also access the self paced learning at free for staff at UofT

To Cancel and Check Fees click here

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