Excel Macros and VBA: Automate Your Excel Workload

This video explians what macros are and how they can be used to drastically reduce your Excel workload.

This video shows you even more examples of how macros can reduce your Excel workload.

We create our first macro using the macro recorder! This video will show you how to start recording a macro, and what to do every step of the way while recording.

This video shows you how to access the code that is generated by the macro recorder. You will also learn how editing the code to fix a macro can be much easier than rerecording a marco.

This video shows you the many ways that you can run macros once you've created them.

This video gives you a brief tour of the Visual Basic for Applications environment, and shows you how to easily recognize code segments.

In this video, we create a simple macro and edit the code in the Visual Basic for Applications environment.

This video shows you how to use conditional IF statements in Visual Basic for Applications (VBA) to make macros that change based on the context in which they're run.

This video show you when to use absolute and relative references when recording macros.

This video explains how to use the For Next code structure in Visual Basic for Applications (VBA) to reduce the amount of actions you have to record to a macro.

This video explains how to use Do While and Do Until loops in Visual Basic for Applications (VBA) to dynamically apply macros that require repetitive actions.

If you're not familiar with relative and absolute references this video is for you. You will need to know these concepts to take full advantage of macros.

This is the code to the macro used at the end of lecture 3. It automatically converts a list of clients to a database-like format.

This video shows you how to leave a review. I like both positive and negative reviews. They let me know what people like and what people don't like.

This video shows you how to request a refund if you're not satisfied with the course. Please leave a comment to tell to why you're not satisfied, so I can continue to improve my course.