All courses
Resource hub
Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Core Tech

Mastering Excel Functions

This course will teach you essential Excel functions along with data analysis techniques and macros, enabling efficient data management and insightful analysis.

Doru Catana - Pluralsight course - Mastering Excel Functions
by Doru Catana
Get started Video play icon Preview course

What you'll learn

Struggling to manage and analyze data efficiently can hinder productivity and decision-making. In this course, Mastering Excel Functions, you’ll learn to harness the full power of Excel to streamline your workflows and uncover insights. First, you’ll explore foundational functions like SUM, AVERAGE, and IF to manipulate data effortlessly. Next, you’ll discover advanced data analysis techniques with VLOOKUP, INDEX-MATCH, and PivotTables. Finally, you’ll learn how to automate repetitive tasks using macros. When you’re finished with this course, you’ll have the skills and knowledge of Excel needed to efficiently manage, analyze, and report data.

Table of contents

About the author

Doru Catana - Pluralsight course - Mastering Excel Functions
Doru Catana

Doru founded and runs a marketing agency with global clients in a wide range of industries. His focus is on campaigns that convert and get new business through the door, not feel good campaigns. In terms of approach he believes in authentic and blunt advertising without the presence of small print.

More Courses by Doru