Chapter 3: Formulas and Functions – Completing Modeling Tasks with a Single Formula
One of the first things that makes Excel more than a glorified electronic calculator is its use of functions and formulas. This feature allows Excel to combine a number of mathematical tasks—some of which can be quite complex—into a single function.
In this chapter, you will learn how to use formulas and will understand a selection of the most widely used functions.
The following topics will be covered in this chapter:
- Understanding functions and formulas
- Working with lookup functions
- Utility functions
- Pivot tables and charts
- Pitfalls to avoid
- New functions in Excel 365
Understanding functions and formulas
In order to enter either a formula or a function, ...
Get Hands-On Financial Modeling with Excel for Microsoft 365 - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
