Excel

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.