Front Cover -- Copyright -- Table of Contents -- Dedication -- About the Author -- Foreword -- The Excel Environment -- Find Icons on the Ribbon -- Seriously, I Really Can't Find This -- Where Are My Macros? -- What Happened to Tools, Options? -- Customizing the Ribbon -- Go Wide -- Minimize the Ribbon to Make Excel Feel a Bit More Like Excel 2003 -- Use a Wheel Mouse to Scroll Through The Ribbon Tabs -- Why Do The Charting Ribbon Tabs Keep Disappearing? -- Use Dialog Launchers to Access the Excel 2003 Dialog -- Icon, Dropdowns, and Hybrids -- All Commands Start at the Top (Except for 2 Controls at the Bottom) -- Make Your Most-Used Icons Always Visible -- The Alt Keystrokes Still Work in 2010 (If You Type Them Slowly Enough) -- Use New Keyboard Shortcuts to Access the Ribbon -- Why Do I Have Only 65,536 Rows? -- Which File Format Should I Use? -- Share Files with People Who Are Still Using Excel 97 Through Excel 2003 -- Why Does The File Menu Cover The Entire Screen? -- How Do I Close The File Menu? -- Increase the Number of Workbooks in the Recent Documents List -- I Just Want The Old Print Preview Back -- Change All Print Settings in Excel 2010 -- Use Live Preview -- Get Quick Access to Formatting Options Using the Mini Toolbar -- What Is Protected Mode? -- Use a Trusted Location to Prevent Excel's Constant Warnings -- My Manager Wants Me to Create a New Expense Report from Scratch -- Open a Saved File Whose Name You Cannot Recall -- Open a Copy of a Workbook -- Excel'S Obsession with Security Has Hampered Linked Workbooks -- Use a Workspace to Remember What Workbooks to Open -- Open Excel with Ctrl+Alt+X -- Have Excel Always Open Certain Workbook(s) -- Set up Excel Icons to Open a Specific File on Startup -- Use a Macro to Customize Startup -- Control Settings for Every New Workbook and Worksheet.

Automatically Move the Cell Pointer in a Direction After Entering a Number -- Return to the First Column After Typing the Last Column -- Enter Data in a Circle (Or Any Pattern) -- How to See Headings as You Scroll Around a Report -- How to See Headings and Row Labels as You Scroll Around a Report -- I Navigate by Sliding the Scrollbar and Now the Slider Has Become Tiny -- Jump to the Edge of the Data -- Jump to Next Corner of Selection -- Zoom with the Wheel Mouse -- Copy a Formula to All Data Rows -- Copy the Characters from a Cell ­Instead of Copying an Entire Cell -- A Faster Way To Paste Special -- Hide the Paste Options in Excel 2007 -- Quickly Turn a Range on Its Side -- Quickly Rearrange Rows Or Columns -- Copy Cells from One Worksheet to Many Other Worksheets -- Quickly Copy Worksheets -- Find Text Numbers -- Why Can't Excel Find a Number? -- Mix Formatting In A Single Cell -- Enter a Series of Months, Days, or More by Using the Fill Handle -- Have the Fill Handle Fill Your List of Part Numbers -- Teach Excel to Fill A, B, C -- Use Excel as a Word Processor -- Add Excel to Word -- Use Hyperlinks to Create an Opening Menu for a Workbook -- Arrange Windows to See Two or More Open Workbooks -- Compare Two Worksheets Side by Side -- Spell check a Region -- Stop Excel from AutoCorrecting Certain Words -- Use AutoCorrect to Enable a Shortcut -- Why Won't the Track Changes Feature Work in Excel? -- Translate with Excel -- I am a Lobbyist Writing Policy Papers for the White House -- How to Print Titles at the Top of Each Page -- Print a Letter at the Top of Page 1 and Repeat Headings at the Top of Each Subsequent Page -- How to Print Page Numbers at the Bottom of Each Page -- How to Make a Wide Report Fit to One Page Wide by Many Pages Tall -- Add a Printable Watermark -- Print Multiple Ranges.

Add a Page Break at Each Change in Customer -- Save My Worksheet as a PDF File -- Send an Excel File as an Attachment -- Save Excel Data as a Text File -- Use a Laser Printer to Have Excel Calculate Faster -- Close All Open Workbooks -- I Just Closed an Unsaved Workbook -- Roll Back to an AutoSaved Version -- Have Excel Talk to You -- Enter Special Symbols -- What Do All the Triangles Mean? -- Why does Excel Insert Cell Addresses When I Edit In a RefEdit Box? -- Beware of Excel Starter -- Edit your Excel Workbooks on the Web -- Collaborate in an Excel Workbook -- Embed Your Dashboard in a Blog Post -- Print all Excel Keyboard Shortcuts -- Get Free Excel Help -- CALCULATING WITH EXCEL -- Start a Formula with = or + -- Three Methods of Entering Formulas -- Use Parentheses to Control the Order of Calculations -- Long Formulas in the Formula Bar -- Copy a Formula That Contains Relative References -- Copy a Formula While Keeping One Reference Fixed -- Create a Multiplication Table -- Calculate a Sales Commission -- Simplify the Entry of Dollar Signs in Formulas -- Learn R1C1 Referencing to Understand Formula Copying -- Create Easier-to-Understand Formulas with Named Ranges -- Use Named Constants to Store Numbers -- Total Without Using a Formula -- Add or Multiply Two Columns Without Using Formulas -- Join Two Text Columns -- Join Text with a Date or Currency -- Sort on One Portion of an Account ID -- How to Isolate the Center Portion of an Account ID -- How to Isolate Everything Before a Dash in a Column by Using Functions -- How to Use Functions to Isolate Everything After a Dash in a Column -- How to Use Functions to Isolate Everything After the Second Dash in a Column -- How to Separate a Part Number into Three Columns -- Excel Is Randomly Parsing Pasted Data -- I Lose Leading Zeroes From CSV Files.

