Excel Statistics and Finance Function Playbook

Focused View

Craig Golightly

1:26:07

102 View

01 - Course Overview

01 - Course Overview.mp4

01:27

02 - Using the SUMIFS Function

02 - Using the SUMIFS Function.mp4

02:43

03 - SUM, SUMIF, SUMIFS Comparison Examples.mp4

02:57

04 - SUMIFS Multiple Criteria Examples.mp4

03:12

05 - SUMFIS Cell Reference Examples.mp4

04:14

06 - SUMIFS Empty and Non-empty Cell Examples.mp4

01:19

07 - SUMIFS Wildcard Examples.mp4

04:10

03 - Using the AVERAGEIFS Function

08 - Using the AVERAGEIFS Function.mp4

03:25

09 - AVERAGE, AVERAGEIF, AVERAGEIFS Comparison Examples.mp4

02:06

10 - AVERAGEIFS Multiple Criteria Examples.mp4

03:52

11 - AVERAGEFIS Cell Reference Examples.mp4

03:00

12 - AVERAGEIFS Empty and Non-empty Cell Examples.mp4

01:14

13 - AVERAGEIFS Wildcard Examples.mp4

04:22

04 - Using the COUNTIFS Function

14 - Using the COUNTIFS Function.mp4

03:34

15 - COUNT, COUNTIF, COUNTIFS Comparison Examples.mp4

01:28

16 - COUNTIFS Multiple Criteria Examples.mp4

03:16

17 - COUNTIFS Cell Reference Examples.mp4

02:57

18 - COUNTIFS Empty and Non-empty Cell Examples .mp4

01:11

19 - COUNTIFS Wildcard Examples .mp4

06:06

05 - Using the NPV Function

20 - Using the NPV Function.mp4

03:42

21 - NPV Investment Examples.mp4

03:04

22 - NPV Different Time Period Examples.mp4

02:53

23 - NPV Capital Budgeting Examples.mp4

02:29

06 - Using the FV Function

24 - Using the FV Function.mp4

04:09

25 - FV Lump Sum and Payment Examples.mp4

02:09

26 - FV Time Period, Rate, and Type Examples.mp4

02:25

07 - Using the PV Function

27 - Using the PV Function.mp4

03:12

28 - PV Annuity Examples.mp4

01:56

29 - PV Savings Goal Examples.mp4

01:53

30 - PV Loan Amount Examples.mp4

01:42

Description

Save time and reduce errors by using the right functions in Excel. Statistics and finance functions can help you make quick work of reports and evaluations. Learn by example how to use the SUMIFS, AVERAGEIFS, COUNTIFS, NPV, FV, and PV functions.

What You'll Learn?

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. Software required: Excel

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Statistics

Excel

Craig Golightly

Instructor's Courses

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.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.