Microsoft Office IconMicrosoft Excel 2007 Power Functions S1 Course

Learn power functions (series 1) to use for Microsoft Excel.

Home / Courses / Microsoft Office

Microsoft Excel 2007 Power Functions Course Banner
Excel 2007 Power Functions (Series 1) Course Brief

This 2-day hands-on class will show case advanced data value validation techniques and ranking data values. Working with date and time values to determine end dates or days have never been easier. These techniques will allow you to obtain results that would otherwise be impossible saving you lots of precious time.

Learn how to use data arrays in formulas for flipping row and column orientations, regression techniques, frequency distribution and many more. Included in this series are mathematical and statistical functions, and text string manipulation.

Tips and tricks, keyboard shortcuts to speed up working with Excel data will also be shown.

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 this module before I may take the Excel Power Functions S2 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 S1
  • Useful Tips/Shortcuts
  • Using New ...IFS Functions
  • Using Statistical Functions
  • Using Math Functions
  • Using Date Functions
  • Using Time Functions
  • Using Array Formulas and Functions
  • Using Text Functions
Excel 2007 Power Functions S1 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 VTLOKEPF1
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 any of these numbers: 6423-1183 | 6423-1187 | 6423-1192.

Past classes

Fellow participants, visit our Facebook to get a copy of your class photo [ click here ].

Excel 2007 Power Functions S1