Front Cover -- Copyright -- Table of Contents -- About the Authors -- Dedication -- Acknowledgments -- Foreword -- Introduction -- Chapter 1 - Excel Basics -- Why Do We Need Excel? -- What 'Practical' Uses Does Excel Have? -- What Is the Intersection of a Row and Column Referred to As? -- What's a Workbook? -- How Many Worksheets Come in a Workbook? -- How Do I Insert New Worksheets into a Workbook? -- What's with the Masking Tape? -- How Can I QUICKLY Erase an Entire Sheet? -- How Can I QUICKLY Delete an Entire Sheet from the Workbook? -- How Would I Go about Deleting Several Cells at the Same Time? -- Can I Reset Some Cells in a Worksheet While Keeping Others? -- What Does 'Freeze Panes' Do? -- What Is the Native File Format for Excel? -- Typing Just Enough Characters to Fill a Cell, Then Moving to Next Cell -- I Can't Select the Right Cell -- My Laptop Screen Is Too Small. I Can't Manage to Click on the Right Cell -- How Can I Add More Rows or Columns to My Spreadsheet? -- What Allows Me to Access Popular Commands from Any Ribbon Tab? -- How Do I Use the Arrows Keys to Navigate More Efficiently? -- How Can I See a List of Worksheet Names, and Quickly Go to a Sheet If I Can't See Its Sheet Tab? -- How Can I Quickly Move between Several Excel Files That I Have Open? -- When Selecting a Range, the Corner That I Started in Is Not Also Highlighted -- How Do I Select a Large Area of Cells without Having to Click and Drag? -- Can I Cut and Paste Cells from One Worksheet into Another? -- Is It Possible to Change How Often Excel AutoSaves? -- How Do I Add Headers and Footers to My Worksheet When I Print It? -- Old School Print Titles at Top of Each Page -- How Do I Center My Work in Excel? -- Print to Blueprint Printer Then Reduce on Copier Three Times -- Chapter 2 - Formatting -- Is There a Way to Make a Sheet with Only a Few Cells and Columns?.

That Dotted Line Isn't There for Centering! -- How Do I Put the Path and File Name in the Footer? -- Word Wrap Woes -- How Can I Merge Multiple Cells into a Single Cell? -- How Can I Copy Cell Formatting? -- How Can I Remove Cell Formatting? -- Is It Possible to Change the Color of a Worksheet Tab? -- Can I Customize Color? -- All My Numbers Are Corrupt! -- Can I Delete Data from a Spreadsheet without Changing the Formatting? -- How Do I Set up Cells to Show Dollars and Cents? -- I Type 0345 in a Cell and Excel Changes It to 345 -- When I Enter 36.80, Excel Leaves off the Zero -- How Can I Show My Numbers as Thousands or Millions? -- How Can I Remove the Lines from Excel? -- How Can I Insert Rows or Columns within My Existing Data? -- Can I Make Part of the Text in a Cell Red? -- Can I Double Space Lines in Excel? -- Are There Any Other Formatting Tips? -- Chapter 3 - Formulas I -- When Is It OK to Use a Calculator with Excel? -- My Coworker Used an Adding Machine to Add a Column of 100 Numbers! -- How Do I Total All the Rows and Columns in My Table of Numbers? -- I Added up a Column of Numbers with a Formula of =A2+A3+A4+A5+A6+ A7+A8+A9+A10 -- How Can I Average a Set of Numbers? -- Can I Change the Default Setting for My AutoSum? -- Do I Have to Put the Sum Formula in the Same Row or Column as the Data? -- Can My Formula Be Open Ended to Accomodate New Numbers? -- How Can I Add up Numbers in One Column Depending on What Is in Another Column? -- My Numbers Aren't Adding up! -- Why Isn't AutoSum Working? -- Tab Tab Tab Tab Tab Tab. Shift-Tab Shift-Tab Shift-Tab Shift-Tab Shift-Tab Shift-Tab -- How Can I Use Excel as a Calculator? -- How Do I Write Equations Using Different Numbers in Different Cells? -- Using the QuickSum Instead of AutoSum -- Is There a Difference between Typing in the Cell Itself and Typing in the Formula Bar?.

