Total Training for Microsoft Excel 2007 Advanced

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.

Download Link:

Lesson 01: Summarizing Data (58 min)

Rapidshare_Part_1 / Rapidshare_Part_2
Rapidshare_Part_3 / Rapidshare_Part_4
Rapidshare_Part_5 / Rapidshare_Part_6
Rapidshare_Part_7 / Rapidshare_Part_8
Rapidshare_Part_9 / Rapidshare_Part_10

Lesson 2: Working with Pivot Tables (52 min)

Rapidshare_Part_1 / Rapidshare_Part_2
Rapidshare_Part_3 / Rapidshare_Part_4
Rapidshare_Part_5 / Rapidshare_Part_6
Rapidshare_Part_7 / Rapidshare_Part_8
Rapidshare_Part_9 / Rapidshare_Part_10
Rapidshare_Part_11 / Rapidshare_Part_12
Rapidshare_Part_13 / Rapidshare_Part_14
Rapidshare_Part_15 / Rapidshare_Part_16
Rapidshare_Part_17

Lesson 3: Charting in Excel (75 min)

Rapidshare_Part_1 / Rapidshare_Part_2
Rapidshare_Part_3 / Rapidshare_Part_4
Rapidshare_Part_5 / Rapidshare_Part_6
Rapidshare_Part_7 / Rapidshare_Part_8
Rapidshare_Part_9 / Rapidshare_Part_10
Rapidshare_Part_11 / Rapidshare_Part_12
Rapidshare_Part_13 / Rapidshare_Part_14
Rapidshare_Part_15 / Rapidshare_Part_16

Lesson 4: Getting Visual (28 min)

Rapidshare_Part_1 / Rapidshare_Part_2
Rapidshare_Part_3 / Rapidshare_Part_4
Rapidshare_Part_5 / Rapidshare_Part_6
Rapidshare_Part_7

Lesson 5: Creating Powerful Formulas (85 min)

Rapidshare_Part_1 / Rapidshare_Part_2
Rapidshare_Part_3 / Rapidshare_Part_4
Rapidshare_Part_5 / Rapidshare_Part_6
Rapidshare_Part_7 / Rapidshare_Part_8
Rapidshare_Part_9 / Rapidshare_Part_10
Rapidshare_Part_11 / Rapidshare_Part_12
Rapidshare_Part_13 / Rapidshare_Part_14
Rapidshare_Part_15 / Rapidshare_Part_16
Rapidshare_Part_17 / Rapidshare_Part_18
Rapidshare_Part_19 / Rapidshare_Part_20
Rapidshare_Part_21 / Rapidshare_Part_22

Lesson 6: Recording Macros (18 min)

Rapidshare_Part_1 / Rapidshare_Part_2
Rapidshare_Part_3 / Rapidshare_Part_4
Rapidshare_Part_5

Lesson 7: Tips & Tricks (28 min)

Rapidshare_Part_1 / Rapidshare_Part_2
Rapidshare_Part_3 / Rapidshare_Part_4
Rapidshare_Part_5 / Rapidshare_Part_6
Rapidshare_Part_7 / Rapidshare_Part_8
Rapidshare_Part_9