Become an Excel VBA Expert for Beginners - Lite

Learn Step by Step Excel with Macros and VBA Code with Practical Exercises.
4.0 (64 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.
1,556 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 7
  • Length 35 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2016 English

Course 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.

What are the requirements?

  • Need to have Microsoft Excel installed
  • No programming skills required

What am I going to get from this course?

  • Use of excel in a powerful way
  • Undersand VBA and use Excel better

What is the target audience?

  • Any professional who wish to learn Advance Excel
  • Students who wish to learn the automotive uses of Excel in detail

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to Macros
Introduction to Excel VBA
Preview
01:01
Introduction to Macros
Preview
06:28
Variables and Numbers
Preview
07:35
Strings in Excel
06:21
Booleans in Excel
07:04
If Statements in Excel
06:17
Bonus Lecture: Discount Coupon
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

EDUmobile Academy, 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.

Ready to start learning?
Take This Course