Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365)
PAYBACK Punkte
14 °P sammeln!
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 com...
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
Andere Kunden interessierten sich für
