Microsoft Excel 2007 Advanced Training, Excel Training Videos: Total Training Software Training

Home » Products » Communication & Office Tools » Excel

Total Training for
Microsoft^® Excel^® 2007: Advanced


Title:	Microsoft Excel 2007 Advanced
Category:	Communication & Office Tools
Presenter:	Bill Jelen Bill Jelen is the host of MrExcel.com and author of sixteen books about Microsoft Excel including Excel 2007 Miracles Made Easy, Pivot Table Data Crunching for Excel 2007, VBA & Macros for Microsoft Excel, Excel for Marketing Managers, and Guerilla Data Analysis Using Microsoft Excel. Over the years, Bill has made 50+ guest appearances on G4 Tech TV's Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show. Bill will entertain you while showing you the powerful tricks in Excel.
Platform:	Windows
Format:	DVD-ROM & Online
Level:	Intermediate to Advanced
Solutions:	Multi-User Education Government International
Description:	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.

Running Time: 6 Hrs, 1 DVD
Project Files: Included

Highlights

Learn how to sort and filter data faster in Excel 2007. You can even sort or filter by color.
Master pivot tables to summarize a million rows of transactional data into a flexible summary without writing a single formula.
Reduce repetitive tasks to a single mouse click by creating a macro. Plus, find out why most recorded macros don't work and the one setting to change to allow many recorded macros to work.
See how to use the three new charting ribbon tabs to quickly format a chart or how to use the dialog boxes to coax charts out of Excel that don't look like Excel charts. You'll discover how to make charts in your company's colors with one keystroke.
Create a report for every customer or department with a couple of mouse clicks. Learn five ways to summarize data and when to use each method.

Free Tutorial 1

Free Tutorial 2

Free Guest Pass
Try before you buy. We're so confident that you're going to love our online training courses, that we're giving you a FREE 7-day guest pass. Experience the next big thing from Total Training.

Get the latest QuickTime Player
Download the free player

Get the latest Windows Media Player
Download the free player

Presenter: Bill Jelen

Bill Jelen is the host of MrExcel.com and author of sixteen books about Microsoft Excel including Excel 2007 Miracles Made Easy, Pivot Table Data Crunching for Excel 2007, VBA & Macros for Microsoft Excel, Excel for Marketing Managers, and Guerilla Data Analysis Using Microsoft Excel. Over the years, Bill has made 50+ guest appearances on G4 Tech TV's Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show. Bill will entertain you while showing you the powerful tricks in Excel.

» Full Bio

Bill's Training Products

» Microsoft Excel 2007: Advanced

Our Advantage

Most Comprehensive Training Available

Industry Leading Tutorials

Interactive Training Programs

Expert Instruction

What Our Customers Are Saying

"The incredible knowledge that I gained from watching the Total Training videos, has helped me to improve the quality of the photos and videos that I publish on the web. With numerous awards to back my achievements, I am happy I made the initial investment."

Craig Kasnoff
Journalist and Owner, CMKC