Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Life Purpose Meditation Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Blender
30-Day Money-Back Guarantee

This course includes:

  • 12.5 hours on-demand video
  • 1 article
  • 52 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Development Programming Languages Excel

The Ultimate Excel Programmer Course

Learn Excel VBA from Scratch with Dan Strong, Bestselling Excel Expert with Over 180K Students Worldwide!
Bestseller
Rating: 4.5 out of 54.5 (13,621 ratings)
102,105 students
Created by Daniel Strong
Last updated 8/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Automate and Customize data entry forms
  • Choose the right Loop for each task
  • Master the CELLS and RANGE objects in multiple scenarios
  • Create multiple Variable styles to match your need
  • Customize your VBA Editor and Understand all the Toolbars and options
  • Debug and Troubleshoot code like a boss!
  • Record, Modify or Write Macros from scratch
  • Make Custom Formulas/Functions on the fly
  • Breeze through IF THEN statements and conquer all the Logical Operators
  • Batch out inter-active MessageBoxes, InputBoxes and give users CHOICES!
  • Generate Basic Reports that can be printed
  • Add filters to report menus to narrow the records
  • Take control of forms, Buttons, Drop-down menus, Checkboxes and option buttons AND so much more. . .
  • Trigger code from a number of different methods - from Clicking on a cell - to De-Selecting a worksheet.
  • Set up Special Commands when a workbook: Opens or closes, is selected, any cell or certain cells are selected, right before printing, etc. . .
  • Manipulate Userforms for data entry, report generation, editing tables/databases - ALL within your control. Restrict the flow of data OR make the Userform(s) responsive, calculating, INTUITIVE.
  • Streamline your work and the work of others.
  • Put Excel ON AUTOPILOT. . .
Curated for the Udemy for Business collection

Course content

