Training Home | Business Applications | Microsoft Excel 2007 Adv

Advanced Microsoft Excel 2007 Tutorial Video

Learn how to take your skills to the next level. This Advanced Microsoft Excel 2007 training DVD is the ultimate in comprehensive learning for the discerning professional.

The training uses broadcast quality audio and video to deliver concise and informative training right to your desktop. The Tutorial comes complete with practical working files and presented via an intuitive, easy-to-use interface, This Advanced Microsoft Excel 2007 tutorial video makes learning simple, quick and enjoyable. All training courses are authored by professional instructors who have a passion for teaching.

Self Paced, Affordable Training Videos - Tutorials Taught by Professionals

Reduce learning time by 80%. Learn from a professional trainer from your own desk.
Suitable for beginners to advanced users. ideal for users who learn faster when shown.
Visual training method, offering users increased retention and accelerated learning.
Breaks even the most complex applications down into simplistic steps.

For evaluation purposes the links below offer an insight into the quality of these Advanced Microsoft Excel 2007 tutorials. In order for the free demo videos to play QuickTime needs to be installed.

Product Trailer
Windows Media Player

Free Demo Tutorial 1
Quicktime »
Windows Media Player »

Free Demo Tutorial 2
Quicktime »
Windows Media Player »

This Weeks Limited Offer

25% off AutoCAD 2010 Videos

OVER 9 hours of Video Training - ONLY $74.95

We are pleased to announce that we have just released our Amazing AutoCAD training videos. This highly intuitive and engaging training course is only $74.95, which is amazing value. To try a free demo just follow the link below. To try for FREE Click Here »

Customer Testimonials

I am both a production company owner with 30 years of experience, and a review writer. When I first started reviewing your site for P3 Update Magazine several months ago, I had no idea how awesome it was. Now, after having viewed over 275 movies, I rely on it to quickly learn new software applications. Learning FCP Studio was easy, and some of the advanced techniques that I learned really impressed my clients. I couldn't imagine anyone not needing this valuable resource.
david h.

SUMMARIZING DATA

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

WORKING WITH PIVOT TABLES

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

CHARTING IN EXCEL

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

GETTING VISUAL

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

CREATING POWERFUL FORMULAS

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

RECORDING MACROS

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

TIPS & TRICKS

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

Microsoft Excel 2007 Tutorial Info

Title Information.

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.. Close »

Instructor : Bill Jelen

All Training Courses by this author

Publisher:

Total Training

Duration:

6 hours - 79 lessons

Platform:

PC or Mac

Fomat :

DVD Video

Price:

$99.99
Sale Price: $69.99

£48.43

€56.62

Select your delivery option

ONLY 1 LEFT!

Advanced Microsoft Excel 2007 Related Training Videos :

Join our Newsletter and Save

By joining our newsletter you will be notified of special offers and limited promotions. We don't sell, rent or otherwise disclose your details to any 3rd party. Sign up today and take advantage.

Just Released Training Titles

Adobe Photoshop CS5 Training
Microsoft Office 2010
Learning Microsoft Project 2010
Learning Microsoft Excel 2010
Carrara 8 Training

Learn Online - Instant Access - Low Price

Giving you amazing freedom to learn at your own pace these online training videos combine high quality professionally created content, broadcast standard high definition video and crystal clear audio, at an extremely cost effective price. The tutorials are presented via an easy to use interface.

You can now access an entire library of professionally created tutorials in High Definition video for the same price as our competitors charge from one DVD.

Users are bound by no constants on the amount of titles that can be viewed, access can be from any location and where available, working files are included at no extra charge.

Customer Comments

Jan in Photoshop CS4 Essential Training offers the clearest tutorials I have seen. Her explanations have an economy to them that nourishes my brain. No wasted words; nothing unclear. She has become a great pleasure in my quest to learn Photoshop. Thank you.
ed s.