Who Should Attend
Managers and Executives who have good working knowledge about Excel and have a need to automate repetitive tasks in Excel.
Learning Objectives
Upon completion of the course, participants will be able to:
- Edit existing macros
- Create macros on the fly
- Share your macros with other colleagues
Course Outline
- 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
Exercise to create macros for
- Comparing 2 worksheets results
- Consolidating data from multiple workbooks
- Splitting data into multiple workbooks
Dates:
Excel 2007/2010/2013