Total Training for Excel 2007: Advanced (5-24 Seat License)

Description

Total Training Licensing: Price is per license. You must purchase a minimum of 5 licenses.

Designed specifically to meet the needs of schools, government agencies, and corporations, Total Training Multi-User Licenses allow organizations to add users to an account at a discounted rate. Multi-User Seating Licenses start at 5 users and are a great way to get your entire staff up to speed on the latest software releases while optimizing your purchasing process.

Total Training for 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.

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.

Level: Intermediate to Advanced
Presenter: Bill Jelen
Running Time: 6 hours

Read  Course Outline