Become an Excel VBA Expert for Beginners - Lite
3.6 (76 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,559 students enrolled

Become an Excel VBA Expert for Beginners - Lite

Learn Step by Step Excel with Macros and VBA Code with Practical Exercises.
3.6 (76 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,559 students enrolled
Created by EDUmobile Academy
Last updated 4/2016
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 35 mins on-demand video
  • 1 article
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Use of excel in a powerful way
  • Undersand VBA and use Excel better
Requirements
  • Need to have Microsoft Excel installed
  • No programming skills required
Description

This course intended for Excel users who want to learn the best way to automate their tasks. Other Microsoft Office applications, as well as Excel, come with a powerful scripting language referred to as VBA. With a little bit of programming knowledge, complicated tasks can be completely automated and finished in seconds. This course assumes no programming experience; only a realistic 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 not be incompatible with later versions of Excel as well. If you're using Excel 2003, you will not manage to open the .xlsm files, but you'll be able to follow along with the demos.

Topics Covered

The course begins with an introduction to macros. You'll find out how to inspect the VBA code that gets created from this process, and how to record a series of activities, the way to run the recorded macro.

You'll then find out the best way to make use of numbers in VBA. There are different kinds of numbers that are utilized in various scenario, so you will be a given an overview of the differences between them.

You'll then be presented to strings. Strings are utilized to symbolizes words and characters in programming. For instance, "hello world" may be saved in your VBA code as a string. You could then perform various operations on your string, like converting it to upper case, replacing a word, counting the number of characters, and others.

Then you'll look at booleans, if-statements and loops. These concepts will enable you to create complex behaviours that wouldn't have been possible by simply recording a macro. You'll able to write code that makes conclusions and implements legitimate rules.

This course is the lite version of "Become an Excel VBA Expert for Beginners"

Hope you join with me.

Who this course is for:
  • Any professional who wish to learn Advance Excel
  • Students who wish to learn the automotive uses of Excel in detail
Course content
Expand 7 lectures 34:46
+ Introduction to Macros
7 lectures 34:46
Strings in Excel
06:21
Booleans in Excel
07:04
If Statements in Excel
06:17
Bonus Lecture: Discount Coupon
00:00