All articles in 'Learn Excel' Category
Pivot Tables are an integral part of Excel based reports. So it is no surprise that many of create multiple pivot reports in one Excel workbook. So when the underlying data changes, we often spend time refreshing individual pivot tables. Today, I want to share a quick tip about how to refresh all pivot tables […]Continue »
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.
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 »
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 »
We break the regular awesomeness on Excel & related beauty to bring you an important notice.
You may know that I run an online Excel & Dashboard training program, called as Excel School. We have been running this course since Jan 2009 and trained more than 1,500 students thru this so far. And starting next Monday (29 August), the course prices are going up.
So, if you are waiting to become awesome in Excel, now is your chance.Continue »
Last week I introduced the technique of using custom Number Formats for Chart Axis labels.
Today I present a few more alternative layouts including Chart Series Data Label Formats.Continue »
A few weeks back, John asked a post question, “ How can I add a £ to the 80 on a Chart axis and leave the rest of the numbers plain numbers ? ”
Custom Number Formats, That’s How.Continue »
Who is this course for?
If you use MS Excel to do data analysis, reporting, day to day tracking or project management then this is the right course for you. If you struggle with formulas or not sure which formula to use for any given occasion, then this is the perfect course for you. We will be introducing more than 40 different formulas with 100s of examples in this course. As we will be using realistic data & examples, you can very quickly apply the same to your day to day work and do so much more with ease & confidence.Continue »
It is megaphone time at Chandoo.org. I have a few quick announcements about upcoming training programs & other interesting stuff. Just read on
1. VBA Classes – 2nd batch details.
2. Good news for our Indian customers
3. New Excel Formula Crash Course – from tomorrow (17 August)
4. Excel School prices going up!
5. Recommended Live Training – Mike’s Power Analyst Bootcamp in US
The other day, while I was putting my kids to sleep, this idea came to me. How do I check if a cell contains a palindrome, using Excel formulas?
Next morning, I wrestled with excel for about 20 minutes and boom, the formula is ready.
But what is a palindrome?
A palindrome is a word, phrase, verse, or sentence that reads the same backward or forward. For example: A man, a plan, a canal, Panama!
So, to check if a cell contains palindrome, we need to reverse the cell contents and see if both original and reverse are the same.
Everyone and their colleague knows the importance of Excel keyboard shortcuts. While it may be a good idea to know a 97 different shortcuts for everything in Excel, the fact is, you don’t use them all the time. So, it all boils down to memorizing the few shortcuts that you use all the time.
In this post, I am sharing 10 such shortcuts that I can’t live without, especially, when I am analyzing data, making charts and formatting my workbooks.Continue »
Today I want to share an Employee Shift Calendar Template with you. You can use this template to keep track of shift timings on various days. See a demo of the template: How does this template work? This template uses a 3 main ideas, Excel formulas to create the calendar & checking for a day’s […]Continue »
Last week we learned how to create dynamic hyperlinks in Excel. Today, I want to show you something even cooler. An interactive dashboard based on hyperlinks, like shown above.
Isn’t it impressive?
Well, to create something like this, you don’t need a degree in advanced cryogenics. You just need a bunch of data, a chart, a one line macro code and some pixie dust (go easy on pixie dust).Continue »
During one my recent training programs, a participant asked an interesting question.
I have a list of values. I would like to place a hyperlink in my workbook that would always take me to the last value in the list.
Something like shown aside.
Click on the image to learn how this is done.Continue »
Today, let us learn how to use NPV() function in Excel & create a simple financial model.
If you are dealing with cash and valuations, you are bound to have come across the NPV function. If you don’t know the assumptions behind the same, I bet it could cost you your job!
Let’s take a simple project – You buy a MSFT stock for USD 100. You receive a dividend of USD 10 in the first year, USD 20 in the second year, USD 40 in the third year and then you sell it out for USD 140. If you could have alternatively put this money in bank at 10% interest rate, have you gained anything?
How do you model this in excel? In this tutorial we understand how you can use NPV to do this analysis and what kind of pitfalls you can land into!!Continue »
A quick announcement folks. I am doing an Excel Boot-camp in Singapore this weekend (July 8-10) along with Paramdeep from Pristine. If you are interested in joining our Bootcamp, this is your last chance. Visit our Singapore Excel Boot-camp page for details & sign-up information. The last date for enrollment is Thursday, 7th of July. […]Continue »