{"product_id":"9780789736680","title":"Formulas and Functions with Microsoft Office Excel 2007 (Business Solutions Series)","description":"\u003cp\u003e“If you’ve never quite grasped formulas and functions, Paul McFedries will radically expand your understanding and use of Excel. And if you’re already an expert and you’re moving up to Excel 2007, this book will quickly show you features you’ve only dreamed of until now...”\u003c\/p\u003e\u003cp\u003e—Thomas ‘Duffbert’ Duff, Duffbert’s Random Musings, http:\/\/www.twduff.com\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eDevelop your Microsoft Excel expertise instantly with proven techniques\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003e Master Excel Ranges \u003c\/li\u003e \u003cli\u003e Create Powerful Arrays \u003c\/li\u003e \u003cli\u003e Troubleshoot Formula Problems \u003c\/li\u003e \u003cli\u003e Validate Worksheet Data \u003c\/li\u003e \u003cli\u003e Perform What-If Analysis \u003c\/li\u003e \u003cli\u003e Model Your Business \u003c\/li\u003e \u003cli\u003e Track Trends and Make \u003c\/li\u003e \u003cli\u003e Forecasts \u003c\/li\u003e \u003cli\u003e Analyze Data \u003c\/li\u003e \u003cli\u003e Find Optimal Solutions \u003c\/li\u003e \u003cli\u003e Build Dynamic Loan \u003c\/li\u003e \u003cli\u003e Schedules \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eMost Microsoft® Excel users learn only a small percentage of the program’s features. They know they could get more out of Excel if they could just get a leg up on building formulas and using functions. Unfortunately, this side of Excel appears complex and intimidating to the uninitiated—shrouded in the mysteries of mathematics, finance, and impenetrable spreadsheet jargon.\u003c\/p\u003e\u003cp\u003eSound familiar? If you’re a businessperson who needs to use Excel as an everyday part of your job, then you’ve come to the right book. Formulas and Functions with Microsoft® Office Excel 2007 demystifies worksheet formulas and presents the most useful Excel functions in an accessible, jargon-free way. This book not only takes you through Excel’s intermediate and advanced formula-building features, it also tells you why these features are useful to you and shows you how to use them in everyday situations. Throughout the book you’ll find no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e• Focuses like a laser on the four technologies that you must master to get the most out of Excel: ranges, formulas, functions, and data analysis tools.\u003c\/p\u003e\u003cp\u003e• Shuns spreadsheet theory in favor of practical know-how that you can put to use right away.\u003c\/p\u003e\u003cp\u003e• Provides numerous real-world examples and techniques to help you learn and understand the importance of each section.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eIntroduction\u003c\/p\u003e\u003cp\u003e1 Getting the Most Out of Ranges\u003c\/p\u003e\u003cp\u003e2 Using Range Names\u003c\/p\u003e\u003cp\u003e3 Building Basic Formulas\u003c\/p\u003e\u003cp\u003e4 Creating Advanced Formulas\u003c\/p\u003e\u003cp\u003e5 Troubleshooting Formulas\u003cbr\u003e II Harnessing the Power of Functions \u003c\/p\u003e\u003cp\u003e6 Understanding Functions\u003c\/p\u003e\u003cp\u003e7 Working with Text Functions\u003c\/p\u003e\u003cp\u003e8 Working with Logical and Information Functions\u003c\/p\u003e\u003cp\u003e9\u0026amp;nbs\u003c\/p\u003e","brand":"Que","offers":[{"title":"Default Title","offer_id":47015942553840,"sku":"9780789736680","price":39.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780789736680_p0.jpg?v=1763806541","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780789736680","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}