VBA - Learning the Magic of Macros
Details
Managers and Executives who have good working knowledge about Excel and have a need to automate repetitive tasks in Excel.
Learning ObjectivesUpon completion of the course, participants will be able to:
- Edit existing macros
- Create macros on the fly
- Share your macros with other colleagues
- Record and run macros
- Where you can store the macros
- Reading from and writing to cells
- Find values in worksheets
- Adding and counting values using macros
- Referring to different worksheets
- Referring to different workbooks
- The power of Looping in macros
- Creating your own worksheet function
- Protecting your codes
- Sharing your codes as Addins
Exercise to create macros for
- Comparing 2 worksheets results
- Consolidating data from multiple workbooks
- Splitting data into multiple workbooks
In a typical Excel course, participants are just taught the A to Z on the formulas and functions, for the purpose of passing the certification tests. After attending these courses, the participants are left on their own to figure out how to apply the formulas and functions effectively in their unique work situations. Some took months and years to accomplish this, but many never ever discovered how. We decided to fill the gap by offering our courses tapping on our Excel experiences, from our Excel-related work experience accumulated over the years (since Lotus 1-2-3 days) and regular consulting work done with companies such as Discovery Asia, Johnson and Johnson, EQ Insurance, DP Architect, etc.
WHY SHOULD YOU CONSIDER OUR COURSES?Unlike the gamut of basic, intermediate and advanced Excel courses geared towards achieving high score for the test given at the end of the training, our solution-based Excel courses work through real-life business situations and problems that business users encounter daily in their jobs and share with them quality solutions aimed to improve their work productivity and efficiency. ...