Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365) |
|
Author:
| McFedries, Paul |
Series title: | Business Skills Ser. |
ISBN: | 978-0-13-755940-4 |
Publication Date: | Apr 2022 |
Publisher: | Pearson Education
|
Imprint: | Microsoft Press |
Book Format: | Paperback |
List Price: | USD $44.99 |
Book Description:
|
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:
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