Become an Excel VBA Expert for Beginners - Lite
3.9 (67 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,557 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Become an Excel VBA Expert for Beginners - Lite

Learn Step by Step Excel with Macros and VBA Code with Practical Exercises.
3.9 (67 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,557 students enrolled
Last updated 4/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 35 mins on-demand video
  • 1 Article
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Use of excel in a powerful way
Undersand VBA and use Excel better
View Curriculum
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 is the target audience?
  • Any professional who wish to learn Advance Excel
  • Students who wish to learn the automotive uses of Excel in detail
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 7 Lectures Collapse All 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
About the Instructor
EDUmobile Academy
4.2 Average rating
5,195 Reviews
134,517 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.