Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Mastering Excel Functions

via Pluralsight

Overview

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

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.

Syllabus

  • Orientation 6mins
  • Foundations of Excel Functions 17mins
  • Working with Data 23mins
  • Decision Making and Logical Operations 12mins
  • Mastering Lookup and Reference 26mins
  • Advanced Math and Custom Function Creation 13mins
  • Advanced Function Applications in Data Analysis 15mins
  • Beyond Functions 5mins

Taught by

Doru Catana

Reviews

Start your review of Mastering Excel Functions

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.