{"product_id":"microsoft-365-excel-formulas-functions-for-dummies-isbn-9781394295517","title":"Microsoft 365 Excel Formulas \u0026 Functions For Dummies","description":"\u003cp\u003e\u003cb\u003eTurn Excel into an unstoppable data-and number-crunching machine\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eMicrosoft Excel is the Swiss Army knife of apps. With over 470 built-in functions and countless custom formulas, the program can help make you the smartest guy or gal in any room. And now that it's been supercharged with Copilot—Microsoft's AI-powered helper—it's even easier to produce accurate and useful results anywhere, anytime. \u003c\/p\u003e\u003cp\u003eBest of all, it doesn't take an advanced degree in mathematics or data science to take full advantage of Excel's functionality. Just grab a copy of this latest edition of \u003ci\u003eExcel Formulas \u0026amp; Functions For Dummies\u003c\/i\u003e and get a flying start on the Excel functions and formulas that power up your data superpowers. With this book, you'll: \u003c\/p\u003e\u003cul\u003e \u003cli\u003eLearn to create and use hundreds of formulas and functions, correct common mistakes, and make calculations\u003c\/li\u003e \u003cli\u003eDiscover how to analyze data and calculate statistics, and even work with dates and times\u003c\/li\u003e \u003cli\u003eUse the ever-evolving, AI-powered Copilot to expand Excel's functionality and make it easier to use\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eGet ready to transform your copy of Excel at home or at work into an unstoppable toolkit equipped for almost any occasion. Grab a copy of \u003ci\u003eExcel Formulas \u0026amp; Functions For Dummies\u003c\/i\u003e today! \u003c\/p\u003e\u003cp\u003eIntroduction 1\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 1: Getting Started with Excel Formulas and Functions 5\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Tapping into Formula and Function Fundamentals 7\u003c\/p\u003e \u003cp\u003eChapter 2: Saving Time with Function Tools 39\u003c\/p\u003e \u003cp\u003eChapter 3: Saying “Array!” for Formulas and Functions 57\u003c\/p\u003e \u003cp\u003eChapter 4: Fixing Formula Boo-Boos 71\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 2: Doing the Math 89\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 5: Calculating Loan Payments and Interest Rates 91\u003c\/p\u003e \u003cp\u003eChapter 6: Appreciating What You’ll Get, Depreciating What You’ve Got 111\u003c\/p\u003e \u003cp\u003eChapter 7: Using Basic Math Functions 127\u003c\/p\u003e \u003cp\u003eChapter 8: Advancing Your Math 145\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 3: Solving with Statistics 173\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 9: Throwing Statistics a Curve 175\u003c\/p\u003e \u003cp\u003eChapter 10: Rolling the Dice on Predictions and Probability 215\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 4: Dancing with Data 235\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 11: Dressing Up for Date Functions 237\u003c\/p\u003e \u003cp\u003eChapter 12: Keeping Well-Timed Functions 255\u003c\/p\u003e \u003cp\u003eChapter 13: Using Lookup, Logical, and Reference Functions 263\u003c\/p\u003e \u003cp\u003eChapter 14: Digging Up the Facts 295\u003c\/p\u003e \u003cp\u003eChapter 15: Writing Home about Text Functions 309\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 5: The Part of Tens 337\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 16: Ten Tips for Working with Formulas 339\u003c\/p\u003e \u003cp\u003eChapter 17: Ten Ways to Get Fancy with Excel 353\u003c\/p\u003e \u003cp\u003eChapter 18: Ten Really Cool Functions 359\u003c\/p\u003e \u003cp\u003eIndex 367\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eKen Bluttman\u003c\/b\u003e is a veteran developer specializing in Excel\/VBA and database-centric web applications. He has written many articles and books on topics including Office\/VBA development, XML, SQL Server, and InfoPath. Ken is the author of \u003ci\u003eExcel Charts For Dummies\u003c\/i\u003e and all previous editions of \u003ci\u003eExcel\u003c\/i\u003e\u003csup\u003e®\u003c\/sup\u003e \u003ci\u003eFormulas \u0026amp; Functions For Dummies\u003c\/i\u003e.   \u003c\/p\u003e\u003cp\u003e\u003cb\u003eWork smarter with powerful Excel\u003csup\u003e®\u003c\/sup\u003e features\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eIt’s important to have the right tool for any job. The Excel spreadsheet app is like a massive toolbox for your data, with more than 470 built-in functions. This book shows you how to use the most powerful formulas and functions to their fullest potential. With step-by-step instructions, examples, and expert tips, you’ll tackle basic calculations, advanced data analysis, and everything in between. Plus, make your spreadsheets smarter and your workflow smoother with the new AI-powered Copilot feature. Go beyond number crunching and make Excel work for you. \u003c\/p\u003e\u003cp\u003e\u003cb\u003eInside… \u003cul\u003e\n\u003cli\u003eTroubleshooting formulas\u003c\/li\u003e \u003cli\u003eVisualizing analysis results\u003c\/li\u003e \u003cli\u003eMaking financial calculations\u003c\/li\u003e \u003cli\u003eTesting statistical hypotheses\u003c\/li\u003e \u003cli\u003eManipulating text entries\u003c\/li\u003e \u003cli\u003eAdding conditional formatting\u003c\/li\u003e\n\u003c\/ul\u003e\u003c\/b\u003e\u003c\/p\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":47989622505701,"sku":"NP9781394295517","price":34.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781394295517.jpg?v=1761784846","url":"https:\/\/k12savings.com\/products\/microsoft-365-excel-formulas-functions-for-dummies-isbn-9781394295517","provider":"K12savings","version":"1.0","type":"link"}