Microsoft Office Excel 2007

1. Boost Your Efficiency. #1 Validate with a Validation List. #2 Validate with Data Entry Rules. #3 Extend a Series with AutoFill. #4 Insert Symbols or Special Characters. #5 Hide Rows by Grouping and Outlining. #6 Find and Replace Formats. #7 Add Comments to Your Worksheet. #8 Let Excel Read Back Your Data. #9 Create Your Own Sort or AutoFill. 2. Work with Formulas and Functions. #10 Enter Formulas Using a Variety of Methods. #11 Name Cells and Ranges. #12 Define a Constant. #13 Create Formulas That Include Names. #14 Calculate with the Function Wizard. #15 Figure Out Loan Terms. #16 Determine the Internal Rate of Return. #17 Determine the Nth Largest Value. #18 Create a Conditional Formula. #19 Calculate a Conditional Sum. #20 Add a Calculator. #21 Find Products and Square Roots. #22 Perform Time Calculations. #23 Perform Date Calculations. 3. Copy, Format, and More. #24 Check Your Formulas for Errors. #25 Trace Precedents and Dependents. #26 Change Text to Numbers. #27 Convert a Row to a Column. #28 Copy with the Office Clipboard. #29 Adjust Column Widths with Paste Special. #30 Specify How to Paste with Paste Special. #31 Create Your Own Style. #32 Copy Styles to Another Workbook. #33 Conditionally Format Your Worksheet. #34 Track Changes While Editing. #35 Consolidate Worksheets. 4. Manipulate Records. #36 Enter Data with a Form. #37 Filter Duplicate Records. #38 Perform Simple Sorts and Filters. #39 Perform Complex Sorts. #40 Sort by Cell Color, Font Color, or Icon. #41 Perform Complex Filters. #42 Filter by Multiple Criteria. #43 Subtotal Sorted Data. #44 Chart Filtered Data Easily. #45 Count Filtered Records. #46 Look Up Information in Your Worksheet. #47 Define Data as a Table. #48 Modify a Table Style. 5. Explore the Patterns in Your Data. #49 Create a PivotTable. #50 Modify PivotTable Data and Layout. #51 Compute PivotTable Sub and Grand Totals. #52 Create a PivotTable Calculated Field. #53 Hide Rows or Columns in a PivotTable. #54 Sort a PivotTable. #55 Create a PivotChart. #56 Describe Data with Statistics. #57 Find the Correlation between Variables. #58 Explore Outcomes with What-If Analysis. #59 Optimize a Result with Goal Seek. 6. Create Charts. #60 Create a Chart That Has Visual Appeal. #61 Add Chart Details. #62 Change the Chart Type. #63 Add a Trendline. #64 Add and Remove Chart Data. #65 Add Error Bars. #66 Create a Histogram. #67 Create a Combination Chart. 7. Present Worksheets. #68 Format Numbers, Dates, and Times. #69 Apply Formats to Cells. #70 Fill with a Gradient. #71 Format Quickly with Format Painter. #72 Insert Shapes into Your Worksheet. #73 Insert Text Boxes into Your Worksheet. #74 Insert Photographs into Your Worksheet. #75 Arrange the Graphics in Your Worksheet. #76 Insert a Background Image. #77 Take a Picture of Your Worksheet. 8. Protect, Save, and Print. #78 Protect Your Worksheet. #79 Save a Workbook as a Template. #80 Choose a Format When Saving a Workbook. #81 Print Multiple Areas of a Workbook. #82 Print Multiple Worksheets from a Workbook. 9. Extend Excel. #83 Paste Link into Word or PowerPoint. #84 Embed a Worksheet. #85 Create a Link from an Excel Workbook. #86 Query a Web Site. #87 Copy a Word Table into Excel. #88 Import a Text File into Excel. #89 Import an Access Database into Excel. #90 Query an Access Database. #91 Reuse a Saved Query. #92 Import an Excel Worksheet into Access. #93 Using Excel with Mail Merge. 10. Customize Excel. #94 Add Features by Installing Add-Ins. #95 Customize the Quick Access Toolbar. #96 Work with Multiple Windows. #97 Save Time by Creating a Custom View. #98 Create a Custom Number Format. #99 Automate Your Worksheet with Macros. #100 Add a Button to Run a Macro.