تفاصيل الدورة
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
الموقع
نبذة عن معهد 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.
عرض الجميع دورات everydayExcel Business Lab Pte Ltd Are you from everydayExcel Business Lab Pte Ltd ? Claim your course!
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Microsoft Office ابتداءً من الآن.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoon1,449 درهممدة الدورة التدريبية: Upto 30 Hours
- MS Office 365 OneDrive Skill-Up55 درهم
1,102 درهممدة الدورة التدريبية: Upto 1 Hour - Microsoft Office Essential Skills Skill-Up37 درهم
735 درهممدة الدورة التدريبية: Upto 3 Hours
