Published on: 2020-03-22 11:51:17
Categories: 28
Share:
Master Microsoft Excel Macros and Excel VBA is the name of a training series on working with powerful Microsoft Excel software. The following set helps you learn how to perform your daily routine tasks correctly and automatically. This course deals exclusively with two topics: Excel Macros and Excel VBA. With this course you will also learn how to write your own code easier. You will also learn the concepts correctly in this tutorial.
Dear students, you will learn using this course to prepare real projects from Excel Macros and Excel VBA from start to finish. In this course, you will also have 66 video tutorials, at the end of which you will become an expert in both 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 up data with a little VBA
7 Lectures
25:28
Project # 4: Using VBA to automate Excel Formulas
6 Lectures
26:41
Project # 5: Bringing it all 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 Wrap Up
2 Lectures
02:04
In order to complete the detailed projects in this course, you will need Microsoft Excel loaded on your computer. Any version of Excel will work.
Videos have been recorded using Excel 2013, but Excel 2007, 2010, 2013 or 2016 will work in order to follow along.
View with your favorite Player after Extract.
This tutorial has English subtitles.
1.13 GB
Sharing is caring: