"Nearly 6 hours of audio & video training!"

If you want to learn the advanced features of Excel 2007, this DVD is for you. Based on Bill Jelen's popular Power Excel Seminar, the DVD will walk you through the best features of Excel 2007. Learn pivot tables, automatic subtotals, charting and more.

Each lesson starts with a video clip. You can use the navigation to jump to a specific lesson:

Once you are watching a lesson, you will hear my voice and watch my mouse as I click around the video screen. At any point, you can jump to a certain topic within the lesson. Here, you can see there are 15 chapter marks within the 75 minute Charting Lesson. You can bookmark any lesson to be able to jump back to it quickly.

The Total Training company has the best production values in the industry. Their intuitive interface will allow you to skip directly to the topics that you need to learn today. Actually, the interface remains unobtrusive outside the video window, but it has incredible depth. There are 30+ controls available to you.

Watch the video on your computer screen and then open the identical Excel 2007 workbook to try the concepts yourself. You can even minimize the video screen to a small size so that you can see both your Excel screen and the video at the same time.

The Total Training interface allows you to jump directly to a Lesson and then a topic within that lesson. Here is the course outline:

Lesson 1: SUMMARIZING DATA (58 min)

Advanced Subtotals
Formatting the Subtotal Rows
Adding and Copying with Subtotals
Consolidating Data
Introducing the SUMIF Command
Working with the SUMIF Command
Using Array Formulas
Looking at AutoSum Tricks
Utilizing Fill Handle Tricks

Lesson 2: WORKING WITH PIVOT TABLES (52 min)

Creating a Pivot Table
Rearranging Fields in a Pivot Table
Explaining the Report Layout Options
Using the Report Filters Feature
Using Top 10 & Date Filters
Handling Blank Cells
Drilling Down in the Pivot Table
Sorting a Pivot Table
Formatting a Pivot Table
Creating Custom Formats
Explaining the Grouping Options
Adding Formulas to a Pivot Table
Changing a Calculation in a Pivot Table
Replicating a Pivot Table
Counting with a Pivot Table
Using Pivot Charts

Lesson 3: CHARTING IN EXCEL (75 min)

Charts Refresher
Moving, Sizing & Copying Charts
Formatting Charts
Formatting a Series
Exploring the Home & Format Ribbons
Deciding What Chart Format to Use
Show a Time Series with Column or Line Charts
Using Combination Charts
Using Line Chart Accessories
Using Bar Charts to Show Comparisons
Using Component Charts
Using Correlation Charts
Exploring Other Charts
Chart Lies Revealed & Advanced Chart Types
Creating a Custom Layout

Lesson 4: GETTING VISUAL (28 min)

Using Conditional Formatting
Using Advanced Conditional Formatting
Highlighting, Sorting & Filtering Columns
Using SmartArt Functions
Using Different SmartArt Graphics
Embedding a Formula into a Shape

Lesson 5: CREATING POWERFUL FORMULAS (85 min)

Using Goal Seek to Find an Answer
Auditing Formulas
Shrinking the Formula Bar
Understanding Errors
Joining Text Columns
Using Custom Formatting Codes
Pasting Values
Using Paste Special
Breaking Apart Text
Converting Text to Numbers
Using Date Functions
Using Bizarre Date Functions
Using Exponents
Using the VLOOKUP Function
Using Index Match
Using the Offset Function
Using the Convert Function
Looking at Interesting but Obscure Functions
Using the Rand Function
Working with Regression
Ranking & Sorting Formulas

Lesson 6: RECORDING MACROS (18 min)

Displaying the Developer Tab
Recording a Simple Macro
Simplifying the Macro
Recording Using Relative References

Lesson 7: TIPS & TRICKS (28 min)

Showing Off New Tips in Excel 2007
Tips for Handling Worksheets
Using Excel as a Word Processor
Miscellaneous Tips
Validating Data
Changing Text Entry Direction
Using Speak Cells
Final Comments & Credits

Click here to order the DVD!

Product Details
DVD-ROM: 5.75 hours
Publisher: Total Training
Price: $99.00

System Requirements: Windows XP or Windows 2000 with Direct X 8.1 or later. Intel Pentium III, 1.0 GHz Processor, Windows Media Player 9 or later, 256MB RAM, 1024x768 screen or larger, DVD-ROM Drive & 32MB Free HD space for the training application. Vista users: please read this note.

Order
Click here to order the DVD!

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.