Excel is used for many jobs, and while you can invent all of your own functions, knowing how to use the built-in functions can save you time and frustration. In this course, Excel Statistics and Finance Function Playbook, you will get an in-depth look at common statistics and finance functions in Excel. First, you will learn the SUMIFS, AVERAGEIFS, and COUNTIFS functions. Next, you will discover the NPV, FV, and PV functions. Finally, you will explore how to apply these functions in various real-life scenarios. When you’re finished with this course, you will have the skills and knowledge of excel statistics and finance functions needed to create accurate reports and compare financial scenarios.
Author Name: Craig Golightly
Author Description:
Craig is passionate about solving problems with the right tools. He has over 20 years of software development experience with large enterprises and small startups on everything from search engines to fighter jets. He has a bachelor’s and master’s degree in computer science with extensive experience in AWS, microservices, and artificial intelligence. Craig enjoys teaching and mentoring others so they can save time and accomplish their goals faster.

Table of Contents

• Course Overview
  1min
• Using the SUMIFS Function
  18mins
• Using the AVERAGEIFS Function
  17mins
• Using the COUNTIFS Function
  18mins
• Using the NPV Function
  12mins
• Using the FV Function
  8mins
• Using the PV Function
  8mins