Excel VBA Programming for Beginners
IC0976

Excel VBA Programming for Beginners

Do you work with data in Excel every day? Do you want to take your skills to the next level and improve your efficiency and reduce repetitive work? This course is designed for individuals and professionals who are new to Visual Basic for Applications (VBA) and who are seeking practical ways to automate frequently performed tasks in Microsoft Excel. Contains Exercise Excel Practice workbooks with solutions.

1  Reviews   4.0 of 5.0

Course Goal

  • Learn how to automate Excel tasks and operations that you perform frequently
  • Discover how to define and manage variables - subroutines and functions
  • Learn how input boxes and message boxes can interact with end users
  • Create cross-functional flowcharts

Audience

  • Consultants
  • Developers
  • End users
  • IT/Business analysts
  • Project Managers
  • Project team members

Exam/Certificate


Lesson Plan

2
Getting Started
3
The VBA Editor
4
First Coding Manipulations

5
VBA Syntax, Keywords, and Comments
6
Objects and VBA's Intellitext
7
Variables and Method Calling Rules
8
How to Define and Manage Variables
9
Constant Variable Types and Variables through Intellitext

10
Subroutines
11
Logical Constructs: The Boolean Type
12
Logical Constructs: If and Switch Statements
13
Methods for Communicating to the User
14
Looping: The For and Do While Loops
15
Looping: Collections and the For Each Loop

16
Functions
17
Returning Values from Functions
18
Completing Exercise 5
19
Determining Limitations
20
The Worksheet Function Object
21
Completing Exercise 5
22
The Range Object
23
Writing an Array Formula

24
The Application Object
25
The Workbook and Worksheet Objects
26
Using Errors to Guide You
27
The Name and Names Objects
28
The PivotTable Object
29
The Chart and ChartObject Objects
30
The PageSetup Object and Print Ranges
31
One Approach To Completing Exercise 8

32
Concluding Remarks
33
Course Excel Exercise Lesson Files with Solution Files for download

Instructor

Simon Calder

4.8 Average Rating

4 Reviews

49 Students

5 Courses

Simon Calder

President

Simon Sez IT makes business and technical software simple to learn. We teach people to use the most popular business software including Microsoft Office, Microsoft Project, Photoshop, Web Design and QuickBooks. We've been teaching online for over ten years.

It all started when the owner, Chris "Simon" Calder was working as a Project Manager in IT for one of Los Angeles most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course which he sold on DVD via eBay. Fast forward to now and Simon Sez IT has taught hundreds of thousands of students through its online course platform and popular YouTube channel.


More Courses by Simon Calder:

Complete Excel 2019 for Beginners
Complete Excel 2019 for Beginners

This Excel course is perfect for those who are new to Excel and who are using Excel 2019 or Excel 365 editions. In th...

5.0

Average Rating

Excel 2019 Advanced
Excel 2019 Advanced

Move your knowledge beyond the basics and supercharge your Excel capabilities. With this 8-hour, expert-led video tra...

5.0

Average Rating

Excel 2016 Intermediate
Excel 2016 Intermediate

This course takes you well beyond the beginner stage to become an Excel power user. Learn the additional advanced ski...

New Course - Not Enough Reviews yet

View All Courses

Student Feedback

4.0

Average Rating

Reviews

Annual Subscription to All Courses
$1599

Or subscribe to this course for

$219


Training 5 or more people?

Unlimited access for your entire SAP team including admin platform and premium reporting.

SAP Training for Businesses

Language: English
Level: Expert
Duration: 4.00 hours
Type:  Instructor-led
Release: Enterprise Software
Category: Business Productivity

SAP students

198

student views.
Join them!


Related Courses