12 sections • 212 lectures • 12h 31m total length

  • Preview04:08
  • Preview01:29
  • Preview01:19
  • Quick Tip - Project Explorer and Properties Window!
    01:11
  • Creating Your First Macro From Scratch
    02:28
  • Adding a Secondary Command. . .
    00:51
  • Debugging in Excel VBA
    01:22
  • Saving a Macro-Enabled Workbook (.xlsm)
    01:11
  • Before You Begin The Exercises
    03:06
  • Exercise 01 - Question
    00:12
  • Exercise 01 - Answer
    03:53
  • Several Ways to trigger your Macro
    01:22
  • Affecting Multiple Cells with One Range Command - 2 Methods
    01:34
  • Adding Strings of Text to a Cell
    01:40
  • Using a Named Range with the Range Object
    01:37
  • Range Object Quiz
    7 questions

  • .VALUE Property
    01:54
  • .TEXT Property
    00:59
  • .ROW and .COLUMN Properties
    01:07
  • .SELECT Property
    00:55
  • .COUNT Property
    01:47
  • Exercise 02a - Question
    00:12
  • Exercise 02a - Answer
    04:32
  • .ADDRESS Property
    01:48
  • .FORMULA Property
    03:47
  • .NUMBERFORMAT Property
    02:27
  • FONT.BOLD, UNDERLINE or ITALIC Properties
    02:43
  • Exercise 02b - Question
    00:12
  • Exercise 02b - Answer
    06:36
  • Properties Quiz
    8 questions

  • The Cells Object
    02:24
  • Using Column Letters instead of Numbers
    00:54
  • Using Cells Positionally within a Range
    02:10
  • Affecting ALL Cells in a Worksheet
    02:05
  • Exercise 03 - Question
    00:12
  • Exercise 03 - Answer
    04:12
  • Using Range Object with Cells Object
    03:01
  • Cells Quiz
    3 questions

  • Intro to Variables
    02:24
  • Declaring Variables - Variable Types
    02:37
  • Declaring Variables - Types Demo
    04:16
  • Concatenation - Joining Two Or More Strings!
    02:26
  • BONUS - Date Math Fun!
    03:41
  • Exercise 04 - Question
    00:12
  • Exercise 04 - Answer
    04:16
  • Calling a Procedure from Another
    01:57
  • Public and Private Variables
    03:06
  • Using Constants
    02:02
  • Preview07:05
  • Variables Quiz
    4 questions

  • File Menu walkthrough
    01:52
  • Edit Menu walkthrough
    05:08
  • View Menu walkthrough
    02:12
  • View Menu2 - Watch Window, Locals Window and Immediate Window
    07:43
  • Watch Window Wonders!
    03:24
  • Insert and Format Menus
    00:39
  • Debug Menu (Important!)
    05:12
  • Run and Tools Menus
    02:09
  • Toolbars Quiz
    4 questions

  • Determining the Last Row in your Data Set
    03:17
  • Determining the Last Column in your Data Set
    02:23
  • Determining the Next Row in your Data Set
    01:05
  • Recording a Macro
    03:38
  • Preview05:54
  • Absolute vs Relative References
    04:07
  • Using With and End With
    03:32
  • Comparison Operators in Excel VBA
    01:01
  • If Then Statement
    02:25
  • Using Is Not Equal To (<>)
    00:41
  • Logical Operator, NOT
    00:56
  • Exercise 06a - Question
    00:12
  • Exercise 06a - Answer
    04:42
  • If, Then, Else Statement
    01:22
  • If, Then, ElseIF Statement. . .
    02:02
  • Comparitive Operators with Text and Numbers!
    02:35
  • Use If Then Statements in a One-Liner of code
    01:42
  • Using GOTO and Labels
    01:52
  • Select Case as Alternative to IF THEN Statements
    02:21
  • Message Box with Yes and No Buttons
    06:27
  • Exercise 06b - Question
    00:12
  • Exercise 06b - Answer
    06:33
  • Relative Positioning using Offset
    04:13
  • Preview04:49
  • Preview04:08
  • Super Important Info Quiz
    5 questions

  • Intro to Loops; the For Next Loop
    03:07
  • Fun with our For Next Loop
    03:46
  • Beginning our first Report using Loops
    05:46
  • Using an InputBox
    02:53
  • Adding InputBox to Our First Report to make it Dynamic
    03:12
  • Add a Button to Open Our Report
    02:23
  • Add a Cool Looking Button or Image to Open Report
    02:19
  • Our First Printable Report part 1 - Declaring and Setting the Sheets
    05:00
  • Printable Report Part 2 - Getting Items On Report Sheet
    06:41
  • Printable Report Part 3 - Clearing Last Report
    03:19
  • Printable Report Part 4 - Ensuring Visibility and Autoselect Report Sheet
    03:34
  • Exercise 07a - Question
    00:12
  • Exercise 07a - Answer
    11:18
  • Using PrintPreview Automatically
    00:50
  • Using PrintOut to Send Directly to Default Printer
    01:59
  • Handling Debug Error When Cancelling InputBox
    02:18
  • For Loop Going Backwards using STEP
    02:49
  • The FOR EACH Loop
    05:17
  • FOR EACH Loop - Practical Examples
    03:30
  • Exercise 07b - Question
    00:12
  • Exercise 07b - Answer
    07:33
  • Intro to DO LOOPS
    03:26
  • DO Until
    01:53
  • Loop Until
    01:31
  • DO While
    01:43
  • Loop While
    00:58
  • EXIT DO - Multiple Exits using your own Criteria along the Way!
    01:48
  • BONUS - Loop Through Multiple Files in a Folder and Scrape Data From Each
    12:09
  • Loops and Reports Quiz
    4 questions

  • Intro to Worksheet Events and Selection_Change
    04:03
  • Worksheet Activate Event
    01:13
  • Worksheet Deactivate Event
    02:28
  • BeforeDelete Event - for Worksheet Deletion
    01:05
  • BeforeDoubleClick Event - Trigger a Macro when Double Clicking
    02:59
  • BeforeRightClick Event - Trigger a Macro when Right-Clicking
    01:43
  • Calculate Event
    02:33
  • Exercise 08a - Question
    00:12
  • Exercise 08a - Answer
    02:09
  • How to Disable Events on the Workbook
    01:32
  • Intro to Change Event
    01:14
  • Change Event with EnableEvents toggle - Avoid endless loop!
    04:51
  • Change Event Triggered with Custom Range Using Intersect
    03:19
  • FollowHyperlinks Event
    02:41
  • Final Thoughts on Worksheet Events and Review Other Events
    02:25
  • Exercise 08b - Question
    00:12
  • Exercise 08b - Answer
    05:42
  • Worksheet Events Quiz
    4 questions

  • Workbook Open
    05:13
  • Workbook Activate
    01:53
  • Before Save
    02:25
  • After Save
    02:13
  • Before Close
    03:32
  • Before Print
    01:21
  • Deactivate
    01:06
  • NewChart
    03:13
  • NewSheet
    01:50
  • Exercise 09 - Question
    00:12
  • Exercise 09 - Answer
    04:36
  • Sheet Activate
    02:19
  • Delete, DoubleClick, RightClick, Calculate, Change
    04:51
  • SheetDeactivate
    02:49
  • Follow Hyperlink
    00:44
  • SheetSelectionChange
    00:42
  • WindowActivate
    01:09
  • WindowDeactivate
    00:25
  • WindowResize
    02:03

  • Activex Controls vs Forms Controls
    03:36
  • Button Click - Wage Calculator
    04:10
  • Keydown Event
    04:18
  • BONUS: Capturing Shift, Alt, Ctrl or some combination using the Shift variable
    03:19
  • KeyPress Event
    02:53
  • MouseMove Event
    02:08
  • MouseMove Event with Application.Statusbar - fun and useful
    03:44
  • MouseUp and MouseDown Events - Left, Middle, & Rightclick, Shift, Alt & Ctrl
    06:28
  • GotFocus and LostFocus Events
    01:09
  • Use a Checkbox for its VALUE
    02:41
  • Checkbox Event Without a Button
    01:58
  • LinkedCell Property with a Checkbox
    01:59
  • Option Buttons Intro - What is an Option Button and Grouping
    03:08
  • Grouping, Alignment and Aesthetics for Controls
    02:45
  • Homemade Quiz using Option Buttons and a Command Button
    04:37
  • Compliance Checker for your Forms or Quizzes Part 1
    03:36
  • Compliance check part 2
    09:50
  • SpinButton with Cell A1
    04:21
  • SpinButtons with Textboxes and Numbers
    06:04
  • SpinButton BONUS - Move Textbox Position with SpinButton
    03:55
  • SpinButton with Dates in a Textbox
    03:31
  • Activex "Label" Control - Basics
    03:50
  • ComboBox - Fill with ListFillRange
    03:34
  • Creating a Dynamic Range
    04:47
  • ComboBox - How to use Multiple Columns
    03:09
  • Using .ADDITEM to Get Specific items in your Combobox List
    09:25
  • Noteworthy Properties of a Combobox
    05:38
  • Multiple Columns in Combobox with .ADDITEM and List, ListCount etc
    07:16
  • ListBox Basics using Dynamic Range
    07:47
  • Listbox Click event and Dynamic Options
    03:26
  • BONUS - Manipulating and Using Multiselect Items in a Listbox
    06:04
  • ListBox - Referencing Column 0 and 1 in a cell Dynamically!
    03:32
  • Dynamic ListBoxes Using .ADDITEM and More
    09:37
  • Make and Utilize INVISIBLE Columns - Special Trick!
    03:35
  • Using a Scroll Bar on a worksheet
    03:29
  • Pictures on a Worksheet, plus using FollowHyperlink Method
    05:52
  • Toggle Button
    02:24
  • A Brief Note on Alternate, 3rd Party Controls
    01:34

