Learn your way! Get started

Excel 2013 Stats Analysis, Part 1: Introduction

with expert John Wiley & Sons

Watch trailer

Excel 2013 Stats Analysis, Part 1: Introduction Trailer

Course at a glance

Included in these subscriptions:

  • Creative Design Power Pack
  • Power Pack Plus

Release date Release date 3/20/2015
Level Level Advanced
Runtime Runtime 1h 2m
Platform Platform Major browsers on Windows Major browsers on Windows Major browsers on Mac OSX Major browsers on Mac OSX Mobile Devices Mobile Devices
Published eBooks Published eBooks Included
Hands-on labs Hands-on labs N/A
Sample files Sample files Included
Exams Exams N/A

Enterprise Solutions
Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

Master statistical analysis with Excel 2013 with this four part learning series of courses . Big data is big business, and many professionals are turning to Excels data analysis tools to help them make sense of their organizational data. Now, you can learn the ins and outs of statistical analysis with Excel – from importing data to utilizing Pivot Tables – with Statistical Analysis with Excel 2013 Advanced Skills. Understand Excels data analysis capabilities and how they can be applied in your organization. Work with data, normal distributions, hypothesis testing, variances, rank, and percentiles. Take advantage of formulas, Pivot Tables, dashboards, and reporting tools to display your data.


This course assumes some familiarity with Microsoft Excel. This course is part of 4 courses; Excel 2013 Statistical Analysis: Introduction; Excel 2013 Statistical Analysis: Charts & Variance; Excel 2013 Statistical Analysis: Z-Scores and Distribution and Excel 2013 Statistical Analysis: Hypothesis Testing. Please be sure to view the courses in order if you are new to the material.

Meet the expert

John Wiley & Sons Our Creative Design courses are presented by experts from Wiley Publishing. Wiley is a global provider of knowledge and knowledge-enabled services that improve outcomes in areas of research, professional practice, and education. They are the publisher of award-winning journals, encyclopedias, books, and online products and services.

Course outline


Intro to Statistics (26:14)
  • Introduction (00:10)
  • Statistics in Excel (03:42)
  • Statistical Functions (04:52)
  • Data Analysis Tool Pack (03:16)
  • Group Data (04:48)
  • Cell Ranges (05:06)
  • Dynamic Changes (04:08)
  • Summary (00:10)
Sort & Summarize Data (16:34)
  • Introduction (00:10)
  • Sorting Data (04:34)
  • Summarize Data (04:24)
  • Multiple Conditions (03:18)
  • Multiple Conditions Cont. (03:56)
  • Summary (00:10)
Charts (19:50)
  • Introduction (00:10)
  • Graphics (03:16)
  • Formatting Charts (05:53)
  • Line Charts (05:55)
  • Pie Charts (04:23)
  • Summary (00:10)