Price: SGD 700
- Duration: 2 Days
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
- Microsoft Office 2016 Complete Diploma Alpha AcademySGD 34
SGD 435Duration: Upto 7 Hours - SGD 14
SGD 340Duration: Upto 18 Hours
