Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365)

Paul McFedries' step-by-step projects walk students 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 students leverage Excel's most useful functions in their everyday work. Becoming an Excel expert has never been easier! By reading this book, students will:

- Improve business analyses by adding intelligence and knowledge to their models

- Replace cumbersome formulas with convenient predefined functions

- Radically simplify complex calculations with Office 365's new dynamic arrays

- Use conditional formatting to reveal anomalies, problems, or opportunities

- Calculate loan payments, interest costs, terms, and amortization schedules

- Project the future value of investments, and plan to achieve investment goals

- Master essential discounting and cash-flow analysis tools, including net present value and internal rate of return

- Sort, filter, and analyze tabular data, from customers to inventory

- Easily analyze huge data sets with PivotTable calculations