All articles with 'vba classes' Tag

Holiday Sale is on, Save upto $50 on your favorite Excel courses

Published on Dec 4, 2013 in products
Holiday Sale is on, Save upto $50 on your favorite Excel courses

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.

Continue »

Chandoo.org Holiday SALE, Starts on Wednesday – 4thDecember!

Published on Dec 2, 2013 in products
Chandoo.org Holiday SALE, Starts on Wednesday – 4thDecember!

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.

Continue »

Become Awesome in Excel while saving money

Published on Dec 3, 2012 in products

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.

Continue »

Chandoo.org Holiday SALE, Starts on Monday – 3rd December!

Published on Nov 30, 2012 in products
Chandoo.org Holiday SALE, Starts on Monday – 3rd December!

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.

Continue »

Announcing Online VBA Classes from Chandoo.org, Please Join Today

Published on Jan 11, 2012 in products, VBA Macros

VBA Classes from Chandoo.org - Learn Microsoft Excel VBA & MacrosFriends & 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.

Continue »

Quick Update about VBA Classes & Discount Expiry!

Published on Jan 5, 2012 in Excel Howtos, Learn Excel

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

Announcements

Read on for a bonus Excel tip as well.

Continue »

Our VBA Class Registrations Close in Few Hours, Join Now & Learn Excel VBA

Published on Sep 16, 2011 in Training Programs, VBA Macros
Our VBA Class Registrations Close in Few Hours, Join Now & Learn Excel VBA

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.

Continue »

Excel Training Recommender – Interactive Excel Tool for you

Published on Sep 12, 2011 in Learn Excel, products, VBA Macros
Excel Training Recommender – Interactive Excel Tool for you

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.

Continue »

My Top 10 Tips for Mastering VBA & Excel Macros [Part 5 of 5 – VBA Crash Course]

Published on Sep 6, 2011 in Learn Excel, VBA Macros
My Top 10 Tips for Mastering VBA & Excel Macros [Part 5 of 5 – VBA Crash Course]

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.

Continue »

Announcing Online VBA Classes from Chandoo.org, Please Join Today

Published on Sep 5, 2011 in products, VBA Macros
Announcing Online VBA Classes from Chandoo.org, Please Join Today

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.

Continue »

Putting It All Together – Our First VBA Application [Part 4 of 5 – Excel VBA Crash Course]

Published on Sep 2, 2011 in Automation, VBA Macros
Putting It All Together – Our First VBA Application [Part 4 of 5 – Excel VBA Crash Course]

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.

Continue »

How to use Cells, Ranges & Other Objects in Excel VBA

Published on Aug 31, 2011 in VBA Macros
How to use Cells, Ranges & Other Objects in Excel VBA

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

Continue »

Understanding Variables, Conditions & Loops in VBA [Part 2 of 5]

Published on Aug 30, 2011 in VBA Macros
Understanding Variables, Conditions & Loops in VBA [Part 2 of 5]

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.

Continue »

What is VBA & Writing your First VBA Macro in Excel [VBA Crash Course Part 1 of 5]

Published on Aug 29, 2011 in VBA Macros
What is VBA & Writing your First VBA Macro in Excel [VBA Crash Course Part 1 of 5]

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
Continue »

MLB Pitching Stats Dashboard in Excel+VBA by our VBA Class Student

Published on Aug 10, 2011 in VBA Macros
MLB Pitching Stats Dashboard in Excel+VBA by our VBA Class Student

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.

Continue »