Microsoft Excel 2007 Power Functions S2
EXCEL 2007 POWER FUNCTIONS (SERIES 2) COURSE BRIEF
This 2-day hands-on class will show case complex data retrieval techniquesusing 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?
Detail
| Date: |
20 Jun 2012 - 21 Jun 2012 23 Jul 2012 - 24 Jul 2012 21 Aug 2012 - 22 Aug 2012 13 Sep 2012 - 14 Sep 2012 04 Oct 2012 - 05 Oct 2012 26 Nov 2012 - 27 Nov 2012 |
| Duration: |
2, day(s) 9:00AM - 5:00PM |
| Fee: | $280.00 |
| Venue: | 12 Prince Edward Road #03-03 (Podium A) Bestway Building Singapore 079212
|
- Fees are subjected to prevailing GST of 7%
- A Certificate of Attendance will be given subject to 90% attendance.
For more information, please contact JobsDB Learning at 65788111 or email to learning@jobsdb.com.sg
• Refreshments are provided for morning and afternoon tea breaks.
• A Certificate of Attendance will be given subject to 90% attendance.
Payment must be made before the commencement of the workshop. No cancellation is allowed 7 days prior to workshop.
SDF Funding Approved!
Please contact JobsDB Learning for more detail.
Outline
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
Who Should Attend
For those who have attended our Microsoft Excel 2007 Basic to Intermediate and Microsoft Excel 2007 Advanced courses