Data Analysis with Excel

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2 Hours 13M | 3.25 GB

Genre: eLearning | Language: English

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. 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. Don’t miss this Excel analytics training, and find out how to slice and dice your data to get the most from it.