Overview
Have you felt bored in performing routine tasks?
Have you ever imaged that Excel can perform routine tasks for you?
Do you fear about the complexity of VBA programming?
If so, you’ll learn how to record a macro, make changes in VBA, so that you can automate your routine tasks with a single mouse click. This training course is designed to equip you with core skill in reading the VBA code. Subsequently, you will be exposed to essential Macro recording techniques. With these Macro recording techniques and capability to read VBA, you can have your very own workable Macro right after this course.
Learning Outcomes
- Read and understand VBA
- Plan and record Macro
- Perform adjustments on recorded Macro
- Add simple branching & repetition logic into recorded Macro
-
Manage recorded Macro
- An advanced working knowledge of Microsoft Excel
- A working knowledge of Microsoft Windows
- A working knowledge of computer, keyboard and mouse
HARDWARE & SOFTWARE: Excel 2007 and above is installed
Who Must Attend
Regular Excel users that want to automate their tasks and with minimal VBA (Visual Basic for Applications) programming. Learned Excel users wanted to create their tools while automate their tasks.
Course Details
MODULE 1: Introduction to Macro/ VBA
o How to Create Excel Macro/ VBA
o What is Macro Recorder
o Limitations of Macro Recorder
o What is VBA
o Macro Recording vs. VBA
MODULE 2: Setting the Stage
o Showing Developer Ribbon
o Macro Security
o Save File as Macro-Enabled Workbook
o Saving Macro-Enabled Workbook
MODULE 3: Visual Basic for Application (VBA)
o Working in Basic Editor (VBE)
o General Structure (Syntax) of VBA
o Adding Comment
o Creating Sub Procedure
MODULE 4: Getting User Feedback
o Message Boxes
o Input Boxes
MODULE 5: Running the Macro
o via Macro Menu
o via Shortcut Key
o via Quick Access Toolbar
o via Shape/ Image
o via Button
MODULE 6: Running the Macro in Slow Motion (Debugging)
o Stepping Through
o Immediate Window
o Breakpoint
o Type of Errors
MODULE 7: Macro Recording
o Record Macro
o Viewing Macro
o Use Relative References
o Plan Your Own Macro (PYOM™) Sheet
MODULE 8: Macro Recording Techniques
o Benefits of Macro Recording
o Typical Mistakes in Macro Recording
o Essential Techniques of Dynamic Macro Recording
MODULE 9: Introduction to Control Structures
o Decision Structures
o Loop Structures
MODULE 10: Macro Recording in Action
o Project #1: Display Standard Message on Selected Cells
o Project #2: Prompt User and Store the Data Entered in Specified Cell
o Project #3: Prompting for User Data Entry, and Insert the Data Entered at the End of Specified Worksheet
o Project #4: Continuously Prompting for User Input Until a Secret Phrase is Entered or the User Give Up
o Project #5: Create a new formula on specified location, and fill the new formula downwards until last record
o Project #6: Convert Formula To Actual Values
o Project #7: Change text to uppercase/ lowercase
o Project #8: Combining Multiple Worksheets into Single Worksheet
o Project #9: Split Data into Designated Worksheets
o Project #10: Import/ Export Macro (from individual file to particular computer)
MODULE 11: Speeding Tips
o Turning Off Screen Updating
o Preventing Alert Messages
o Pause Automatic CalculationA
Methodology
Face-to-face learning with demonstrations and practical hands-on.
Course Leader
Mr C.T. Tai accumulated 18 years of corporate and training experience as a result of his career as a Computer Programmer, Software Architect, SAP Consultant, Project Manager and PMO Manager. His passion for Microsoft Excel training sparked from his experience in delivering training to his team of consultants.
Mr Tai had vast of experiences in Microsoft Excel corporate training, which covering multi-national businesses, local businesses, and non-profit organizations. He has trained corporations including Petronas, AirAsia, Maxis, Red Bull, Intel, CISCO, Freescale, Schneider Electric Industries, Gutor Electronic Asia Pacific, CHEP, Coppertech, LKC Group, QEL Group, C & J Clark, Worldtech Solutions. Brandt Malaisie, United Nations Development Programme, Ministry of Health Malaysia.
He is a Microsoft Certified Excel Expert, MBA holder, certified PSMB Trainer and PRINCE2 Practitioner. He commands well in English, Bahasa Melayu and Mandarin. He designed and delivered various Microsoft Excel training, ranging from regular usage to advanced usage, from Macro/VBA programming to data analytic with PivotTable/ PowerPivot.
On a personal level, he is a strong believer of continual improvement is a journey of self-learning. In his classes, he guides the participants on forming their own solutions. He did not attend any formal classes on Microsoft Excel, however he acquired the skills and knowledge as a Certified Excel Expert via self-learning. He is a living proof of continual improvement.
Mr Tai is also a highly sought after Microsoft Excel Trainer. He received regular feedback from his participants for being inspiring in his nature. He relates his trainings and teaching with the practical side of the corporate world. He is known as a trainer and teacher who instil the essence of learning.
OR
Others professional trainer in this field.
To contact Tai, please call +6012 6869628 or +603 8074 9056 or email: info@itrainingexpert.com
Testimonies
"The trainer was very clear in this explanation on how to use the excel functions to enhance my work. Great job. Thanks" Farhan, Rail Transit.
“I have learned a lot of knowledge from this course, Excel based (Intermediate level). Both the training and the trainer are equally good. I would like to join other Microsoft Office course.”– Secretary, NUR Power Sdn Bhd
“Thanks to my trainer. I learned to apply Microsoft Excel in my future work. He is good and expressive. He is able answer all my questions immediately. I hope to join for Microsoft Excel – Advanced Level.”– Accounts, Hiraki Timur Sdn Bhd.
“During the course, I learned to simplify my work using Excel. After the course, I am so excited and can’t wait to apply the knowledge that I learned from this course. My Excel training is an excellent and knowledgeable trainer. I hope to join Microsoft Excel – Advanced Level conducted by him.”– Accounts, Hiraki Timur Sdn Bhd.
Investment
In house arrangement only.
Click here to Request for In house Quotation
Please contact us at +6012 6869 628 | +603 8074 9056
Email: info@itrainingexpert.com
Payment mode:
Payment must be 100% upfront upon confirmation.