Must-Know Excel Functions to Increase Your Productivity

Please log in to access your purchased courses.

Earn PDUs

Earn 3 PMI-PDUS at the completion of your course

Earn a Certificate

Earn a Certificate from industry leaders in Project Management

Pace your self

Study on demand at your own pace with 100% online training

Who is this course for?

  • Intermediate Excel users who want to expand their knowledge of worksheet functions
  • Professionals from various industries looking to enhance their data analysis and manipulation skills
  • Anyone seeking to automate tasks and perform complex calculations efficiently in Excel

What will you learn?

  • Understand the concept of functions in Excel and how they can simplify your work
  • Use the IF function to automate data entry based on specific conditions
  • Count occurrences of particular values within a range using COUNTIFS
  • Sum up numbers that match specific criteria with SUMIFS
  • Eliminate common error messages like #DIV/0 and #N/A using IFERROR
  • Master the powerful XLOOKUP function to search for data in tabular lists effortlessly
  • Apply your newfound knowledge of functions to real-world scenarios and projects
  • Gain confidence in leveraging Excel’s built-in functions to streamline your workflows

Must-Know Excel Functions to Increase Your Productivity

Or log in to access your purchased courses
9 students have taken this course