All Levels
16 hours
Java Tutorial for Complete Beginners
Learn to program using the Java programming language
John Purcell
What you'll learn:
- ✓Learn to program in Java
16 hours
73 lectures
Access on mobile and TV
Certificate
DevelopmentJava
All LevelsOffice ProductivityExcel VBA
Master Microsoft Excel Macros and Excel VBA
Project Based Course on Excel VBA (Visual Basic for Applications) and Excel Macros
Created by Kyle Pew • 2,000,000+ Students
5 hours
Video Content
64
Lectures
98,123
Students
4.6
Rating
4.6
(98,123 students enrolled)What you'll learn
✓Learn how to automate daily routine tasks within Excel
✓Learn best practices when creating macros and streamline your VBA code
✓Determine when it's best to use the Macro Recorder versus VBA
✓Learn how to write custom VBA Macros to create more robust automation
✓Learn VBA programming concepts to create dynamic, re-usable code
✓Complete real world Macro/VBA projects from beginning to end
Course Content
10 sections • 64 lectures • 05:25:04 total length
Course Introduction and Overview
2 lectures • 11:05
Course Introduction and Overview
2 lectures • 11:05
Welcome to the Course05:50
Understanding the Why and How Behind Excel Macros05:15
Project #1: Using Excel's Macro Recorder Tool
8 lectures • 25:06
Project #1: Using Excel's Macro Recorder Tool
8 lectures • 25:06
Introduction to Project #1 - Inserting and Formatting Text02:01
Project #1 - Start Recording!07:40
Running A Macro02:43
Project #1 - Running a Macro with a Button03:35
Project #1 - Opps! I Need to Edit My Macro04:27
+4 more lectures
Excel VBA Concepts
8 lectures • 44:20
Excel VBA Concepts
8 lectures • 44:20
Excel VBA Concepts03:32
The Visual Basic Editor03:25
Excel VBA Modules02:01
Creating Excel VBA Procedures08:17
Adding Code to a VBA Procedure04:04
+4 more lectures
Project #2: Moving Beyond the Basics and Into VBA
8 lectures • 39:01
Project #2: Moving Beyond the Basics and Into VBA
8 lectures • 39:01
Introduction to Project #2 - Interacting with the User02:56
Project #2 - Breaking Down the VBA Code03:34
Project #2 - Prompting the User for Information06:54
Continue Excel VBA InputBox07:20
Project #2: Building Logic in Your Macros04:31
+4 more lectures
Project #3: Preparing and cleaning up Data with a little VBA
7 lectures • 25:28
Project #3: Preparing and cleaning up Data with a little VBA
7 lectures • 25:28
Introduction to Project #3 - Cleaning Up and Formatting Multiple Worksheets03:06
Project #3: Preparing to use the Macro Recorder02:54
Project #3 - Inserting the Headers03:26
Project #3 - Formatting the Headers02:21
Project #3 - Putting it all Together with alittle VBA Magic10:47
+3 more lectures
Project #4: Using VBA to automate Excel Formulas
6 lectures • 26:41
Project #4: Using VBA to automate Excel Formulas
6 lectures • 26:41
Introduction to Project #4 - Automate Microsoft Excel Formulas with VBA02:10
Project #4: Automate the SUM Function through Code08:01
Project #4 - Continue Automate SUM Function06:28
Project #4 - Test the SUM Function03:45
Project #4: Loop the SUM Function over Multiple Worksheets06:17
+2 more lectures
Project #5: Bringing it all togther and create a weekly report
5 lectures • 23:24
Project #5: Bringing it all togther and create a weekly report
5 lectures • 23:24
Introduction to Project #5 - Creating a Final Report02:59
Project 5: Creating the Final Report Loop07:45
Project #5 - Copying and Pasting Data with VBA09:26
Project #5 - Running the Final Report Procedure03:14
Project #5 - Quiz - Test Your Knowledge of Creating the Final Report3 questions
+1 more lectures
Project #6: Working with VBA Forms
11 lectures • 48:30
Project #6: Working with VBA Forms
11 lectures • 48:30
Introduction to Project #6 - Working with Excel VBA Forms03:01
Project #6: Creating an Excel VBA Form05:05
Project #6: Adding Controls to the Form04:01
Project #6: Adding VBA Code to the Initialize Event of the Form08:49
Project 6: Adding VBA Code to the ComboBox Change Event04:32
+7 more lectures
Project #7: Importing Data from Text Files
8 lectures • 46:27
Project #7: Importing Data from Text Files
8 lectures • 46:27
Project #7: Opening a Text File for Import06:45
Project #7: Get Data from Text File05:30
Project #7: Importing Multiple Text Files with the GetOpenFilename Method09:32
Project #7: Creating a Loop to Read Each File07:26
Project #7: Adding a New Sheet for Imported Data02:36
+3 more lectures
Course Wrap Up
1 lectures • 01:02
Course Wrap Up
1 lectures • 01:02
Congratulations! You're an Excel Macro/VBA Master01:02
Description
Course Material Works in Microsoft Excel 2007, 2010, 2013 and 2016
Join me in this course and take control of Microsoft Excel and master the process of automating routine tasks through the use of Excel Macros and Excel VBA.
During this course you will build a foundation of working with Excel Macros and VBA. This foundation will be built as you engage and participate in project based Excel Macro/VBA exercises, detailed throughout the lectures within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks.
As you engage and participate in this course, you will be introduced to the wonders of creating simple Macros through the Macro Recorder and then quickly take you into the world of Excel VBA where you will experience building a more dynamic, robust experience for yourself and your peers.
Each project contains exercise files that you can download and use to complete the assigned Excel Macro/VBA projects. The course also contains detailed instructions through the video lectures as well as a series of PDF documents that you can reference as you complete the projects.
Below are a few samples of the projects you will complete by enrolling and participating in this course.
- Automate placing and formatting a title on a worksheet
- Interact with the users of your Macros through Input and Message boxes in order to receive input on how a Macros should work
- Cleaning up multiple Excel Worksheets and prepare the data to be reported on
- Create a report based on multiple sets of data found within multiple Excel Worksheets, copying data from one Worksheet into the Master Report Worksheet
- Automate the creation of Excel Formulas to SUM data up in your Report
- Working with Excel VBA User Forms
- Importing Data from External Text Files
Each of these projects will direct you through key Excel VBA programming concepts and direct you to identify and use best practices in creating Excel Macros.
So, don’t lose another moment performing Excel tasks manually. Enroll now and learn how you can get Microsoft Excel to your work for you.
Who this course is for:
- This Excel Macro/VBA course is meant for those that use Microsoft Excel and are looking to become more efficient by automating their daily Excel tasks. No prior programming experience is required.
This course includes:
- 5 hours on-demand video 0
- 17 downloadable resources
- Access on mobile and TV
- ∞Full lifetime access
- Certificate of completion
Instructor
Kyle Pew • 2,000,000+ Students
Students also download
Explore related courses to expand your learning journey.
All Levels
22 hours
The Complete Python Bootcamp From Zero to Hero in Python
Learn Python like a Professional Start from the basics and go all the way to creating your own applications and games
Jose Portilla
What you'll learn:
- ✓You will learn how to leverage the power of Python to solve tasks.
- ✓You will build games and programs that use Python libraries.
- ✓You will be able to use Python for your own work problems or personal projects.
- +9 more skills
22 hours
156 lectures
Access on mobile and TV
Certificate
DevelopmentPython
All Levels
52 hours
100 Days of Code: The Complete Python Pro Bootcamp
Master Python by building 100 projects in 100 days. Learn data science, automation, build websites, games and apps!
Dr. Angela Yu, Developer and Lead Instructor
What you'll learn:
- ✓You will master the Python programming language by building 100 unique projects over 100 days.
- ✓You will learn automation, game, app and web development, data science and machine learning all using Python.
- ✓You will be able to program in Python professionally
- +6 more skills
56.5 hours
592 lectures
Access on mobile and TV
Certificate
DevelopmentPython