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 2

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

 

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

Topics:


• 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.

 

Register

 

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


To Cancel and Check Fees click here


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

 

Back