If you already use Excel, you know how repetitive and time consuming some tasks can be. This course is designed to teach you how to take those repetitive and time consuming Excel tasks, and make them happen in a click of a button! If you use Excel a lot in your work, this course is essential; it will reduce your workload significantly.
In this course you will learn:
In addition to the video courses and exercise files, you will have access to me! Come visit me during my office hours on Tuesdays & Thursdays from 10am - 12pm EST. This will give you a chance to ask any questions that you may have, or just stop by to say hello! All you have to do is go to the discussion section of the course and post whatever you'd like me to see.
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 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.
We are dedicated to producing high quality educational content for Udemy students. When you enroll in any of our courses, you can be confident that that it will be continually updated with the latest, most accurate information.
Think Forward Training is partnered with experts in many topics including Excel, Matlab, and Musical performance. We have many courses in the works, covering a broad range of topics. We look forward to developing a trusted student-instructor relationship with you!