Excel: Macros in Depth

سرفصل های دوره

Learn how to use macros to automate tasks in Microsoft Excel, and start creating simple macros of your own. In this course, join developer and educator Robin Hunt as she shows you how to record a macro in stages, share macros between workbooks, set up keyboard shortcuts to run macros quickly, and use Visual Basic for Applications (VBA) to code macros that can't be recorded. Along the way, Robin offers tips for enhancing your personal productivity and troubleshooting and resolving common errors and bugs. Be sure to test out your new macros skills as you progress through the course in the practice challenges at the end of each section.

01 - Introduction

01 - Automating your work with Excel macros

02 - 1. Getting Started

01 - Applying basic programming with macros

02 - Understanding VBA code created by macros

03 - Security settings

04 - Recording a macro that formats

05 - Running existing macros

03 - 2. Creating Routines with Macros and VBA Code

01 - The VBA window and VBA components

02 - Using For and ForNext statements

03 - Using Do While and Do Until statements

04 - Capturing input for macros

05 - Leveraging macros for the VBA code

06 - Calling macros to run in sequence

07 - Leveraging row counts for formatting

08 - Challenge Adding an input box

09 - Solution Adding an input box

04 - 3. Using Macros and VBA for Personal Productivity

01 - Saving to the personal macro workbook

02 - Understanding when to use absolute or relative references

03 - Using logic in macros

04 - Creating a custom Ribbon tab for macros

05 - Leveraging the Quick Access Toolbar for macros

06 - Challenge Adding a remove rows macro to every file

07 - Solution Adding a remove rows macro to every file

05 - 4. Running a Macro

01 - Creating a shortcut for your macro

02 - Planning and creating macros for navigation

03 - Challenge Adding a help button for information

04 - Solution Adding a help button for information

06 - 5. Troubleshooting and Debugging

01 - Debugging code with stepping through

02 - Setting a breakpoint and blocking comments

03 - Challenge Troubleshooting broken macros

04 - Solution Troubleshooting broken macros

07 - Conclusion

01 - Applying macro and coding concepts

02 - Extending your capabilities with macros

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)