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