Description

Data Analysis with Excel (Video Training)

Data Analysis with Excel (Video Training)
MP4 | Video: AVC 1280×720 | Audio: AAC 44KHz 2ch | Duration: 2 Hours 13M | 3.25 GB
Genre: eLearning | Language: English

How this course will help you

Wondering how to get the best information from your data using Excel? Want to see some great ways to visualize it? Join Dr. Wayne Winston, who has been teaching the most effective ways to use Excel to solve business problems for more than 18 years, for an in-depth and practical look at the details.

Focus on four key areas. First, explore ways of describing data using visual tools, like charts and histograms, in Excel, and look at statistical functions to get better information from your data.

Second, learn about PivotTables, including how to create and manage them and how to use PivotTable tools to quickly view your data in different ways.

How this course will help you

Third, see how to use conditional formatting to both highlight important data and to show changes in your data over time. Finally, get the details on using Excel tools to create a forecast model using trend curves.

Dont miss this Excel analytics training, and find out how to slice and dice your data to get the most from it.

In this video training from DataAnalyst.com, youll learn everything you need to know about Excel analytics, including building charts and charts of key data points, using conditional formatting to highlight important information, and creating a trend model using Excel trend curves.

How this course will help you

Don’t miss out on this comprehensive overview of the power of Excel analytics!

Excel has a ton of data analysis features, and theyre all easy to use! In this Microsoft Excel tutorial, youll learn how to use Excel tools to create a forecast model using trend curves, as well as how to analyze your data using conditional formatting.

We show you some fun ways to break down your data, show you the difference between calculating averages vs. finding medians in Excel, and much more!

Excel analysis is an essential skill for sales professionals to make the most out of their data. This course will show you how to use your data in Excel and make it easier to understand and communicate info to others. You’ll learn techniques that you can use right away, including conditional formatting and trend curves.

Automate the Analysis of your Excel Data with Conditional Formatting, Create a Trend Curve in Excel and See How to Use Data Validation Rules and Pivot Tables.