Open CSV File With Dates in D/M/Y Format -- Parse Data With Leader Lines -- Parse Multi-Line Cells -- Change Smith, Jane to Jane Smith -- Convert Numbers to Text -- Fill a Cell with Repeating Characters -- CLEAN Hasn't Kept Up With The Times -- Add the Worksheet Name as a Title -- Use AutoSum to Quickly Enter a Total Formula -- AutoSum Doesn't Always Predict My Data Correctly -- Use the AutoSum Button to Enter Averages, Min, Max, and Count -- Ditto The Formula Above -- The Count Option of the AutoSum Dropdown Doesn't Appear to Work -- Total the Red Cells -- Automatically Number a List of Employees -- Discover New Functions Using the fx Button -- Get Help on Any Function While Entering a Formula -- Yes, Formula Autocomplete Is Cool, if You Can Stop Entering the Opening Parentheses -- Use F9 in the Formula Bar to Test a Formula -- Quick Calculator -- When Entering a Formula, You Get the Formula Instead of the Result -- You Change a Cell in Excel but the Formulas Do Not Calculate -- Calculate One Range -- Why Use the Intersection Operator? -- Find the Longest Win Streak -- Add B5 On All Worksheets -- Consider Formula Speed -- Exact Formula Copy -- Calculate a Loan Payment -- Calculate Many Scenarios for Loan Payments -- Back into an Answer Using Goal Seek -- Create an Amortization Table -- Do 40 What-if Analyses Quickly -- What-If For 3 Or More Variables -- Rank Scores -- Rank a List Without Ties -- Sorting with a Formula -- Round Numbers -- Round to the Nearest 0.05 with MROUND -- Round Prices to the Next Highest 5 -- Round 0.5 towards Even Per ASTM-E29 -- Separate the Integer From the Decimals -- Why Is This Price Showing 27.85000001 Cents? -- Calculate a Percentage of Total -- Calculate a Running Percentage of Total -- Use the ^ Sign for Exponents -- Raise a Number to a Fraction to Find the Square or Third Root.

Calculate a Growth Rate -- Find the Area of a Circle -- Figure Out Lottery Probability -- Help Your Kids with Their Math -- Convert Units -- Match Web Colors with HEX2DEC -- Find the Second Largest Value -- Format Every Other Row in Green -- Use IF to Calculate a Bonus -- IF with Two Conditions -- Tiered Commission Plan with IF -- Display Up/Down Arrows -- Stop Showing Zeroes in Cell Links -- Calculate Sales Over Quota -- Count Records That Match a Criterion -- Build a Table That Will Count by Criteria -- Sum Records That Match a Criterion -- Can the Results of a Formula Be Used in SUMIF? -- Calculate Based on Multiple Conditions -- Avoid Errors Using IFERROR -- Multiple Conditions Using SUMPRODUCT -- Use VLOOKUP to Join Two Tables -- Every VLOOKUP Ends in False -- Lookup Table Does Not Have to Be Sorted -- Beware of #N/A from VLOOKUP -- Add New Items to the Middle Of Your Lookup Table -- Consider Naming the Lookup Table -- Remove Leading and Trailing Spaces -- Your Lookup Table Can Go Across -- Copy a VLOOKUP Across Many Columns -- INDEX Sounds Like AN Inane Function -- You Already Know MATCH, Really! -- INDEX Sounds Like an Inane Function - II -- VLOOKUP Left -- Fast Multi-Column VLOOKUP -- Return the Next Larger Value in a LOOKUP -- Two-Way Lookup -- Combine Formulas into a Mega-Formula -- Combine Two Lists Using VLOOKUP -- Watch for Duplicates When Using VLOOKUP -- Return the Last Entry -- Return the Last Matching Value -- Sum All of the LOOKUPs -- Embed a Small Lookup Table In Formula -- I Don't Want to Use a Lookup Table to Choose One of Five Choices -- Lookup Two Values -- Add Comments to a Formula -- Create Random Numbers -- Randomly Sequence a List -- Play Dice Games with Excel -- Generate Random Without Repeats -- Calculate a Moving Average -- Calculate a Trendline Forecast -- Build a Model to Predict Sales Based on Multiple Regression.

Measure the Accuracy of a Sales Forecast.