The perennial bestseller, updated for Excel 2007. Equally valuable for beginners and power users, this book is packed with examples, techniques, and tips from Mr. Spreadsheet. Here"s how to: Understand formulas, functions, tables, worksheets, and workbooks. Explore unlimited conditional formatting. Develop custom functions and create UserForms. Analyze data with external database files and pivot tables. Enhance worksheets with SmartArt tools. Customize the Quick Access Toolbar to save time. Create killer formulas that let you do more. If you know Excel basics, Mr. Spreadsheet can help you create financial formulas, develop custom worksheet functions, and greatly extend Excel"s capabilities. You can: Release the power of array formulas. Master operators, error values, and absolute vs. relative references. Find errors and debug your formulas. ...