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

Microsoft Excel 2007: Advanced

Video Description

Now that you got your feet wet learning the new features in Microsoft Excel 2007 in the first video series, Total Training for Microsoft Excel 2007: Essentials, you're ready to dive into the advanced capabilities. While creating pivot tables and macros seems daunting, you'll be at ease learning some new techniques that will streamline your next data analysis project. Sit back and discover how to unleash the power of Excel with this in-depth video series.

Table of Contents

  1. CHAPTER 1: SUMMARIZING DATA
    1. INTRODUCTION 00:01:42
    2. Advanced Subtotals 00:07:37
    3. Formatting the Subtotal Rows 00:07:20
    4. Adding and Copying with Subtotals 00:06:16
    5. Consolidating Data 00:06:13
    6. Introducing the SUMIF Command 00:05:15
    7. Working with the SUMIF Command 00:06:00
    8. Using Array Formulas 00:05:56
    9. Looking at AutoSum Tricks 00:06:13
    10. Utilizing Fill Handle Tricks 00:05:29
  2. CHAPTER 2: WORKING WITH PIVOT TABLES
    1. INTRODUCTION 00:00:35
    2. Creating a Pivot Table 00:03:09
    3. Rearranging Fields in a Pivot Table 00:01:51
    4. Explaining the Report Layout Options 00:03:54
    5. Using the Report Filters Feature 00:05:59
    6. Using Top 10 & Date Filters 00:04:08
    7. Handling Blank Cells 00:03:35
    8. Drilling Down in the Pivot Table 00:02:37
    9. Sorting a Pivot Table 00:02:18
    10. Formatting a Pivot Table 00:03:54
    11. Creating Custom Formats 00:02:10
    12. Explaining the Grouping Options 00:05:39
    13. Adding Formulas to a Pivot Table 00:04:47
    14. Changing a Calculation in a Pivot Table 00:01:58
    15. Replicating a Pivot Table 00:01:27
    16. Counting with a Pivot Table 00:02:23
    17. Using Pivot Charts 00:02:04
  3. CHAPTER 3: CHARTING IN EXCEL
    1. INTRODUCTION 00:00:28
    2. Charts Refresher 00:04:59
    3. Moving, Sizing & Copying Charts 00:02:21
    4. Formatting Charts 00:05:46
    5. Formatting a Series 00:02:13
    6. Exploring the Home & Format Ribbons 00:04:14
    7. Deciding What Chart Format to Use 00:03:13
    8. Show a Time Series with Column or Line Charts 00:10:15
    9. Using Combination Charts 00:06:11
    10. Using Line Chart Accessories 00:02:40
    11. Using Bar Charts to Show Comparisons 00:03:40
    12. Using Component Charts 00:08:37
    13. Using Correlation Charts 00:06:50
    14. Exploring Other Charts 00:07:30
    15. Chart Lies Revealed & Advanced Chart Types 00:04:35
    16. Creating a Custom Layout 00:01:42
  4. CHAPTER 4: GETTING VISUAL
    1. INTRODUCTION 00:00:48
    2. Using Conditional Formatting 00:04:39
    3. Using Advanced Conditional Formatting 00:03:44
    4. Highlighting, Sorting & Filtering Columns 00:05:12
    5. Using SmartArt Functions 00:05:07
    6. Using Different SmartArt Graphics 00:05:55
    7. Embedding a Formula into a Shape 00:02:35
  5. CHAPTER 5: CREATING POWERFUL FORMULAS
    1. INTRODUCTION 00:00:37
    2. Using Goal Seek to Find an Answer 00:05:10
    3. Auditing Formulas 00:07:48
    4. Shrinking the Formula Bar 00:01:32
    5. Understanding Errors 00:06:03
    6. Joining Text Columns 00:03:51
    7. Using Custom Formatting Codes 00:01:50
    8. Pasting Values 00:03:38
    9. Using Paste Special 00:02:24
    10. Breaking Apart Text 00:04:17
    11. Converting Text to Numbers 00:03:49
    12. Using Date Functions 00:06:07
    13. Using Bizarre Date Functions 00:04:55
    14. Using Exponents 00:02:38
    15. Using the VLOOKUP Function 00:06:15
    16. Using Index Match 00:02:34
    17. Using the Offset Function 00:03:18
    18. Using the Convert Function 00:02:30
    19. Looking at Interesting but Obscure Functions 00:06:07
    20. Using the Rand Function 00:02:23
    21. Working with Regression 00:04:49
    22. Ranking & Sorting Formulas 00:02:33
  6. CHAPTER 6: RECORDING MACROS
    1. INTRODUCTION 00:00:41
    2. Displaying the Developer Tab 00:02:31
    3. Recording a Simple Macro 00:04:26
    4. Simplifying the Macro 00:02:30
    5. Recording Using Relative References 00:08:04
  7. CHAPTER 7: TIPS & TRICKS
    1. INTRODUCTION 00:00:22
    2. Showing Off New Tips in Excel 2007 00:02:40
    3. Tips for Handling Worksheets 00:02:25
    4. Using Excel as a Word Processor 00:02:22
    5. Miscellaneous Tips 00:04:11
    6. Validating Data 00:04:56
    7. Changing Text Entry Direction 00:02:58
    8. Using Speak Cells 00:04:57
    9. Final Comments & Credits 00:02:52