Total Training for:
Microsoft Excel 2007: Advanced
Hosted by Bill Jelen
Format: DVD (ROM)
Platform: Windows
Experience Level: Intermediate to Advance
Running Time: 5 hours 45 minutes
Project Files: Included
Did you ever wonder how your colleagues were able to
sort through data and provide an insightful summary complete with
charts? Well, the search is over. Now is the perfect time to sharpen
your Excel skills to ensure your business goals are being met.
Watching these tutorials you will learn the math functions to produce
budgets and forecasts, and how to quickly spot trends using pivot
tables and other analysis tools. Then once you’ve crunched the
numbers, you’ll learn how to output the results in
professional-looking charts right from within Excel.
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.
Back to Top