August 2025
Intermediate
1h 6m
English
Closed Captioning available in German, English, Spanish, French, Italian, Japanese
Overview
Financial and Statistical Functions helps you build strong skills in using Excel 365 for financial management and statistical analysis. You will learn how to calculate loans, project savings, forecast trends, and interpret data patterns with precision. Whether you want to improve your business decisions or manage personal finances more effectively, this learning experience provides clear, practical guidance.
You will work with key financial functions such as PMT, IPMT, and PPMT to calculate loan payments, break them into interest and principal portions, and plan repayment strategies. The SLN function will be used to compute straight-line depreciation, giving you an accurate view of asset value over time. For forecasting, you’ll apply tools like FORECAST.LINEAR, TREND, and the forecast sheet wizard to predict future values from historical data.
On the statistical side, you’ll explore NORM.DIST and NORM.INV to analyze distributions, calculate percentiles, and assess variability using measures like standard deviation and quartiles. You’ll also gain experience with LINEST for linear regression and the Solver tool for tackling complex financial problems.
Throughout the course, practical exercises will guide you in building real-world solutions for budgeting, sales projections, and inventory planning. By the end, you will be equipped to manage complex calculations, generate accurate forecasts, and analyze data effectively. These are valuable skills that strengthen both professional projects and personal financial planning.
In this course, you'll learn how to:
The following files are included in the Resources section below:
Exercise Files - Used to practice and complete the course exercises.
Course Files - Used to follow along with the instructor during lessons.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.