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!***
Range Properties
-
1Intro and Course Workbooks download
An introduction to the course
-
2Get the Developer Tab and Intro to Developer Tab
-
3Getting started with Range object
In this lesson, will learn about the range object and how to use it as if you're typing into cells yourself.
-
4Quick Tip - Project Explorer and Properties Window!
These 2 editing tools are essential and you'll see me use them throughout the course. Super easy, check it out!
-
5Creating Your First Macro From Scratch
In this lesson, we'll make our first macro from scratch. It's super easy!
-
6Adding a Secondary Command. . .
Now let's add a little spice to our macro!
-
7Debugging in Excel VBA
How to go line-by-line when you want to analyze your code more thoroughly.
-
8Saving a Macro-Enabled Workbook (.xlsm)
In this lesson was show you how to save your workbook as a macro enabled workbook.
-
9Before You Begin The Exercises
This video is a pre-requisite for the Exercises as it shows how to make a simple button to trigger the macros much cleaner! Also, it iterates the importance and procedure of using the Macro Recorder - your new best friend!
Thanks
Dan
-
10Exercise 01 - Question
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.
This will be located in the "01 The Range ObjectExercises" folder. Please open "Exercise 01 - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.
Happy Coding!
Dan
-
11Exercise 01 - Answer
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
-
12Several Ways to trigger your Macro
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.
-
13Affecting Multiple Cells with One Range Command - 2 Methods
-
14Adding Strings of Text to a Cell
-
15Using a Named Range with the Range Object
You don't only have to use the cells names, you can also use named ranges. Check it out!
-
16Range Object Quiz
The Cells Object
-
17.VALUE Property
Value returns the actual value of a cell, not it's formatting, eg: 12.5 instead of $12.50
-
18.TEXT Property
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.
-
19.ROW and .COLUMN Properties
Gleaming the row or column of a range you're working with can be very valuable. Learn how to wield this tool now!
-
20.SELECT Property
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!!
-
21.COUNT Property
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.
-
22Exercise 02a - Question
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.
This will be located in the "02 Range PropertiesExercises" folder. Please open "Exercise 02a - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.
Happy Coding!
Dan
-
23Exercise 02a - Answer
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
-
24.ADDRESS Property
Address brings the exact location of the cell or range you're referring to, such as $A$2 or A1:B3.
-
25.FORMULA Property
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!!
-
26.NUMBERFORMAT Property
Change the formatting of your ranges on the fly with this handy dandy tool.
-
27FONT.BOLD, UNDERLINE or ITALIC Properties
Everybody needs to know how to automatically make ranges Bold, Italic or Underline!!
-
28Exercise 02b - Question
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.
This will be located in the "02 Range PropertiesExercises" folder. Please open "Exercise 02b - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.
Happy Coding!
Dan
-
29Exercise 02b - Answer
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
-
30Properties Quiz
A Quick List of questions to make sure you've got it so far - on the Range Properties.
Variables
-
31The Cells Object
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!
-
32Using Column Letters instead of Numbers
You don't have to use column 2, there's a way to use B instead when using the cells object.
-
33Using Cells Positionally within a Range
More on the cells object. . .
-
34Affecting ALL Cells in a Worksheet
Quick tip on making changes to all cells in a sheet - easy.
-
35Exercise 03 - Question
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.
This will be located in the "03 The Cells ObjectExercises" folder. Please open "Exercise 03 - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.
Happy Coding!
Dan
-
36Exercise 03 - Answer
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
-
37Using Range Object with Cells Object
Sandwich these two concepts, the range object used with the cells object. Cool!
-
38Cells Quiz
Toolbars and Menus
-
39Intro to Variables
Using variables is important and fun! They make calculations way easy!
-
40Declaring Variables - Variable Types
Sometimes you have to let Excel know what to expect when using variables.
-
41Declaring Variables - Types Demo
Here, let me give you some cool examples.
-
42Concatenation - Joining Two Or More Strings!
Concatenation is just a fancy word - it's easy.
-
43BONUS - Date Math Fun!
In this short lecture, we learn about Date and Time built in variables that assist us in making calculations based on the time or date the user interacts with our program! Fun!!!
-
44Exercise 04 - Question
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.
This will be located in the "04 VariablesExercises" folder. Please open "Exercise 04 - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.
Happy Coding!
Dan
-
45Exercise 04 - Answer
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
-
46Calling a Procedure from Another
You can open one macro from within another!
-
47Public and Private Variables
Share your variables with other modules or userforms or keep them private. . up to you.
-
48Using Constants
These special variables shouldn't change, so lets tell excel what they are, and we can use them anytime, anywhere!!
-
49BONUS! Passing Variables to Another Procedure - ByVal and ByRef
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!
-
50Variables Quiz
Super Important Tools and Excel Logic
-
51File Menu walkthrough
All the cool things you can do from the file menu, including importing and exporting modules or userforms. neat
-
52Edit Menu walkthrough
Now the Edit menu.
-
53View Menu walkthrough
View Menu has some neat things and perspectives for your macro and/or variables. . .
-
54View Menu2 - Watch Window, Locals Window and Immediate Window
really useful things. Watch this now!
-
55Watch Window Wonders!
More on the watch window.
-
56Insert and Format Menus
All about the insert and format menus
-
57Debug Menu (Important!)
Learn how to debug like a BOSS! Mainly ways to save you time and headaches.
-
58Run and Tools Menus
Last but not least on the Menus. . .
-
59Toolbars Quiz
Loops and Report Writing Basics
-
60Determining the Last Row in your Data Set
You'll need to memorize this one-liner, but it's easy once you know what it means.
-
61Determining the Last Column in your Data Set
Very similar to last row.
-
62Determining the Next Row in your Data Set
Really really easy to grab the Next row in your set. Great for auto-data entry.
-
63Recording a Macro
How to record a macro and use it to LEARN!!
-
64BONUS! - Dynamic Sorting!
How to Sort dynamically, even when more rows are added. No more hard-coding!
-
65Absolute vs Relative References
More on the recording tool.
-
66Using With and End With
Want to save a lot of keystrokes? Listen to this lesson.
-
67Comparison Operators in Excel VBA
Equal to, less than, IS NOT Equal to, etc. . . this is good to know!
-
68If Then Statement
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.
-
69Using Is Not Equal To (<>)
Another logical tool.
-
70Logical Operator, NOT
Using the word NOT to negate a statement.
-
71Exercise 06a - Question
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.
This will be located in the "06 Super Important Tools and Excel LogicExercises" folder. Please open "Exercise 06a - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.
Happy Coding!
Dan
-
72Exercise 06a - Answer
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
-
73If, Then, Else Statement
Adding the "Else" aka otherwise part of the IF THEN statement.
-
74If, Then, ElseIF Statement. . .
What in the world is ELSE IF??
-
75Comparitive Operators with Text and Numbers!
Don't let text mess you up when comparing to numbers.
-
76Use If Then Statements in a One-Liner of code
Save space and use a one-liner of code for your basic If Then statements! Easy!
-
77Using GOTO and Labels
Jump to different areas of code like a teleportation device!
-
78Select Case as Alternative to IF THEN Statements
Try this on for size to save keystrokes when using If Then statements. It's nice once you get used to it.
-
79Message Box with Yes and No Buttons
"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.
-
80Exercise 06b - Question
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.
This will be located in the "06 Super Important Tools and Excel LogicExercises" folder. Please open "Exercise 06b - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.
Happy Coding!
Dan
-
81Exercise 06b - Answer
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
-
82Relative Positioning using Offset
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.
-
83BONUS - User Defined Functions 101
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!
-
84BONUS - UDF Lesson 2
-
85Super Important Info Quiz
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!