Excel 2007 Advanced Course Brief

This 2-day hands-on follow on course is designed to equip users with features in Microsoft Excel 2007 that will enable you to perform better data analysis and create more complex and comprehensive reports and make better decisions.

Learn how to consolidate data and use Excel like a database to filter and retrieve data using Excel functions. You will also learn how to generate dynamic reports through data field selection and criteria quickly and easily.

This course is designed with sufficient hands-on exercises to allow you to practice key lessons taught to enforce understanding on Microsoft Excel and experience Excel’s ability to greatly reduce you time in scenario planning and data analysing.

I am a very experienced user of an earlier version of Microsoft Excel; can I skip the Basic to Intermediate course and attend this course?

If you have not used Microsoft Excel 2007, NO, we do not recommend that you skip this course. You are likely to find yourself lagging behind as you would be struggling to find or locate features in the 2007 version which is totally different from the earlier versions.

Overview of Microsoft Excel 2007 Advanced

• Working with Templates
• Working with Data Validation
• Using Advanced Functions
• Working with Database
• Filtering Data
• Using Database Functions
• Consolidating Data
• Using the Scenario Manager
• Auditing Worksheets
• Using Goal Seek
• Creating Macros
• Working with Pivot Table

Excel 2007 Advance Course Details

Can't Find a Suitable Course Date or Syllabus?
Need to Customise a Course?

If you would like us to notify you whenever a new course date becomes available, simply fill up our Notify form and we will let you know the moment any new course dates are released.

If you are looking for a customised course or an in-house course, call us and speak to any of your representatives and we would be happy to assist you.

Call us at 6423-1183.