Excel 2007: Advanced

In this course for experienced Excel users, you’ll master advanced functions and formatting techniques to help you make the most of Excel 2007. You’ll learn how to manage your data more effectively by creating PivotTables and Pivot Charts, using the sort and filter functions for tables, and applying conditional formats. You’ll also learn how to improve upon your ability to analyze data by utilizing tools such as Scenario Manager and Goal Seek. Time-saving macros are covered, as well as advanced functions, including math and statistics functions and v-lookups.
This course includes step-by-step instructions and engaging visuals for an easy learning experience.
This course aligns with the CAP Body of Knowledge and should be approved for 3 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.