Find the best online course
Back to course list
Excel for Mac: Advanced Formulas and Functions (365/2019)
  • Level: Intermediate
  • Duration: 02h 18m
  • Release date: 2021-04-22
  • Author: Dennis Taylor
  • Provider: Lynda

Excel for Mac: Advanced Formulas and Functions (365/2019)

Description
Content

Looking to master all the formulas and functions available in Excel for Mac? In this comprehensive course, Dennis Taylor presents numerous Excel formulas and functions and shows how to use them efficiently. Dennis begins with tips and keyboard shortcuts to accelerate the way you work with formulas within one or multiple worksheets. He then covers how to perform logical tests with the IF, AND, OR, and NOT functions, search and retrieve data with lookup functions (VLOOKUP, XLOOKUP, MATCH, and INDEX), analyze data with statistical functions, use text functions to clean up worksheets, work with array formulas and functions, and master date and time calculations. If you’re looking to up your formulas and functions skills in Excel, join Dennis as he uses practical examples that transition effortlessly to real-world scenarios.