Excel Statistics and Finance Function Playbook
Offered By: Pluralsight
Course Description
Overview
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.
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
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
Taught by
Craig Golightly
Related Courses
Top Excel Formulas for Accounting and Finance! Become more efficient at your job! Vlookup | FiltersSkillshare Excel Spreadsheet Formulas - Old School or Dynamic Arrays?
ExcelIsFun via YouTube Average, Moving Average at Different Granularity - DAX or Excel Formulas
ExcelIsFun via YouTube Average of Customer Total Sales by Product - Formulas, DAX or Array Formula?
ExcelIsFun via YouTube Standard Deviation with Criteria - Power Query, PivotTable, or Array Formula
ExcelIsFun via YouTube