Data

PluralSight – Analyze Data in Microsoft Excel with the Analysis ToolPak

PluralSight – Analyze Data in Microsoft Excel with the Analysis ToolPak
English | Tutorial | Size: 29.3 MB


Enhance your analysis skills in Excel using the Analysis ToolPak add-in. This course will teach you the benefits of Analysis ToolPak in Microsoft Excel and how to utilize it.

PluralSight – Summarize Data in Microsoft Excel

PluralSight – Summarize Data in Microsoft Excel
English | Tutorial | Size: 52.4 MB


Crunching numbers is the bread and butter of Excel. This course will teach you how to count and summarize values.

PluralSight – Data Validation Techniques in Microsoft Excel

PluralSight – Data Validation Techniques in Microsoft Excel
English | Tutorial | Size: 59.5 MB


In this course, you will learn how to effectively set up data validation rules for text, numeric, and date data, and configure static and dynamic drop-down lists, helping to maintain accurate and reliable employee and organizational databases.

PluralSight – Data Analysis Functions and Techniques in Microsoft Excel

PluralSight – Data Analysis Functions and Techniques in Microsoft Excel
English | Tutorial | Size: 191.6 MB


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.