Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Financial and Statistical Functions: Learn Excel 365
Financial and Statistical Functions
Course Introduction (1:37)
DOWNLOAD ME: Course Files
DOWNLOAD ME: Exercise Files
Personal Financial Functions (5:22)
Personal Financial Functions Exercise (3:29)
Calculating Interest Payments Using the PMT, PPMT & IPMT Functions (4:20)
Calculating the Depreciation Per Year with the SLN Function (5:40)
Forecasting Terminology and Functions: SLOPE, INTERCEPT, FORECAST.LINEAR, and TREND (12:00)
One Click Forecasting (5:02)
Using the NORM.DIST and NORM.INV Functions to Calculate Probability (5:00)
Using STDEV.S, STDEV.P and QUARTILE.INC to Measure Dispersion (5:51)
Statistical Functions Exercise (1:36)
Using the LINEST Functions for Linear Regressions (6:11)
Using the Solver Program (5:54)
Solver Program Exercise (2:57)
Course Conclusion (1:42)
Course Quiz and Certificate of Completion
Course Quiz
Calculating the Depreciation Per Year with the SLN Function
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock