Course Information
Course Overview
Learn how to use the power of Excel Macros and VBA to automate and reduce you Excel workload to almost nothing!
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:
- What macros are and why you should use them.
- How to read and edit Visual Basic for Application code, and quickly edit macros.
- How to make conditional macros that work in a variety of situations.
- How to create macros that apply effects dynamically to large sets of Excel data.
- How to save enormous amounts of time by automating your Excel work.
Course Content
- 6 section(s)
- 16 lecture(s)
- Section 1 Welcome to Excel 2013: Macros!
- Section 2 What is a Macro and when to Use Them?
- Section 3 Let's Explore Visual Basic for Applications (VBA)!
- Section 4 Unlock the True Power of Macros, Starting Here
- Section 5 Supplemental Lectures
- Section 6 Was this Course Worth Your Money?
What You’ll Learn
- Automate your Excel workload
- Impress your boss with your Excel wizardry!
- Build your Resume by adding Excel Programming to your Skills
Skills covered in this course
Reviews
-
GGeorge Takyi
Course is OK. Could use better video . Last update on the course by instructor was almost 10 years ago in August 2015! Need to archive the course or update.
-
KKendall Gill
As a beginner I found it very interesting, work with excel every day yet I never knew what a macro was, Thank you!
-
SSalaheddine Mokhlis
je n'ai pas trouvé rien de spécial sur ce cours, très très basique. Aucune utilité.
-
MMarcin Gut
Nagrywanie makr - ok VBA - totalne podstawy, które większość kursów pokrywa w jednym/dwóch filmikach. Dobre dla osób bez doświadczenia