All articles with 'Learn Excel' Tag
You take an apartment on rent at $1000 per month and the owner puts an escalation clause saying 10% increment each 3 years. How do you model this in excel? In this tutorial we understand how escalations at certain frequency can be implemented using the mod function in excel. What is the mod() function Simply […]Continue »
With Excel 2007, Microsoft has introduced a powerful and useful feature called as Tables. One of the advantages of Tables is that you can write legible formulas by using structural references. That means, you can write easy to understand formulas like this,
But, there is a problem. When you write these formula and drag the formula cell sideways to fill remaining cells, Excel changes table column references and thus makes your formulas almost useless.
Well, there is a simple workaround for this problemContinue »
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 opened registrations for our first batch of Online VBA classes on May 9th. This program is aimed at beginners & intermediate level VBA users. The aim of this course is to make you awesome in VBA. We will be closing registrations for this program in few more hours (exactly at 11:59 PM, Pacific time, on 20th May 2011)Continue »
Here is a cool count-down timer application made in VBA to remind you about our VBAClasses registration closing time!
Read the rest of this post to learn how this particular app is built.
If you want to learn VBA, then click here to join our class.Continue »
– Cue, alluring music.
Just like Jack and the crew of Oceanic Airlines flight 815, Excel has a number of LOST functions.
This post will look at some of Excel’s Undocumented, Unloved and Rarely used Functions
We have a challenge in our VBA class. Many of the students who join our VBA program have no formal programming background. They may have written a few simple programs long time ago, but most of them lack basic understanding of programming. Teaching VBA can be difficult if we do not address this problem.
So, we have added a lesson on “Introduction to Programming”. In this lesson, our aim is to introduce programming to non-programers.
Since many of you are considering to join our VBA classes, it is appropriate that we give this introduction to programming lesson as a demo lesson. Please watch it below.Continue »
Ok, You’ve just finished the mother of all Spreadsheets. Not only does it solve your companies budget, it tracks production, reports variances, makes a mean cup of coffee and some say, “it May Even Solve World Peace ?”.
But the boss walks in and asks “I have a list of items which I need to distribute evenly into colored buckets”
I had never thought of that option, Maybe I can constrain my model and let it work it out for me ?
Solver I need your help !
Dear Readers & Friends,
I am very happy to announce that our first batch of VBA Classes is 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.
What are the benefits of this class?
Oh so many! Learning VBA one ups your Excel mojo. You will suddenly start saying “Yes” several work opportunities & challenges. Your boss might fall in love with you. You realize the potential to automate large chunks of your work and save time & money.Continue »
Today, I want to quickly share a few things about the upcoming VBA Classes.
I have been running online training programs since Jan, 2010. I have trained more than 900 students till date. Still, whenever I am launching a new program, I could feel that familiar sense of eagerness, tension and tremendous enthusiasm building up. I feel eager because I want to meet you, teach you and learn from you. I feel tensed because I want to do it right. I feel enthusiastic because these training programs give me a lot of new ideas and open-up new possibilities.Continue »
Since I am busy with background work on VBA Classes launching next week, today I want to give you two quick updates.
1. John Walkenbach is offering 80% discount on his Power Utility Pack Excel add-in, only today (3rd May) between 11AM-1PM EST.
2. You can win an XBOX 360 + Kinect by participating in PowerPivot Nerdtastic Quiz on their facebook page.
Read more to get the details about these two.Continue »
Few days ago, I have asked you, Do you want to learn Excel VBA online? and many of you said YES. So we are starting the program, on next Monday – 9th of May.
VBA Classes is a 12 week online training program that will explain various Excel VBA concepts to you in an easy to understand format. Just like Excel School, we will keep this fun, exciting, interactive and useful. We will learn from each other as much as we learn from this course. To help you understand how this course works, we made a small video. You can watch it and get other details about the program in this post.Continue »
Today, we will take a detour to world-wide web and learn how we can improve our dashboards, reports, presentations or workbooks by using one of the ideas, called as Golden Triangle.Continue »
Last week, we have learned what Pivot Table Report Filters are & how to use them.
Today, I am going to show, how you can use simple macro code to change the report filter value dynamically.
We will learn how to create the chart shown here.Continue »
Today we will learn about Pivot Table Report Filters.
We all know that Pivot Tables help us analyze and report massive amount of data in little time. Excel has several useful pivot table features to help us make all sorts of reports and charts.
Report Filters are one such thing.Continue »
Many of you have emailed and asked me, “Chandoo, can you help us learn VBA too? Just like you do with Excel.”
Well, as flattering as those requests were, the fact is, I was lousy at VBA. Well, I used to be very good at Visual Basic, back in the college days. But my programming skills have rusted over the years as I did very little coding. I guess, I have become a business-guy. So it took me time to re-learn VBA. And now, I am happy to announce that We are ready to start our very first batch of VBA Class.
But, before we start, I need some help from you. I want to know what is it that you want to learn, so that we can design the course curriculum & methodology around your needs.
So please take a few minutes and complete this survey:Continue »