Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Excel VBA Programming - The Complete Guide
Excel VBA Programming - The Complete Guide

Excel VBA Programming - The Complete Guide: Automate your Excel workflow, accelerate your productivity, and master the fundamentals of programming with VBA!

Arrow left icon
Profile Icon Boris Paskhaver
Arrow right icon
$9.99 $178.99
Full star icon Full star icon Full star icon Full star icon Half star icon 4.4 (5 Ratings)
Video Aug 2019 17hrs 19mins 1st Edition
Video
$9.99 $178.99
Subscription
Free Trial
Renews at $19.99p/m
Arrow left icon
Profile Icon Boris Paskhaver
Arrow right icon
$9.99 $178.99
Full star icon Full star icon Full star icon Full star icon Half star icon 4.4 (5 Ratings)
Video Aug 2019 17hrs 19mins 1st Edition
Video
$9.99 $178.99
Subscription
Free Trial
Renews at $19.99p/m
Video
$9.99 $178.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Key benefits

  • Intermediate knowledge of popular Excel features and basic knowledge of data types is required to take this course

Description

Welcome to Excel VBA Programming–The Complete Guide, the most comprehensive VBA course! Visual Basic for Applications (VBA) is a powerful language built on top of popular Microsoft Office applications such as Excel, Access, and Outlook. It allows developers to write procedures called macros that perform automated actions. Anything that you can do in Excel, you can automate with VBA! Over the course of more than 18 hours of content, we cover VBA from the ground up, beginning with the fundamentals and proceeding to advanced topics including: • The Excel Object Model • The Visual Basic Editor • Objects and methods • Variables and data types • Writing your own procedures • Workbooks and workbook objects • Worksheets and worksheet objects • Range references • Range actions • Conditional logic • Iteration • Alerts • Configuring Excel functionality • Custom functions • Arrays • Debugging, even procedures, and user forms No programming experience is required; complete beginners are more than welcome! VBA is a great language to start with because it lets you master the fundamentals of programming in a familiar work environment. No extra software is necessary: VBA is bundled with all modern versions of Excel. Excel is the World's most popular spreadsheet software and is available on over 750 million computers worldwide. Whether you use it for professional or personal reasons, VBA can help you remove redundancy in your workflows and accelerates your productivity drastically! Thanks for checking out this course! All the code and supporting files for this course are available at - https://github.com/PacktPublishing/Excel-VBA-Programming---The-Complete-Guide

Who is this book for?

This course is for spreadsheet users who want to automate their daily workflow and business analysts who want to remove redundancy from their common tasks. Excel users who are curious about exploring programming in a familiar work environment will also benefit from the course.

What you will learn

  • Automate tasks and procedures in Excel using Visual Basic for Applications (VBA)
  • Utilize objects in the Excel Object Model to emulate user actions in Excel
  • React dynamically to user events such as entering a cell value or opening a workbook
  • Get comfortable with the fundamentals of computer programming

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Aug 23, 2019
Length: 17hrs 19mins
Edition : 1st
Language : English
ISBN-13 : 9781839214240
Vendor :
Microsoft
Languages :
Tools :

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Product Details

Publication date : Aug 23, 2019
Length: 17hrs 19mins
Edition : 1st
Language : English
ISBN-13 : 9781839214240
Vendor :
Microsoft
Languages :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total $ 95.97 264.97 169.00 saved
Excel VBA Programming - The Complete Guide
$9.99 $178.99
Hands-On Financial Modeling with Microsoft Excel 2019
$38.99
VBA Automation for Excel 2019 Cookbook
$46.99
Total $ 95.97 264.97 169.00 saved Stars icon
Banner background image

Table of Contents

17 Chapters
Getting Started Chevron down icon Chevron up icon
The Fundamentals of the Excel Object Model Chevron down icon Chevron up icon
The Visual Basic Editor Chevron down icon Chevron up icon
Objects and Methods Chevron down icon Chevron up icon
Variables and Data Types Chevron down icon Chevron up icon
Procedures Chevron down icon Chevron up icon
Object Deep Dive Chevron down icon Chevron up icon
Range References Chevron down icon Chevron up icon
Range Actions Chevron down icon Chevron up icon
Conditionals Chevron down icon Chevron up icon
Iteration Chevron down icon Chevron up icon
Miscellaneous Features Chevron down icon Chevron up icon
Arrays Chevron down icon Chevron up icon
Functions Chevron down icon Chevron up icon
Debugging Chevron down icon Chevron up icon
Events Chevron down icon Chevron up icon
User Forms Chevron down icon Chevron up icon

Customer reviews

Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.4
(5 Ratings)
5 star 40%
4 star 60%
3 star 0%
2 star 0%
1 star 0%
N/A Jan 20, 2022
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Super Service! Fast delivery.
Feefo Verified review Feefo
Anil Kumar Tatineni Jun 27, 2020
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I purchased Excel VBA course video. Boris has done a great job in explaining the subject. At $7.9 it is value for money.
Feefo Verified review Feefo
Erik Oct 25, 2024
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
Very good education about excel vba progrogramming. Ended a little abrupt without a summary or information about course ending?
Subscriber review Packt
N/A Mar 19, 2022
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
Very informative & easy to follow
Feefo Verified review Feefo
Soon Siong Tan Jan 13, 2022
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
The tutorial are clear and easy to understand.
Feefo Verified review Feefo
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How can I download a video package for offline viewing? Chevron down icon Chevron up icon
  1. Login to your account at Packtpub.com.
  2. Click on "My Account" and then click on the "My Videos" tab to access your videos.
  3. Click on the "Download Now" link to start your video download.
How can I extract my video file? Chevron down icon Chevron up icon

All modern operating systems ship with ZIP file extraction built in. If you'd prefer to use a dedicated compression application, we've tested WinRAR / 7-Zip for Windows, Zipeg / iZip / UnRarX for Mac and 7-Zip / PeaZip for Linux. These applications support all extension files.

How can I get help and support around my video package? Chevron down icon Chevron up icon

If your video course doesn't give you what you were expecting, either because of functionality problems or because the content isn't up to scratch, please mail customercare@packt.com with details of the problem. In addition, so that we can best provide the support you need, please include the following information for our support team.

  1. Video
  2. Format watched (HTML, MP4, streaming)
  3. Chapter or section that issue relates to (if relevant)
  4. System being played on
  5. Browser used (if relevant)
  6. Details of support
Why can’t I download my video package? Chevron down icon Chevron up icon

In the even that you are having issues downloading your video package then please follow these instructions:

  1. Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
  2. Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.