All articles with 'vba classes' Tag

Our holiday sale for 2013 is now live. Click here to purchase your favorite Excel, advanced Excel, dashboards & VBA courses at discount.

What is this holiday sale?

Two of our most popular, awesome & valuable courses are on sale.

1. Excel School & Dashboards program – Save $30
2. Excel School, VBA & Dashboards program – Save $50

Our customers from India save Rs 1,200 & Rs 2,000 respectively.

Here is a quick announcement folks!

Many of you asked me whether we are going to have a holiday sale at Chandoo.org this year. Of course we have a sale!

Details of Chandoo.org Holiday Sale – 2013

Dates of the sale – 4th & 5th December, 2013 (Wednesday & Thursday)

You can save up to $50 in this holiday sale.

Hi Folks,

The moment you are waiting for is here. Our 2012 Holiday SALE is now on.

If you are ready, Just visit Holiday SALE page.

To know more read on…,

What is on sale?

Two of our most popular, awesome & valuable courses are on sale.

1. Excel School & Dashboards program – Save $30
2. Excel School, VBA & Dashboards program – Save $50

Our customers from India save Rs 1,200 & Rs 2,000 respectively.

Here is a quick announcement folks!

Many of you asked me whether we are going to have a holiday sale at Chandoo.org this year. Of course we have a sale!

Details of Chandoo.org Holiday Sale – 2012

Dates of the sale – 3rd & 4th December, 2012 (Monday, Tuesday)

What is on sale?

This year, you can save up to $50 on our best selling training courses.

• Course: Excel School Dashboards program
  • Discount: $30
• Course: Excel School + VBA + Dashboards program
  • Discount: $50

Friends & Readers of Chandoo.org,

I am so happy to tell you that our VBA Classes are now open for your consideration. Click here to know more & join us.

What is this VBA Class?

VBA Class is a structured and comprehensive online training program for learning Microsoft Excel VBA (Macros). It is full of real world examples & useful theory.

The aim of VBA Classes is to make a beginner an expert in VBA.

Read on to understand the benefits of this program & how to sign-up.

I have 2 quick announcements & 1 Excel tip for you.

Announcements

• Registrations for next batch of VBA Class start form January 11th (Wednesday). Please click here to download the course brochure.
• 20% Holiday discount on Excel School expires tonight (Midnight, Pacific Time). Please visit Excel School page and use the code LETSGOEXCEL to claim your discount.

Read on for a bonus Excel tip as well.

Hi everyone, I have a quick announcement for you.

Registrations for our VBA class will be closing in a few hours

As you may know, we have re-opened the doors for our VBA Class on September 5th. This program is aimed at beginners & intermediate level users. The aim of our VBA class is to make you awesome in Excel & VBA.

We will be closing registrations for this program in few more hours (exactly at 11:59 PM, Pacific time, on 16th September, 2011)

Click here to join our VBA Class now.

First a Quick Announcement: Our VBA Class enrollments will be closed this Friday (Sep 16). If you want to learn VBA & Excel, please consider joining our course. More than 120 students have already joined us in the second batch and are learning VBA as you read this. Click here to learn more about the VBA Classes and join us.

Moving on…,

As you may know, Chandoo.org offers quite a few Online Excel training programs. Over the last few weeks, many of you have emailed us and asked which training program is best for your situation. This got me thinking. “It should be easy for YOU to know what is best.”

So today morning, I locked my office room and made a beautiful Excel workbook that asks you only 2 questions and tells you which training programs are best for you. Try it here.

This article is part of our VBA Crash Course. Please read the rest of the articles in this series by clicking below links.

In the part 5 of our VBA Crash Course, let me share you my tips for mastering Excel VBA.

A warning before jumping in to the tips: I am not a VBA expert. I am a learner, just like you. I find VBA quite interesting language to learn and explore. These tips are based on what I have learned writing VBA (and VB code) in the last 12 years.

Dear Friends & Readers of Chandoo.org

I am happy to announce that our Online VBA Training Program is now open for your consideration. Please read this short post to understand the benefits of this program and how you can join. Click here to join our class, if you are ready.

What is this VBA Class?

VBA Class is a structured and comprehensive online training program for learning Microsoft Excel VBA (Macros). It is full of real world examples & useful theory.

The aim of VBA Classes is to make a beginner an expert in VBA.

In part 4 of our VBA Crash Course, we are going to create our very first VBA application using what we learned so far.

We will take the “We Are Nuts” example and create a daily sales tracker application using all the things you have learned so far. You can download the example VBA workbook and play with it to learn better.

In part 3 of our VBA Crash Course, we are going to learn how to speak with various Excel objects like Cells, Ranges etc. and deal with them.

Objects – what are they?

Any thing and everything is an object. Your dog, your bed, your neighbors cat, their car, your bike, your computer, the shiny new Excel workbook you just created, my website, your email account – every thing is an object.

From our “We are nuts” example yesterday, you can already see these objects:

One awesome owner (that is you)
24 store manager objects
24 store objects

In part 2 of our VBA Crash Course, we are going to learn what Variables, Conditions & Loops are and how to use them in Excel VBA.

What are Variables, Conditions & Loops?

If you are new to computer programming, you might think I am speaking legalese. So, to make it easy to understand, lets assume you run a bunch of stores across the town. To make it colorful, lets call your stores “We are nuts” – a dry fruit and nuts store chain. At the end of every day, you call each of the 24 store managers and ask them how much sales they have made in that day.

Now, you are not the kind of boss who micro-manages & nitpicks. So you don’t really note down sale for every store. Instead, as you call the store manager, you just mentally update the total. So first store says “$2,300” your total is 2300. Second manger says “$4,000”, the total now will be 6300. So on.

The value 6300 here is nothing but a variable.

We will use the “We are nuts” example thru out this lesson & towards the end we will build a sales logging application using Excel VBA.

This article is part of our VBA Crash Course. Please read the rest of the articles in this series by clicking below links.

1. What is VBA & Writing your First VBA Macro in Excel
2. Understanding Variables, Conditions & Loops in VBA
3. Using Cells, Ranges & Other Objects in your Macros
4. Putting it all together – Your First VBA Application using Excel
5. My Top 10 Tips for Mastering VBA & Excel Macros

Nothing gives a teacher more satisfaction than seeing a student apply the knowledge to do something awesome. So naturally, I jumped with joy when I got this email from Dan, one of my VBA Class students,

Hi Chandoo,
After going thru your VBA Classes, I realized that we can lots of awesome stuff with pivot tables + simple macros. I recently created an Excel Dashboard to depict MLB (Major League Baseball) Pitching Stats. I could not have done this had I not learned VBA. Thank you so much for teaching the class.

I got curious and requested Dan, if I could share the file with you all. Being a lovely person, Dan agreed immediately.