Requirements

  • You should already have Microsoft Excel (version 2003 and up). Obviously the newer the better, but VBA works the same in all versions. It's just that newer versions have more options, thus more VBA Commands to control those options.
  • Very very basic Excel skills needed for this course (like opening the program, how to click on cells and type things.) You really don't need any Excel experience, because I'll take you from Start to Finish in this course. I was just trying to be funny.

Description

Teach Excel to Do Your Work FOR YOU. . .

Microsoft Office is everywhere, installed on over 750 million computers, but most users only know how to set up a basic table or maybe even do a few formulas here and there.

In my course, I teach you how to take Excel by the horns and make it do whatever you want, whenever you want. It can go through loads of information and create a printable report for you. You can make custom forms so that you can access, analyze, edit, or add new information quickly to your data tables/ worksheets.

Excel programming utilizes a simple but effective tool called "VBA" - the hidden programming language that runs quietly in the background while you work. It’s very easy and straight-forward to use.

I'll show you the easiest tricks to learn this basic language in a fun, progressive method. Learn at your own pace. With each of my short, info-packed lectures, you'll learn another essential skill that you can immediately use. You'll find yourself handling these Automation tools instantly and in any spreadsheet you already use every day. If there's one thing I'm good at - and my students are good at - it's AUTOMATION.

My motto is, "If I'm not making everybody's job easier, quicker and more enjoyable, I don't deserve to have this job" - and that's what I live by.

Take this course and access your true potential.

Oh, and I want to be the first to hear about your New Raise you get once you're making Excel Programs and running everything on autopilot for your co-workers!

-Dan


Here's what some of the students are saying:

“I love this course. Extremely easy to follow along. If you are looking to learn more about Excel this is it!” - Jim C.

“Loving this course! The information is presented quite clear and concise, and it is a really great way of learning VB really fast, yesterday I was a total ignorant of the subject. Today I programmed my first macro and cannot wait to learn more.” - Marcela T.

“I had experimented with VBA previously, but I really feel like this course is exactly what I needed to take my Excel knowledge to the next level. In only 2 weeks I've improved my reporting exponentially and it's all thanks to this course!" - Ryan S.

“You can't go wrong with Daniel Strong!” - Steven S.

“The presenter explains in detail and demonstrates what he's covering, easy to follow along and learn!” - David B.

“Teaches you the fundamental of VBA programming without any prior experience. Shows with easy to follow Example!. thanks for the video!”  - Sean C.

