Course details
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
- 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
Course Location
About everydayExcel Business Lab Pte Ltd
everydayExcel Business Lab is a training company offering Professional Microsoft® Excel CThierses with a Business Perspective. They tailor-made Excel cThierses for busy Executives and Managers who do not have the time to explore the various uses of formulas and functions to solve real business problems in sales and marketing, human resThierce, administration, business development, etc.
See all everydayExcel Business Lab Pte Ltd courses Are you from everydayExcel Business Lab Pte Ltd ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Office starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Office 2016 Complete John AcademySGD 46
SGD 980Duration: Upto 3 Days - Microsoft Office Mastery StudyHubSGD 18
SGD 354Duration: Upto 17 Hours
