Excel 2007 Visual Quick Tips

Fully updated for Excel 2007! Would you like to make Excel formulas easier to create and read, save time by customizing and automating your Excel worksheets, and learn how to present data with dramatic visual appeal? Then this Visual Quick Tips book is for you. This book will increase your productivity by providing you with shortcuts, tricks, and tips to help you work smarter and faster. Straightforward task descriptions Succinct explanations Full-color screen shots Numbered steps Learn How To: Add comments and styles to worksheets Sort and filter complex data Import, export, and hyperlink content

Table of Contents:
Chapter 1 Boosting Efficiency Name Cells and Ranges 4 Validate with a Validation List 6 Validate with Data Entry Rules 8 Extend a Series with AutoFill 10 Insert Symbols and Special Characters 12 Hide Rows by Grouping and Outlining 14 Add Comments to a Worksheet 16 Let Excel Read Back Data 18 Chapter 2 Working with Formulas and Functions Calculate with the Function Wizard 22 Define a Constant 24 Create Formulas That Include Names 26 Figure Out Loan Terms 28 Determine the Internal Rate of Return 30 Determine the nth Largest Value 32 Create a Conditional Formula 34 Calculate a Conditional Sum 36 Add a Calculator 38 Find Products and Square Roots 40 Perform Time Calculations 42 Perform Date Calculations 44 Chapter 3 Copying, Formatting, and More Check Formulas for Errors 48 Change Text to Numbers and Then Calculate 50 Convert a Row to a Column 52 Copy with the Office Clipboard 54 Specify How to Paste with Paste Special 56 Create Your Own Style 60 Copy Styles to Another Workbook 62 Conditionally Format a Worksheet 64 Track Changes While Editing 68 Consolidate Worksheets 70 Chapter 4 Manipulating Records Enter Data with a Form 74 Filter Duplicate Records 76 Perform Simple Sorts and Filters 78 Perform Complex Sorts 80 Perform Complex Filters 82 Filter by Multiple Criteria in the Same Column 84 Subtotal Sorted Data 86 Chart Filtered Data Easily 88 Count Filtered Records 90 Look Up Information in a Worksheet 92 Define Data as a Table 94 Modify a Table Style 96 Chapter 5 Exploring Patterns in Data Create a PivotTable 100 Modify PivotTable Data and Layout 104 Compute Sub- and Grand Totals 106 Create a Calculated Field 108 Hide Columns or Rows in a PivotTable 110 Sort a PivotTable 111 Create a PivotChart 112 Describe Data with Statistics 114 Find the Correlation Between Variables 116 Explore Outcomes with What-If Analysis 118 Optimize a Result with Goal Seek 120 Chapter 6 Creating Charts Create a Chart That Has Visual Appeal 124 Add Chart Details 126 Change the Chart Type 130 Add a Trendline to a Chart 132 Add and Remove Chart Data 134 Add Error Bars 136 Create a Histogram 138 Chapter 7 Presenting Worksheets Format Quickly with Format Painter 142 Insert Shapes into a Worksheet 144 Insert Text Boxes into a Worksheet 146 Insert Photographs into a Worksheet 148 Arrange the Graphics in a Worksheet 150 Insert a Background Image 152 Take a Picture of a Worksheet 154 Chapter 8 Protecting, Saving, and Printing Protect a Worksheet 158 Save a Workbook as a Template 160 Choose a Format when Saving a Workbook 162 Print Multiple Areas of a Worksheet 164 Print Multiple Worksheets from a Workbook 166 Chapter 9 Extending Excel Paste Link into Word or PowerPoint 170 Embed a Worksheet 172 Hyperlink a Worksheet 174 Query a Website 176 Import a Text File 178 Import an Access Database 182 Query an Access Database 184 Reuse a Saved Query 188 Export a Worksheet to Access 190 Chapter 10 Customizing Excel Install Add-Ins 196 Customize the Quick Access Toolbar 198 Work with Multiple Windows 200 Save Time by Creating a Custom View 201 Create a Custom Number Format 202 Automate a Worksheet with Macros 204 Create an Icon to Run a Macro 206 Index 208