Excel 2007 VBA (Udemy.com)

Power up your workbooks with Visual Basic for Applications automation

Created by: Intellezy Trainers

Produced in 2016

icon
What you will learn

  • Understand the object model
  • Create, edit and run recorded macros
  • Understand the Visual Basic editor
  • Understand programming basics
  • Use Visual Basic functions
  • Create and use cotnrol structures
  • Create, use and edit UserForms
  • Debug macros and trap for errors

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 96 / 100

icon
Course Description

This course introduces you to Excel macro programming using Microsoft's Visual Basic for Application (VBA). The overall focus of this course is to teach you proper Visual Basic programming techniques along with an understanding of Excel's object structure. Other topics in this course include; recording macros, programming basics, proper variable declaration, Visual Basic functions, control structure use, looping, and Userform creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them.Who this course is for:
  • Intermediate and Advanced level users of Excel who need to automate worksheets and workbooks

icon
Instructor Details

placeholder

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today's rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.

icon
More courses by Intellezy Trainers

American Sign Language Level 1

$11.99

Windows 10 Troubleshooting

$11.99

Oracle PL/SQL Fundamentals vol. I & II

$11.99

Microsoft 365 Administration (Exam 70-346)

$11.99

Microsoft Azure Solutions (Exam 70-533)  9 Course Bundle

$11.99

Azure Introduction to Cloud Services

$11.99

icon
More visual basic .net courses

Basic C# Clearly Explained

$11.99

Let's Code: VB.Net Exercises for Beginners

$11.99

Learn To Program Tic-Tac-Toe with C# and Visual Studio

$11.99

What's New in C# 6, C# 7 and Visual Studio 2017

$11.99

Beginners Guide To C# With Visual Studio 2017

$11.99

VB.NET Introduction

$11.99

icon
Reviews

4.8

4 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Womberbat

Good video, very easy to follow along

By Gergely Kocsis

Everything was clear, I got all the explanations in every lesson.

Maybe the only thing I miss is the downloadable content per lessons, e.g. a text file which contains the macro which is being presented. But it may not do things faster. Thank you.

By Jan E

Very clear instructions. Instructor never use any filler words or say anything that is not on topic ... Hope it continues like this

By Heli Balassiano

i think that its very clear and help me very much to learn what i planed to learn. thanks a lot i like it:)