How Do I Build a Formula? -- Is There a Way to Do Exponents in Excel? -- Why Doesn't the COUNT Function Count All Non-Blank Cells? -- Chapter 4 - More Advanced Topics -- What Are Some Useful Shortcut Keys? -- What Is a Simple Way to Compare Two Different Ranges of Data? -- What Does the Format Painter Do? -- Does Splitting One Worksheet Allow Me to Use One Spreadsheet as Two? -- Why Would I Ever Use the Shapes? -- How Can I Click a Cell That Has a Hyperlink, without Following the Link? -- Why Is There a Green Triangle in the Top Left of a Cell? -- How Can I Find or Replace an Asterisk or Question Mark on My Worksheet? -- How Do I Make a Cell Show an Abnormality in a Spreadsheet? -- How Do I Undo Conditional Formatting? -- What Are the Auto-Fill Options? -- How Can I Hide Some Columns? -- How Do I Unhide the Columns? -- How Do I Unhide One Column but Not the Others? -- How Can I Delete Rows with Blank Cells? -- I Need to Increase All Numbers in a Particular Column by 5? -- How Do I Set the Same Page Setup for All Sheets in My Workbook? -- What Are Cell Comments and When Should I Use Them? -- Can I Resize a Comment? -- Use Visible Comments to Guide the Person Using Your Worksheet -- Can I Change the Default Color of All Future Comments? -- Track Changes - What Does It Do, What Does It Not Do? -- Can I Require a Password to Open an Excel File? -- What to Do If I Forgot My Password for a Secured Workbook? -- How Do I Make My Workbook Read Only So It Can't Be Changed? -- Why Does Excel Ask Me to Save When Nothing Has Changed? -- What Is a Macro? -- What Is an Add-In? -- Can You Set up Data to Auto-Delete after a Certain Amount of Time Has Passed? -- Can Excel Talk? -- Chapter 5 - Charts -- How Do I Convert My Data into a Chart? -- How Do I Go about Setting up a Chart and a Table Simultaneously? -- Chapter 6 - Formulas II.

I Typed 12-13 in a Cell and Excel Changed It to December 13? -- I Want to Move to Level 3 -- How Can I Make Excel Round Numbers? -- I Have to Divide This Row by the Mean of All Rows -- How Can I Run Several Different Versions of a Calculation? -- How Can I Strip Away the Left or Right Part of a Cell? -- How Can I Separate People's First and Last Names? -- How Can I Fill Empty Cells with the Entry from Above? -- What Are Your Favorite Excel Functions? -- Why Don't the Formulas in My Workbook Re-calculate? -- Is There a Way to Find the Value of Data or Numbers in Several Different Spreadsheets? -- Excel Doesn't Recognize My Dates? -- Is It Possible to Make Excel Auto-Date? -- How Can I Set up Dates to Display the Way I Want after Importing? -- How Can I Combine a Date with Words in a Cell, and Make It Look like a Date? -- How Can I Add or Subtract Days, Months, or Years from a Date? -- Is It Possible to Find the Date for a Particular Day in Excel? -- How Can I Calculate Time and Show a Result That Makes Sense? -- Chapter 7 - Other Applications -- Can I Transfer Excel Files from Excel 2003 to Excel 2010? -- How Do I Import Files into Excel? -- How Can I Transfer Data from Excel to a Word Document? -- After I Transfer an Excel Range to PowerPoint, Can I Edit the Data? -- Chapter 8 - Every Way To -- Tell Me Every Way to … -- Tell Me Every Way to Change Column Widths -- Tell Me Every Way to Copy Cells -- Tell Me Every Way to Paste Cells -- Tell Me Every Way to Copy a Formula down a Column -- Tell Me Every Way to Convert Formulas to Values -- Tell Me Every Way to Total a Column -- Tell Me Every Way to Format Every Other Row -- Tell Me Every Way to Turn Data Sideways -- Chapter 9 - Data Analysis Intro -- Introduction to the Data Analysis Chapter -- How Do I Sort Data? -- What Is the Filter on the Data Tab? -- Why Can't I Filter to All of the Arizona Records?.

How Can I Get Just the Unique Items from a List? -- How Do I Remove Duplicates? -- My Boss Wants Me to Sort by Customer and Add Totals after Each Customer -- How Can I Bold the Numbers in My Subtotaled Data? -- What Is a Pivot Table? -- Chapter 10 - Formulas III -- How Can I Make a Decision in a Formula? -- What Is VLOOKUP and How Can I Use It? -- How Can I Look up a Value across a Row Instead of down a Column? -- How Can I Avoid Those Ugly Formula Errors like #DIV/0! and #N/A? -- How Do I Convert Numbers to Words? -- Why Does Excel Ask to Update Links When There Aren't Any Links in My Workbook? -- How Can I Track Billable Hours in a Weekly Time Sheet? -- Chapter 11 - Other Resources -- I Have a Question That Is Not Answered in This Book -- What Should I Do after I Have Mastered Every Technique in This Book? -- Index -- Quick Reference -- Excel Aptitude Test -- To Learn More -- Back Cover.