|
ORGANISATION & PERSONAL DEVELOPMENT
|
|
Unleashing the Potential of Excel
Achieve Breakthrough Performance in Data Management for VWOs
|
| Date: | 7 November 06 (full day) &
14 November 06 (half day) |
| Time: | 9am – 5pm (7 Nov) &
9am-1pm (14 Nov) |
| Duration: | 11 hours (1.5 day) |
| Closing Date: | 18 Sept 2006 |
| Venue: | 1 Maritime Square,
HarbourFront Centre |
| Course Fees: | Member
S$389 (inclusive of 5% GST) or
S$194.60
per eligible participant with 50% funding
from VWO Capability Fund (pending VCF
approval)
Non-Member
S$420.00 (inclusive of 5% GST)
|
|
Do you use Microsoft Excel like a record book where you store details of your donors? Or use it to perform tedious summation of the money donated? How about turning it into a powerful tool where you can get
answers to the following questions:
- Which month of the year is the best time to get
donation?
- Who are the major donors and when do they donate?
- How to reduce the time spend on administrative
tasks such as submitting details to authorities?
- How to create reports in minutes for your
management?
- Which month of the year do you see the highest
amount donated and where is it coming from?
- Is the same donation pattern repeating year after
year?
Learning Objectives:
Taking a hands-on approach and making use of
real-life decision-making scenarios in VWOs,
participants will be able to:
- Learn about the especially useful built-in functions in
Excel
- Apply the functions learnt in managing monetary
donations for their organisations
- Working with Date, Sub-Total and IF function
- Using Auto Filters, Go to, and Conditional formatting
- Counting records based on criteria
- Merging data from two list of records
- Using Pivot Table, Pivot Chart, and MS Query
Target Participants /
Admission Requirements:
VWO / NPO marketing, fundraising & database
personnel who uses Microsoft Excel and wants to ex-ploit it to the fullest
Register now and find out how you can
be eligible for a $100 SSTI voucher
for this programme!
|
Trainer:
Mr. Jason Khoo specialises in spreadsheets and databases, and has helped
companies extract valuable information from databases of existing systems.
As such, these companies have become more cost e.cient, having saved
thousands of dollars by using existing PC applications like the MS Office
as their solution. Examples of such
solutions include customer segmentation programmes, sales lead
generation programmes (mini CRM), and also having personalised email
broadcast to targeted customers etc.
Jason has worked in local listed companies and foreign MNCs supporting
the marketers in analysing their
marketing plans and providing quality information for the decision-making.
He was also a .nancial controller in a Fortune 500 company for a business
unit which generates a total revenue of more than S$100 million per annum.
|
For further details and enquiries
•Tel: (65) 6210 6660 •Fax: (65) 6463 1078 •Email: ncss_ssti@ncss.gov.sg
•Website: http://www.ssti.org.sg
|
In-House Training
SSTI will be pleased to organise any of the courses on a customised,
block-booked basis, scheduled on a convenient date for an agency. This
is applicable to any agency with a minimum of 15 participants.
|
