Free Sample
CHAPTER 1: SUMMARIZING DATA

Free Sample
07:20
Formatting the Subtotal Rows

Free Sample
06:16
Adding and Copying with Subtotals

Free Sample
06:13
Consolidating Data

Free Sample
05:14
Introducing the SUMIF Command

Free Sample
06:00
Working with the SUMIF Command

Free Sample
05:56
Using Array Formulas

Free Sample
06:13
Looking at AutoSum Tricks

Free Sample
05:29
Utilizing Fill Handle Tricks
Free Sample
CHAPTER 2: WORKING WITH PIVOT TABLES

Free Sample
00:35
INTRODUCTION

Free Sample
03:09
Creating a Pivot Table

Free Sample
01:51
Rearranging Fields in a Pivot Table

Free Sample
03:54
Explaining the Report Layout Options

Free Sample
05:59
Using the Report Filters Feature

Free Sample
04:08
Using Top 10 & Date Filters

Free Sample
03:35
Handling Blank Cells

Free Sample
02:37
Drilling Down in the Pivot Table

Free Sample
02:18
Sorting a Pivot Table

Free Sample
03:54
Formatting a Pivot Table

Free Sample
02:10
Creating Custom Formats

Free Sample
05:39
Explaining the Grouping Options

Free Sample
04:47
Adding Formulas to a Pivot Table

Free Sample
01:58
Changing a Calculation in a Pivot Table

Free Sample
01:27
Replicating a Pivot Table

Free Sample
02:23
Counting with a Pivot Table

Free Sample
02:04
Using Pivot Charts
Free Sample
CHAPTER 3: CHARTING IN EXCEL

Free Sample
00:27
INTRODUCTION

Free Sample
04:59
Charts Refresher

Free Sample
02:21
Moving, Sizing & Copying Charts

Free Sample
05:46
Formatting Charts

Free Sample
02:13
Formatting a Series

Free Sample
04:14
Exploring the Home & Format Ribbons

Free Sample
03:13
Deciding What Chart Format to Use

Free Sample
10:15
Show a Time Series with Column or Line Charts

Free Sample
06:11
Using Combination Charts

Free Sample
02:40
Using Line Chart Accessories

Free Sample
03:40
Using Bar Charts to Show Comparisons

Free Sample
08:37
Using Component Charts

Free Sample
06:49
Using Correlation Charts

Free Sample
07:30
Exploring Other Charts

Free Sample
04:35
Chart Lies Revealed & Advanced Chart Types

Free Sample
01:42
Creating a Custom Layout
Free Sample
CHAPTER 4: GETTING VISUAL

Free Sample
00:48
INTRODUCTION

Free Sample
04:39
Using Conditional Formatting

Free Sample
03:44
Using Advanced Conditional Formatting

Free Sample
05:12
Highlighting, Sorting & Filtering Columns

Free Sample
05:07
Using SmartArt Functions

Free Sample
05:55
Using Different SmartArt Graphics

Free Sample
02:35
Embedding a Formula into a Shape
Free Sample
CHAPTER 5: CREATING POWERFUL FORMULAS

Free Sample
00:37
INTRODUCTION

Free Sample
05:10
Using Goal Seek to Find an Answer

Free Sample
07:48
Auditing Formulas

Free Sample
01:32
Shrinking the Formula Bar

Free Sample
06:03
Understanding Errors

Free Sample
03:51
Joining Text Columns

Free Sample
01:50
Using Custom Formatting Codes

Free Sample
03:38
Pasting Values

Free Sample
02:24
Using Paste Special

Free Sample
04:17
Breaking Apart Text

Free Sample
03:49
Converting Text to Numbers

Free Sample
06:07
Using Date Functions

Free Sample
04:55
Using Bizarre Date Functions

Free Sample
02:38
Using Exponents

Free Sample
06:15
Using the VLOOKUP Function

Free Sample
02:34
Using Index Match

Free Sample
03:18
Using the Offset Function

Free Sample
02:30
Using the Convert Function

Free Sample
06:07
Looking at Interesting but Obscure Functions

Free Sample
02:23
Using the Rand Function

Free Sample
04:49
Working with Regression

Free Sample
02:32
Ranking & Sorting Formulas
Free Sample
CHAPTER 6: RECORDING MACROS

Free Sample
00:41
INTRODUCTION

Free Sample
02:31
Displaying the Developer Tab

Free Sample
04:26
Recording a Simple Macro

Free Sample
02:30
Simplifying the Macro

Free Sample
08:03
Recording Using Relative References
Free Sample
CHAPTER 7: TIPS & TRICKS

Free Sample
00:22
INTRODUCTION

Free Sample
02:40
Showing Off New Tips in Excel 2007

Free Sample
02:25
Tips for Handling Worksheets

Free Sample
02:22
Using Excel as a Word Processor

Free Sample
04:10
Miscellaneous Tips

Free Sample
04:56
Validating Data

Free Sample
02:58
Changing Text Entry Direction

Free Sample
04:57
Using Speak Cells

Free Sample
02:52
Final Comments & Credits