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

Pluralsight

Data Analysis Functions and Techniques in Microsoft Excel

via Pluralsight

Overview

This course will enable you to implement logical functions, lookup and reference functions, what-if analyses, and visualization with sparklines, using datasets to evaluate sales, credit eligibility, employee data, and investment scenarios.

Excel data analysis skills will help you make informed business decisions. In this course, Data Analysis Functions and Techniques in Microsoft Excel, you’ll gain the ability to analyze and interpret complex datasets. First, you’ll explore how to use logical functions like IF, IFS, SUMIF, and NESTED IFS to categorize sales and profit levels, classify products, and evaluate credit eligibility criteria for customers. Next, you’ll discover how to implement lookup and reference functions such as VLOOKUP, XLOOKUP, INDEX, and MATCH to efficiently find and reference data across single and multiple sheets, with a focus on employee-related data. Finally, you’ll learn how to perform what-if analysis using Goal Seek, Scenario Manager, and data table functions to assess the impact of various business scenarios, as well as how to visualize data trends and comparisons using sparklines charts. When you’re finished with this course, you’ll have the skills and knowledge of Excel data analysis needed to confidently analyze, interpret, and visualize data, driving better decision-making in your organization.

Syllabus

  • Logical and Conditional Functions 10mins
  • Lookup and Reference Functions 23mins
  • Scenarios and What-if Analysis 10mins
  • Data Visualizations with Sparklines 5mins

Taught by

Janani Ravi

Reviews

Start your review of Data Analysis Functions and Techniques in Microsoft Excel

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.