Excel: Macros in Depth (365/2019)

Learn about how to use macros to automate tasks in Excel and see how to create simple macros of your own. Veteran Excel trainer Dennis Taylor shows 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. The course wraps up with a macro project that brings together each of the elements in a real-world scenario: converting a mailing list into a database-friendly format.

Topics include:

• Explain automation using macros.
• Analyze the macro from the Developer tab or the View tab.
• Identify the use of macros from a keystroke shortcut.
• Examine the VBA window and VBA components.
• Distinguish between absolute and relative references.
• Apply best practices when testing a macro in step mode.

About the Author

Dennis Taylor is an Excel expert who has 25+ years of experience in spreadsheet authoring and training. Dennis has experience working as an author, speaker, seminar leader, and facilitator. Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the U.S. and Canada presenting over 300 seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented over 500 Excel webinars to a diversity of audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado.

Product Details

• Full Video Tutorials
• Video File Format: MP4
• Skill Level: Intermediate
• Video Duration: 2h 4m
• Instructor: Dennis Taylor