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
