Title Details

#1 Enter Numbers and Fractions.

#2 Enter Dates and Times.

#3 Name Cells and Ranges.

#4 Validate Data Entry Using a Pick List.

#5 Extend a Series of Dates with Autofill.

#6 Add a Symbol or Special Character.

#7 Compare Multiple Spreadsheets Using Freeze Panes.

#8 Hide Rows to Compare Data with Outlining.

#9 Access Excel by Keyboard.

#10 Access Excel by Voice with Speech Recognition.

#11 Find and Replace Data.

#12 Generate a Worksheet Using InfoPath.

2.Working with Formulas and Functions.

#13 Add Values in Different Ways.

#14 Make Magic with the Function Wizard.

#15 Document Formulas with Comments.

#16 Document Worksheets with OneNote.

#17 Define a Constant.

#18 Apply Names in Functions.

#19 Figure Out the Best Loan Terms.

#20 Determine the Internal Rate of Return.

#21 Determine the Nth Largest Value.

#22 Create a Conditional Function.

#23 Calculate a Conditional Sum.

#24 Discover Your Inner Calculator.

#25 Find Products and Square Roots.

#26 Calculate the Duration Between Two Times.

#27 Calculate Days Between Two Dates.

#28 Change Text to Numbers.

3.Copying Data, Formats, and More.

#29 Copy a Range with the Office Clipboard.

#30 Transpose a Row into a Column.

#31 Copy Styles to Another Workbook.

#32 Copy Chart Formatting into Another Chart.

#33 Copy Formulas with Paste Special.

#34 Track Changes while Editing.

4.Using Excel Lists.

#35 Generate a List Automatically.

#36 Enter List Data Using a Form.

#37 Import a Word List into Excel.

#38 Sort and Filter a List.

#39 Sort by Multiple Criteria.

#40 Find Averages in a Sorted Group.

#41 Filter by Multiple Criteria.

#42 Remove Duplicate Records from a List.

#43 Count Filtered Records.

#44 Filter by Multiple Criteria in the Same Column.

#45 Chart a Filtered List.

#46 Look Up Information in a List.

5.Exploring Patterns in Data.

#47 Create a PivotTable.

#48 Modify PivotTable Data and Layout.

#49 Find the Average of a Field.

#50 Create a Calculated Field.

#51 Hide Rows or Columns in a PivotTable.

#52 AutoFormat a PivotTable.

#53 Create a PivotChart.

#54 Describe Data with Statistics.

#55 Discover Associations within Your Data.

#56 Explore Outcomes with What-If Analysis.

#57 Optimize a Result with Goal Seek.

6.Creating Charts.

#58 Create a Chart.

#59 Modify Chart Details.

#60 Change the Chart Type.

#61 Add a Trendline to a Chart.

#62 Add and Remove Chart Data.

#63 Visually Represent Missing Chart Data.

#64 Use Error Bars in a Chart.

#65 Pull a Slice from a Pie Chart.

#66 Label the Slices of a Pie Chart.

#67 Create a Histogram.

#68 Paste a Chart into Word.

#69 Embed a Chart into Word.

7.Presenting Worksheets.

#70 Format Numbers as Percentages.

#71 Format a Column of Currencies.

#72 Format Column Headings.

#73 Format Quickly with Format Painter.

#74 Group Formats in a Style.

#75 Insert a Background Image into Your Worksheet.

#76 Create a Transparent Image.

8.Saving and Printing Worksheets.

#77 Save a Workbook as a Template.

#78 Save a Workbook as an XML Spreadsheet.

#79 Print Multiple Cell Ranges on One Page.

#80 Print Multiple Areas of a Workbook.

#81 Print Multiple Worksheets of a Workbook.

#82 Repeat Headings of a Row and Column.

#83 Print Functions to Show Calculations.

9.Extending Excel.

#84 Hyperlink a Worksheet to Another Office Document.

#85 Embed a Chart within PowerPoint.

#86 Publish an Interactive Workbook.

#87 Import a Worksheet from the Web.

#88 Query a Web Site.

#89 Query an Access Database.

#90 Reuse a Saved Query.

#91 Import a Worksheet into Access.

#92 Use Excel Data to Create Labels in Word.

10.Customizing Excel.

#93 Add Features by Installing and Using Add-Ins.

#94 Launch a Specific Workbook when Excel Opens.

#95 Create a Custom Workspace.

#96 Save Time by Creating a Custom View.

#97 Create a Custom Number Format.

#98 Create a Macro to Format Numbers.

#99 Create a Button to Run a Macro.

#100 Enlarge Screen Elements.