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.
Read more
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.
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
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 thehands 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.
14 deals to help you save
BFCMSALE24
BFCMSALE24
UDEAFNULP2024
What's inside
Learning objectives
- 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. . .
- Trigger macros using worksheet and userform controls (buttons, shapes, dropdowns, listboxes, click actions, loads of fun controls)
- Change cell properties using code - cell color, font properties (bold, italic, underline, etc), borders and more!
- Master beginning to advanced math with variables and learn proper use, declaration and scope
- Learn string functions, concatenation and how to control case-sensitivity with vba functions
- Create your own functions to be used in vba or in a cell!
- Uncover advanced search functions only available in vba
- Fun with date and time math to calculate duration, length and intervals
- Projects: create full games, learn from coding exercises and enjoy mid-lecture challenges!
- Discover and master the vbe (visual basic editor) and all the mysterious buttons and features within!
- Deal with errors and learn how to prevent them
- Feed information from one macro to another using byref and byval methods
- Utilize variable types: constants, static, module-level, public, private, 'option private module', etc
- Bonus #1: free e-book "excel vba master keyboard shortcuts" - now with more shortcuts (for pc and mac) than anywhere else
- Bonus #2: free image tools for better looking buttons, images and form backgrounds
- Bonus #3: free mouse icons packs to customize mouseover effect on many controls including a userform background!
- Three methods of accessing a worksheet using code
- Get the boundaries of a range of cells the way pros do (better lastrow and lastcol techniques)
- Dynamically sort or filter data. you can have multiple sort options, each assigned to different buttons!
- Utilize user-input (messageboxes, inputboxes, userforms) and use conditional logic (if then, case statements, and, or, not) to control direction
- Insert worksheet functions into cells programmatically using regular or r1c1 notation
- Practice code slimming and efficiency techniques, such as with/ end with statements
- Speed up your code massively with dan's "vba speed hacks"
- Get random numbers to generate passwords, create filenames, produce random actions in games/projects, speed tests
- Search cells and strings with advanced pattern matching & comparison, like operator and instr functions
- Advanced messagebox features (including special icons, direction, buttons: yes/no, yes/no/cancel, abort/retry and many more...)
- Create optional udf parameters and choose volatile or non-volatile functionality
- Show more
- Show less
- 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. . .
- Trigger macros using worksheet and userform controls (buttons, shapes, dropdowns, listboxes, click actions, loads of fun controls)
- Change cell properties using code - cell color, font properties (bold, italic, underline, etc), borders and more!
- Master beginning to advanced math with variables and learn proper use, declaration and scope
- Learn string functions, concatenation and how to control case-sensitivity with vba functions
- Create your own functions to be used in vba or in a cell!
- Uncover advanced search functions only available in vba
- Fun with date and time math to calculate duration, length and intervals
- Projects: create full games, learn from coding exercises and enjoy mid-lecture challenges!
- Discover and master the vbe (visual basic editor) and all the mysterious buttons and features within!
- Deal with errors and learn how to prevent them
- Feed information from one macro to another using byref and byval methods
- Utilize variable types: constants, static, module-level, public, private, 'option private module', etc
- Bonus #1: free e-book "excel vba master keyboard shortcuts" - now with more shortcuts (for pc and mac) than anywhere else
- Bonus #2: free image tools for better looking buttons, images and form backgrounds
- Bonus #3: free mouse icons packs to customize mouseover effect on many controls including a userform background!
- Three methods of accessing a worksheet using code
- Get the boundaries of a range of cells the way pros do (better lastrow and lastcol techniques)
- Dynamically sort or filter data. you can have multiple sort options, each assigned to different buttons!
- Utilize user-input (messageboxes, inputboxes, userforms) and use conditional logic (if then, case statements, and, or, not) to control direction
- Insert worksheet functions into cells programmatically using regular or r1c1 notation
- Practice code slimming and efficiency techniques, such as with/ end with statements
- Speed up your code massively with dan's "vba speed hacks"
- Get random numbers to generate passwords, create filenames, produce random actions in games/projects, speed tests
- Search cells and strings with advanced pattern matching & comparison, like operator and instr functions
- Advanced messagebox features (including special icons, direction, buttons: yes/no, yes/no/cancel, abort/retry and many more...)
- Create optional udf parameters and choose volatile or non-volatile functionality
- Show more
- Show less
Syllabus
The Range Object
An introduction to the course
Getting FAST Help and Other Freebies with Excel Ninjas Group
Get the Developer Ribbon (PC and Mac)
Read more
Syllabus
An introduction to the course
In this lesson, will learn about the range object and how to use it as if you're typing into cells yourself.
Now let's add a little spice to our macro!
How to go line-by-line when you want to analyze your code more thoroughly.
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.
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 Object\Exercises" 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
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
You don't only have to use the cells names, you can also use named ranges. Check it out!
Value returns the actual value of a cell, not it's formatting, eg: 12.5 instead of $12.50
Gleaming the row or column of a range you're working with can be very valuable. Learn how to wield this tool now!
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!!
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.
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 Properties\Exercises" 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
Address brings the exact location of the cell or range you're referring to, such as $A$2 or A1:B3.
Change the formatting of your ranges on the fly with this handy dandy tool.
Everybody needs to know how to automatically make ranges Bold, Italic or Underline!!
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 Properties\Exercises" 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
A Quick List of questions to make sure you've got it so far - on the Range Properties.
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!
You don't have to use column 2, there's a way to use B instead when using the cells object.
More on the cells object. . .
Quick tip on making changes to all cells in a sheet - easy.
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 Object\Exercises" 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
Sandwich these two concepts, the range object used with the cells object. Cool!
Using variables is important and fun! They make calculations way easy!
Sometimes you have to let Excel know what to expect when using variables.
Here, let me give you some cool examples.
Concatenation is just a fancy word - it's easy.
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!!!
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 Variables\Exercises" 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
These special variables shouldn't change, so lets tell excel what they are, and we can use them anytime, anywhere!!
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!
All the cool things you can do from the file menu, including importing and exporting modules or userforms. neat
Now the Edit menu.
View Menu has some neat things and perspectives for your macro and/or variables. . .
really useful things. Watch this now!
All about the insert and format menus
Last but not least on the Menus. . .
You'll need to memorize this one-liner, but it's easy once you know what it means.
Very similar to last row.
Really really easy to grab the Next row in your set. Great for auto-data entry.
How to record a macro and use it to LEARN!!
How to Sort dynamically, even when more rows are added. No more hard-coding!
More on the recording tool.
Want to save a lot of keystrokes? Listen to this lesson.
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.
Another logical tool.
Using the word NOT to negate a statement.
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 Logic\Exercises" 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
Adding the "Else" aka otherwise part of the IF THEN statement.
Don't let text mess you up when comparing to numbers.
Save space and use a one-liner of code for your basic If Then statements! Easy!
Jump to different areas of code like a teleportation device!
Try this on for size to save keystrokes when using If Then statements. It's nice once you get used to it.
"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.
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 Logic\Exercises" 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
Good to know
Save this course
Save
Activities
Review the Basics
Show steps
Brush up on the basics of Excel to ensure you have a solid foundation before diving deeper into VBA programming.
Show steps
-
Review the basics of creating and formatting worksheets
-
Practice entering and manipulating data in cells
-
Go through tutorials or online resources to reinforce your understanding
Read "Excel 2019 VBA Programming For Dummies"
Show steps
Supplement your VBA learning with a comprehensive guide that covers essential concepts and practical examples.
Show steps
-
Read through the book, focusing on the chapters relevant to your learning goals
-
Take notes or highlight important concepts and techniques
-
Complete the practice exercises or challenges provided in the book
Automate a Repetitive Task with VBA
Show steps
Put your VBA skills to the test by automating a repetitive or time-consuming task in your daily workflow.
Browse courses on
Excel Automation
Show steps
-
Identify a task that you perform repeatedly in Excel
-
Break down the task into smaller steps
-
Write VBA code to automate each step of the task
-
Test and refine your VBA code to ensure it works correctly
-
Implement the automated task into your workflow and track the time savings
Show all three activities
Review the Basics
Show steps
Brush up on the basics of Excel to ensure you have a solid foundation before diving deeper into VBA programming.
Show steps
- Review the basics of creating and formatting worksheets
- Practice entering and manipulating data in cells
- Go through tutorials or online resources to reinforce your understanding
Read "Excel 2019 VBA Programming For Dummies"
Show steps
Supplement your VBA learning with a comprehensive guide that covers essential concepts and practical examples.
Show steps
- Read through the book, focusing on the chapters relevant to your learning goals
- Take notes or highlight important concepts and techniques
- Complete the practice exercises or challenges provided in the book
Automate a Repetitive Task with VBA
Show steps
Put your VBA skills to the test by automating a repetitive or time-consuming task in your daily workflow.
Browse courses on
Excel Automation
Show steps
- Identify a task that you perform repeatedly in Excel
- Break down the task into smaller steps
- Write VBA code to automate each step of the task
- Test and refine your VBA code to ensure it works correctly
- Implement the automated task into your workflow and track the time savings
Career center
Data Analyst
Business Analyst
Financial Analyst
Management Consultant
Operations Research Analyst
Software Engineer
Data Scientist
Machine Learning Engineer
Actuary
Statistician
Economist
Market Researcher
Financial Planner
Insurance Agent
Loan Officer
Reading list
Save
Share
Similar courses
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
