Excel 2007 Level 4: Power User (Excel 2007 Level 4: Power User)

This one-day hands-on course is for those advanced Excel users that need to conduct data analysis using the more complex formulas and features in Excel. Learn how advanced formulas, functions and arrays can help streamline your data mining processes and provide useful projections for your agency’s needs. These tools include Wizards, problem models, methods for correlating data and advanced customization techniques. Because the book provided with this course is designated as “Approved Courseware” for the Microsoft Certified Application Specialist program, this course will help students prepare for the Excel 2007 exam. For comprehensive certification training, all levels of Excel 2007 should be completed. Upon successful completion of this course you should be able to:

• Use advanced formulas, functions, and arrays
• Use information, date, and time functions
• Use advanced editing and formatting, including Paste Special and Go To Special
• Merge styles
• Apply advanced chart formatting
• Analyze and share information
• Use the Wizard add-ins
• Run solver models and reports
• Embed and link information
• Set up advanced customization including automation

Audience: Completion of the Microsoft Excel 2007 Level 1, 2 & 3 courses or equivalent knowledge and experience is recommended.