Learn your way! Get started

Excel 2013 Data Analysis, Part 1: Finance & Stats

with expert John Wiley & Sons

Watch trailer

Excel 2013 Data Analysis, Part 1: Finance & Stats Trailer

Course at a glance

Included in these subscriptions:

  • Creative Design Power Pack
  • Power Pack Plus

Release date Release date 3/17/2015
Level Level Intermediate
Runtime Runtime 1h 9m
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 data analysis with Excel 2013 in this three part learning course, Excel 2013 is Microsoft’s industry leading spreadsheet application that allows you to organize, visualize and calculate your data. Lesson coverage includes building formulas and adding functions and conditions to a formula, analyzing financial data to determine loan payments and interest rates, analyzing statistical data and calculating the variance and standard deviation, and sorting and filtering data. You’ll also see an overview of analyzing data with Goal Seek and Scenarios, forecasting data to reveal trends, working with the Analysis ToolPack, and building PivotTables.


This course assumes some familiarity with Microsoft Excel. This course is part of 3 courses; Excel 2013 Data Analysis: Finance & Stats; Excel 2013 Data Analysis: Sorting and Techniques; and Excel 2013 Data Analysis: Forecast and PivotTable. 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

Finance & Statistical

Formulas for Data Analysis (14:08)
  • Introduction (00:10)
  • Building Formulas (04:45)
  • Move & Copy Formulas (03:58)
  • Array Formulas (02:55)
  • Add a Function to a Formula (02:10)
  • Summary (00:10)
Conditionals & Date-Time (16:38)
  • Introduction (00:10)
  • Conditional Formulas (04:41)
  • Example Formulas (05:10)
  • Date Calculations (03:59)
  • Time Calculations (02:27)
  • Summary (00:10)
Analyzing Financial Data (18:32)
  • Introduction (00:10)
  • Calculate Future Values (04:01)
  • Calculate Present Value (02:22)
  • Loan Payment Analysis (02:23)
  • Calculate Principal & Interest (03:59)
  • Calculate Required Interest (03:16)
  • Internal Rate of Return (02:09)
  • Summary (00:10)
Analyzing Statistical Data (20:32)
  • Introduction (00:10)
  • Calculating an Average (03:52)
  • Median & Mode (01:51)
  • Finding the Rank (03:25)
  • Determine the Nth Value (02:17)
  • Grouped Frequency Distribution (02:36)
  • Variance & Standard Deviation (03:34)
  • Finding the Correlation (02:33)
  • Summary (00:10)