×
5 Lessons
10 Lessons

Spreadsheet Management

The Spreadsheet Management Lessons offers comprehensive training in electronic spreadsheet usage, covering essential skills and advanced functions. Students will gain proficiency in navigating spreadsheets, entering and manipulating data, utilizing formulas and functions, creating macros, formatting worksheets, working with charts and graphics, and protecting worksheet integrity.

13 Lessons
15 Lessons
💰 Using Financial Functions: Unlocking Financial Analysis 💸
In this lesson, you’ll learn how to use Excel’s financial functions to perform a range of financial calculations. From the PMT, FV, PV, IRR, and NPV functions, we’ll cover their purpose, how they are used, and when to apply them in real-world scenarios.
Topics covered:
Understanding Excel’s financial functions
Performing financial calculations using PMT, FV, PV, IRR, and NPV functions