Description
Master Microsoft Excel Macros and Excel VBA The name of a training series on working with the powerful Microsoft Excel software. The following set helps you learn how to perform your daily routine tasks correctly and automatically. This course deals with two topics in particular: Excel Macros and Excel VBA. From this course, you will also learn how to write your own code easily. You will also learn the concepts correctly in this tutorial.
Master courses cover Microsoft Excel Macros and Excel VBA
Dear students, you will learn to create real projects from Excel macros and Excel VBA from start to finish using this course. You will also have access to 66 video tutorials in this course, at the end of which you will become an expert in both Excel Macros and Excel VBA.
Course Specification:
- Publisher: Udemy
- Instructor: Kyle Pew
- Level: Basic to advanced
- Duration: 05:30:51
- Number of lessons: 66 lessons
- Language: English with English subtitles
Master Title in Microsoft Excel Macros and Excel VBA
Course Introduction and Overview
2 Lectures
11:05
Project #1: Using Excel’s Macro Recorder Tool
8 Lectures
25:06
Excel VBA Concepts
8 Lectures
44:20
Project #2: Moving Beyond the Basics and Into VBA
8 Lectures
39:01
Project #3: Preparing and cleaning data with a little VBA
7 lectures
25:28
Project #4: Using VBA to Automate Excel Formulas
6 Lectures
26:41
Project #5: Bringing everyone together and creating a weekly report
5 lectures
23:24
Project # 6: Working with VBA Forms
12 lectures
53:24
Project #7: Importing Data from Text Files
8 Lectures
46:27
Course Completion
2 Lectures
02:04
Prerequisites:
To complete the projects detailed in this course, you will need to have Microsoft Excel loaded on your computer. Any version of Excel will work.
The videos are recorded using Excel 2013, but Excel 2007, 2010, 2013, or 2016 will work to follow along.
Pictures
installation Guide
After extract watch it with your favorite player.
This tutorial has English subtitles.
download link
File Password: free download software
size
1.13 GB