Excel

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.

PluralSight – Data Transformation with Power Query in Microsoft Excel

PluralSight – Data Transformation with Power Query in Microsoft Excel
English | Tutorial | Size: 141.5 MB


Power Query adds significant data preparation capabilities to many of Microsoft’s most popular data products. This course will teach you to connect, transform, combine, and load data from various sources using Power Query with Microsoft Excel.