Classbaze

Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Excel VBA Exercises and Real-World Projects

Create your own tools from scratch with Excel VBA!
4.5
☆☆☆☆☆ 4.5/5
(214 reviews)
1,771 students
Created by
Karen Tateosyan

9.1

Classbaze Grade®

8.4

Freshness

8.7

Popularity

9.7

Material

Detailed Analysis »

Create your own tools from scratch with Excel VBA!
Go to course »
Platform: Udemy
Price: check current price
Video: 15h 18m
Language: English
Next start: On Demand

Best Excel VBA classes:

Skillshare_logo_2020
Best Excel VBA classes on Skillshare »
Coursera Logo
Best Excel VBA classes on Coursera »
Pluralsight Logo
BestExcel VBA classes on PluralSight »
Udemy logo
Best Excel VBA classes on Udemy »
linkedin
Best Excel VBA classes on LinkedIn (Free trial) »

Classbaze Rating

Classbaze Grade®

9.1 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness

8.4 / 10
This course was last updated on 1/2021.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Popularity

8.7 / 10
We analyzed factors such as the rating (4.5/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Material

9.7 / 10
Video Score: 9.9 / 10
The course includes 15h 18m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 6 hours 20 minutes of 125 Excel VBA courses on Udemy.
Detail Score: 9.7 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
5 resources.
0 exercise.
0 test.

In this page

About this course

  The course will teach you this
  What you need to START the course
  Who can start this course?
General questions
  Coupons & Discounts
  Guarantees & money back
  Financial aid
Teacher
Classbaze hand picked recommendations

About the course

What am I going to learn from this course?
The purpose of this course is to learn practical skills and knowledge in using Excel VBA.
By the end of this course you will be able to create intermediate to advanced level Excel VBA real-world projects from scratch. You will be able to manipulate raw data in Excel with ease by designing Excel tools which save time, increase productivity and minimize the risk of making mistakes.
What is the target audience for this course?
This training program is for Excel users with no or little knowledge in Excel VBA programming.
What is the course structure organized?
This course consists of 6 sections.
The first section is called “Introduction to VBA” – we’ll have to get familiar with the basic concepts of VBA before we dive into the more advanced stuff.
The second section is called “Speed, Logic and VBA Exercises” – we’ll get familiar with using Excel worksheet and VBA functions, declaring variables, using loops, if-then statements, and also many different data manipulation techniques such as sorting data, removing blank rows, removing case sensitivity, applying borders or colors to a range of cells, etc. There will be many Excel exercises and examples in this section.
Sections 3 to 6 including are all about using Excel VBA to create real-world projects from scratch:
· Creating dynamic report of sales / payments in different currencies
· Data matching project (by multiple criteria)
· Sending emails project (using MS Outlook)
· Creating a case tracking system (using MS Form Controls)
What do I need in order to enroll in this course?
You need a Microsoft Excel version installed on your device. I have used Excel 2016 for this course, but the examples in it should run on earlier versions of Excel as well. The newer version you have, the better.
I am using Excel for Mac. Will this make any difference?
There are certain differences between Excel for Windows and Excel for Mac, so some of the codes may not work properly on Mac.
Do I need to have advanced level of using Excel before learning VBA?
No, it’s not necessary.

What can you learn from this course?

✓ Learn how to manipulate text using functions like LEFT, RIGHT, LEN, INSTR, SEARCH, FIND, etc.
✓ Learn how to match data with ease using VLOOKUP, INDEX and MATCH functions, etc.
✓ Learn how to analyze and aggregate data using COUNTIF, SUMIF, MAX functions, etc.
✓ Learn important data manipulation techniques in VBA such as finding the last used row, sorting data, removing duplicate values, deleting empty rows, etc.
✓ Create a better user experience using MS Form Controls.
✓ Save your Excel files and protect them with a password with just a single click.
✓ Send Outlook emails directly from Excel.
✓ Respond to worksheet events such as updating a cell or making a double-click.
✓ Boost your Excel skills by learning VBA and macros.
✓ Design your own Excel tools from scratch to automate your daily tasks.

What you need to start the course?

• Basic knowledge of Excel (programming knowledge NOT required).

Who is this course is made for?

• Excel users who would like to get familiar and advance quickly in VBA coding
• Excel users who would like to improve their practical skills by solving exercises and reviewing real-world projects

Are there coupons or discounts for Excel VBA Exercises and Real-World Projects ? What is the current price?

The course costs $11.99. And currently there is a 52% discount on the original price of the course, which was $24.99. So you save $13 if you enroll the course now.
The average price is $16.6 of 125 Excel VBA courses. So this course is 28% cheaper than the average Excel VBA course on Udemy.

Will I be refunded if I'm not satisfied with the Excel VBA Exercises and Real-World Projects course?

YES, Excel VBA Exercises and Real-World Projects has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any financial aid for this course?

Currently we could not find a scholarship for the Excel VBA Exercises and Real-World Projects course, but there is a $13 discount from the original price ($24.99). So the current price is just $11.99.

Who will teach this course? Can I trust Karen Tateosyan?

Karen Tateosyan has created 3 courses that got 258 reviews which are generally positive. Karen Tateosyan has taught 2,078 students and received a 4.5 average review out of 258 reviews. Depending on the information available, we think that Karen Tateosyan is an instructor that you can trust.

Learn everything about

Karen Tateosyan

Process Optimization Manager
My name is Karen and I am from Bulgaria.I work at one of the world’s leading online payment providers but it is the VBA programming in Excel which I would describe as my hobby. During my career I have developed many Excel tools for the companies I have worked for.I believe that Excel is one of the most used programs in the business world. Probably, we spend more time only on Facebook, Instagram and YouTube these days. My mission is to share practical knowledge in Excel VBA which goes beyond knowing how to write a few lines of VBA code.
Browse all courses by on Classbaze.
Karen Tateosyan's full profile and courses »
Go to class »

9.1

Classbaze Grade®

8.4

Freshness

8.7

Popularity

9.7

Material

Detailed Analysis »

Create your own tools from scratch with Excel VBA!
Go to course »
Platform: Udemy
Price: check current price
Video: 15h 18m
Language: English
Next start: On Demand

Classbaze recommendations for you

Automate Complex Tasks with Microsoft Excel VBA & Excel Macros (Real-World Projects included). Achieve More. Save time.

Unlock Excel VBA and Excel Macros

Automate Complex Tasks with Microsoft Excel VBA & Excel Macros (Real-World Projects included). Achieve More. Save time.
4.7
★★★★★ 4.7/5
152,664 students
Programming for the Business Professional

Ultimate Excel VBA

Programming for the Business Professional
4.6
★★★★★ 4.6/5
14,535 students

Other courses by ​Karen Tateosyan

Go to class »