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