Microsoft Excel 2007 Advanced Course
  |
Training Category
|
: |
MS Advanced Excel 2007 Course |
| Skill Level |
: |
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.
|
| Course Objective |
: |
Upon completion of this course, you will be equipped with the skills to use advanced excel functions to perform data retrieval and analysis. Perform time saving tasks on scenarios, reports and pivot tables effectively.
|
| Course Outline |
: |
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
|
Audience |
:
|
| Public Sector - |
Division 1, 2, 3 & 4 |
| Private Sector - |
Applicable to All |
|
| Time |
: |
9.00am - 5.00pm
|
| Course Duration |
: |
14 Hours
|
Training Location
|
: |
Click for Details
|
Skills Development
Fund (SDF) Subsidy |
: |
Companies sponsoring employees may apply for SDF assistance through SDF EasyNet Website: www.sdf.gov.sg. The sponsored employee must be Singaporeans and Permanent Residents.
Note:
Please select GIL Consultancy Pte Ltd as the training provider for this course, and that the registration must be completed at least one day before the course
commencement date. Full course fees will be charged in the case of non-adherence.
|
| Other Details |
: |
| • |
Refreshments are provided for morrning and afternoon tea breaks. |
| • |
A Certificate of Attendance will be given subject to 90% attendance. |
|
| |
|
|
| Course Code |
: |
VTLOAKMEA |
| |
|
|
|
|
| Course Schedule |
| • |
| • |
| • |
| • |
| • |
| • |
| |
| • |
|
| |
 |
| |
|
| If you would like to have this course conducted as an in-house class for your staff or you would like to customise a course to your business needs, contact us for a no obligation discussion. |
|
| |
|
|
|
| |
 |
Page Assistant
To register for the course:
Step 1.
Click on the appropriate 'Course Date' radio button.
Step 2.
Click on the 'Register' button at the bottom of the page. |
|
 |
| |
|
