تفاصيل الدورة
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 Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- Microsoft Office 2016 Beginners Diploma Alpha Academy34 SGD
439 SGDمدة الدورة التدريبية: Upto 3 Days - Microsoft Office Essentials London Institute of Business & Management26 SGD
288 SGDمدة الدورة التدريبية: Upto 67 Hours
