This is second episode of our Monthly Master Class.
In this one, you will learn all about SUMPRODUCT. Know all about basics to advanced usage of this powerful & versatile formula in this 98 minute master class. Continue reading
Today is Friday the 13th. If you are a raging friggatriskaidekaphobiac, I suggest you to stop reading this post. For the rest of you, I have something fun.
Given a year in cell C3, let’s find out all the months with Friday the 13th. Something like above. Continue reading
Over the past 3 weeks we have been able to showcase some Excel Tips, Tricks, Cheats and Hacks from some of the best excel practitioners on the net.
But now it’s your turn… Continue reading
Have you ever wondered about applying different Spreadsheet Formats or Styles to reports which you may be send to different people and so the styling may be different for each recipient?
I haven’t, but in this post I will show how you can add it to your worksheets. Continue reading
Okay, time for another challenge.
Imagine you have some data like this. Each cell contains 3 numbers separated by line break – CHAR(10) and you need to extract the number that is 10 digits long.
Go ahead and solve this riddle. Continue reading
Learn some Excel Tips, Tricks, Cheats & Hacks from some Notable [Non-MVP] Excel Websites. Continue reading
Learn some Excel Tips, Tricks, Cheats & Hacks from some Notable [Non-MVP] Excel Websites. Continue reading
Excel Tips, Tricks, Cheats & Hacks – Chandoo.org Excel Ninja Edition
Learn some of the Chandoo.org Excel Ninja’s favorite Excel Tips, Tricks, Cheats & Hacks Continue reading
Recently I saw an interesting Earth Venus cosmic dance video on Facebook. See the original video below or here.
Although this is not entirely accurate from physics & astronomy perspectives, the dance is a stunning example of patterns that are generated by simple things.
I wanted to recreate this cosmic dance in Excel. How else am I to get my spreadsheet fix on a Saturday?
Here is a quick demo of the final outcome. Read on to learn more about the Earth Venus cosmic dance. Continue reading
Here is a simple IF formula challenge for you. Go ahead and post your answers in the comments section. Can this person vote in Sumeria? Imagine you are the chief election officer in the great country of Sumeria. You have introduced a new eligibility criteria for voters just before the grand presidential elections of 2016. In order […] Continue reading
