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.
