Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Macros & VBA Excel to your Wishlist.

Add to Wishlist

Macros & VBA Excel

A well designed course to learn Macros and Visual Basics for Applications in Excel
4.2 (1,256 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.
13,552 students enrolled
Created by ioniya .
Last updated 11/2013
English
$10 $20 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 2 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
By the end of this course, you will be able to write programs to customise Excel.
View Curriculum
Requirements
  • Microsoft excel 2010
Description

This course is an Introduction to VBA & Macros in excel.

In this course we have tried to cover all the topics necessary for you get started on creating applications in Excel as per your needs.

As always, to make things easier we have included links to download Exercise files as well as the results for each topic.

Who is the target audience?
  • Some knowledge of excel and its features will make it easier for you to follow this course
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 47 Lectures Collapse All 47 Lectures 04:02:28
+
Introduction
2 Lectures 03:02
Introduction to VBA
02:54

Exercise files
00:08
+
Recording a Macro
2 Lectures 06:38
Getting started
01:51

Recording first Macro
04:47
+
Objects in VBA
11 Lectures 59:12
Overview
04:37

Object under project
06:20

Worksheet object
05:44


Cell object
04:31

Range object
06:00

Properties and range
05:52

Properties and method
04:02

Dates
04:00

Working with color
07:13

Variables
05:41
+
Various boxes and functions in VBA
19 Lectures 01:43:32
Message box
06:41

Input box
05:25

Button
02:44

If then
09:40


Case
09:23

For
07:11

Do loop
07:08

Logical operator
08:29

User defined functions
04:48

Event handling
04:04

Copy and paste
03:31

Conventions
07:15

Array
05:01

Importing data
05:03

Calculator
02:44

CountA function
02:58

For each loop
02:20

Password protection
04:19
+
Userforms
3 Lectures 20:23
Userform
07:36

Forms and label
08:00

Creating a userform
04:47
+
More features
9 Lectures 49:24
Text box
09:56

List box
06:58

Combobox
05:52

Checkbox
07:05

Option button
05:21

Command button
03:59

Multipage
04:12

Image
02:57

Export and Import
03:04
+
Conclusion
1 Lecture 00:01
Conclusion
00:01
About the Instructor
4.3 Average rating
2,615 Reviews
27,078 Students
9 Courses
When you know better, You Do better !!

Ioniya is a video publishing company based in india. Ioniya has created a platform which is trying to bridge the gap between the students and the industries. Authors who have wide knowledge in their fields, help us design our courses which are very practical. We, are an organisation moulding software learning skills to professionals and students bridging the gap between industry specific needs and efficient working. We build the digital literates. We provide an effective method through simulation, a teaching which is very effective and consumes very little time. Ioniya builds an ecosystem in which the learners have a knowledgeable experience in learning from us.

We started with video tutorials for Microsoft office and Engineering softwares like Autocad. We are working on tutorials for many other softwares like Tally, Catia, Weblogic and languages like java,.net etc. With the help of a platform like Udemy, we hope to spread this ocean of knowledge throughout the world.

Report Abuse