The Ultimate Excel Programmer Course

The Ultimate Excel Programmer Course, available at $199.99, has an average rating of 4.75, with 279 lectures, 11 quizzes, based on 16953 reviews, and has 120604 subscribers.

You will learn about 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 Dans 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 This course is ideal for individuals who are 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. or 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. or Beginning to Advanced Excel users who are ready to Automate their projects and use extremely customizable macros, build their own UserForms and learn the fundamentals of programming in a safe, easy, progressive way It is particularly useful 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. or 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. or Beginning to Advanced Excel users who are ready to Automate their projects and use extremely customizable macros, build their own UserForms and learn the fundamentals of programming in a safe, easy, progressive way.

Enroll now: The Ultimate Excel Programmer Course

Summary

Title: The Ultimate Excel Programmer Course

Price: $199.99

Average Rating: 4.75

Number of Lectures: 279

Number of Quizzes: 11

Number of Published Lectures: 279

Number of Published Quizzes: 8

Number of Curriculum Items: 290

Number of Published Curriculum Objects: 287

Original Price: $199.99

Quality Status: approved

Status: Live

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.

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 Dans 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

Who Should Attend

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.

Beginning to Advanced Excel users who are ready to Automate their projects and use extremely customizable macros, build their own UserForms and learn the fundamentals of programming in a safe, easy, progressive way

Target Audiences

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.

Beginning to Advanced Excel users who are ready to Automate their projects and use extremely customizable macros, build their own UserForms and learn the fundamentals of programming in a safe, easy, progressive way

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

Course Curriculum

Chapter 1: The Range Object

Lecture 1: Course Intro and Download Kit

Lecture 2: Getting FAST Help and Other Freebies with Excel Ninjas Group

Lecture 3: Get the Developer Ribbon (PC and Mac)

Lecture 4: What Is The Range Object and Your First Macro From Scratch

Lecture 5: Adding Secondary or Subsequent Commands

Lecture 6: Debugging in Excel VBA and Stepping Through Code

Lecture 7: Three Easy Ways To Test Or Store A Value

Lecture 8: How and When To Record a Macro (Plus Clean Up Tips)

Lecture 9: Three Main Data Type Notations For Entering Into Cells

Lecture 10: Several Ways of Triggering Macros (Intro To Buttons and Fun Controls)

Lecture 11: Exercise 01 – Objectives Overview

Lecture 12: Exercise 01 – Solution

Lecture 13: Affecting Multiple Cells With One Range Command

Lecture 14: Using a Named Range with the Range Object

Lecture 15: Tips and Best Practices For Better Development Skills

Chapter 2: Range Properties

Lecture 1: VALUE, TEXT and FORMULA Properties – Reading and Writing Functions To a Cell

Lecture 2: Row and Column Properties

Lecture 3: SELECT Method

Lecture 4: COUNT Property

Lecture 5: Exercise 02a – Objectives Overview

Lecture 6: Exercise 02a – Solution

Lecture 7: ADDRESS Property

Lecture 8: NUMBERFORMAT Property

Lecture 9: FONT Collection – BOLD, ITALIC, UNDERLINE Properties

Lecture 10: Exercise 02b – Objectives Overview

Lecture 11: Exercise 02b – Solution

Lecture 12: Add Color To Cells, Inside and Out (4 Ways)

Chapter 3: The Cells Object

Lecture 1: Intro To The Cells Object

Lecture 2: Using The Cells Object and Practical Applications

Lecture 3: Using Column Letters instead of Numbers

Lecture 4: Using Cells Positionally within a Range

Lecture 5: Affecting ALL Cells in a Worksheet

Lecture 6: Exercise 03 – Objectives Overview

Lecture 7: Exercise 03 – Solution

Lecture 8: Using Range Object With Cells Object (To Affect Multiple Cells)

Chapter 4: Variables

Lecture 1: Intro to Variables

Lecture 2: Math With Variables

Lecture 3: Variable Declaration and Different Variable Types

Lecture 4: Variable Type Demonstration

Lecture 5: String Manipulation – Concatenation Examples

Lecture 6: String Manipulation – Len, Left, Right Functions

Lecture 7: String Manipulation – Mid Function (2 Methods)

Lecture 8: String Manipulation – Replace Function

Lecture 9: String Manipulation – Format Function

Lecture 10: String Manipulation – InStr Function and Practice Projects

Lecture 11: Date and Time Functions and Fun DateTime Math Tricks

Lecture 12: CDate and DateDiff Functions

Lecture 13: Exercise 04 – Objectives Overview

Lecture 14: Exercise 04 – Solution

Lecture 15: Scope and Heirarchy of Variables and Procedures

Lecture 16: VARIABLE SCOPES – Public, Private and other Variables

Lecture 17: Procedural Scopes – Public Versus Private Subs, Option Private Module

Lecture 18: Using Constants

Lecture 19: Passing Values to Another Procedure – ByRef vs ByVal

Chapter 5: Toolbars and Menus

Lecture 1: File Menu Walkthrough

Lecture 2: Edit Menu Walkthrough

Lecture 3: View Menu Walkthrough Pt 1

Lecture 4: View Menu Pt 2 – Watch Window, Locals Window and Immediate Window

Lecture 5: Insert, Format and Debug Menu Walkthrough

Lecture 6: Run and Tools Menu Walkthrough

Chapter 6: Super Important Tools and Excel Logic

Lecture 1: Three Ways To Access Other Sheets – Sheet Name, Index and CodeName

Lecture 2: Get the Last Row of Your Data Set

Lecture 3: Get the Last (Rightmost) Column of Your Data Set

Lecture 4: Get the Next Row in Your Data Set – Data Entry Basics

Lecture 5: Recording a Macro 101

Lecture 6: Dynamically Sorting The Employee Data

Lecture 7: Absolute vs Relative References and OFFSET() Function

Lecture 8: R1C1 Notation and How To Use In Formulas

Lecture 9: Using Worksheet Functions in the VBE

Lecture 10: Random Password Generator – Objectives Overview

Lecture 11: Random Password Generator – Solution

Lecture 12: Using With and End With

Lecture 13: If Then Statement

Lecture 14: Using Is Not Equal To And The NOT Operator

Lecture 15: AND, OR and NOT Operators

Lecture 16: Exercise 06a – Objectives Overview

Lecture 17: Exercise 06a – Solution

Lecture 18: Using ELSE and ELSEIF Commands

Lecture 19: Rock, Paper, Scissors Game – Objectives Overview

Lecture 20: Rock, Paper, Scissors Game – Solution

Lecture 21: The LIKE Operator

Lecture 22: Compare Strings With Case Insensitivity Using UCase and LCase

Lecture 23: Comparitive Operators With Text and Numbers (IsNumeric Function)

Lecture 24: Two Ways to Use If Then Statements in a One-Liner of Code

Lecture 25: Using GOTO and Labels, Common Uses, Error Routing

Lecture 26: Select Case as Alternative to IF THEN Statements

Lecture 27: Advanced MessageBox Features

Lecture 28: User Interaction – Message Box with Yes, No Buttons

Lecture 29: Exercise 06b – Objectives Overview

Instructors

Daniel Strong
Excel Instructor/Programmer

Rating Distribution

1 stars: 153 votes

2 stars: 358 votes

3 stars: 1753 votes

4 stars: 5771 votes

5 stars: 8918 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!