Excel 2007 Level 4: Power User

Course Catalog

Courses and Programs > Computers > Spreadsheets and Accounting

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.

No classes currently available. Click here to continue searching for courses.

Some Title

Pages

More
Thanks for dropping by!
Stay updated by
subscribing to the RSS feed.

Join us on Facebook.