Excel 2007: Advanced

This course focuses on the advanced features of Microsoft Excel 2007 and provides you with the knowledge you need to perform high-level tasks and complex analyses. You’ll learn how to create and modify custom templates, overcome common formatting issues when working with dates and times, and develop advanced charts including combination and picture charts. This comprehensive course will show you how to sort and filter data, create outlines, and consolidate your worksheets. You’ll discover how to create and edit macros to save you time when dealing with repetitive tasks and how to safely share your workbooks without losing valuable data. You’ll also develop techniques for verifying your data to ensure accuracy and learn how to perform complex analyses by generating scenarios.
This course is 2 hours and 18 minutes in length. It is part of the Excel 2007 training series and includes engaging narration and step-by-step visual instructions to help you take your Excel knowledge to the next level.