The Ultimate Excel Programmer Course

Learn Excel VBA from scratch with Dan Strong! I've trained over 40K students on YouTube, check it out!
4.4 (1,472 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
34,008 students enrolled
$80
Take This Course
  • Lectures 173
  • Contents Video: 10 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2014 English

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

What are the requirements?

  • You should already have Microsoft Excel (version 2003, 2007, 2010 or 2013). 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.

What am I going to get from this course?

  • 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. . .

What is the target audience?

  • 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.
  • I don't think Office 365 has programming abilities with VBA as of yet, so be wary of this if you only use Office 365. They may release that as a feature in the future, but we're not there yet.
  • 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. Some Mac users have taken this course, but it's best with Excel for PC.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: The Range Object
11:37

An introduction to the course

01:30

To get the very important Developer Tab, (in excel 2010) go to File>Options>Customize Ribbon and check the box that says Developer on the right.

01:20

In this lesson, will learn about the range object and how to use it as if you're typing into cells yourself.

02:29

In this lesson, we'll make our first macro from scratch. It's super easy!

00:52

Now let's add a little spice to our macro!

01:23

How to go line-by-line when you want to analyze your code more thoroughly.

01:11

In this lesson was show you how to save your workbook as a macro enabled workbook.

01:24

There's more than one way to skin that cat! Macros are designed to be triggered a number of ways. In this video we'll discuss this.

Affecting Multiple Cells with One Range Command - 2 Methods
01:35
Adding Strings of Text to a Cell
01:40
01:37

You don't only have to use the cells names, you can also use named ranges. Check it out!

Range Object Quiz
4 questions
Section 2: Range Properties
01:54

Value returns the actual value of a cell, not it's formatting, eg: 12.5 instead of $12.50

01:00

Text returns the full formatting of something so if a cell had $12.50, it would return the full $12.50, not 12.5 value.

01:07

Gleaming the row or column of a range you're working with can be very valuable. Learn how to wield this tool now!

00:55

If you click on a cell or highlight several cells, you've just selected them. Turns out, Excel can automatically select things - like a ghost clicking around for you!!

01:47

This isn't the same as the worksheet function COUNT, this simply counts how many cells you have in the range, not how many aren't blank.

01:48

Address brings the exact location of the cell or range you're referring to, such as $A$2 or A1:B3.

03:47

You can automatically put a worksheet formula into a range within your macro

UPDATE: Please note that when I say "Absolute value" I mean the "Actual value", I don't mean that this value cannot be negative numbers. Thanks and program on!!

02:27

Change the formatting of your ranges on the fly with this handy dandy tool.

02:44

Everybody needs to know how to automatically make ranges Bold, Italic or Underline!!

4 questions

A Quick List of questions to make sure you've got it so far - on the Range Properties.

Section 3: The Cells Object
02:24

Pinpointing which cells you want using rows and columns, almost like latitude and longitude for coordinates. Very useful when we use loops in the lessons to come!

00:55

You don't have to use column 2, there's a way to use B instead when using the cells object.

02:10

More on the cells object. . .

02:05

Quick tip on making changes to all cells in a sheet - easy.

03:01

Sandwich these two concepts, the range object used with the cells object. Cool!

Cells Quiz
3 questions
Section 4: Variables
02:24

Using variables is important and fun! They make calculations way easy!

02:37

Sometimes you have to let Excel know what to expect when using variables.

04:25

Here, let me give you some cool examples.

01:57

You can open one macro from within another!

03:06

Share your variables with other modules or userforms or keep them private. . up to you.

02:02

These special variables shouldn't change, so lets tell excel what they are, and we can use them anytime, anywhere!!

07:05

Sometimes you want to use your current variables in another procedure. Sometimes you just need to throw the value in there but don't want it affected in the original procedure, other times you want to manipulate the original so it's different when you get back to the originating procedure. Here's how to do all of that!

Variables Quiz
4 questions
Section 5: Toolbars and Menus
01:52

All the cool things you can do from the file menu, including importing and exporting modules or userforms. neat

05:08

Now the Edit menu.

02:12

View Menu has some neat things and perspectives for your macro and/or variables. . .

07:43

really useful things. Watch this now!

03:25

More on the watch window.

00:40

All about the insert and format menus

05:12

Learn how to debug like a BOSS! Mainly ways to save you time and headaches.

02:13

Last but not least on the Menus. . .

Toolbars Quiz
4 questions
Section 6: Super Important Tools and Excel Logic
03:17

You'll need to memorize this one-liner, but it's easy once you know what it means.

02:23

Very similar to last row.

01:06

Really really easy to grab the Next row in your set. Great for auto-data entry.

03:39

How to record a macro and use it to LEARN!!

05:54

How to Sort dynamically, even when more rows are added. No more hard-coding!

04:07

More on the recording tool.

03:32

Want to save a lot of keystrokes? Listen to this lesson.

01:01

Equal to, less than, IS NOT Equal to, etc. . . this is good to know!

02:25

Here's where the fun begins. . . If Then statements are super fun and help you arrive at the logical conclusions you need to pretty easily.

00:41

Another logical tool.

00:56

Using the word NOT to negate a statement.

01:22

Adding the "Else" aka otherwise part of the IF THEN statement.

02:02

What in the world is ELSE IF??

02:35

Don't let text mess you up when comparing to numbers.

01:42

Save space and use a one-liner of code for your basic If Then statements! Easy!

01:52

Jump to different areas of code like a teleportation device!

02:21

Try this on for size to save keystrokes when using If Then statements. It's nice once you get used to it.

06:27

"Do you like Excel VBA? Click Yes or No"

In this lecture, you'll learn how to let the user select yes or no and navigate the macro depending on their choices. Very powerful and yet simple to utilize.

04:13

Offset allows you to take your current position and roll with it - no matter where the macro takes you, you can always affect a cell 3 rows down and 5 columns right, for example.

05:03

Learn how to create your own functions that work within cells with the equals sign just like =SUM, or use them within macros to simplify code!

BONUS - UDF Lesson 2
Preview
04:31
5 questions

This is stuff you really need to understand so you can program effectively. It's fun to know, don't worry you can retake this quiz for life and the course is yours for life!

Section 7: Loops and Report Writing Basics
03:07

Loops help us analyze data, as well as write data. Every VLOOKUP you've every used has a built in loop to go from one row to the next and find you the answer. We're going to make our own loops and tell it when to start and stop. It's super fun and easy once you learn the basics. Check it out!

03:46

Now let's make it interesting. . . add some spice to our first loop.

05:46

We'll start with a basic loop to analyze all the rows in our data set.

02:53

An InputBox is a tool to get insight or data entry from a user.

03:12

An InputBox helps the user feel involved and can make this report dynamic based on what they want to see.

02:23

Add a button . . . it's what all the cool kids are doing. . .

02:19

Let's make a button that looks much neater using Shapes!

05:00

Everyone wants reports that can go to the printer and look good on paper. Learn the basics to this valuable skill.

06:41

Get the data you need on the correct sheet in the correct row and column!

03:19

You need to clear out the last report you wrote onto the report sheet.

03:34

This will show you how to make it unhidden, just in case, as well as bringing the report sheet we want to see to the forefront without the user needing to hunt for it.

00:50

Add an Auto-Print Preview. It's fun and useful!

01:59

Instead of Print Preview, why not just have it go straight to the printer. Do not pass go, do not collect $200!!!

You can predetermine how many copies to print or prompt the user perhaps with another inputbox?! This normally is sent to your default printer.

02:18

If you hit cancel or "X" out of your InputBox, here's how to handle errors that may pop up. It's so simple.

02:49

Rather than always starting at the beginning, you may sometimes want to start at a larger number and head backwards, counting downwards or descending. It's super easy!

05:17

This will loop through each item in a group, like objects or cells in a named range or shapes/buttons on a page or userform!

03:30

Here's another example of how to use a FOR EACH loop. More to come!

03:26

DO Loops are a bit different as you don't define the start and end points so clearly. Very interesting though!

01:53

Do Until loops and loops until certain conditions are met.

01:31

Loop until is very similar to Do until, except it ALWAYS does the loop at least once, and then it decides whether to continue or not.

01:43

Do While loops are kind of the opposite as UNTIL loops, because they only run during ideal conditions.

00:58

Very similar again to the do while, except, once again - it goes through the loop at least once and only continues if conditions are ideal.

01:48

Here's how to exit a DO loop anywhere you want, even in the middle of a loop and move on past the DO loop portion of your macro. You can set up these multiple times in a loop if you need.

Loops and Reports Quiz
4 questions
Section 8: EVENTS: Worksheet Events made Easy
04:03

Trigger a macro on a worksheet through various means. Change event is when anything changes on a sheet, your macro is triggered. Cool!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Daniel Strong, Excel Instructor/Programmer

Hi! My name is Daniel and i'm 29. I've lived most my life in Scott City, 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 Gervin (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.

Ready to start learning?
Take This Course