Background - Spreadsheet Risk Management In the Managing Spreadsheet Risk series so far we have looked at the concept of spreadsheet risk and how to manage it both at a company level and at a...

continue reading...

We love to compare. The instinct to compare leaves no one. Even my two year old twins compare their toys with each other (and fight). It would make Excel hugely popular if Microsoft builds a handy...

continue reading...

Count How Many Times a List of Values Occurs in a Range (or How Can I Simplify My Formula) Today in Formula Forensics we look at how to count how many times a range of values occurs within a Range...

continue reading...

In the past here at Chandoo.org and at many many other sites, people have asked the question "How can I display a number multiplied or divided by 10, 100, 1000, 1000000 etc, but still have the cell...

continue reading...

It has been a while since we had an Excel Links feature. So here we go again. But before jumping in to all the Excel goodness, let me share a few tidbits about our Bangkok adventure.

continue reading...

Houston, We've Had a Problem! In the initial emails requesting a solution to yesterday's Formula Forensics, Chandoo's solution, although Technically correct, Didn't work ? This post looks at the...

continue reading...

Today in Formula Forensics we look at how to Calculate the Maximum value from a list subject to other fields meeting certain criteria:

continue reading...

This series of articles will give you an overview of how to manage spreadsheet risk. These articles are written by Myles Arnott from Excel Audit Part 1: An Introduction to managing spreadsheet risk...

continue reading...

A common Forum Post question and one that Chandoo has written about a few times is, Does my data overlap with another range? This week Formula Forensics examines Pradhishnair's Overlapping Chaninage...

continue reading...

Hello my friend, I have a few quick updates to start the week. Just read on to keep up. Excel VBA section of Chandoo.org During last few weeks, I have spent several hours organizing all the VBA...

continue reading...

Not that I have friggatriskaidekaphobia or anything. But since today is Friday & 13th, lets put our Excel skills to test and find out when the next Friday the 13th is going to be.

continue reading...

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...

continue reading...

Here is a quick Excel tip to kick start your week. Sometimes, we want to enter same data in to several cells. You can use CTRL+Enter to do this in a snap. (1) Select all the cells where you want to...

continue reading...

Obviously, everywhere you look this week, you find advice on how to do better in 2012. While you don't have to wait for a new year to become awesome at your work, You might use the occasion. So,...

continue reading...

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...

continue reading...

In the second installment on Excel Spreadsheet Risk Management, Myles takes a look at How companies can manage spreadsheet risk?. He tells us, how we can set a formal governance framework to reduce...

continue reading...

Here is something fun, personalized and delicious to start your new year. A Picture Calendar built in Excel! Using this you can print a 12 month calendar with your own photos. Its fun to use, easy...

continue reading...

This year has been the most hectic since we started Chandoo.org. We had 178 posts, more than 7,500 comments & 10,000 forum posts. We have trained more than 2,500 students thru Excel school, VBA...

continue reading...

2011 has been the most awesome year since we started Chandoo.org. Without doubt, the credit goes to our community - that is you. I feel very fortunate to have you in our community. You inspire me...

continue reading...

Here is a new year gift to all our readers - free 2012 Excel Calendar Template. This calender has, » One page full calendar with notes, in 4 different color schemes » 1 Mini...

continue reading...