Top Functions in Excel

In this course, Emily teaches essential Excel functions—from text and logical functions to financial calculations and data analysis—helping you enhance efficiency, accuracy, and decision-making skills.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Description

In this course, Emily will guide you through the essential functions of Excel, empowering you to enhance data analysis efficiency and reduce errors across a wide range of tasks. You'll begin by mastering fundamental concepts such as formulas, functions, and cell referencing to build a strong foundation. From there, Emily introduces key text string functions like CONCAT and TRIM for manipulating and formatting data, followed by logical functions such as IF and AND to help with decision-making in formulas. You'll then explore common math functions, including SUM and AVERAGE, as well as statistical functions like COUNT and COUNTIF for analyzing data sets. Lookup and reference functions, including VLOOKUP and XLOOKUP, are covered to enable efficient data searches. You'll also dive into financial functions for calculating loans and investments, along with date and time functions to manage schedules and timelines. This comprehensive course will leave you well-equipped to manage and analyze data proficiently in Excel, whether for business or personal use.

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

Module 00 - Getting Started

Module 01 - Introduction 9 min.

Module 02 - Text String Functions 23 min.

Module 03 - Logical Functions 16 min.

Module 04 - Math Functions 19 min.

Module 05 - Statistical Functions 12 min.

Module 06 - Lookup and Reference Functions 20 min.

Module 07 - Financial Functions 11 min.

Module 08 - Date and Time Functions 8 min.

Module 09 - Conclusion 2 min.

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Emily Taylor

Power BI Trainer

Emily graduated from Indiana University with a bachelor's degree in elementary education and the University of North Florida with a master's degree in educational leadership. After 11 years of teaching varying grades (K-5) in Indiana and Florida, she joined the Pragmatic Works team as a Power BI Trainer. Emily's primary goal is to provide engaging trainings that help customers gain confidence using Power BI. When not in the office, Emily enjoys camping, the beach, cheerleading, and visiting family in Indiana.

Learn More

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion