Learning The Magic of Macros
Based on 2007/2010 (Excel VBA).
In-House sessions are available upon request.
Learning the Magic of Macros makes use of real case examples. Unlike most Excel macros courses which are designed for programmers, this course is specially designed for advanced Excel users who do not have any background in programming. Two groups of Excel users are likely to benefit from this course:
- Those who are keen to explore macros to automate and speed up tedious and repetitive Excel tasks, and
- Those who like to modify existing macros built by someone else and customize them for their own use.
Using case examples to constantly engage the participants on the technical topic of programming, this course aims to help users create macros that are able to significantly reduce the amount of time spent on a time-consuming Excel job and make complicated Excel jobs simple enough for those without advanced Excel skills to handle.
Who Should Attend:
Managers and Executives who have good working knowledge about Excel and have a need to automate repetitive tasks in Excel.
Upon completion of the course, participants will be able to:
- Edit existing macros.
- Create macros on the fly.
- Share your macros with other colleagues.
|Section 1: Record and run macros|
|Section 2: Where you can store the macros|
|Section 3: Reading from and writing to cells|
|Section 4: Find values in worksheets|
|Section 5: Adding and counting values using macros|
|Section 6: Referring to different worksheets|
|Section 7: Referring to different workbooks|
|Section 8: The power of Looping in macros|
|Section 9: Creating your own worksheet function|
|Section 10: Protecting your codes|
|Section 11: Sharing your codes as Addins|
|Learning The Magic of Macros (2-Day)||14:00:00|
No Reviews found for this course.