Have a question?
Ready to purchase?

Please call us at:
(65) 6-348-2062

Or email us at:
info@vmaxsolutions.com



Join our mailing list to be notified of the latest information, promotions and product updates.


Add this page to your favorites for convenient
access & reference.

 

 

 

 

 

 

 

 



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


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
     
     
     

© 2006 Vmax Solutions Pte. Ltd. All Rights Reserved.
All registered trademarks, trademarks, product names, video clips and pictures are the property of their respective owners.
Vmax Solutions is not responsible for typographical errors. Video clips & photos may not represent actual products.
All web information is subjected to change without notice.