Mr. Spreadsheet's Excel 2007 Library

The perennial bestseller, updated for Excel 2007Equally 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 workbooksExplore unlimited conditional formattingDevelop custom functions and create UserFormsAnalyze data with external database files and pivot tablesEnhance worksheets with SmartArt toolsCustomize the Quick Access Toolbar to save timeCreate killer formulas that let you do moreIf 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 formulasMaster operators, error values, and absolute vs. relative referencesFind errors and debug your formulasEliminate formulas by using pivot tablesCreate single- and multi-cell array formulasUse VBA to build custom functionsExpand Excel with VBA, and feel the powerThis power-user's guide is packed with procedures, tips, and ideas for expanding Excel with Visual Basic for Applications.Mr. Spreadsheet helps you:Create powerful Excel applicationsEnhance Excel with VBA macrosExpand Excel's shortcut menusCustomize UserForms and develop new utilitiesWrite event-driven codeBuild user-friendly toolbars, menus, and help systemsGet acquainted with Excel 2007's all-new featuresThere's a new user interface, new open file formats, a larger worksheet grid, better use of memory, new functions and templates, and more.Learn to:Manage the RibbonDeal with function argumentsChange data entry orientationCreate a drop-down list in a cellConvert a vertical range to a tableChange the look of the entire programNobody knows Excel like Mr. Spreadsheet!Excel 2007 BibleExcel 2007 FormulasExcel 2007 Power Programming with VBAJohn Walkenbach's Favorite Excel 2007 Tips & TricksBonus CD-ROMAward-winning Power Utility Pak on CD-ROM!Mr. Spreadsheet's Excel 2007 Library also includes a full, licensed version of John Walkenbach's famous Power Utility Pak, updated for Excel 2007 and valued at $40 US. It's a valuable collection of add-ins, providing additional functionality that will make your life with Excel easier!Walkenbach, John is the author of 'Mr. Spreadsheet's Excel 2007 Library ', published 2007 under ISBN 9780470176542 and ISBN 0470176547.