Using Microsoft Excel 2010

Table of contents

1. Chapter 1: Getting to Know the Excel Interface
   1. SHOW ME Media 1.1—Adding a Command to the Quick Access Toolbar 00:01:01
   2. SHOW ME Media 1.2—Freezing Columns 00:01:23
2. Chapter 2: Introducing the Excel Web App
   1. SHOW ME Media 2.1—Creating a Windows Live ID 00:01:56
   2. TELL ME MORE Media 2.2—Saving to SkyDrive from Excel 00:01:24
3. Chapter 3: Entering Data in Excel
   1. SHOW ME Media 3.1—Using the Fill Handle to Fill in a Series 00:02:30
   2. SHOW ME Media 3.2—Converting Formulas to Values 00:00:59
   3. TELL ME MORE Media 3.3—Pasting and Delimited Text 00:01:48
4. Chapter 4: Data Formatting
   1. SHOW ME Media 4.1—Creating a Custom Style 00:02:13
   2. SHOW ME Media 4.2—Using Format Painter 00:01:36
   3. SHOW ME Media 4.3—Creating a New Theme 00:05:14
   4. SHOW ME Media 4.4—Applying Conditional Formatting 00:03:27
   5. TELL ME MORE Media 4.5—Using Preset Conditional Formatting Rules 00:00:37
5. Chapter 5: Using Formulas
   1. SHOW ME Media 5.1—Entering a Basic Formula 00:03:19
   2. TELL ME MORE Media 5.2—Typing an Array within an Array 00:01:17
   3. SHOW ME Media 5.3—Evaluating a Formula 00:01:13
6. Chapter 6: Using Functions
   1. SHOW ME Media 6.1—Using the AutoSum Functionality 00:02:30
   2. TELL ME MORE Media 6.2—Using the INDEX Function 00:02:24
   3. SHOW ME Media 6.3—Calculating Times Over 24 Hours 00:05:11
   4. SHOW ME Media 6.4—Using Goal Seek to Return a Value 00:02:38
7. Chapter 7: Sorting
   1. SHOW ME Media 7.1—Sorting Values with the Sort Dialog 00:01:37
   2. SHOW ME Media 7.2—Using the Quick Sort Buttons to Sort Multiple Columns 00:01:52
   3. TELL ME MORE Media 7.3—Creating Custom Lists 00:01:17
   4. SHOW ME Media 7.4—Rearranging Columns Using the Sort Dialog 00:02:25
8. Chapter 8: Filtering and Consolidating Data
   1. SHOW ME Media 8.1—Using the Search Function to Include and Exclude Items in the Filtering Listing 00:00:55
   2. SHOW ME Media 8.2—Using the Search Function to Filter for Specific Dates 00:00:57
   3. SHOW ME Media 8.3—Using the Advanced Filter with Various Criteria 00:01:47
   4. TELL ME MORE Media 8.4—Finding Duplicates 00:01:39
9. Chapter 9: Subtotals and Grouping
   1. TELL ME MORE Media 9.1—Adding Grand Totals When the Subtotals Were Manually Entered 00:01:58
   2. SHOW ME Media 9.2—Using the Subtotal Tool 00:01:33
   3. SHOW ME Media 9.3—Subtotaling by Multiple Columns 00:02:21
   4. SHOW ME Media 9.4—Inserting Blank Rows Between Subtotal Groups 00:03:21
10. Chapter 10: Pivot Tables
    1. SHOW ME Media 10.1—Creating a Pivot Table 00:02:35
    2. TELL ME MORE Media 10.2—Using Other Data Sources 00:01:19
    3. SHOW ME Media 10.3—Grouping Dates into Months and Years 00:03:17
    4. SHOW ME Media 10.4—Adding Slicers to a Pivot Table 00:03:30
11. Chapter 11: Creating Charts
    1. TELL ME MORE Media 11.1—The Importance of Choosing the Right Chart Type 00:01:53
    2. SHOW ME Media 11.2—Creating a Chart 00:04:28
    3. SHOW ME Media 11.3—Assigning a Series to the Secondary Axis 00:02:35
    4. SHOW ME Media 11.4—Creating Sparklines 00:04:29
12. Chapter 12: SmartArt, WordArt, and Pictures
    1. SHOW ME Media 12.1—Inserting SmartArt 00:04:54
    2. SHOW ME Media 12.2—Inserting SmartArt That Includes Images 00:01:52
    3. SHOW ME Media 12.3—Linking SmartArt to Cells 00:04:29
    4. TELL ME MORE Media 12.4—Applying Styles 00:01:53
13. Chapter 13: Macros and UDFs
    1. TELL ME MORE Media 13.1—Creating a Trusted Location 00:01:56
    2. SHOW ME Media 13.2—Getting the Most Out of the Macro Recorder by Using the Keyboard 00:02:18
    3. SHOW ME Media 13.3—Recording a Macro Using Relative Referencing 00:02:58
    4. SHOW ME Media 13.4—Creating a Simple UDF 00:03:35