|
Green Dot Consulting offers a wide range
of programming and application development using Microsoft Office products and Visual
Basic for Applications (VBA).
VBA can completely automate mundane or
repetitive tasks and offers connectivity between Microsoft Office applications.
For example, VBA in Microsoft Access can send emails with attachments automatically
or reconcile itself with external applications such as SAP or MYOB, and so much
more!
Here are some examples of recent projects:
Microsoft PowerPoint
We recently designed a PowerPoint presentation
that ran as a quiz engine. The presentation asked a series of questions on occupational
health and safety, to ensure employees were properly trained. If the employee got
the answer correct they could move into the next slide, if not, they would need
to watch a video on workplace safety. All the quiz results across the organization
were tracked so managerial reports could be developed, showing statistics on OH
& S knowledge across the entire organization.
Microsoft Access
Access is a powerful database application
that can store mass amounts of information, automate common tasks and produce detailed
reports on data. Green Dot has designed and implemented many Access databases, from
Laundromat management systems to CCTV. For more information on the projects,
Click Here >>
Microsoft Excel
Many organizations use Excel extensively
in every day business tasks, but don’t realize how easily you can automate Excel!
Our most recent project in Excel took data from a corporate payment system and reconciled
the data against the corporate accounting package to ensure the payments leaving
the organization matched the invoices in the accounting system. This system has
saved thousands of dollars in only a few weeks, and continues to pay for itself
daily!
General Consulting
From over 10 years experience in office
automation and Microsoft products we have in-depth knowledge of how to increase
your business efficiency.
Project Management
Green Dot Consulting can provide expert
advice and management of your IT application development process. We primarily use
the PRINCE2 methodology of project management to ensure all projects are controlled
and reported efficiently.
For more information on any of these services,
or simply to discuss what is possible, please contact us
ONLINEor
on 0420 713 868.
|