<p>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!</p><p>By reading this book, students will:</p><ul><li>Improve business analyses by adding intelligence and knowledge to their models</li><li>Replace cumbersome formulas with convenient predefined functions</li><li>Radically simplify complex calculations with Office 365's new dynamic arrays</li><li>Use conditional formatting to reveal anomalies, problems, or opportunities</li><li>Calculate loan payments, interest costs, terms, and amortization schedules</li><li>Project the future value of investments, and plan to achieve investment goals</li><li>Master essential discounting and cash-flow analysis tools, including net present value and internal rate of return</li><li>Sort, filter, and analyze tabular data, from customers to inventory</li><li>Easily analyze huge data sets with PivotTable calculations</li></ul>

<div>Part 1: Mastering Excel formulas</div><div><br></div><div>Chapter 1: Building basic formulas</div><div><br></div><div>Chapter 2: Creating advanced formulas</div><div><br></div><div>Chapter 3: Troubleshooting formulas</div><div><br></div><div>Part 2: Harnessing the power of functions</div><div><br></div><div>Chapter 4: Understanding functions</div><div><br></div><div>Chapter 5: Working with text functions</div><div><br></div><div>Chapter 6: Working with logical and information functions</div><div><br></div><div>Chapter 7: Working with lookup functions</div><div><br></div><div>Chapter 8: Working with date and time functions</div><div><br></div><div>Chapter 9: Working with math functions</div><div><br></div><div>Part 3: Building business formulas</div><div><br></div><div>Chapter 10: Implementing basic business formulas</div><div><br></div><div>Chapter 11: Building descriptive statistical formulas</div><div><br></div><div>Chapter 12: Building inferential statistical formulas</div><div><br></div><div>Chapter 13: Applying regression to track trends and make forecasts</div><div><br></div><div>Chapter 14: Building loan formulas</div><div><br></div><div>Chapter 15: Working with investment formulas</div><div><br></div><div>Chapter 16: Building discount formulas</div><div><br></div><div>Part IV: Building business models</div><div><br></div><div>Chapter 17: Analyzing data with tables</div><div><br></div><div>Chapter 18: Analyzing data with PivotTables</div><div><br></div><div>Chapter 19: Using Excel's business modeling tools</div><div><br></div><div>Chapter 20: Solving complex problems with Solver</div>

Paul McFedries

Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365)

A digital version of the text you can personalize and read online or offline.

eTextbook

This product is a bound, printed text book.

Print

Paperback

Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365), 1st edition

VitalSource eTextbook

Paperback