John Walkenbach's Favorite Excel 2010 Tips and Tricks

Build robust Excel 2010 apps quickly and efficiently

Known as "Mr. Spreadsheet," John Walkenbach's name is synonymous with excellence in computer books that explain the complexities of various topics. With this collection of favorite Excel tips and tricks, you get a unique look at ways to make Excel 2010 more efficient than you ever imagined.

Packed with easy-to-understand advice regarding all aspects of Excel, this book shares improved ways of speeding up application development with Excel and maximizing the power of Excel to create robust applications.

• Addresses the extensive changes to the 2010 version of Excel and shares tricks and shortcuts for making your Excel experience as successful and efficient as possible
• Reveals ways to deal with function arguments, create "impossible" charts, and tame the Ribbon bar
• Discusses absolute vs. relative references, change data entry orientation, and sort more than three columns
• Demonstrates ways to enter fake data for testing purposes

With John Walkenbach's Favorite Excel 2010 Tips and Tricks, you'll get a jump start on mastering the extensive changes to the 2010 version of Excel.

(Computer Bookshops Limited)

Bli först med att recensera och betygsätt boken John Walkenbach's Favorite Excel 2010 Tips and Tricks - du kan vinna 200 kr varje månad i tävlingen "Månadens recension".

John Walkenbach, arguably the foremost authority on Excel, has written hundreds of articles and created the award-winning Power Utility Pak. His 50-plus books include Excel 2010 Power Programming with VBA, Excel 2010 Formulas, and the Excel 2010 Bible, all published by Wiley. Visit his popular Spreadsheet Page at spreadsheetpage.com.

(Computer Bookshops Limited)

Introduction.

Part I: Basic Excel Usage.

Tip 1: Understanding Excel Versions.

Tip 2: Maximizing Ribbon Efficiency.

Tip 3: Understanding Protected View.

Tip 4: Selecting Cells Efficiently.

Tip 5: Making "Special" Range Selections.

Tip 6: Undoing, Redoing, and Repeating.

Tip 7: Discovering Some Useful Shortcut Keys.

Tip 8: Navigating Sheets in a Workbook.

Tip 9: Resetting the Used Area of a Worksheet.

Tip 10: Understanding Workbooks versus Windows.

Tip 11: Customizing the Quick Access Toolbar.

Tip 12: Customizing the Ribbon.

Tip 13: Accessing the Ribbon with Your Keyboard.

Tip 14: Recovering Your Work.

Tip 15: Customizing the Default Workbook.

Tip 16: Using Document Themes.

Tip 17: Hiding User Interface Elements.

Tip 18: Hiding Columns or Rows.

Tip 19: Hiding Cell Contents.

Tip 20: Taking Pictures of Ranges.

Tip 21: Performing Inexact Searches.

Tip 22: Replacing Formatting.

Tip 23: Changing the Excel Color Scheme.

Tip 24: Limiting the Usable Area in a Worksheet.

Tip 25: Using an Alternative to Cell Comments.

Tip 26: Understanding the Excel Help System.

Tip 27: Making a Worksheet "Very Hidden".

Tip 28: Working with the Backstage View.

Part II: Data Entry.

Tip 29: Understanding the Types of Data.

Tip 30: Moving the Cell Pointer after Entering Data.

Tip 31: Selecting a Range of Input Cells before Entering Data.

Tip 32: Using AutoComplete to Automate Data Entry.

Tip 33: Removing Duplicate Rows.

Tip 34: Keeping Titles in View.

Tip 35: Automatically Filling a Range with a Series.

Tip 36: Working with Fractions.

Tip 37: Resizing the Formula Bar.

Tip 38: Proofing Your Data with Audio.

Tip 39: Controlling Automatic Hyperlinks.

Tip 40: Entering Credit Card Numbers.

Tip 41: Using the Excel Built-In Data Entry Form.

Tip 42: Customizing and Sharing AutoCorrect Entries.

Tip 43: Restricting Cursor Movement to Input Cells.

Tip 44: Controlling the Office Clipboard.

Tip 45: Creating a Drop-Down List in a Cell.

Part III: Formatting.

Tip 46: Using the Mini Toolbar.

Tip 47: Indenting Cell Contents.

Tip 48: Quick Number Formatting.

Tip 49: Creating Custom Number Formats.

Tip 50: Using Custom Number Formats to Scale Values.

Tip 51: Using Custom Date and Time Formatting.

Tip 52: Examining Some Useful Custom Number Formats.

Tip 53: Updating Old Fonts.

Tip 54: Understanding Conditional Formatting Visualization.

Tip 55: Showing Text and a Value in a Cell.

Tip 56: Merging Cells.

Tip 57: Formatting Individual Characters in a Cell.

Tip 58: Displaying Times That Exceed 24 Hours.

Tip 59: Fixing Non-Numeric Numbers.

Tip 60: Adding...

(Computer Bookshops Limited)