Microsoft Excel 2007 Advanced
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.
Detail
| Date: |
17 May 2012 - 18 May 2012 23 May 2012 - 24 May 2012 30 May 2012 - 31 May 2012 07 Jun 2012 - 08 Jun 2012 12 Jun 2012 - 13 Jun 2012 18 Jun 2012 - 19 Jun 2012 |
| Duration: |
2, day(s) 9:00AM - 5:00PM |
| Fee: | $280.00 |
| Venue: | 12 Prince Edward Road, #03-03 (Podium A) Bestway Building
|
- Fees are subjected to prevailing GST of 7%
For more information, please contact JobsDB Learning at 65788111 or email to learning@jobsdb.com.sg
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.
• Refreshments are provided for morning and afternoon tea breaks.
• A Certificate of Attendance will be given subject to 90% attendance
Outline
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
Facilitators
Our key facilitators for Microsoft Office workshops-
Yin Leng
Former NIE Trainer
Former CSC (Civil Service College) Trainer
Possess a degree in Computer Science with Management and has been training since 1995 in IT in both the private and public sectors. She is a certified Microsoft Office Specialist Master Instructor. Her dedication to training is well liked and appreciated by the participants. She has vast knowledge in computer programming and applications software and enjoys imparting her knowledge and skills. She is proficient in providing training in Internet, Microsoft Office application and customised software courses.
Sherie Poh
Former CSC (Civil Service College) Trainer
Holds a Degree in Computer Science and Child Psychology. She has been a corporate IT trainer since 1992. She had commercial experiences on the usage of a wide range of application software. Her training experience includes Microsoft Office Applications, Project, Lotus Notes, web related applications and programming like Visual Basic, VBA for Excel and Access. She always demonstrates competency in the skills and knowledge required of her during training.
Who Should Attend
For those who have attended our Microsoft Excel 2007 Basic to Intermediate course or for users with good working knowledge and experience in using Microsoft Excel 2007.