About the Book :
Whether youre just discovering Excel or are already a power user, theres no better instructor than "Mr. Spreadsheet," John Walkenbach. From basic formulas, functions, and chart creation to data analysis, custom number formats, data validation, and Excel programming with VBA, this is the comprehensive resource for Excel 2007. No matter what your level of expertise, youll benefit from hundreds of examples, exercises, tips, techniques, and workarounds. Learn your way around cells, rows, columns, worksheets, workbooks, and rangesDiscover how to create charts and diagrams, organize lists, and simplify complex tasks using ExcelDevelop formulas that manipulate text, look up values, and perform financial applicationsAnalyze data using external database files and pivot tablesUse XML to facilitate data reporting, analysis, importing, and exportingExplore conditional formatting, link and consolidate worksheets, and use Excel in a workgroupUnderstand how Excel uses HTML in Internet applicationsProgram Excel using VBA, develop UserForms, and create custom add-ins
About the Author :
John Walkenbach principal of J-Walk and Associates, Inc. is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 30 books and 300 articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at www.j-walk.com/ss and promotes all his books at that site.
Interesting Facts :
HISTORIC BESTSELLER: Excel Bible is a perennial bestseller. The 2003 Edition has sold over 90,000 units.NAME RECOGNITION OF AUTHOR: John Walkenbachs name is synonymous with excellence in computer books that explain the complexities of the worlds leading digital business tool. John Walkenbach, known as Mr. Spreadsheet, is author of more than 30 books. His web site on Excel is the most frequently visited Excel site after Microsoft. The authors previous books, including Excel 2003 Bible, Excel 2003 Power Programming with VBA and Excel 2003 Formulas, consistently appear at the top of many bestseller lists.FULLY UPDATED: This edition of Excel Bible covers all the new features of Excel 2007, including how to navigate through the new user interface, how to maximize the advantages of the new file formats, and how to maximize all the new features of this revolutionary upgrade of Microsoft Office.DOMINANT SPREADSHEET TOOL: Microsoft Office Excel is the dominant spreadsheet application for the Windows platform. It is an indispensable business tool.VALUABLE CD: The CD contains all the templates and worksheets used in the book plus John Walkenbachs award-winning Power Utility Pak.
AcknowledgmentsIntroductionPart I: Getting Started with ExcelChapter 1: Introducing ExcelChapter 2: Whats New in Excel 2007?Chapter 3: Entering and Editing Worksheet DataChapter 4: Essential Worksheet OperationsChapter 5: Working with Cells and RangesChapter 6: Introducing TablesChapter 7: Worksheet FormattingChapter 8: Understanding Excels FilesChapter 9: Using and Creating TemplatesChapter 10: Printing Your WorkPart II: Working with Formulas and FunctionsChapter 11: Introducing Formulas and FunctionsChapter 12: Creating Formulas That Manipulate TextChapter 13: Working with Dates and TimesChapter 14: Creating Formulas That Count and SumChapter 15: Creating Formulas That Look Up ValuesChapter 16: Creating Formulas for Financial ApplicationsChapter 17: Introducing Array FormulasChapter 18: Performing Magic with Array FormulasPart III: Creating Charts and GraphicsChapter 19: Getting Started Making ChartsChapter 20: Learning Advanced ChartingChapter 21: Visualizing Data Using Conditional FormattingChapter 22: Enhancing Your Work with Pictures and DrawingsPart IV: Using Advanced Excel FeaturesChapter 23: Customizing the Quick Access ToolbarChapter 24: Using Custom Number FormatsChapter 25: Using Data ValidationChapter 26: Creating and Using Worksheet OutlinesChapter 27: Linking and Consolidating WorksheetsChapter 28: Excel and the InternetChapter 29: Sharing Data with Other ApplicationsChapter 30: Using Excel in a WorkgroupChapter 31: Protecting Your WorkChapter 32: Making Your Worksheets Error-FreePart V: Analyzing Data with ExcelChapter 33: Using Microsoft Query with External Database FilesChapter 34: Introducing Pivot TablesChapter 35: Analyzing Data with Pivot TablesChapter 36: Performing Spreadsheet What-If AnalysisChapter 37: Analyzing Data Using Goal Seek and SolverChapter 38: Analyzing Data with the Analysis ToolPakPart VI: Programming Excel with VBAChapter 39: Introducing Visual Basic for ApplicationsChapter 40: Creating Custom Worksheet FunctionsChapter 41: Creating UserFormsChapter 42: Using UserForm Controls in a WorksheetChapter 43: Working with Excel EventsChapter 44: VBA ExamplesChapter 45: Creating Custom Excel Add-InsPart VII: AppendixesAppendix A: Worksheet Function ReferenceAppendix B: Whats on the CD-ROMAppendix C: Additional Excel ResourcesAppendix D: Excel Shortcut KeysIndex