Easy Excel VBA macro programming for non programmers
Fast paced learning for Excel experts who need quick solutions
If you are an extensive user of Microsoft Excel then you’ll be aware that there are just some things that you would love to automate. You may have already tried to record some basic macros to speed up repetitive tasks. Recorded macros, however, have limitations and you’ll soon want to be experimenting with a little VBA programming language and that is when you will need this course.
This course is aimed at Excel users with no programming knowledge. It teaches you to extend the capabilities of Excel and achieve amazing results with very little programming knowledge.
This workshop is completely hands on. Each user has their own PC. We use Office 2007 but this course is suitable for users who have, or may be upgrading to 2010.
This course will be unlike any other computer course you attend. Your trainer, Sharon Connolly has been an international professional speaker and trainer for over 20 years. Sharon has been featured on TV both in the UK and in Singapore. She's an expert in delivering complex technology in an easy to understand manner and specialises in giving you practical applications so you'll immediately be able to put your new knowledge to work.
Detail
| Date: |
08 Jun 2012 15 Aug 2012 22 Aug 2012 |
| Duration: |
1, day(s) 9:00AM - 5:00PM |
| Fee: | $395.00 |
| Venue: | Knowledge Connection
3 Temasek Boulevard
Singapore, 038983
Singapore |
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.
Outline
We fill the agenda fit to bursting so you can get more out of your course and less time away from your business
Real business solutions you can put to work straight away. Comprehensive training manual. Shortcut card and post course email support. Certificate awarded. Sample templates available to access after the course.
Excel Macros. Recording, Running and Editing
Assigning macros to buttons, shortcut keys and toolbars
The language of VBA: Objects, Properties, Methods and arguments
Communicating with the user, Message boxes, Input boxes
Decision structure, If statements and Select Case
Looping, For next loops, Do until loops
Error Trapping
Running macros automatically with events
Facilitators
Sharon Connolly is a professional speaker and trainer living and working in Singapore. Originally from the UK. Sharon lists Amazon, Microsoft, Hewlett Packard, Standard Chartered, Credit Suisse, Barclays Capital and Accenture amongst her client list. Sharon started her IT training career in 1990 and has taught over 25,000 students Microsoft Mastery. Sign up now so you don't miss an outstanding opportunity to rise above your peers by taking your skills to the next level and enhance your mastery of Excel
Who Should Attend
This course is aimed at the frequent Word/Excel user that needs to take their excel use to the next level fast! It’s aimed at IT professionals who are quick learners, but anyone that uses Excel extensively in their job and wants to quickly increase their expertise may attend.
This course is particularly aimed at those who need to create Excel solutions or automation to speed up time-consuming tasks
Testimonials
There is more to being a great trainer and simply having expert knowledge and sharing it, although obviously Sharon excels in both respects. What makes Sharon stand out is her ownership of the day. Completely prepared and therefore totally calm and able to focus on hosting taking an interest in the delegates. People clearly feel very at ease with Sharon, and as a result relax, enjoy their course and learn more.
Joanna Hibbert
Sharon conducts regular public workshops in Microsoft Office for ST Training Solutions. Our participants regularly comment at how knowledgeable she is. When I sat in the workshop, I learned so many shortcuts that I didn't know before. She was also very patient in answering all questions from the group. For a technically competent IT trainer who is able to deliver to any level, I can recommend Sharon highly.
Shirley Taylor, ST Training Solutions and President of Asia Professional Speakers Singapore
I have worked with Sharon for the past 12 months in which time she has provided IT training to numerous employees. Sharon really understands our business and has personalised the courses she delivers to enhance the learning experience for our employees. The delegate feedback is always positive - Sharon is seen as the expert in IT training, is very personable and is a pleasure to work with.
Sharon Rees - Learning and Development Manager, Amazon