Unlock Excel VBA and Excel Macros
Automate Complex Tasks with Microsoft Excel VBA & Excel Macros (Real-World Projects included). Achieve More. Save time.
Created by Leila Gharani - Microsoft MVP, Bestselling Instructor
Students: 122318, Price: $159.99
Students: 122318, Price: Paid
Go from Beginner to Microsoft Excel VBA Expert!
I'll take you step-by-step through engaging video tutorials and teach you everything you need to know to be able to use VBA to improve your work flow, save time and automate your current Excel projects.
What differentiates this course from the other Microsoft Excel VBA & macros courses? It includes:
Over 50 Microsoft Excel VBA & macro examples. These are solutions my clients have needed through the years. They are likely to be useful for you too.
Using the right VBA syntax is the most difficult part. An important topic which isn't covered enough in other VBA courses. In this course you understand why you write things in certain ways.
Create 3 Complete Excel VBA Tools. We go from idea to final product and cover each step.
Over 100 pages of documentation (including useful code) so you can easily refer to it when in need.
Simple explanations for complex concepts.
High quality video and different delivery methods to keep things interesting.
Lots of ideas to automate your current tasks.
Learn from Google or from this Course?
I've been there! I first learnt VBA from Google.
It was truly a light-bulb moment, when I realized that Google has some answers - it could give me some of the code I was looking for - but there two things missing:
The WHY - why does the code work in one situation but not another.
Structure - topic sequence, real-case examples, workbooks, documentation.
Don’t waste your time
Don't waste your time on poor quality videos and confusing explanations. In this Excel VBA course, complex topics are taught in a simple way by an instructor with 17 years of experience. The content has been carefully crafted and clearly organized. The videos are high quality and include animations to emphasize points. Most importantly you learn VBA by doing.
"I have already tried some VBA classes but so far I was never able to apply what I learnt to my own work. This course is different. I have already used some of the techniques Leila is teaching and applied it to my work files. I was able to reduce manual work for me and my colleagues by creating my own macros from scratch. Highly recommended!!!" -- Randy Taylor
"Leila is the real deal... there are many VBA courses on Udemy (some of which I've taken) that merely demonstrate the functionalities. Leila explains the important foundation concepts and how the model is set up allowing you to truly create VBA code from thought rather than copying and pasting from various places. Her class is professionally constructed, with resources and content for each lecture, practice content for you to try things yourself and good Q&A opportunities to answer specific questions. Trust me, this is the course you want to take." -- Justin Fazzio
What you can look forward to in this course:
Understand how to use the right syntax in VBA
Useful Excel VBA codes you can directly use for your work
Use the macro recorder for simpler tasks and improve the code
Working with the Visual Basic Editor
Debugging tools and error handling methods
Different ways to reference ranges and cells
Different methods to loop
How to work with data types
PivotTables in Excel using VBA
Importing data from other files and exporting data to text files
Interacting with other applications (Word, PowerPoint, Outlook)
ActiveX and Userforms to enhance the Excel interface
Basically all the knowledge you need to automate tasks in Excel
The Ultimate Excel Programmer Course
Learn Excel VBA from Scratch with Dan Strong, Bestselling Excel Expert with Over 180K Students Worldwide!
Created by Daniel Strong - Excel Instructor/Programmer
Students: 105169, Price: $139.99
Students: 105169, Price: Paid
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!
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!***
Master all the MS Excel Macros and the basics of Excel VBA
Learn automation of tasks with Excel Macros and Excel VBA With different Excel Projects
Created by Yassin Marco - Helped over 895 000+ students in 198 countries
Students: 87512, Price: $74.99
Students: 87512, Price: Paid
Working with microsoft Excel is not always easy and learning to automate your work with the use of VBA is even harder. Indeed, VBA is a programming language that is really useful in Microsoft Excel especially if you want to be able to automate all the tasks that you want to accomplish. If you :
- Are in school and want to learn how to program With VBA
- Need to learn Excel VBA for work or task automation
- Want to start a personal project that requires you to have Excel VBA knowledge
- Simply want to learn a new skill and improve your Excel knowledge
Then you will love this course. Not only you will by the end of this course have a complete understanding of how the VBA programming language works but you will also be able to use it on a daily basis to improve the quality of the projects that you are creating on Microsoft Excel for work school or any other personal reason.
The structure of the course
The way this course has been created is to help you learn all the Basics that are around the use of VBA with Microsoft Excel. Indeed, with this course you will at first learn the power of Macros with Microsoft Excel. This will already allow to automate the majority of the task that you are currently doing on Microsoft Excel. Then, When you will understand how to properly record your own macro you will learn all the programming behind a macros and write with the use of VBA your own macros. This way you will be able to autome every task that you are doing with microsoft Excel and make every program that you create way more efficient.
Also, another really important aspect about this course is that it will help you learn by practice. In other words, for each element that you will learn you will have a lot of practice. This goes for the macro recording part as well as for the macro creation part. Also, this course has plenty of small projects that are integrated. This will allow you to be able to use all the theoritical knowledge that will will learn and put it into application with this course.
For who is this course designed
If you have a passion for Microsoft Excel and always wanted to learn how to use this program in an efficient way, then this course is definetly for you. Indeed, this course have been created in order to help everyone that start it get all the information you need to be able to work efficiently with excel. Not only you will be able to create more advanced applications by integrating VBA and macros in your spreadsheet but you will also be able to make your life way easier by automating all your tasks. Also, all the futur programs or apps that you will create with Excel will have more advanced features and will become more easier to use.
Why should I take this course
If you want to learn how to properly work with VBA programming language and Microsoft Excel then you should definetly take a look at this course. Not only you will learn all the basics of Macros but you will also learn how to effectively write your own programs directly on microsoft Excel. This will alow you to be way more effective at work since you will know how to automate the majority of the tasks that you are currently doing on microsoft Excel.
There is no risk involved in taking this course
This course comes with a 100% satisfaction guarantee, this means that if your are not happy with what you have learned, you have 30 days to get a complete refund with no questions asked. Also, if there is any concept that you find complicated or you are just not able to understand, you can directly contact me and it will be my pleasure to support you in your learning.
This means that you can either learn amazing skills that can be very useful in your professional or everyday life or you can simply try the course and if you don't like it for any reason ask for a refund.
You can't lose with this type of offer !!
ENROL NOW and start learning today :)
Excel VBA programming by Examples (MS Excel 2016)
Recording Macro, Creating Excel VBA form, Fetching data from MS Access, Working with multiple sheets and workbook
Created by Gopal Prasad Malakar - Trains Industry Practices on data science / machine learning
Students: 85195, Price: $19.99
Students: 85195, Price: Paid
Understand what you are going to achieve through the VBA by seeing demo and then see step by step explanation of VBA code. Learn about Excel VBA syntax, Excel VBA form and control, methods of using forms and controls, several workout examples to see usage of Excel VBA for automation.
In this course, you will learn following stuff in step by step manner
Level 01 – start without coding – Automate tasks using Excel Macro recording
Demo of an excel macro
What is excel macro
When to use it
How to record a macro/create a shortcut action
How to run a recorded macro
How to create a shortcut for a macro action
How to run a recorded macro on a new dataset (excel workbook)
How to record a relative macro
What is the difference between a relative macro and a general macro.
How to understand what was recorded as macro.
How to delete a macro
Level 02 A – Understand Excel VBA integrated development environment
How to reach VBA window
What are different component of the window
What is use of those components
How to use breakpoint, properties window, edit tools etc.
Level 02 B – Understand Excel VBA syntax
How to define a variable
Different types of variables
How to write a for loop
How to display output in an interactive way
How to write output in a different worksheet
How to take user input through a prompt
How to use user input
How to use record macro to know VBA syntax
How to use breakpoint
How to run macro through click of a button
When you need to write do while / do until loop
Syntax of do while / until loop
How to take input from excel sheet for program execution
How to ensure variable names are correct before execution of program
If else command, If elseif else command
Using mod function (for remainder)
Showing status bar
Workout Examples 01 – Using Forms for user entry, chart display etc.
See a worked out example of a VBA form
Learn about various control, design aspects of Excel VBA form
Learn about why will need form, and such controls
Hide Data sheet and format other sheet to make it look professional
Ensure proper data type
Ensure value selection from combo box only
Learn to define level, text, combobox and button command
Learn to pass dropdown data in combobox
Learn to use form entry into VBA
Learn to write back on Excel form
Learn how to load form while getting excel started
Learn to change properties of control through VBA
Workout Examples 02 – fetching data from MS Access using Excel VBA
How to use Excel as front end and fetch data from microsoft Access database
Where to use this à Greatly useful when many users have Excel but don't have MS access database in the PC
Where Reference is needed
Watch window - how to use it
How to edit the code for many fields and different databases
Workout Examples 03 – One sheet per product or agent
How to use do while loop to let it run for as many records as it has got
How to find block size (starting and ending row for each product)
How to add sheet using VBA and give it a name
How to ensure that the tool remains intact with multiple runs and even a mistake can't cause issue
How to repeat header in each tab or worksheet
Workout Examples 04 – Inventory management, coupon assignment and customer communication using Excel VBA
Traverse through various sheets and workbooks using VBA
Writing derived information from one sheet to another
Passing several parameters to VBA for conditional traversal
3 should mean three coupons to get reserved
[Coupon code : Validity] will need comma if there are multiple vouchers
Error handling : alert, if there are no coupons
Protecting Excel tool for further usage
Workout Examples 05 – Reading data from a microsoft access database and writing it into a text file
Reading Microsoft Access data using VBA
directly writing output into a text file
Making the output comma separated
Workout Example 06 - Designing survey form in Excel VBA with option buttons / list box etc.
Workout Example 07 - Insert Excel VBA form data in MS Access database
Workout Example 08 - Using pivot table, vlookup and several other formula for a sampling work
Workout Example 09 - Windows based user authentication and Voice notification of execution of VBA
Workout Example 10 - Running SQL command through VBA. Read Excel sheet as a table inside VBA
You will learn
Reading complete worksheet data into a table
Managing named as well as unnamed headers
Running SQL command inside VBA
Little advance SQL coding as well (by product)
Workout Example 11 - Voice based reminder tool
You will learn how to remind speaker about how much time is left through automated announcement.
Workout Example 12 - Running VBA code in automated manner
You will learn what is takes to used Windows scheduler to schedule the VBA code to run in automated manner with desired frequency.
Workout Example 13 - Recursive file and folder size within a folder
Many a times we need a tool, which should recursively put file names and file sizes within a folder.
I mean to say that, if you pass name of a folder and say in that folder, it has
Then it should again go into the 2 folders and if it finds a folder again say in any of the folder, it should go within that folder too and should create result, with name and size of all the files & folders.
Workout Example 14 - Combine all the files inside a folder through VBA
1. Combine Multiple files - having same layout (same number of fields and fields are always in the same column) but not neessarily same number of rows
2. Also put file name as first column in the final data set
All the data files are in the same folder
There is nothing other than data files in that folder
Usually data files should have a way to know, which file was referred
All the data files are excel files only
Excel Essentials: The Complete Excel Series – Level 1, 2 & 3
Excel: The WHOLE Excel Mastery Series In One! From Excel Novice To VBA Programmer - Excel 2013, 2016, 2019 & Excel 365
Created by Alan Jarvis - Everything Is Easy, Once You Know How - 100,000+ Students!
Students: 82746, Price: $149.99
Students: 82746, Price: Paid
Over 120,000 students in 201 countries are becoming Excel masters with THIS series. Check out the FREE PREVIEW LECTURES and SEE WHY!
This COMPLETE* course is one of the HIGHEST RATED courses anywhere on Excel, with over 9000 5 STAR REVIEWS:
*Why buy 5 individual Excel courses, when this one complete course will give you everything you'll ever need?
What other students are saying:
"This may be the single, greatest course on Excel in existence. It is that good. Concise, yet comprehensive and informative. The instructor has a gift for teaching in an old-world, grade school type of way, which I find particularly useful. He explains each new concept quite clearly and then builds upon the concepts to establish a very strong foundation. Remarkable class and presentation. I highly recommend this instructor. Brilliant." - Kevin Ward (May 2020)
“Course is more than I expected. Instructor provides in depth knowledge of Excel and is effective at communicating it. This course, practice and effort are making me an Excel WIZ ! Thanks Alan.” – Tom Howard (April 2020)
“This course is by far the best course on Excel. Alan is a great instructor and has an art of teaching from the grassroots level and gradually building up to the advanced level which I think is a great way for the concepts of Excel to sink in the brain.” - Kshipra Jawdekar (April 2020)
Excel is the most in commonly used and in demand tool for making sense of data. When you can harness that power, you will be a sought after employee and YOU CAN EARN MORE MONEY!.
If you run a business, being proficient in Excel can help you see your business in a completely different light.
If you are reading this, you have already taken your first important step. You want to learn Excel from the ground up, and go from a complete beginner, to super user, to being part of the few Excel Elite, and being able to program your very own full blown applications using VBA (including automating not only Excel, but Outlook, Word, Powerpoint and even Windows itself!).
This complete course contains all the lectures, quizzes, projects, and downloadable resources contained in Levels 1, 2 and 3. In fact, everything you will need to go from novice to coder! There's no need to buy one course after another to become an Excel master...it's all here!
Yes, but 27 hours, Alan?
Don't worry! We have a very (very) active student forum, so new lectures are regularly added in the SQA Sections (Student Questions Answered). If I can't explain something in a post, or I get a particularly interesting question, I'll make a video for you to walk you through your own specific sticking point!
You can find the detail of each section below, but here's a summary of how it breaks down:
Level 1 Beginners: Base course - 3 hours, SQA - I hour
Level 2 Advanced: Base course - 6.5 hours, SQA - 2 hours
Level 3 VBA Programming: Base course - 11.5 hours, SQA - 3 hours
The course is structured so you can dip in and out whenever you want...you don't have to do it all at once :)
Here's what you get inside...
In Excel Essentials: Level 1 Basics - Master Excel Step-By-Step
Average review HIGHER than the other Microsoft courses on Udemy!
Average minutes viewed 27% HIGHER than other Microsoft course!
New students join THIS Excel course EVERY DAY!
Great news! I have added a new bonus section to this course "Student Questions Answered"!
In this section you will find custom made tutorials to answer YOUR specific questions! Just drop a message in the discussion board, and if I can't answer it in a simple message, I'll make a video just for you!
What other students are saying:
"This is the most comprehensive course I've seen on Udemy..." - Renato Ferreira
"This course is a must and it could be the only one you need, if you want to master Excel for any reason. It is well organized, it covers all topics of Excel, from the fundamentals (formatting, writing data, put that data to use, etc...), continuing to a more advance use of the program, like applications for the formulas included in the app. But the part that outstands in the course, is the macro-programming part. It helps you to start programming in VBA in a step by step fashion. The instructor explains every lesson quite well, he is easy to follow, and you can notice he knows the app and have lots of experience with it. He is also very responsive and will reach you as soon as he can in case you have any doubt about the topics covered in the course. For me is a five stars course, thumbs up for a well roundup course." - David Garcia Silvarrey
"This is the best Excel course ever! I like that the topics are broken down into few minutes at a time". - Sheryl Blosel
"This course is wonderful. If you were and absolute beginner like I was, this is the course that you should take. This course starts at the absolute beginning and shows you in detail how to use the program and how to make it do what you need it to. I am almost through section 2 and I cant believe how much I have learned and I couldn't imagine taking an Excel course from anyone else. If you are thinking about getting an Excel course for refreshing your skills, or just starting from the beginning, this is the course for you" - Jake Rose
Next to soft skills, being able to use Microsoft Excel well is probably one of the most sought after skills employers are looking for in today’s competitive market. Make sure you can compete…
Do you want to master one of the must have skills for any work place?
Are you willing to invest a little time now for your own future?
Want to learn powerful, little known tools most users don't know about?
Do you want to get ahead of your competition?
If you are a complete beginner looking to master Excel, or you just want to brush up on the basics, you've come to the right place. If you want to earn more money by developing a skill set that today’s employers demand, this is the course is for you!
Getting to grips with Excel will give you a distinct advantage in whatever work you currently do, and can open the door to new opportunities.
Many of my students have gone on to get better paying jobs, change career, or even start their own businesses, using the very skills you will soon master.
“I spent over 30 years mastering Excel, so you don't have to!”
In this course we cover in detail all of the basic functions of Excel, and you will learn not only how to use it, but some powerful tools to allow you understand how it works. There is a difference between repeating something and understanding it.
Who is this course aimed at?
Complete beginners, and those who want to build a solid foundation upon which to build their skills.
How is it structured?
Together we concentrate on building a single complete project from beginning to end, using all the basic functions and give you a thorough understanding.
I know your time is valuable, so most lectures are between 3-5 minutes, allowing you to dip in and out when it's convenient for you. This also maximizes your learning, and makes it easy if you ever need to go back to refresh your memory...no need to click through a 40 minute lecture to find the part you're looking for!
There are screencasts, lots of quizzes, presentations, pdfs, downloadable files...all designed to optimize your learning.
What do I get with this course?
Lifetime access to over 4 hours of HD content.
Over 50 bite-size lectures, each covering a specific topic in detail. Some of which I have never seen taught before!
Multiple quizzes to ensure you cement your learning!
Downloadable source file, practice file, and pdf cheat sheets that you can take with you and quickly refer back to if you are away from home.
Access to the Q&A forum, so if you have any questions, you can ask me!
What other students are saying:
"This course is exactly what I was looking for. Simply explained, and in a level of detail I could follow. I really enjoyed it, and will recommend it to all my friend"s – Beatrice
"This course [Level 1] gives a solid foundation for a beginner who wants to develop their skills...To sum up Folks, this is a HIGHLY RECOMMENDED course. I will be shortly enrolling myself in the next course with Alan of course" – Alex
"Fantastic course! The instructor is extremely knowledgeable and the way he organized the course makes it extremely easy to follow. I highly recommend this course to anyone looking to increase their knowledge of Excel." – Dan Hughes
So, Why take THIS course?
I have been using Excel for over 20 years, but there is a difference between being good at something and being able to teach it. In that time I have taught thousands of people how to master its power. Because I have taught so many people, I know not to assume you already understand something, and I have probably already heard every question you are likely to have.
This course took over 4 months to produce, and has been tested extensively with hundreds of people. If something didn't work, or wasn't clear, it was revised until it did, to make this the best possible course on Excel.
Of course, we never stop learning, and I will continue to develop this course, and your skills, with your feedback. And remember, if you have a question, post it in the Q&A and I will answer it for you personally.
In Excel Essentials: Level 2 - Intermediate/Advanced:
THIS course will take your Excel skills to the next level!
New "Student Questions Answered" added
The HIGHEST RATED Excel Level 2 course on Udemy!
Average minutes viewed almost triple that of other Microsoft courses!
So, you have an understanding of the basics, but would you like to use Excel like the professionals? If so, read on…
For students who have already completed Level 1 in this series, or already have a good basic understanding of Excel, what you will learn in this course will supercharge your skills... and your career.
So, What’s inside?
Over 90 bite-sized lectures
8.5 hours of quality HD content
41 downloadable resources
All the source files for each project
Access to me (in case you have any questions)!
You will learn powerful and little known techniques to enable you to build your own powerful spreadsheet solutions. We will do this by creating multiple projects together, step-by-step, and in depth to guarantee your understanding. Each project builds on the last, so your skills develop cumulatively.
What other students are saying:
"This is a great course for anyone wishing to learn or brush up on the basics. The presentations are easy to follow!" – Pamela Reyna
"This is a very simple, clear and concise and easy to follow course that is perfect for beginners" – Sean Loftus
"The author of this course takes you through it one simple step at a time, and it is really easy to follow. I like that the lectures are short, and focus on one thing at a time, which was perfect for me. I actually now feel confident using Excel. Well done and thank you!"– Nickie Student
You will learn how to combine multiple functions in a simple way to create powerful solutions that most users believe can't be done in Excel!
Each project in the course is designed to introduce a range of concepts that showcase the true power of Excel, and show you what is really possible.
In Project One:
The fastest way to create powerful dynamic templates (by cheating!)
Manipulating calculations with time and dates
Simple and nested logical testing
Building complex and dynamic text strings
ActiveX controls (and how to customize them)
In Project Two:
Building a fully functional complex relational database
A Masterclass in Vlookups (WAY beyond the basics here!)
Importing data from multiple sources
Controlling user entry
In Project Three:
Creating named ranges (and why you would want to)
Building dynamic named ranges
Getting Excel to create them for you!
A powerful trick very few users know about!
In Project Four:
Hyperlinking (so it ALWAYS works!)
Creating Macros, and using them to automate your work!
Executing Macros from buttons
Building dynamic formulas using Excel’s Indirect function
In Project Five:
Project management made simple with Gantt charting!
Have your chart timeline ALWAYS begin at the best date
Nesting multiple logical tests (simply!)
Making your timeline completely dynamic by changing a single cell!
This isn't just a course with a bunch of formulas, it's hands on guide through real life projects. You will learn how to build complex solutions using the very same methods I use.
In Excel Essentials: Level 3 - VBA Programming:
If you really want to harness the full power of Excel, then learning how to program in VBA is ESSENTIAL!
If you got this far, it's because:
You want to join the Excel elite, and program your own solutions?
Maybe you want to automate most of your work, do more in less time with less effort?
Could be you want to earn more money?
Perhaps you may even fancy a career change?
If you answered yes to any of the above, I want you in my student community!
In this course you will learn everything you need to know about coding in VBA, even if you've never looked at a line of code before!
What other students are saying:
"This is a great course! ...I can't wait to start using it. I will certainly be using the emailing program! And reports. My mind is reeling!" - Nickie Student!
"Taught in easy bite size chunks makes the learning fun as well as informative" – Joe Long
"If you are serious about learning how to make excel work for you, you should take this course" - Beatrice
Introducing Visual Basic For Applications
Visual Basic for Applications, or VBA, is included with Excel, so there's nothing more to buy. If you have Excel, you already have access to VBA.
VBA is the powerhouse. It's the code that lives under the hood where the magic happens.
A lot of people can record a Macro, but being able to program in VBA is quite a different thing. It separates the good from the truly amazing, and I want you to be amazing!
Now, one of those words in "Visual Basic for Applications" carries more weight than the others. And no, it's not "Basic" (though coding the way I will teach you is simple!).
No, it's "Applications". In fact, it's the "s" at the very end. The significance is that VBA works across ALL MICROSOFT APPLICATIONS! Word, Outlook, Access, PowerPoint, Internet Explorer, and even WINDOWS ITSELF!
In this course I will not only teach you how to code for Excel, there are even THREE, no...FOUR Bonus Sections:
Yes, even controlling Windows
and now...Automating PowerPoint!
What Makes Me Qualified To Teach You?
Well, I'm a regular guy. I don't have a University degree, but what I do have is the drive to learn new things and never be beaten by a problem...a lot like you, I guess.
What I also have is over 20 years of experience in using Excel, and programming solutions with VBA.
I have built simple helper systems to make life easier for my colleagues. I've programmed complete MRP systems to run the procurement division of a £1.3b company, and everything in between.
So, I can do it, does that mean I can teach you?
You bet! I have taught hundreds of students one on one, and even more in groups. Many of my students have gone on to better paying jobs, start their own businesses, or at the very least made their work lives less stressful! One of my most recent students got a promotion and a 15% pay rise just 16 weeks after learning how to code! Not bad, hey?
Why Is Your Course Different, Alan?
I'm glad you asked!
If you got this far, you already know you get:
Over 15 hours of HD video lectures
72 downloadable resources
All the source code for the course + more!
There are lots of great courses on coding in VBA. There are even lots of free videos on YouTube. Many of them show you all the basics in kind of a "little bit of everything" approach. I looked at what was available, and I knew I had to create something different. Of course, I still cover all the basics, just like the other courses, but we will go beyond the basics, and cover in depth the "missing bits".
In addition, I will teach you my step-by-step process, the actual methods I use to build powerful solutions easily and quickly. I'm sure programming can be difficult, but not the way I do it!
You will learn how streamline your code for efficiency (and make it execute faster!) from the beginning. After we've covered all the basics, we will go on to create 6 separate projects using those very tools and techniques, where we will pull together all of your earlier learning, and give you the confidence to program your own solutions as soon as you finish the course!
What other students are saying:
"I'm coming close to finishing this course...This course has given me the knowledge and confidence to succeed, get promoted and think seriously about building a career based on what I can learn from great teachers like Alan." - Thomas Heaton
"Alan is an excellent tutor, goes very deep into every single thing, and he is not bothered to repeat even the smallest tricks and tips along the way. I feel like I got amazing new skill, this course has opened my eyes on how I should "see" excel from now on. Definitely the best course I have ever taken on Udemy" - Aleksandar Stankovic
With So Much Power, What Will You Create?
With the skills you will learn in this course you will be limited only by your imagination.
If you can describe it, you can most likely code it. What will YOU create?
Let's see. Enrol now, and I look forward to welcoming you to the course!
Excel VBA Programming – The Complete Guide
Automate your Microsoft Excel workflow, accelerate your productivity, and master programming with VBA! Beginners welcome
Created by Boris Paskhaver - Software Engineer | Consultant | Author
Students: 62282, Price: $19.99
Students: 62282, Price: Paid
Welcome to Excel VBA Programming - The Complete Guide, Udemy's most comprehensive VBA course!
Visual Basic for Applications (VBA) is a powerful language built on top of popular Microsoft Office applications like Excel, Access, and Outlook. It allows developers to write procedures called macros that perform automated actions. Anything that you can do in Excel, you can automate with VBA!
Over the course of more than 18 hours of content, we'll cover VBA from the ground up, beginning with the fundamentals and proceeding to advanced topics including:
- The Excel Object Model
- The Visual Basic Editor
- Objects and Methods
- Variables and Data Types
- Writing Your Own Procedures
- The Workbooks and Workbook Objects
- The Worksheets and Worksheet Objects
- Range References
- Range Actions
- Conditional Logic
- Configuring Excel Functionality
- Custom Functions
- Even Procedures
- User Forms
In addition to the video content, the course is packed with dozens of quizzes, challenges, and assignments to test your knowledge of your material as you progress.
No programming experience is required -- complete beginners are more than welcome! VBA is a great language to start with because you can master the fundamentals of programming in a familiar work environment.
No extra software is necessary - VBA is bundled with all modern versions of Excel.
Excel is the world's most popular spreadsheet software and is available on over 750 million computers worldwide. Whether you use it for professional or personal reasons, VBA can help you remove the redundancy in your workflow and accelerate your productivity drastically!
Thanks for checking out the course!
Master Microsoft Excel Macros and Excel VBA
Project Based Course on Excel VBA (Visual Basic for Applications) and Excel Macros
Created by Kyle Pew - Microsoft Certified Trainer
Students: 49823, Price: $49.99
Students: 49823, Price: Paid
Course Material Works in Microsoft Excel 2007, 2010, 2013 and 2016
Join me in this course and take control of Microsoft Excel and master the process of automating routine tasks through the use of Excel Macros and Excel VBA.
During this course you will build a foundation of working with Excel Macros and VBA. This foundation will be built as you engage and participate in project based Excel Macro/VBA exercises, detailed throughout the lectures within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks.
As you engage and participate in this course, you will be introduced to the wonders of creating simple Macros through the Macro Recorder and then quickly take you into the world of Excel VBA where you will experience building a more dynamic, robust experience for yourself and your peers.
Each project contains exercise files that you can download and use to complete the assigned Excel Macro/VBA projects. The course also contains detailed instructions through the video lectures as well as a series of PDF documents that you can reference as you complete the projects.
Below are a few samples of the projects you will complete by enrolling and participating in this course.
- Automate placing and formatting a title on a worksheet
- Interact with the users of your Macros through Input and Message boxes in order to receive input on how a Macros should work
- Cleaning up multiple Excel Worksheets and prepare the data to be reported on
- Create a report based on multiple sets of data found within multiple Excel Worksheets, copying data from one Worksheet into the Master Report Worksheet
- Automate the creation of Excel Formulas to SUM data up in your Report
- Working with Excel VBA User Forms
- Importing Data from External Text Files
Each of these projects will direct you through key Excel VBA programming concepts and direct you to identify and use best practices in creating Excel Macros.
So, don’t lose another moment performing Excel tasks manually. Enroll now and learn how you can get Microsoft Excel to your work for you.
Introduction to Microsoft Excel VBA
Learn Microsoft Excel VBA Fundamentals (Excel 2010, 2013, 2016)
Created by Kyle Pew - Microsoft Certified Trainer
Students: 24816, Price: $94.99
Students: 24816, Price: Paid
Microsoft Excel VBA (Visual Basic for Applications) provides Excel users with the ability to automate any Excel task. Excel Tasks that would normally take an extensive amount of work and time to complete can ultimately be automated and completed in a single click of a button. All that's needed to automate your experience is a little Excel VBA knowledge.
Maybe you've heard of Excel Macros and VBA. Or, maybe you've even attempted to create your own. Jumping into VBA can be a bit daunting and overwhelming. I've been teaching Excel for 15+ years and have had loads of questions from those that have taken the dive into learning Excel VBA. Where should I start? What do I need to know? What's a variable? Enroll in this course and I'll share the knowledge and experience I've gained working with Excel VBA.
WHAT YOU'LL LEARN
- Fundamentals of Excel VBA
- Proper Syntax Writing VBA Code
- Excel Object Structure to Effectively Communicate with Excel
- Working with the Most Common VBA Objects in Excel
- Automate Routine Microsoft Excel Tasks
- And More....
EXERCISE FILES AND QA
As you go through the video lectures you can download the exercise files, found within each section. Use the exercise files to practice the concepts you will be learning.
The course contains a QA section where you can interact with me and ask any questions as you develop your VBA skills.
As you participate in this introductory Excel VBA course you will build the knowledge and confidence to automate your experience in Excel, saving you time and money.
Microsoft Excel VBA for Beginners – Learn VBA Step by Step
Serious about learning VBA for Excel? This course makes learning VBA easy. Jump in and master Microsoft Excel VBA today!
Created by Steve McDonald - Dedicated Instructor Will Help You Excel | 300K+ Students
Students: 24223, Price: $94.99
Students: 24223, Price: Paid
Welcome to the Excel VBA Programming Course for Beginners. If you need to learn how to program VBA for your job or for yourself, this course was designed for you!
You'll start with the very basics of understanding what VBA is and what it does. You'll learn how to install VBA and record your first macro. Then, you'll progress to learning all of the essential terminology as you create your own functional VBA modules. By the end of this course, you'll be able to create your own user forms that other users can interact with and enter data into, and you'll be able to troubleshoot and debug your code, make it run faster, and even create your own custom Excel functions.
The beauty of VBA is that when you learn to master it, you can program Excel to do the work for you.
Using VBA, you can save a ton of time for your organization by automating repetitive and tedious tasks.
VBA isn't exactly easy, but it's one of the simplest and easiest to learn programming languages. It's like the gateway drug that gets you hooked on programming. And in this course, I'll walk you through the initial learning curve to give you a solid foundation from which to launch your programming skills.
This is a very detailed course and you will walk away with a vastly expanded vocabulary and a full toolbox of VBA programming skills.
The truth is, you could teach yourself VBA using free articles and videos on the internet. The challenge is that VBA can be hard to learn without the right info and the right examples. It's easy to waste a lot of time learning things that aren't useful in the real world. By following this course, you'll get clear, step-by-step guidance along a relevant and valuable learning path to master the essentials of Excel VBA.
I have a lot of personal experience learning and using VBA as an engineer and I'm very excited to pass that knowledge on to you! Ever since my days as a college tutor, I've loved teaching and helping people learn challenging subjects. So, if you're ready to learn how to start programming in Excel VBA, I'm excited to show you how!
Thanks for checking out the course and I'll see you in the first lesson.
By the way, did I mention that Udemy has a 30-day money back guarantee? That's right. You can take the whole course, and if in those first 30 days you don't feel like you're actively getting better at using VBA, you can get a full refund. So, you really have nothing to lose. Dive in and start learning Excel VBA today!
Excel with Microsoft Excel VBA User Forms
Learn to Create and Program Microsoft Excel VBA User Forms like a Pro
Created by Kyle Pew - Microsoft Certified Trainer
Students: 17929, Price: $74.99
Students: 17929, Price: Paid
Customize Your Excel Interactions with Excel VBA UserForms
Microsoft Excel is a very powerful tool, but doesn't always provide the most accessible approach to working with your data. Through the use of Excel VBA and Excel VBA UserForms, you'll be able to create a more accessible and efficient environment to work with your specialized data.
By participating in this course on Microsoft Excel VBA UserForms you will journey through a step by step, project based learning experience. Each project you will be introduced to will build upon the previous project. While completing each project from start to completion, you'll build an Excel experience you'll want to re-create for each of your Microsoft Excel projects.
- Learn key VBA concepts that relate to building Excel VBA UserForm interafces
- Streamline yours and your users experience working with large Excel data sets
- Create intuitive Excel interfaces to create reports and provide summarized data based on Excel tables.
Join me in this course and become and Excel VBA UserForm champion! See you in the course.
Beginners to Expert Excel and Excel VBA 38 Hours Mega Course
Learn Excel formulas, Pivot Tables, Excel VBA macros, charts and the basics with our Microsoft Excel 38+ hours tutorial
Created by Mach 42 Productions - Excel Consulting | 21,000+ Students
Students: 15681, Price: $19.99
Students: 15681, Price: Paid
This comprehensive 38 hours+ Microsoft Excel and Excel VBA course includes content from our Mach 42 Productions Excel courses 1 through 11 and our IT careers course, to take you from beginner to expert level:
Excel Course 1- Step By Step Beginners Excel
Excel Course 2- How To Use Excel comments
Excel Course 3- Excel Charts And Tips To Make Better Charts
Excel Course 4- How To Make Waterfall Charts
Excel Course 5 - Advanced Excel Charts
Excel Course 6- Automated Excel Charts And Tables
Excel Course 7- Learn How To Use Excel Text Functions
Excel Course 8- Advanced Excel tips
Excel Course 9- Quick Excel Tips For Excel Reports
Excel Course 10- Advanced Excel Skills And Career Tips
Excel Course 11- Spreadsheet Protection
8 Ways to Further your IT Career
If you are enrolled on any of our above courses, please bear this in mind before considering this one.
Our in-depth Excel syllabus takes you from beginner level to advanced level in Excel and will help build you a solid understanding of Excel and use it effectively in your work. Over 38 hours of Excel content is provided in this course including:
How to use the basics of Excel e.g. create new worksheets, copy, cut and paste, the Excel ribbon and how to print documents properly
How to sort, find and replace Excel data quickly
How to understand, write, use, audit formulas and coverage of Excel text functions, maths operators and advanced functions including vlookup via worked examples/case studies. We provide hours of material on this to build your confidence levels (11 sections)
Coverage of Excel charts from beginner level to advanced automated charts. We cover charts such as bar charts, line charts, waterfall charts and funnel charts. We also provide tips on how to make better charts.
A thorough grounding in Excel Pivot Tables- from scratch. This tool alone can save you a lot of time in your data work.
Essential Excel tips to boost your work and help you make better Excel reports e.g. how to watermark Excel sheets
How to protect your Excel spreadsheets using Excel’s security model.
Excel VBA- We teach from ground up Excel’s powerful VBA programming language which can be used to automate tasks, clean up data (very fast) and overall increase your productivity. Our VBA learning culminates in building real life (and actually useful) programs/macros which you can use in your everyday work. Further the skills taught will enable you to build your own macros. All the source code is provided in our examples in addition to testing your knowledge with assignments and tasks. We have over 7 hours of lecture videos covering Excel VBA.
Excel career tips- Advice on how to write Excel examples for your CV/Resume
Full support is given on this Excel course by means of our course discussion forum, lecture quizzes and tasks/activities are provided right from the start of the course. All Excel workbooks used in the lectures are provided too.
Remember by picking up essential Excel skills, you can significantly increase your productivity, save time and money and furthermore be confident that you can use one of the most popular office business tools today.
Macros & VBA Excel
A well designed course to learn Macros and Visual Basics for Applications in Excel
Created by Parallel Learning - When you know better, You Do better !!
Students: 14019, Price: $19.99
Students: 14019, Price: Paid
This course is an Introduction to VBA & Macros in excel.
In this course we have tried to cover all the topics necessary for you get started on creating applications in Excel as per your needs.
As always, to make things easier we have included links to download Exercise files as well as the results for each topic.
Ultimate Excel VBA
Programming for the Business Professional
Created by Mark Talbert - Educator and Consultant
Students: 12847, Price: $24.99
Students: 12847, Price: Paid
This is an introductory course on how to program Excel using VBA macros. You will learn to automate and extend the Excel environment to supercharge your Excel models, automate routine tasks, customize your user interface, and manage large quantities of data. This course is based on the instructor's semester-long college courses which have produced thousands of graduates in the fields of business, finance, health care and public policy. Designed for busy professionals who need to take their Excel abilities to the next level, you will not waste time on topics which you are unlikely to use, and you will receive extra attention to the often confusing or overlooked details that will make the most difference to your ultimate understanding. Over 8 hours of instruction!
Project Based Excel VBA Course
Become an Excel Programmer, fueled by plenty of practice
Created by Brandon Brown - Programmer
Students: 11342, Price: $99.99
Students: 11342, Price: Paid
Learn how to automate tasks in the world's most popular business tool, Microsoft Excel. This course only requires access to Excel, and it will teach you the core concepts to launch your programming career.
Some highlights of this course:
A step-by-step guide in making a comprehensive game of Battleship.
Several hours of high quality video lectures, covering topics such as variables, loops, and text files.
Exercises at the end of every section, and extra projects at the end of the course.
Microsoft Excel – From Excel Beginner to Excel Expert
Learn Pivot Tables, Formulas, Charts, Data Analysis, Dashboards, VBA, Macros & More for Excel 2010, 2013 or Excel 2016
Created by Martyn Blythin - Data Minded Excel Training, 30,000+ students
Students: 11081, Price: $59.99
Students: 11081, Price: Paid
Just imagine what it would feel like if using Excel was effortless - if you could create charts, functions, and analyse data with ease. Becoming an Excel expert isn't about learning what every button and every formula does - it's about learning methods you can use over and over again to effortlessly clean, enrich and analyse data.
I bet your a bit like me, you've tried learning through trial and error, but it takes a long time and involves a lot of mistakes along the way! I've been using Excel for over 15 years and there's still a few functions I've never used. The good news is that you can become an Excel expert in just a few hours by learning the right tools and approaches to use. How would it feel to have those skills on your resume and at your next job interview?
So, you want to become an Excel expert but you don't want to overwhelm yourself with stuff you're never going to use and you need the skills for your job, or the next job you hope to get. As I see it, you have three options. First, you could take a classroom based course and try to learn it all in a day, but from experience I know many people who have just been overwhelmed with the amount of information and the pace of learning. Second, you could do absolutely nothing, stay exactly where you are right now with your Excel skills. Or third, you could give this a try, work it alongside your current job and be genuinely good at Excel within a week or two.
We designed this Microsoft Excel - Excel from Beginner to Advanced using feedback received from over 30,000 students over years who told us they wanted opportunities to advance Excel skills. This course has it all, including:
Downloadable challenges to test your knowledge.
Multiple choice quizzes at the end of each module.
Each lesson has a downloadable Excel file containing the examples used.
Cheat sheets for functions & excel keyboard shortcuts that you can have at your desk for reference.
Ask me any Excel question on the course message boards.
A certificate of completion at the end of the course.
The course covers all levels, from beginner to advanced, so you don't have to worry about if the course is right for you, and you don't have to buy multiple courses for each level of your Excel knowledge! The course is split into 6 core modules:
Module 1: Master The Basics - Useful excel for beginners, including Excel fundamentals
Module 2: Your Data Gameplan - cover how to organise your data including Excel filters
Module 3: Your Functions Toolkit - Learn Excel advanced formulas and functions
Module 4: Your Data Analysis Strategy - The Complete Microsoft Excel Pivot Tables and Pivot Charts including Excel pivot table basics and data analysis Excel
Module 5: Your Dashboard Playbook - Learn how to create an Excel Dashboard
Module 6: Your Excel Automation Machine - Learn how to create an Excel macro and use Excel VBA code to automate your work. Excel vba programming is an extremely powerful tool, once you know the basics.
The course also comes with everything you'd expect from a great online course, including:
Lifetime access to the material
Unlimited free updates to the course
30 day money back guarantee
If you're prepared to give this a try, then we're certain you will see the results as early as the first day you try it.
Here is what students said about this Excel course:
"Love the tips. Best practices quite relevant and to be kept in mind. Also, there are quizzes to test your understanding of the previous lessons as well as links to the lectures for the answers that you missed. I love this course. Highly recommended!"
- Mary J. de Guzman
"This is a really great course. He started at what I would definitely consider an intermediate Excel level--and I even learned some things during that part--and then took us well into advanced Excel, as promised. Martyn was also very responsive, answering in-depth questions I had, even when they were beyond the scope of the course."
- Randy Crane
"Thoroughly enjoyed the course as it was very well paced. Bite-sized yet providing clear concise detailed instructions that I could follow the activities in a separate local spreadsheet and learn by doing. Good clarity in speech and good examples help. Martyn also reverts back quickly if you have a question or suggestion."
- Kaushal Vyas
Who is this course for?
This course can be used whatever your industry - anything from Excel for Accounting and Bookkeeping to excel for investment banking or Excel for data science. Anyone who is looking to achieve excellence in Excel and advance excel skills at work and on their resume.
Although this course does not issue an official microsoft excel certification, it includes a Udemy certificate of completion which you can use to illustrate your Excel skills on your resume and in interviews.
Microsoft Excel VBA – Solving Complex Problems Using Basics
Become a fluent Excel VBA coder
Created by Sihle Mhlanga - Instructor and Accountant at Pundit Excel
Students: 11066, Price: $19.99
Students: 11066, Price: Paid
Microsoft Excel Professional Date Picker Series - Part 2
Microsoft Excel VBA - Solving Complex Problems Using Basics, is designed to make you a skilled and faster VBA coder.
In this course, you’re going to learn VBA concepts that will boost your coding skill and give you the abilities to solve complex problems that are thrown at you. I will teach you the art of writing a complex code piece-by-piece using basic techniques.
After this course, you must be a skilled and fluent coder, knowing clearly how to manipulate complex Excel VBA problems. The skills you will get here are usable across all areas of VBA programming.
So, after completing this course, all you will need to do next is to add new distinct knowledge on specific areas of VBA programming e.g.
how to work with a Multi-page User Form,
How to work with an editable User Form,
Understanding the User Form Environments,
Understanding the worksheet environments,
working with databases,
authentication & authorisation in Excel
However, studying all these new areas will be very simple because you already have the coding skill cemented in your mind, and that skill is appliable across all areas of VBA learning. Many people make a mistake and jump to study these areas first before they learn the art of writing a VBA code. As a result, they suffer confusion, and everything they learn fails to add up.
In this course, I’m going to put you on the right track in your Excel VBA career.
Now, this is part 2 in the professional date picker series. In part 1 of the date picker series, I mentioned that VBA coding becomes complicated only when the commands you pass to an object must first be derived through calculation. Well, we have come to that complicated part. This is the part in the date picker series where you must become an expert coder. So, this course will add a top layer on the foundation we built in part 1 of the date picker series. I will teach you how to solve complex problems using basics, and you will learn how to write a complex code step by step.
If this is what you are looking for, please sign up for the course.
Excel VBA – The Complete Excel VBA Course for Beginners
Learn Excel VBA and take your spreadsheets to the next level.
Created by Alan Murray - Microsoft MVP, Founder of Computergaga
Students: 7531, Price: $94.99
Students: 7531, Price: Paid
Hear What Some of Our Students are Saying.....
"Really, really good course on VBA! *****"
"Great content, great examples, would definitely take another course from this instructor again!"
"Excellent course for getting started with VBA. The instructor makes every concept clear, and guides you through with many examples.
"Great course for a beginner or as a refresher. I know I will be coming back to some of these lectures as needed for some of his code tidbits because as he says, "you can't remember everything", and I love knowing where I can find what I am looking for.
Want to take your Excel skills to the next level and learn Excel VBA? Well, you have come to the right place.
This course covers everything you need to become proficient in Excel VBA. In just a few hours you can be writing your own macros to perform complex tasks and automate reports.
Areas covered include;
Learning the basics of the VBA language.
Using loops to perform repetitive tasks.
Interacting with users via userforms and message boxes.
Working with built-in VBA Functions.
Accessing directories and files.
Automating report generation and saving as PDF.
Creating your own Excel functions and Add-Ins.
You will receive;
Support from the Instructor.
Lifetime access to lectures and content.
Real-world Excel VBA projects to complete.
Fun and no-nonsense lessons.
Ok, no more time for waffle. Grab a coffee and let's get cracking.
Excel VBA: How to Write Macros Like a Professional
Learn how to write real-world Excel VBA Macros from scratch. No experience required!
Created by Paul Kelly - Udemy Instructor, Professional Software Developer
Students: 7523, Price: $99.99
Students: 7523, Price: Paid
September 2018 Added New Content!
How to Copy and Filter Data using Excel VBA
This new section comes with 13 Exercises plus full solutions to help you practice and reinforce what you have learned.
April 2018 Added New Content!
Learn how to build an entire Excel VBA application from start to finish. In this brand new section you will see techniques not taught in any other Excel VBA course.
This new section(number 15) contains proven principles and little-known techniques that will help you build an application in a fraction of the time it would normally take you.
You will also learn tips and tricks that will reduce your errors, make your code more organised, and make your applications easier to maintain and update.
This is the only Excel VBA course that shows you first hand, a professional developer creating a VBA application from scratch.
January 2018 Added New Content!
Using Arrays in Excel VBA: 6 brand new lectures.
FINALLY! A Way To Write Excel VBA Like a Professional
If you think the top Excel VBA programmers are smarter or more gifted than you, then you're mistaken. Truth is, they use dozens of proven programming principles.... little-known techniques that are completely unknown to most VBA users. What are these principles? How can you learn them? And how can you use them to create your own Macros? In this course, Paul Kelly teaches you dozens of must-have secrets that he learned during his 20+ years as a professional software developer, including
*How To Easily Open Any Workbook - I provide the code, You can use it everywhere!
* Why using Loops can increase your productivity exponentially - Start using them immediately
* How To Create a Real-World VBA Project - A step-by-step guide through a Fruit Sales example project
* The Error Translator Table - An easy way to resolve errors that should have been written years ago
* Which worksheet method to use - Your code will still work even if the user changes the sheet name!
* How to easily test the output of your macros - It's childs play to write values to this Window
* How To Quickly Create Solid Excel Macros - Tons of examples you can "steal" for yourself.
* The In Built VBA Tools That Help You Easily Find Bugs - If you think you would make a good detective then you may really enjoy this
* How to Easily Format any Cell - Changing a cells font, color, format is so simple you could do it now.
* These "Evil" Workbook types should never be used - Do You Use them?
* And Much More.
Remember if you are not happy with the course for any reason you can get a FULL REFUND within 30 days - no questions asked!!!
Excel VBA Macros: Hyper-disambiguated Excel VBA Programming
Learn Excel VBA macros, using clean, clear VBA programming techniques and code that you fully understand
Created by Grant Gamble - Developer, trainer and author
Students: 7084, Price: $89.99
Students: 7084, Price: Paid
This is a Udemy best-selleing course. Here is some of the feedback from other students:
"Best intro I've seen for a non programmer. Explains key concepts well." Ron Willett
"Wonderful way of teaching. Shows the full hierarchy of both Excel and VBA objects. Now know the differences." Bill Malemba
"Concise, thorough, yet repetitive enough to allow the concepts to stick. Love the real-world examples and the emphasis on concepts over code parroting. Best VBA tutorial I've found, hands down, bar none - covers top to bottom application/VBA structure which is immensely helpful. Well-organized, all code can be re-visited with provided worksheets..." Dy622
"this is my favourite excel vba course. Lot of exercises, lot of different area is covered, and really explains everything from step 1, not just the how, but the why as well. thanks to the course I understand vba and macros better than ever before."
Excel VBA programming can seem baffling, especially when you don't fully understand the code you are asked to write. Learn to write Excel VBA macros, from scratch, to automate Microsoft Excel tasks and operations.
This course is aimed particularly at Excel users without much programming experience, who struggle to remember the syntax and structure of the VBA (Visual Basic for Applications) programming language.
During the course, we will use a style of programming which emphasizes the significance of each line of code that you write. This means that when you revisit the code, the meaning of each line is apparent from the syntax, rather than becoming more and more unfamiliar. The course also demonstrates how to get the maximum benefit from IntelliSense, Microsoft's code completion feature.
Whether you are looking to enhance your career prospects by adding Excel VBA to your C.V., save your company money or increase your productivity, this course will provide your with all the knowledge you need to get started.
You can download all of the materials used in the lectures, so that you can follow along. (Please, remember to unZIP the downloaded files.)
Microsoft Excel VBA Fundamentals – Learn Basic Coding Skills
Microsoft Excel Professional Date Picker Series - Part 1
Created by Sihle Mhlanga - Instructor and Accountant at Pundit Excel
Students: 6769, Price: Free
Students: 6769, Price: Free
Microsoft Excel VBA Fundamentals course is designed to teach relevant basics for VBA programming.
It is for those who aspire to become a VBA programmer and don’t know where to start. It is also suitable for those who automate their spreadsheets by record macros but seek to learn how to write the code themselves.
This course will provide you with adequate knowledge and help you to take your first steps in writing a clean, easy to read and maintain VBA code. I will teach you how to do this step-by-step, and you will learn with understanding.
So, this short course seeks to accomplish the following three goals:
To provide you with a clear perception of the VBA developer environment
To give you a proper understanding of how to work with the VB Editor tools to design a professional UserForm.
To teach you how to write the code that will drive or manipulate the properties of the UserForm.
Get a good start, acquire basic VBA coding skills for Microsoft Excel 2010, 2013, 2016, Excel 2019 and Office 365
How to Build a VBA App in Just 30 Minutes
Quick Start guide introducing lots of the VBA concepts required to build great apps
Created by Craig Barry - UK Based Engineer
Students: 6331, Price: Free
Students: 6331, Price: Free
Ever wanted to impress work colleagues with a user interface for your Excel documents? This free course walks you through the simple steps to achieve this.
Now is your chance to shortcut the long and tricky tutorials online, simply follow along with a basic worked example and learn how you can setup your own user interface form in Excel.
This course does not require any prior coding skills, you will need access to a computer running Microsoft Excel. You will also need to actually follow along and try out what you learn in order to get maximum value from this fantastic free course!
Craig has been working with Excel for well over a decade. He started out automating tasks for senior colleagues as a student using simple macro recorders, since that point he has never stopped using and learning what Excel can do to make his life easier.
A word of warning, although the course is delivered in 30 minutes, beginners will need to go back and re-watch the lessons presented in this course, as well as ask questions to the instructor – Craig. Learning a new skill is never easy, you didn’t learn to speak your native tongue in 30 minutes, and neither will you learn to code in 30 minutes- no matter how good the course is!
Excel VBA Essentials for Reporting Automation
Use Excel & Access with Excel VBA macros & SQL to automate any Excel report, and become a master at Data Analytics!
Created by Benjamin Termonia - Artificial Intelligence & Automation Passionate
Students: 6236, Price: $79.99
Students: 6236, Price: Paid
Start creating your Excel Dashboard and Data Analytics reports today with VBA macros !
After some years spent in the financial industry, I have frequently noticed that data processes were not as efficient as they could be. Too many times I saw people spend hours creating the same reports, and start again the following month. Usually, this followed a single common pattern: collect data from a specific source, modify and format it, save it and send it.
The moment I realized that it was possible to automate pretty much any routine tasks with a few lines of code was a real revelation for me. Since then, I have been focusing on automating all the processes that my colleagues and I needed, replacing hours of manual processing with a single button click.
Well, this is exactly what I want to show; how you can spare your time and your colleague's, so you can focus on tasks where you have a real added-value.
The objective of this course is thus to show that it is possible for everyone to automate many different data processes from start to finish.
The key to doing this is using the right tools, so you will find that Excel is great, but it is even more powerful when used with other applications. Among other things, we will work with Microsoft Access, which is the Office database tool. We will see how more efficient it is to use Access compared to Excel for certain tasks, but also how these two applications can be used together to build an even more efficient process.
End-to-end automation reachable by anyone
Why is this course different from the others I can find on the same subject?
This course is different for several reasons:
We follow a very specific objective. While some courses try to detail everything you can do with a specific application, we are here looking to achieve a specific goal, which is automating a practical business situation.
It spans several topics and applications, not just one. A lot of courses focus in depth on a single specific subject like Microsoft Excel, Microsoft Access, VBA or SQL. On the contrary, this course will mix all these relevant subjects, so the final objective is reached faster.
Only key elements are presented. The objective is not to present all the possible things you can do with VBA, but only those which are useful and needed to pursue our final goal. We will seek the relevance of the concepts over the quantity.
Theory is reduced to a minimum and mixed with practice. I do not believe that theoretical explanations alone is enough to understand this kind of subject. However, I do believe that practice is. That's why we will mix both.
Short videos that focus on a specific topic. Just as we are not going to go through every capabilities of VBA, neither will we spend hours on a specific subject. Videos will be concise and straight to the point.
What you will learn is usable immediately. This course does not present isolated concepts, but it presents a complete solution that you should directly be able to implement for your own needs, once you have completed this course.
Can I find the content of this course on Google?
Honestly ... yes, you can! I myself learned a lot about VBA and other programming languages using Google. I can tell you there are tons of useful information you can find online (a few billions in less than a second to be exact).
But this is for the exact same reason that I would have liked to have a resource like this one at the very beginning. Simply, because there are multiple ways to automate a process, which makes it much more complicated to build without any experience.
By following a specific method, with tailored explanations and examples, you have the opportunity to learn a subject much faster. Of course, this doesn't prevent you to keep on exploring the subject afterwards.
Why should I follow this course and learn automation?
There are different reasons for that.
First and perhaps the most obvious is that data is taking up more and more space in most of today's businesses. The more comfortable you are with data, the better prepared you will be for this trend.
After completing this course, I am pretty sure you will approach things differently. I'm not saying you will be an expert in database management or in big data ... because it is not the objective. However, you will have a much clearer vision of what can be automated, with what tools, and most importantly how it can make your life easier.
By following this course, you will have the opportunity to rethink your existing processes, and build new ones, in a much more efficient way. This will more than likely have a positive impact on you and your colleagues, but also on your boss's appreciation of your work.
Finally, maybe the principal reason is that automation is not as complicated as it seems. Contrary to what you might expect, it does not take years to start coding. This course only lasts about 5 hours, which is less than a single work day and already enough to cover many of the important things to know.
So, if you have absolutely no idea what you can automate, or how you can automate it ...
Join us today! and this might be the most productive work day you have had in awhile.
Complete Web Automation with Excel VBA
Fill Out Web Forms Dynamically, Navigate Web Pages Intuitively, And Extract & Manipulate Data To Increase Efficiency!
Created by Daniel Strong - Excel Instructor/Programmer
Students: 5546, Price: $109.99
Students: 5546, Price: Paid
Using a website has become part of everyday life in both work and play. Many of us spend hours a day scouring the web or filling out tedious forms online for work!
Throughout the course, I take you through all the undocumented processes, enabling you to locate and interact with any element on a webpage using a variety of strategies, from basic text & attribute searches to Advanced strategies such as XPath, CSS Selectors, and Regular Expression (RegEx) functionalities.
You’ll learn how to fill out web forms dynamically, navigate web pages intuitively, and extract and manipulate data to increase efficiency.
Once you understand how to find an element (or group of elements), you'll learn to evaluate whether elements are hidden, enabled or disabled, visible, selected, checked or unchecked, and then we'll show you how to completely control mouse and keyboard commands and positioning. Then we’ll learn how and when to trigger macros with precision using "Timeouts and Waits"!
In addition to basic navigation, I'll show you how to Open, Access and Toggle multiple tab Windows, how to resize, re-position and auto-scroll your browser window as well as use login techniques with set credentials. You'll be able to deal with pop-ups, alerts, notifications and Frames like an expert. I'll even show you the secrets of controlling the clipboard, saving screenshots to your Excel file or even taking all or parts of online tables into your spreadsheets automatically. Finally, I'll take you through drop down menus and working with list boxes to complete your WebDriver mastery.
The course comes loaded with several examples in each section, including several engaging and challenging exercises to help you solidify what you've learned (with solution videos immediately following).
You’ll receive 100% of the source code, downloadable materials and course workbooks instantly, yours to keep FOREVER. In addition, you’ll receive LIFETIME ACCESS to the course videos, including updates, BONUS videos and lectures as they come out and any future source code and workbooks – Yours to keep – FREE.
All students will receive LIFETIME ACCESS to ask me any questions about the materials in the FORUM section – as well as chat with other students and help each other. As always, this is backed by a 30 day 100% No questions asked refund as well.
So Stop wasting your time with tedious online tasks when you can automate your online workflow Today!
Order “Complete Web Automation with Excel VBA” course Now!
Ultimate Excel Waterfall Chart Course
Impressive Excel Waterfall Charts for Your Reports - From Scratch. No Add-ins, No VBA - For ANY Excel Version!
Created by Leila Gharani - Microsoft MVP, Bestselling Instructor
Students: 4935, Price: $94.99
Students: 4935, Price: Paid
Want to Include impressive Waterfall / Bridge Charts in your Corporate Reports?
Waterfall graphs or bridge charts provide great visualizations for Management Reports.
In this course you learn how to include different variations of the Waterfall Chart in your reports. No VBA or Add-ins are required.
The best part is you can use ANY version of Excel too.
You'd like to impress your Management and colleagues by introducing new techniques to create simple and effective Waterfall charts? Then this course is for you!
Downloadable Excel Workbook of all Waterfall Charts covered. Feel free to use these as your Waterfall Templates.
Cheat Sheets in PDF format as your Quick Reference Guide for the future.
Why use a Waterfall Chart?
A waterfall chart or a bridge chart is a very liked chart by Management. For good reason too. They provide an effective way of visualizing your data that helps you understand how you got from one balance to another balance. They are common for financial figures – they allow you to see the profit development – how you got from gross sales to net income or how your earnings developed from last year to this year. But they are also a good story teller for non-financial data.
Do you use Excel add-ins for your Waterfall or struggle with your data preparation?
Many people use Excel add-ins to create the Waterfall chart. Why? Because they save on the frustration and headache that comes with preparing the data properly for the charts. On the downside, sometimes add-ins can't do exactly what you'd like and for some charts you might want to do it from scratch. You might also be interested to find out what the best method is for creating Waterfall charts from scratch in Excel. If you are, this is the right course for you!
Waterfall Charts Covered
Excel 2016 Waterfall chart (for those that have Excel 2016)
The most flexible method to create the Waterfall chart (for any Excel version)
How to tweak the Waterfall chart for presentation purposes, e.g. long category labels can result in an "untidy" look for the chart and divert attention from your message, adding dynamic, moving arrows that reflect the total difference between end and beginning values, etc.
Vertical Waterfall chart - bar Waterfall version - (for any Excel version)
and much more - new lectures will be added to address different business issues
You can take this course no matter which Excel version you have. The course is done on Excel 2016 but you can follow along on your version as well. Everything can be recreated in older version of Excel – 2007, 2010 & 2013, except of course the new Excel 2016 waterfall chart. Whenever I use a technique that’s available from a specific Excel version, I do state it in the video. You don’t need to worry about compatibility when you share your charts. Something you need to worry about if you use Excel 2016 standard waterfall chart.
Praise for Visualization Secrets for Impressive Reports
"She frames the content in ways that are applicable to my current job..." -- Lauren Brown, Udemy Student
"She has me thinking of different ways to organize my data...and to better present my results to my readers..." -- Robert Goodman, Udemy Student
"I have purchased several courses on this topic from Udemy, but this is by far the best..." --Merchant, Udemy Student
"Every video I learn something new." -- Darshan Patel, Udemy Student
"Leila does an excellent job to show how to easily update graphs dynamically, and best visualize your data..." -- Ugur, Udemy Student
"Course is clear, to the point and very dynamic. Excellent!" -- Paul Guirlet, Udemy Student
Intro to Quantitative Financial Modeling in Excel
Learn how to build financial models in Excel and VBA for different financial topics
Created by FM x FM - Subject Matter Expert in Financial Modeling
Students: 4464, Price: Free
Students: 4464, Price: Free
Excel is an excellent tool for understanding the intricacies involved in financial modeling. The aim in each section of the course is to explain the implementation of the models using Excel.
Some models discussed in this course:
Black-Scholes-Merton (BSM) Option Pricing Model
Binomial Option Pricing Model
Option Implied Volatility
Value-at-Risk (VaR) and Conditional Value-at-Risk (CVar): Historical, Gaussian and Cornish-Fisher (NEW! Added on 4th June 2020)
Optimization of VaR and Trading Liquidity Risk: Unwinding a Position Optimally (NEW! Added on 4th June 2020)
To benefit from this course, it is advised that you try building the models as you go through the videos.
As I am nearing to the 2 hour limit for a free course, I will no longer be adding new videos to this course. If I want to add more videos, then I will have to convert it to a paid-course, which I am not planning to do anytime soon.
Bulk Emails | Outlook automation using Excel VBA
Automated Emails using Excel macros and Outlook
Created by Kamal Girdher - Professional Trainer and Automation Expert
Students: 3649, Price: Free
Students: 3649, Price: Free
Learn how to send customized emails using Excel vba and outlook. You can switch email accounts in between, customize subjects, body, attach customized files, add tables, use template for body and attachments and lot of other things.
If this sounds interesting to you. Go ahead and enroll for this course.
Microsoft Excel – Excel from Beginner to Advanced & VBA
Master Excel with this A-Z Microsoft Excel Course (Microsoft Excel 2013, Excel 2016, and Excel 2019)
Created by Brian Wells - A Dedicated Instructor That Will Help You Excel
Students: 3390, Price: $94.99
Students: 3390, Price: Paid
★★★★★ Course access includes the exact files I use to download and follow along, 1 on 1 Instructor support, lifetime access and a 30 day money back guarantee ★★★★★
Welcome to our course on Microsoft Excel from Beginner to Advanced.
⇉ This course is MASSIVE! You receive 9.5 hours of video content & 138 lectures!
By Enrolling in this course you get instant life-time access to all four levels of Microsoft Excel!
Excel Macros & VBA.
This Microsoft Excel course combines the basic fundamentals to the most advanced features, after taking this online class you will be able to use Microsoft Excel at an expert level. You can learn Microsoft Excel easily and quickly if it is taught correctly. Developed by a Microsoft Certified Master Instructor, this course provides comprehensive coverage on Microsoft Excel.
As an additional bonus, you can download all of the Excel project files that are used in the videos so that you can get a “hands-on” approach to learning the material. You will also be shown how to find and download free "Excel templates" which are spreadsheet templates that you can use like "budget templates" or a "calendar template" or a "schedule template."
PLUS included in this course is 84 Excel Shortcuts that will increase your everyday speed using Microsoft Excel.
Another great aspect of this course is that, at the end of this Excel class, you will be given a CERTIFICATE OF COMPLETION. This course has a quiz after every video so if you need to prove that you have learned the material, or if you’re an employer or supervisor that needs to ensure that someone has actually done the work, this is easily done by looking at the results of these quizzes.
This class is guaranteed to teach you Microsoft Excel. Once enrolled, you will have access to this Excel course for the rest of your life. You will always be able to come back to this Excel class to review material or to learn new material about how to use Excel.
⇉ Watch the promo video to see How Quickly You Can Begin to Master Microsoft Excel!
Enrol now and transform your abiliy to use Microsoft Excel.
Excel Macros & Excel VBA Programming for Beginners
Become a proficient Excel Macros and Excel VBA Programmer in very short time. Excel 2019 Macros & VBA Examples included.
Created by Andreas Exadaktylos - Best Selling Teacher | Msc Computer Scientist
Students: 3344, Price: $89.99
Students: 3344, Price: Paid
COMPLETELY REDONE ON SEPTEMBER 2020 WITH NEW VIDEOS!
Become a proficient Excel Macros & VBA Programmer in a very short time.
Excel VBA is powerful. Everybody wants to learn Excel Macros and VBA. They can make Excel work like magic. But most Excel users never use them. Other spending several days on a multi-hour course or working through a 1000-page book, getting overwhelmed with information. So why waste a great deal of time learning things you may never use.
In this course my goal is to help you learn ways to create Excel Macros that won’t burst your brain. Also to convey the main principles of VBA language and allow beginners, taking their first steps, to learn without requiring individual training.
Content and overview
A macro is a sequence of instructions that automates some aspect of Excel so that you can work more efficiently and with fewer Errors. Macros are written in VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft.
If you think Excel VBA programmers are smarter or more gifted than you, then you’re mistaken. Yes, macros can be intimidating and yes, programming is a huge topic. If you saw a course on Excel programming with hundreds of lectures, would you really watch all of them?
But wait a minute… What about people who may not have programming background, but aspire to reap the utmost from the program? Are there any programming principles and well-guarded secrets that you can learn and use them to create any Macros you want?
In this course you will find several short, to the point lectures covering Excel Macros and VBA entertaining and accessible to non-techies. The goal is not to make you a star Excel programmer. If you want to be that, go for it! But I’ll give you some best practices and make this course extremely practical. After all, you are not a programmer, you just need to write an Excel Macro to help you get your work done.
Why is this course different?
It's super practical. Free downloadable Excel working files are included to allow you to follow along using the same material I use throughout the lectures. You can download all of them.
It's comprehensive and fast. Microsoft Excel Macros and VBA are complex, that's why the course is broken down into bite-sized pieces
I update the Excel class monthly with new lectures!
It has a Homework-Quiz after section so to prove that you have learned the material.
You will learn the most current version of Microsoft Excel (2019) but the concepts are compatible with Excel 2007, Excel 2010, Excel 2013 and Excel 2016
Compatible with Microsoft Office for Macintosh
Are you looking to learn practical Macro and VBA techniques you can put to use instantly? If so, then this is the course for you. It’s entirely project based and it’s full of examples which are fully explained and easy to understand. It has been recorder with the brand new Excel 2019 in full HD 1080p. If you get stacked don’t worry. I have fast and fully support through the discussion board. And if you don’t like the course simply return it. There is a 30-day money back guarantee. At the end of this Microsoft Excel class you will be given a Certificate of Completion
What are you waiting for? Enroll now! (it is 100% no risk deal)
Excel VBA: The VBA Beginner’s Blueprint to Programming Excel
You're Minutes Away From Learning How To Program Excel!
Created by IsáBel . - Microsoft Certified IT Professional. Trainer of 21 Years
Students: 3267, Price: $109.99
Students: 3267, Price: Paid
Become an Excel Programmer and You Can Finally Put Your Work On Autopilot!
Even with all of Excel's great features, and built-in tools, you might find yourself doing repetitive tasks, that take longer than they should.
Or the day will come when you say, "Oh, I wish there were a better way to do this!"
The good news is that Excel, and other Microsoft Office applications, comes with Visual Basic for Applications (VBA), a programming language that will extend the functionality of your Office applications.
In This Course You Get:
- Free Downloadable Workbooks - makes it easy to follow along & practice after class.
- Test Your Skills - exercises to get you engaged & reinforce what you have learned.
- Code Snippets - with common code bites.
- VBA Glossary - talk the talk
This is a VBA beginner's course that will get you on the road to being in that elite group of VBA programmers.
Learning to program can seem daunting at first, but I'm going to make it as easy as possible.
With that said, VBA is a huge topic, and yes, there are a lot of lectures in this course.
But don't stress out.
What I do go over will get you from, "I don't even like looking at VBA", to, "I can do this!"
NOTE: There are multiple ways to get the same result in VBA.
So the way I write a procedure or two might be slightly different than your co-workers code, or yours, and that's O.K.
If you're ready to cut your workload, automate your tasks, and learn a desirable skill while your at it, click the Take This Course button on the top right, and I will help start programming your Excel workbooks with VBA.
Master Excel VBA ANIMATION easily. Beginners to advanced
Create mind blowing Excel dashboards, charts with Excel animation. Learn easily quickly with no prior coding experience
Created by Kishon Deori - Excel expert , Animator & video compositor
Students: 2886, Price: $44.99
Students: 2886, Price: Paid
Excel animation made easy! Yes, animation can change the way your user look at your Excel projects. It's a WOW experience you give to your users just like those killer apps in the app store! The great news is this course is designed for all levels of Excel user. Anyone with basic Excel skill without any prior VBA or coding skills can get started with animation in Excel. This is a step by step course on animating in Excel and thus is a complete comprehensive course. Check out the comments by my current students to see how easy it is to get started with animation with this course. This is a project based course and all the working files are included for fast and fun learning. Now learn this most satisfying skill in Excel in no time!
**The only Excel animation course you'll find anywhere! It's a professionally designed course with super easy concepts and tricks for creating unlimited beautiful and meaningful animations for any Excel dashboard, reports, charts or anything. No prior experience of coding required. Now take your Excel work to a whole new level! Satisfaction guaranteed.**
Do you want to get super creative at work and make every Excel project impressive? Do you want to wow your users: your clients, customers, your boss and anyone? Get started learning Excel animation and become highly wanted ! There's no limit with Excel animation, create what you can think! Get things to action in no time! Create professional animation such as splash screen animations for all Excel projects and have your users jaws dropped as soon as they click open a workbook. Never before animation in Excel was so easy and awesome as this course requires no prior knowledge of coding and all you need to know is just the bare basics of Excel and you are ready to become an excellent animator. Everything is covered step by step from beginner's to master level. Animation in Excel is achieved through VBA (programming language of Excel), but they are super easy and in fact easier than writing some excel formulas like Vlookup. Also in adition to learning concepts and writing simple codes, I'll also show you how you can record macros and modify the codes a very little to achieve any desired animation. This means you'll not have to take the stress of remembering codes and yet understand how things work and when required you'll be able to write animation codes from the scratch! So in any case you'll end up becoming a developer and a creative professional with this course. If you are a complete beginner, you gonna love it. It's super easy to get started with animation in Excel. And if you are already an advanced Excel user or a seasoned VBA programmer, you would be so glad to come across this course, as you will learn tons of tricks to create awesome animations in Excel.
How many people do you know who knows animation in Excel? Chances are not many or maybe none! So be the first to upgrade your skill in Excel! With the Exercise files/ working files included, everything in this course is step by step learning. From writing your first macro/program to writing beautiful animation codes which are not only very easy but very fun to learn. And the best part is you don't have to remember any codes, as Excel will generate those codes when you record a macro. I will take you through all the projects by recording macros and then just make little tweaking to the codes generated by Excel. And also I'll show you how to get the codes from the internet that you are looking and create animations with that. So like I said, no stress on the brain learning codes and it's just fun animating. So some of the things you'll learn are:
move around shapes in Excel with codes,
understand 3D rotations in X, Y, Z axis
Morphing of shapes
create amazing animated splash screens to create first impression when a user clicks open your Excel workbook. Its a winning trick you'd always use once you learn
create loading screens like seen on web pages / mobile apps in your Excel workbooks
create animated password access splash screen system to your Excel workbooks.
learn different styles of animated menus like slide out menus, slide down menus, scaling menus, toggle button animated menus
chart animation / graph animation in Excel
Learn text animation, that you'll always use in all simple to big Excel projects. Because it's insanely easy and useful!
learn to apply various animations in all kinds of dashboards/reports/simple information workbook
learn awesome button animations for that great user experience every time someone interacts with your dashboards/reports/projects
creative mouse hover animation for all projects
various transitions and effect animations
learn all properties of shapes such as transparency, blur, Scale height/width, glow, color to achieve amazing animation effects that can be applied to any project.
Fun is guaranteed throughout this course as you would be amazed to see yourself animating your imagination right within Excel. By the end of the course, you'll be armed with tons of tricks to create any kind of professional animation for any projects. And if you get stuck somewhere or trying out new animation ideas just post your questions on Udemy forum and I'm always around for quick support.
This course is frequently updated with new animation tricks so that you continue to gain from this course. And this course also comes with 30 days of risk free money back guarantee from Udemy. So, for any reason if you are not satisfied, you get full refund, no questions asked. So, go ahead and enroll in this course today and become a creative tech professional.