Become an Excel VBA Expert for Beginners
4.2 (120 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,829 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Become an Excel VBA Expert for Beginners to your Wishlist.

Add to Wishlist

Become an Excel VBA Expert for Beginners

Learn Step by Step Excel with Macros and VBA Code with Practical Exercises.
4.2 (120 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,829 students enrolled
Created by EDUmobile Academy
Last updated 11/2015
English
Current price: $10 Original price: $195 Discount: 95% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand automotive ways to use excel.
  • Undersand VBA and use Excel better
  • Use of excel in a powerful way.
  • Get a deeper and more functional knowledge of excel.
View Curriculum
Requirements
  • Need to have Microsoft Excel installed.
  • Students just having average skills in Excel. No programming skills required.
Description

Overview

This is a one-hour course that is intended for Excel users who want to learn how to automate their tasks. Excel, as well as other Microsoft Office programs, come with a powerful scripting language known as VBA. With a little bit of programming knowledge, complex tasks can be fully automated and completed in seconds. This course assumes no programming experience; only a reasonable level of familiarity with Excel.

Prerequisites

Microsoft Excel : This courses uses Excel 2007 for the demonstrations, and comes with .xlsm files for the code examples. These demos and files will be compatible with later versions of Excel as well. If you are using Excel 2003, you will not be able to open the .xlsm files, but you will be able to follow along with the demos.

What you will learn

The course begins with an introduction to macros. You will learn how to record a sequence of actions, how to run the recorded macro, and how to inspect the VBA code that gets generated from this process.

You will then learn how to use numbers in VBA. There are different types of numbers which are used in different situation, so you'll be a given an overview of the differences between them. You will be shown how to do simple arithmetic operations inside your VBA code.

You will then be introduced to strings. Strings are used in programming to represents words and characters. For example, "hello world" could be stored in your VBA code as a string. You could then perform various operations on your string, such as converting it to upper-case, replacing a word, counting the number of characters, and many others.

Then you will look at booleans, if-statements and loops. These concepts will allow you to create complex behaviors that would not have been possible by simply recording a macro. You will able to write code that implements logical rules and makes decisions.

Ranges and Worksheets will be introduced next. These objects are what will allow you to read and manipulate your Excel data from your VBA code. We will then move on to subs and functions. These will allow you to organize your code into small, cohesive pieces, making it easier to reason about complex tasks.

Finally, we will end the course with a simple, practical exercise. We will take a list of phone numbers that are in inconsistent formats, and write some code that will convert them into a standard format at the press of a button.

Who is the target audience?
  • Students who wish to learn the automotive uses of Excel in detail.
  • Any professional who wish to learn Advance Excel.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 10 Lectures Collapse All 10 Lectures 01:04:57
+
Introduction to Macros
2 Lectures 07:29
+
Variables and Numbers
1 Lecture 07:35
+
Strings
1 Lecture 06:21
Strings
06:21
+
Booleans
1 Lecture 07:04
Booleans
07:04
+
If Statements
1 Lecture 06:17
If Statements
06:17
+
Loops
1 Lecture 07:16
Loops
07:16
+
Worksheets and Ranges
1 Lecture 06:56
Worksheets and Ranges
06:56
+
Subs and Functions
1 Lecture 07:08
Subs and Functions
07:08
+
Phone Number Formatting Exercise
1 Lecture 08:51
Phone Number Formatting Exercise
08:51
About the Instructor
EDUmobile Academy
4.2 Average rating
5,757 Reviews
138,736 Students
79 Courses
Programming Made Easy

EDUmobile Academy develops high quality video training courses around topics in mobile development including iPhone, Android, Windows Phone, Java, Responsive Web Design and other emerging technologies.

Every course is created by an expert developer AND a trained mentor in the area of expertise.

Each course undergoes a rigorous planning, review and an internal quality check phase - to ensure that the teaching is of highest standards available online.

EDUmobile Academy was founded in 2008 when smart phones were just emerging into the market. Founder Vishal Lamba is experienced in multiple areas of digital design, mobile development and design, web technologies and digital marketing. He has a mathematics and computer science degree from Lawrence University, USA.

Vishal works closely with content creators and teachers to ensure that every course released meets the internal rigorous quality standards.

All course creators and trainers are currently based in the USA. Support for each course on Udemy is provided with quick turn around by a small team of developers and trainers.