Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

    Microsoft Excel 2007: Advanced

    Subscriber Reviews • Browse Similar Topics

    Overview

    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.

    Subscriber Reviews

    Average Rating: 5 out of 5 rating Based on 5 Ratings

    "Smart n short" - by Srujan on 23-SEP-2011
    Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
    awesome!
    Report as Inappropriate

    "Useful" - by Anonymous on 20-FEB-2011
    Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
    Very useful! Thanks!
    Report as Inappropriate

    "Manager" - by Anonymous on 07-DEC-2009
    Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
    Excellent coverage and easy to follow.
    Report as Inappropriate

    Table of Contents

    Chapter/Selection

    Time

    CHAPTER 1: SUMMARIZING DATA

    INTRODUCTION

    Play Video

    00:01:42

    Advanced Subtotals

    Play Video

    00:07:36

    Formatting the Subtotal Rows

    Preview

    00:07:20

    Adding and Copying with Subtotals

    Preview

    00:06:15

    Consolidating Data

    Preview

    00:06:13

    Introducing the SUMIF Command

    Preview

    00:05:14

    Working with the SUMIF Command

    Preview

    00:05:59

    Using Array Formulas

    Preview

    00:05:55

    Looking at AutoSum Tricks

    Preview

    00:06:13

    Utilizing Fill Handle Tricks

    Preview

    00:05:29

    CHAPTER 2: WORKING WITH PIVOT TABLES

    INTRODUCTION

    Preview

    00:00:35

    Creating a Pivot Table

    Preview

    00:03:08

    Rearranging Fields in a Pivot Table

    Preview

    00:01:51

    Explaining the Report Layout Options

    Preview

    00:03:54

    Using the Report Filters Feature

    Preview

    00:05:58

    Using Top 10 & Date Filters

    Preview

    00:04:07

    Handling Blank Cells

    Preview

    00:03:35

    Drilling Down in the Pivot Table

    Preview

    00:02:37

    Sorting a Pivot Table

    Preview

    00:02:18

    Formatting a Pivot Table

    Preview

    00:03:54

    Creating Custom Formats

    Preview

    00:02:10

    Explaining the Grouping Options

    Preview

    00:05:38

    Adding Formulas to a Pivot Table

    Preview

    00:04:47

    Changing a Calculation in a Pivot Table

    Preview

    00:01:58

    Replicating a Pivot Table

    Preview

    00:01:27

    Counting with a Pivot Table

    Preview

    00:02:22

    Using Pivot Charts

    Preview

    00:02:03

    CHAPTER 3: CHARTING IN EXCEL

    INTRODUCTION

    Preview

    00:00:27

    Charts Refresher

    Preview

    00:04:59

    Moving, Sizing & Copying Charts

    Preview

    00:02:21

    Formatting Charts

    Preview

    00:05:46

    Formatting a Series

    Preview

    00:02:12

    Exploring the Home & Format Ribbons

    Preview

    00:04:13

    Deciding What Chart Format to Use

    Preview

    00:03:13

    Show a Time Series with Column or Line Charts

    Preview

    00:10:14

    Using Combination Charts

    Preview

    00:06:10

    Using Line Chart Accessories

    Preview

    00:02:39

    Using Bar Charts to Show Comparisons

    Preview

    00:03:39

    Using Component Charts

    Preview

    00:08:36

    Using Correlation Charts

    Preview

    00:06:49

    Exploring Other Charts

    Preview

    00:07:30

    Chart Lies Revealed & Advanced Chart Types

    Preview

    00:04:35

    Creating a Custom Layout

    Preview

    00:01:41

    CHAPTER 4: GETTING VISUAL

    INTRODUCTION

    Preview

    00:00:47

    Using Conditional Formatting

    Preview

    00:04:38

    Using Advanced Conditional Formatting

    Preview

    00:03:43

    Highlighting, Sorting & Filtering Columns

    Preview

    00:05:11

    Using SmartArt Functions

    Preview

    00:05:06

    Using Different SmartArt Graphics

    Preview

    00:05:54

    Embedding a Formula into a Shape

    Preview

    00:02:35

    CHAPTER 5: CREATING POWERFUL FORMULAS

    INTRODUCTION

    Preview

    00:00:37

    Using Goal Seek to Find an Answer

    Preview

    00:05:09

    Auditing Formulas

    Preview

    00:07:48

    Shrinking the Formula Bar

    Preview

    00:01:31

    Understanding Errors

    Preview

    00:06:03

    Joining Text Columns

    Preview

    00:03:50

    Using Custom Formatting Codes

    Preview

    00:01:49

    Pasting Values

    Preview

    00:03:37

    Using Paste Special

    Preview

    00:02:23

    Breaking Apart Text

    Preview

    00:04:17

    Converting Text to Numbers

    Preview

    00:03:49

    Using Date Functions

    Preview

    00:06:07

    Using Bizarre Date Functions

    Preview

    00:04:55

    Using Exponents

    Preview

    00:02:37

    Using the VLOOKUP Function

    Preview

    00:06:14

    Using Index Match

    Preview

    00:02:33

    Using the Offset Function

    Preview

    00:03:17

    Using the Convert Function

    Preview

    00:02:29

    Looking at Interesting but Obscure Functions

    Preview

    00:06:07

    Using the Rand Function

    Preview

    00:02:22

    Working with Regression

    Preview

    00:04:49

    Ranking & Sorting Formulas

    Preview

    00:02:32

    CHAPTER 6: RECORDING MACROS

    INTRODUCTION

    Preview

    00:00:41

    Displaying the Developer Tab

    Preview

    00:02:31

    Recording a Simple Macro

    Preview

    00:04:26

    Simplifying the Macro

    Preview

    00:02:29

    Recording Using Relative References

    Preview

    00:08:03

    CHAPTER 7: TIPS & TRICKS

    INTRODUCTION

    Preview

    00:00:21

    Showing Off New Tips in Excel 2007

    Preview

    00:02:39

    Tips for Handling Worksheets

    Preview

    00:02:25

    Using Excel as a Word Processor

    Preview

    00:02:21

    Miscellaneous Tips

    Preview

    00:04:10

    Validating Data

    Preview

    00:04:56

    Changing Text Entry Direction

    Preview

    00:02:58

    Using Speak Cells

    Preview

    00:04:57

    Final Comments & Credits

    Preview

    00:02:52

    Extras

    The publisher has provided additional content related to this title.


    Description
    Content

    Exercise file

    • M1XL07_P01_PF.sit

    Exercise file

    • M1XL07_P01_PF.zip