About the book

Use Excel 365 and Excel 2021 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including recent improvements ranging from dynamic arrays to XLOOKUP and LET. McFedries step-by-step projects walk you through handling key tasks, from building timesheets to projecting cash flow and aging receivables. His practical examples and clear instructions demystify intermediate-to-advanced-level formula construction, and help you leverage Excels most useful functions in your everyday work.

Contents:

Part I: Mastering Excel Formulas

1.  Building basic formulas
2. Creating advanced formulas
3. Troubleshooting formulas

Part II: Harnessing the power of Functions

4. Understanding functions
5. Working with text functions
6. Working with logical and information functions
7. Working with lookup functions
8. Working with date and time functions
9. Working with math functions

Part III: Building Business formulas

10. Implementing basic business formulas
11. Building descriptive statistical formulas
12. Building inferential statistical formulas
13. Applying regression to track trends and make forecasts
14. Building loan formulas
15. Working with investment formulas
16. Building discount formulas

Part IV: Building Business Models

17. Analyzing data with tables
18. Analyzing data with PivotTables
19. Using Excel’s business modeling tools
20. Solving complex problems with Solver