Microsoft

Create and Format Specialized Charts in Microsoft Excel

Create and Format Specialized Charts in Microsoft Excel
English | Tutorial | Size: 48.7 MB


Enhance your visualization skills with this course on creating and formatting specialized charts. This course will teach you how to design and customize scatter plots, histograms, and bubble charts to visualize and analyze complex data sets.

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.