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.

PluralSight – Create and Format Basic Charts in Microsoft Excel

PluralSight – Create and Format Basic Charts in Microsoft Excel
English | Tutorial | Size: 36.7 MB


Presenting data clearly is important for data analysis and storytelling. This course will teach you how to create and customize bar, line, and pie charts.

PluralSight – Time Series Analysis in Microsoft Excel

PluralSight – Time Series Analysis in Microsoft Excel
English | Tutorial | Size: 37.6 MB


Master the essentials of time series analysis in Excel. This course will teach you how to manage dates, create time series line charts, calculate moving averages, and forecast future trends.