Excel: Macros in Depth

Focused View

Robin Hunt

2:14:35

9 View

01 - Introduction

01 - Automating your work with Excel macros.mp4

00:33

02 - 1. Getting Started

01 - Applying basic programming with macros.mp4

02:49

02 - Understanding VBA code created by macros.mp4

03:42

03 - Security settings.mp4

04:39

04 - Recording a macro that formats.mp4

10:01

05 - Running existing macros.mp4

05:36

03 - 2. Creating Routines with Macros and VBA Code

01 - The VBA window and VBA components.mp4

06:19

02 - Using For and ForNext statements.mp4

10:19

03 - Using Do While and Do Until statements.mp4

07:24

04 - Capturing input for macros.mp4

03:38

05 - Leveraging macros for the VBA code.mp4

07:39

06 - Calling macros to run in sequence.mp4

05:24

07 - Leveraging row counts for formatting.mp4

02:57

08 - Challenge Adding an input box.mp4

00:22

09 - Solution Adding an input box.mp4

02:18

04 - 3. Using Macros and VBA for Personal Productivity

01 - Saving to the personal macro workbook.mp4

04:23

02 - Understanding when to use absolute or relative references.mp4

03:16

03 - Using logic in macros.mp4

07:28

04 - Creating a custom Ribbon tab for macros.mp4

04:13

05 - Leveraging the Quick Access Toolbar for macros.mp4

02:13

06 - Challenge Adding a remove rows macro to every file.mp4

00:28

07 - Solution Adding a remove rows macro to every file.mp4

05:15

05 - 4. Running a Macro

01 - Creating a shortcut for your macro.mp4

03:10

02 - Planning and creating macros for navigation.mp4

09:48

03 - Challenge Adding a help button for information.mp4

00:21

04 - Solution Adding a help button for information.mp4

01:33

06 - 5. Troubleshooting and Debugging

01 - Debugging code with stepping through.mp4

06:17

02 - Setting a breakpoint and blocking comments.mp4

08:27

03 - Challenge Troubleshooting broken macros.mp4

00:16

04 - Solution Troubleshooting broken macros.mp4

02:01

07 - Conclusion

01 - Applying macro and coding concepts.mp4

01:12

02 - Extending your capabilities with macros.mp4

00:34

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Macros

Robin Hunt

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.