If you? Ve never quite catch formulas and functions, Paul McFedries will radically expand your understanding and use of Excel. Duff, Duffbert? S Random Musings, http://www.twduff.com Develop your Microsoft Excel expertise instantly with proven techniques Master Excel Ranges Create Powerful Arrays Troubleshooting Data Validation Formula Worksheet Perform What-If Analysis Model Track Your Business Trends and Make Forecasts Analyze Data Find Optimal Solutions Build Dynamic Loan Schedules Most users of Microsoft Excel learn only a small part of this program? Features. Throughout your book? Will find-nonsense, tutorials step-by-step and a lot of practical examples aimed directly at business users. ? Focus 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. ? Provides many real world examples and techniques to help you learn and understand the importance of each part. Introduction 1 Getting the Most Out Range 2 Using Range Names 3 Building Basic Formulas 4 Creating Advanced Formulas 5 Troubleshooting Formulas II Harnessing the Power Function 6 Understanding Functions 7 Working with Text Functions 8 Working with Logical and Information Functions 9 Working with Lookup Functions 10 Working with Date and Time Functions 11 Working with Math Functions 12 Working with Statistical Functions III Building Business Models 13 Analyzing Data with Tables 14 Analyzing Data with PivotTables 15 Using Excel? S Business-Modeling Tools 16 Using Regression to Track Trends and Make Forecasts 17 Solving Complex Problems with Solver IV Building Financial Formulas 18 Building Loan Formulas Building Investment Formulas 19 20 Building Discount Formulas Paul McFedries is known as a teacher of Windows and Office, particularly Excel, and is the president Logophilia Limited, a technical writing company. These books include Microsoft Office Access 2007 Forms, Reports, Queries, Tricks Microsoft Office 2007 Gurus (all from Que), and Microsoft Windows Vista Unleashed (Sams). Category Office Productivity Suite Covers Microsoft Office Excel 2007 User Level Intermediate - Advanced