105 Excel VBA Functions Explained
What you'll learn
- Advanced use of Excel VBA in business applications development
- Computer programming techniques implemented in Excel VBA
- Layout a strong foundation for efficient, professional business applications built with Excel VBA
Requirements
- Basic Excel knowlegde: Worksheets, Cells, Formulas, Tables, Ranges
- Basic Excel VBA knowlegde: Subs, Functions, Variables, Conditional Flow, Loops
Description
“Since I have started your 105 Excel VBA Functions course on Udemy I have become a big fan of your approach. This course is not just a basic VBA course but it actually generates useful tips for real life problems” - Marcel Eggen, The Netherlands
In this course I'll walk you through 105 Excel VBA functions that have been proven in real life business applications I developed for my customers over the years.
Unlike a boring walk-through of explaining VBA, here you learn in the fastest way possible, which is learning by example.
In addition to giving you actual code you can use today, each of the 105 pieces of code include a video where I explain the code line by line, along with imporant programming best practices and VBA masters secrets.
You will not find any course like it anywhere!
You will have the option of downloading* all of these functions and using them in your own programs!
I have also included user interaction dialog boxes for a professional look and a pleasant user experience. Use these User Forms to create more dialog boxes for your specific applications.
By understanding my thought process and how these functions are written, you will improve your own VBA skills when writing your own functions.
In addition, if you plan to create Excel VBA applications for clients, or even within your company, when you download this functions library of mine, you will have a solid foundation for actual business applications built with Excel.
I have used these functions in projects for companies like: Citadis, Re-solutions Insurance, Hospitality Designs, Customer Faithful and many others.
This library will save you tons of time and frustration you would otherwise invest to create these functions yourself.
* Your name and email are required if you wish to download the 105 Excel VBA Functions Pack
Who this course is for:
- People looking to develop a professional Excel VBA career
- Excel VBA developers looking to take it to the next level by developing business-grade information systems on Excel VBA
- Advanced Excel users curious about Excel VBA
Course content
- Preview09:06
Instructor
![Mor Sagmon](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.8 Instructor Rating
- 10 Reviews
- 157 Students
- 1 Course
I'm an Excel VBA master and professoinal developer of business applications for businesses all over the world.
I started computer programming at the age of 13, using technologies you probably never have heard about.
Having worked for the software giant SAP for 15 years and having served as an Information Systems manager for 4 years, allowed me to become an expert in translating real life business processes into beautiful and intuitive software solutions.
The business applications I build on Excel are exceptional, as you'll appreciate during the course.
I train and support others in building their own career. I offer online training and personal mentoring for a select number of software consultants.
I'm a computer science graduate with a major in Information Systems and Databases from the prestigious Technion university in Israel, and I make sure that my students get the foundation just right!