Switch content of the page by the Role togglethe content would be changed according to the role
![](https://www.pearson.com/store//pmccommercewebservices/v2/medias/size-W370-A1030-00-26-99-A103000269978-A103000269978-Lrg.jpg?context=bWFzdGVyfGltYWdlc3wxMzM2ODJ8aW1hZ2UvanBlZ3xzeXMtbWFzdGVyL2ltYWdlcy9oNjEvaDk0LzEyOTk2NzQ0NzczNjYyL3NpemVfVzM3MF8vQTEwMzAvMDAvMjYvOTkvQTEwMzAwMDI2OTk3OC9BMTAzMDAwMjY5OTc4X0xyZy5qcGd8ZmYxNmRjZGEyMzEzZWNlMzYxMWVhMzVjZDkwY2NlMWM1M2VmOGRmMDk3MDdmNDk5MTY0ZDZhYjAxNzk2NzkyNg)
Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365), 1st edition
Published by Microsoft Press (March 25, 2022) © 2022
- Paul McFedries
- Available for purchase from all major ebook resellers, including InformIT.com
$35.99
Price Reduced From: $44.99
Details
- A print text
- Free shipping
- Also available for purchase as an ebook from all major ebook resellers, including InformIT.com
This product is expected to ship within 3-6 business days for US and 5-10 business days for Canadian customers.
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
Need help? Get in touch