O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Microsoft Excel 2010

Using Microsoft Excel 2010

by Bill Jelen, Tracy Syrstad
Publisher: Que
Release Date: August 2010
ISBN: 9780132378093
View table of contents
Start watching

Video Description

Using Microsoft Excel 2010brings you over 45 media elements detailing everything from getting familiar with the Excel interface and accessing the Excel Web App to using SmartArt and creating macros. Watching this media is the fastest way to get comfortable with the newest version of Microsoft Excel. Topics covered include signing up for a Windows Live ID, converting formulas to values, using Format Painter, using conditional formatting, using Goal Seek to return a value, using the AutoSum feature, using the Quick Sort buttons, using the search function to filter for specific dates, linking SmartArt to cells, recording a macro using relative referencing, and much, much more!

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