Microsoft Excel 2010 Bible

If Excel can do it, John Walkenbach can show you how What better way to learn Excel 2010 than from ???Mr. Spreadsheet??? himself? Excel guru, Microsoft MVP, and author of all the previous top-selling editions of Excel Bible, John Walkenbach provides more than 1,000 pages packed with techniques, tips and tricks for beginners as well as Excel power users. Discover what's new in Excel 2010, learn shorcuts you didn't know, make the Ribbon interface work for you and master all the latest ins-and??outs with this must-have guide.

• Get up speed on everyhing new in Excel 2010
• Understand function, charts, worksheets, and workbooks
• Perform magic with array formulas- and even more with Sparklines
• Master ???what-it analysis, Goal Seeking, external database files, and pivot tables
• Develop custom function porgam with VBA and create Userforms
• Try new sllce-and dice tools to dynamically fillter your data

Table of Contents
Part I: Getting started with Excel

• Chapter I: Introducing Excel
• Chapter 2: Entering and Editing Worksheet Daia
• Chapter 3: Essential Worksheet Operations
• Chaptev 4: WoOdng wOth CON and Ranges
• Chapter 5: Introducing Tables
• Chapter 6: Worksheet Formatting
• Chapter 7: Understanding Excel Files
• Chapter 8: Using and Creating Templates
• Cha.piev 9: PHrtiling Your Work.

Part II: Working with Formulas and functions

• Chapter 10: introducing Hamm':las and honclions.
• Chapter 11: Creating Formias That Manipulate Text
• Chapter 12: Working with Dates and time
• Chapter 13: Creating Formulas That count
• Chapter 14: Creating Formulas That Look up values
• Chapter 15: Creating Formulas That Financial Appliction
• Chapter 16: Introducing Array Formulas
• Chapter 17: Performing Magic with Array Formulas

Part III: Creating Charts and Graphics

• Chapter 18: Getting Starting Making Charts
• Chapter 19: Learning Advanced Charting
• Chapter 20: Visualizing Data Using Conditional Fong
• Chapter 21: Creating SparMine Graphic
• Chapter 22: Enhancing Your Works with Pictures and Drawings

Part IV: Using Advanced Excel Features

• Chapter 23: Customizin the Excel User Interface
• Chapter 24: Using Custom Number Formats
• Chapter 25: Using Data Validation
• Chapter 26: Creating and Using Worksheet Outlines
• Chapter 27: linking and Consolidating Worksheets
• Chapter 28: Excel and the lnternet
• Chapter 29: Sharing Data with Other Office Applications
• Chapter 30: Using Excel in a Workgroup
• Chapter 31: Protecting Your Work
• Chaplet'. 32: Making Y ur Worksheets Error-Free

Part V: Analyzing Data with Excel

• Chapter 33: Getting Data From External Database Files
• Chapter 34: introducing Pivot Tabies
• Chapter 35: An2alyzing Data with Pivot Tables
• Chapter 36: PerforrrQing Spreadsheet What-If Analysis
• Chapter 37: Analyzing lata Using Goal Seeking and Solver
• Chapter 38: Analyzing Data with the Analysis To llPak

Part Vi: Programming Excel with VBA

• Chapter 39: Introducing Visual Basic for Applications
• Chapter 40: Creating Customs Worksheets Functions
• Chapter 41: Creating UserForms
• Chapter 42: Using User Form Ctntrols in a Worksheet
• Chapter 43: Working with Excel Events
• Chapter 44: VBA Examples
• Chapter 45: Creating Custom Excei Add-ins
top