Skip to content
UdemyExcelPaid courseAll LevelsCertificate

The Ultimate Excel Programmer Course (Udemy.com)

Learn Excel VBA from Scratch with Dan Strong, Bestselling Excel Expert with Over 180K Students Worldwide!

Created by: Daniel Strong

Last updated January 2023

icon
What you will 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.

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.6 out of 5higher than 63% of them
  • Reviews17,286#24 of 356 by number of reviews
  • Length30.5 hourslonger than 94% of them
  • Last updatedJanuary 2023earlier than 58% of them

icon
Course 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!***

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Daniel Strong

Dan Strong is a renowned software instructor and efficiency solutions specialist with over 16 years of highly diversified experience in report generation, data analysis, automation, and various other Information Technology (IT) tasks. He is a passionate Excel VBA programmer and has been using Excel since his early teens. He has developed various programs that have improved the lives of those who use them. Dan's passion for teaching led him to start a YouTube channel where he taught Excel VBA, and he has turned thousands of people into Excel programmers. He has been recognized by Microsoft for developing innovative systems and creating effective training strategies. Dan is a founding member of the invite-only Microsoft Office Creators, Excel Creator Program, and Microsoft Tech Community programs. His 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. Daniel is 36 years old and currently resides in Missouri, United States.

icon
More courses by Daniel Strong

$199.99

$99.99

$174.99

icon
Reviews

4.6

17,286 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Michael Cartier on 5/15/2024

The content was okay, but the recording quality was not good. In many of the individual classes (especially sections 7 through the end), the presentation would just lock up for at least 30 seconds randomly, sometimes within just a few moments of each other. Frequently I had to refresh the screen one or more times, and other times I would physically close out of the internet for at least a minute and then wait for it to get back to my session. A lesson saying it only took say 7-8 minutes might end up taking 20-30 minutes. I tried varying the speed and other factors but it didn't help.

By Dave Seymour on 10/29/2023

Absolutely awesome course. Has pushed my excel programming to another level. The cost of the course is more than reasonable for the amount of training you’re getting. The course is well laid out and instructed very well. It literally takes you from zero to hero in no time.

By Dan Akins on 4/19/2023

Comprehensive, yet concise. Daniel presented complex VBA topics that was easy to comprehend. His step by step approach allowed me to duplicate the VBA examples provided and gain a thorough understanding of key VBA concepts. I highly recommend this course!!

By Russell Lait on 8/24/2022

This is a great course covering everything from the basics to advanced topics! I definitely learned a lot and have been able to apply the learnings toward building complex Excel applications that are being used by large groups within our enterprise.

By N K on 8/9/2022

Courses content are awesome, purposeful and easy to digest. Dan brings a lot of positive energy which makes him really interactive and entertaining to listen to, which definitely helped a lot during the some of the challenging parts of the course. Dan might be the best instructor I have found here on Udemy yet. I would definitely recommend the course for a non-VBA user like me!

By Erick Rodrigo García Hernández on 8/6/2022

This is a perfect course, where you'll get a new pack of skills for a industry applications, for me this was a PERFECT COURSE, able to make dynamic reports, searching applications, wonderful course, BUT i really want to know what is the next step, the next course.

By Lindsay LaPlante on 3/28/2022

Quite good. However he DOES give us exercises sometimes that I can't figure out, only to find out his solution contains things we have not gone over at all yet. That is very frustrating. Its happened multiple times, most notably with vlookup. We were just expected to have previous knowledge of this function I guess? But there were other ones too. It's not a bad course though, I'm learning a lot and I still recommend it Edit: So I just finished the course. Some more complaints I had were it would be nice to have more exercises later in the course. Especially the last Section, that's the best way to solidify the learnings he taught us. I also would have liked to know how to create or update charts with VBA, but I think if I searched for some online tutorials I probably wouldn't be too lost figuring it out. Also I did almost the entire course with captions (no audio), they could be a bit better.. a lot of it didn't make any sense, a lot of times I was just guessing what he was saying. Overall I feel like it was well worth the money for this course, I feel like I could actually go into work and design some interesting things. Glad I purchased the course, thanks for teaching me. Thumbs up

By Jas Reehal on 7/21/2021

I found this course well very structured and started a level that was suitable for someone with very little VBA prior VBA experience. The course content was engaging and challenging. It was presented in a very likeable and informal friendly manner, it was easy to forget that the presenter was not physically present in the room with you. I completed the course over a period of many months, with many weeks long intervals. I found that I needed to keep copious notes, comments and observations after each lecture and exercise to help me review earlier stuff when I came back to the course, helping me to rapidly get up to speed. For some reason I found the last half dozen or so lectures seemed not to be as good as the majority of the course. Over all I would highly recommend this course to anyone who wished to make more effective use of Excel.

By Alexander Ptitsyn on 12/27/2020

Great course

By Roma on 12/20/2020

slow pace and clear

By Johnny Alvarez on 12/20/2020

Love it.

By Dale Krueger on 12/13/2020

I am fairly new to VBA, taking it very slowly and working along with the video. Easy to understand.

Showing 12 of 370 reviews

icon
Quality Score

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

Overall Score : 92 / 100