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
Craig has over 15 years of software development on a variety of teams, including Fidelity.com, Overstock.com, F-16 aircraft, and several startups. Craig is passionate about solving problems with the right tools and enjoys teaching and mentoring others so they can save time and accomplish their goals faster.
Course Overview (Music) Hi everyone. My name is Craig Golightly, and welcome to my course, Excel Statistics and Finance Function Playbook. I am a senior software consultant. Statistics functions make reporting easy, and finance functions can help you compare different investment options and calculate loan payments. Whether you are just getting started or need a refresher for a few functions, this course is designed for you as an easy reference for statistics and finance functions in Excel. You will learn function syntax, pitfalls to avoid, best practices to follow, and see examples of the functions in action. We will cover the following Excel functions: SUMIFS, AVERAGEIFS, COUNTIFS, NPV, FV, and PV. By the end of this course, you will understand where and how to use these functions in your Excel spreadsheets. Before beginning the course, you should be familiar with Excel. From here, you should feel comfortable continuing to other Excel courses such as Excel Logic Function Playbook, Managing Excel Workbooks for Analytics. I hope you'll join me on this journey to learn about statistics and finance functions in Excel with the Excel Statistics and Finance Function Playbook course, at Pluralsight.