"I've taken several different VBA courses here on Udemy and this one from Daniel is by far the most interesting and easy to understand. I've done exactly 107 lectures so far and already was able to automate 80% of my tasks at work that I've been doing manually for years... I'm angry with myself because of the time I wasted by not buying this course earlier. I can't even imagine what I will be able to do after finishing the entire course :)" - Robert

“Well explained, easy to understand lectures. Enjoyable and informative videos.” - Marlena

“Very clear explanations broken down in short videos. Daniel goes at a slow pace that is easy to follow and understand, even for people with no programming experience.” - Gustavo P.

“Best course on VBA ever taken. Thanks a lot!” - Nikita L.

“This is an excellent course!!!  There's a lot of good, useful "stuff" here.  The examples are practical and real-world!” - Todd W.

“Wow, I thought I knew a little bit about Excel but clearly I had only seen the tip of the iceberg. This course has opened my eyes to the true power of VBA within excel. Great course, fantastic instructor.” - Scott K.

“By large and far, one of the best step by step guide to VBA programming I have ever seen. I have been playing around with VBA for over a year now, have watched countless videos and have read numerous articles and "How-to" guides, but I have never seen something this complete, this throughout. I am amazed at how little I actually new about the VBA world. Thanks a million!” - Alex B.

“Everything I have been looking for, you would have to buy multiple books for this level of instruction!” - Luke S.

"Excellent VBA basic to advance tutorial." – Sandeep G.

“This course is good for beginners and for experienced programmers.  Experienced programmers may want to skip through some sections on basics, but it is good to see how the basics work in the context of and excell worksheet.  He goes over different events and triggers (like buttons) to execute code.  This is a really good course if you plan to do some pretty complex vba code with forms and reports.”  - Christian H.

“Very helpful if you do any type of data analysis.” – Jonathan D.

“I think this is an excellent gateway to the tools we need to use going forward. I like the
hands on nature.”
– Andre C.

“Much better than other classes and seminars. Great course.” – Mark S.

“The instructor made VBA easy and straight forward to use.” – Min Z.

“Very thorough and practical.” – Juan S.


***Now Available for Offline Viewing!***

Who this course is for:

  • This Excel course is for anyone who wants to learn Automation secrets in Excel VBA. It’s for complete newbies and/or students looking for a refresher or Reference tool, to pick and choose relevant lessons for their projects. No prior programming knowledge is needed.
  • This course is probably not for you if you’re looking to learn super advanced report authoring, which will be covered in a future course specifically on this topic. We will, however, make sure you know how to make good solid reports from your data and many tricks to make them look good.
  • If you're using Excel for Mac, you will find that this course won't cover all the various differences in Excel Mac, as this course was filmed using Excel for PC and Excel VBA is a bit limited for Mac users, esp on the design side. Many students end up programming in windows and just using Mac to run the Excel wb or will virtualize Windows within Mac using programs like Parallels or Bootcamp.

Featured review

David Ryan Hall
David Ryan Hall
45 courses
18 reviews
Rating: 5.0 out of 5a year ago
I like how short and to the point the videos have been so far, not having 3 to 4 features in one video is nice and will make reviewing easier. Just took my first quiz and I appreciated how thorough it was, definitely tested me over the most important concepts, not a filler quiz like other courses offer with just 4 questions.

Instructor

Daniel Strong
Excel Instructor/Programmer
Daniel Strong
  • 4.5 Instructor Rating
  • 15,326 Reviews
  • 121,298 Students
  • 10 Courses

Hi! My name is Daniel and i'm 31. I've lived most my life in Missouri, United States. I've been using Excel since my early teens, and very early on realized that I absolutely love it. After working on various projects in my spare time for years, improving the lives of those that used my programs, I knew this was more than just a hobby for me; it's my passion. A few years back, I got my first opportunity to program in Excel, but when I landed the job I was asked to re-write my predecessor's coded programs with fancy databases and automated Crystal reports! I found my Excel skills somewhat lacking. I HAD TO LEARN VBA! I studied and studied what I could online and in books, but I wasn't able to learn much that way. I had to dive into my first project for months and months - basically just teaching myself and "figuring it out". I realized that if only someone was out there teaching Excel VBA like Mike Girvin (ExcelIsFun) taught Excel, making everything simple and visual - then Anyone could learn VBA! I started a YouTube channel, mostly for myself as a reference tool, but people started to bite. People flooded my inbox with questions and comments that I was literally changing their lives for the better. My passion is and always has been teaching, and I've turned thousands of people into Excel programmers. Now, with Udemy, I'm going to teach the good stuff - the stuff I kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistable and irreplacable. Building REAL Programs, Advanced Reporting and Data Analysis. Dashboards and live data. Automation. My main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems and change Real Lives.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.