Udemy – Master Microsoft Excel Macros and Excel VBA 2018-2

Description

Master Microsoft Excel Macros and Excel VBA is the name of a training package for working with the powerful Microsoft Excel software. The following collection will help you learn how to carry out your usual daily tasks correctly and automatically. In this training course, two topics are specifically addressed to Excel Macros and Excel VBA. You will also learn how to write the code you need more easily with this course. You will also learn the concepts correctly in this tutorial.

Features of the Microsoft Excel Excel Macros and Excel VBA course

Dear students, using this training course, you will learn to prepare real projects from Excel Macros and Excel VBA from the beginning to the end. In this training course, you students will also have 66 video training sessions in front of you, which at the end of this course, you will become an expert in both Excel Macros and Excel VBA.

Course specifications

Publisher: Udemy

Instructor: Kyle Pew

Level: Basic to Advanced

Duration: 05:30:51

Number of lessons: 66 lessons

Language: English with English subtitles

Master Excel Microsoft Excel Macros and Excel VBA headings

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 togther and create 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

Prerequisites

In order to complete the projects detailed in this course, you will need Microsoft Excel loaded on you 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.

Installation

After Extract, watch with your favorite Player.

This tutorial has English subtitles.