This is third episode of our Monthly Master Class.
In this one, you will learn how to get maps in to your Excel workbooks. Understand 5 key techniques for making maps based visualizations in Excel – from regular charts to cell grids to VBA to Power Maps, everything is covered in this intense Master Class.Continue »
Here is an interesting problem to start your day.
Let’s say you work as DNA sequencing engineer at The Enterprise. And you just unlocked the sequence that is responsible for all male problems. The early onset of baldness. The sequence code is AAAA. And you want to find out how many times this sequence is found in a sample of DNA strings, in the range B6:B19. Essentially you want the above.
So how do you write the formula?Continue »
Here is a quick & awesome way to make your dashboards sexy. Add an on / off switch to your conditional formats.
Take a look at above demo to understand what I mean.Continue »
Time for a quick personal update. We (Jo, kids & I) are moving to New Zealand on July 15th. We are going to Wellington and will be living there for next 2 years. New Zealand…Really? Why? How? To understand that, we need to go back in time, to EDATE(TODAY(), -75). In April 2010, I moved back to […]Continue »
Our newest contest is inspired from a question asked by Kaushik, one of our forum members, interesting problem.
Need to quickly visualize 3 variables ( Company, years, Financials) in a single […] chart.
Create a chart to understand multiple variable data and you could win $100 Amazon gift card. Do send your charts before 4th of July to qualify for the prizes.Continue »
My twins (Nishanth & Nakshtra) are now almost 7. They are super keen to learn how computers work. So the other day, I showed them Code.org where there are several coding exercises disguised as games. They loved those games … err coding exercises. So that got me thinking… why not make a game in Excel that teaches kids simple programming concepts.
So I built a Snowman & Hot Chocolate Maze game. In this post, let’s understand how to build such a game using Excel VBA.Continue »
Okay, this is an extension of the Neither “A” Nor “B” sum problem we discussed few days back.
Imagine you have a table named mydata with a few columns and a stop list named stop.list as shown above.
How would you calculate,
- Sum of Hours for all activities excluding those in stop list?
- Sum of all Regular hours for activities not in stop list?
So go ahead and post your answers in the comments.Continue »