14 ways to check if an year is leap year, using Excel [just for fun]
Today is February 29th, and that means, this year we have one more day to be awesome. So lets celebrate it in Excel style!
Lets learn 14 different ways to tell if an year is leap year, using Excel Formulas.
Why 14? because, we are awesome like that.
How to add your own Macros to Excel Ribbon [quick tip]
Do you know that in Excel 2010 you can create your own Ribbon tabs and add anything to them, including your own macros? Today, we are going to take a look at this useful feature and learn how to add your own macros as buttons to Excel Ribbon. Steps to Add your own macros to […]
Join my Excel Dashboard Masterclass in Australia [May-June 2012]
Hello folks, I have a super exciting news to share with you all. I will be conducting a series of Masterclasses on Advanced Dashboards & Excel in Australia this Autumn (May – June 2012). So if you live in (or nearby) Sydney, Melbourne, Canberra, Perth or Brisbane and want to one up your dashboard skills, […]
Designing a Customer Service Dashboard in Excel [Part 1 of 4]
Sawadee Krup folks. Today, we begin a new series on Chandoo.org – Making a Customer Service Dashboard using Excel. This 4 part tutorial teaches you,
Designing Customer Service Dashboard
Data and Calculations for the Dashboard
Creating the dashboard in Excel
Adding Macros & Final touches
Customer service is one area where a lot of data is collected regularly. Understanding all this and making business decisions is quite complex task. This is where dashboards shine.
Read on to learn how to design customer service dashboards.
Formula Forensics 013. – On Vacation
Formula Forensics is on Vacation.
Formula Forensics is actually on a working Holiday and has visited the Excel Hero Academy this week.
So today in Formula Forensics we will showcase some of the work that have been derived from the learning’s at the Excel Hero Academy.
Formula Forensics 012. – A Neat Formula
;
Today we look at a very neat way of doing a complex Nested If or Vlookup style problem with a simple but beautiful Sumproduct based formula.
Use Text Format to Preserve Leading Zeros in Excel [Quick Tip]
Here is a quick tip to add awesome to your Wednesday.
If you want to enter numbers like 00023 or 023.340 or 23.34500 in your Excel sheet, you would notice that Excel magically removes leading zeros and trailing zeros (after decimal point) as the number 23 is same as 00023. But sometime, we want 00023, not 23. Then what?!?
Very simple, we use TEXT format instead of number format. Just select the cells where you are going to enter these numbers, and from Home ribbon > Number area, select “Text” as cell type. This tells Excel to treat any value you enter as Text, not as number. So when you type 00023, it will appear as 00023.