Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365)
(Autor) Paul McFedriesPaul 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
Paul McFedries
Paul McFedries is a Canadian author known for his work in the technology and language sectors. He has written over 70 books on topics ranging from computing to language and has contributed to various publications such as PC Magazine and Scientific American. McFedries is known for his clear and concise writing style that makes complex topics accessible to readers of all levels.
One of his most notable works is "Word Spy," a book that explores the ever-evolving world of language and new words. McFedries has made significant contributions to the field of linguistics and technology with his insightful analysis and research. His work has had a lasting impact on both his literary genres, influencing how readers understand and interact with language and technology.
Other related
