Course Dates
Click on Month for dates
SDF Subsidy Available
Testimonials
Good presentation and experience. Enjoyed the lesson.
Wong Kah Wai (SPF)
supported by
Microsoft Excel 2007 Power Functions S2 Course
Learn power functions (series 2) to use for Microsoft Excel.
Excel 2007 Power Functions (Series 2) Course Brief
This 2-day hands-on class will show case complex data retrieval techniques using lookup functions or a combination of functions based on multiple conditions. Through powerful search capabilities, you will also be able to achieve data replacement in records with ease.
Learn how to use form control to create dynamic forms and charts. Together with easy to achieve dropdown selections you can display relevant range of data and results.
This course will use practical examples to enhance learning and relevance in using these formulas and functions in real-world scenarios.
I am a very experienced user of an earlier version of Microsoft Excel; can I take up this course?
Yes, you can, ONLY IF you are familiar with the Excel 2007 interface, well-versed in formula creation and know how to use basic Excel functions, otherwise we would recommend against taking up this course.
Must I complete the Excel Power Functions S1 course before I can take this course?
No, the Excel Power Functions series is designed to be independent of each other. You may select to attend whichever series that is appropriate to you.
Overview of Microsoft Excel 2007 Power Functions S2
- Handling Advanced Search Functions
- Using Functions for Data Matching
- Using Information Functions
- Using Functions in Form Controls
- Using Functions in Dynamic Charts
- Using Database Functions
Excel 2007 Power Functions S2 Course Details
| Skill Level | For those who have attended our Microsoft Excel 2007 Basic to Intermediate and Microsoft Excel 2007 Advanced courses. |
| Audience | Public Sector - Division 1, 2 & 3 Private Sector - Applicable to All |
| Course Fee | S$280.00 (Before SDF) Subsidy available Subject to GST charges from 21 May 2011 |
| Course Location | Oaks Training Centre |
| Time | 9.00am - 5.00pm |
| Course Duration | 14 Hours |
| Other Details | • Refreshments are provided for morning and afternoon tea breaks.
• A Certificate of Attendance will be given subject to 90% attendance. |
| Course Code | VTLOKEPF2 |
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.
Past classes
Fellow participants, visit our Facebook to get a copy of your class photo [ click here ].
 |
 |