Microsoft Excel 2007 Power Functions Course
Excel 2007 Power Functions Course Brief
This 3-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.
You will learn advanced data value validation techniques and ranking data values. Working with date 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 and form control to create even greater dynamics in report generation. Together with easy to achieve dropdown selections you can display relevant range of data and results.
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 skip this course and take up this course?
Yes, you can, ONLY IF you are very familiar with the Excel 2007 interface and you have attended the basic to advanced level Excel courses, otherwise we would recommend against taking up this course.
Overview of Microsoft Excel 2007 Power Functions
- Formula and Function Tips/Shortcuts
- Lookup and Reference Functions
- The New Power Functions (IFS)
- Statistical Functions
- Maths Functions
- Date Functions
- Array Formulas and Functions
- Text Functions
- Information Functions
- Integrating Form Controls into the Worksheet
Excel 2007 Power Functions 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$320.00 (Before SDF) Subject to GST charges from 21 May 2011 |
| Course Location | Oaks Training Centre |
| Time | 9.00am - 5.00pm |
| Course Duration | 21 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 | VTLOAK1EPF |
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 ].
 |
 |
 |