How do you explain Excel to a small kid? [poll]
When I was in Perth, I visited Hui’s house one day. Lovely, Hui’s daughter (who is about 14) asked Hui how he knew me. So Hui told that we both share a passion for Excel and that;s how we got to know each other. Then she asked, What is Excel?
At this point, we both tried to explain what Excel is to her in a few ways with no success. Later Hui came up with a brilliant explanation.
He said, Excel has lots of small calculators all interconnected, so that you can do any sort of calculation.
So here is a challenge for you. How would you explain Excel to a small kid (computer literate, but not yet in college).
Formula Forensics 024. Is this number a Prime Number ?
Is my number a Prime Number?
What is a Prime Number?
Today in Formula Forensics we answer both questions.
Highlight Row & Column of Selected Cell using VBA
When looking at a big table of analysis (or data), it would make our life simpler if the selected cell’s column and row are highlighted, so that we can instantly compare and get a sense of things. Like above.
Who doesn’t like a little highlighting. So lets learn how to do highlighting today.
Visualizing Roger Federer’s 7th Wimbledon Win in Excel
Did I tell you I love tennis? Some of my personal heroes & motivators are tennis players. And as you can guess, I admire Roger Federer. Watching him play inspires me to achieve more. So last night when he lifted Wimbledon trophy for 7th time, I wanted to celebrate the victory too, in my style. So I made an interactive timeline chart in Excel depicting his victory.
Creating a Masterchef Style Clock in Excel [for fun]
Jo (wife) likes to watch Masterchef Australia, a cooking reality show every night. Even though I do not find contestant’s culinary combats comforting, occasionally I just sit and watch. You see, I like food.
The basic premise of the program is who cooks best in given time. To tell people how much time is left, they use a clock that indicates how much time is left (much like a stop clock, with a small twist).
One day, while watching such intense battle, my mind went
It be cool to make such a clock using hmm… Excel?
While I cannot share my snapper (or pretty much any other food item) with you, I can share my Masterchef style Excel clock with you. So behold,
Find the last date of an activity
We know that using VLOOKUP, we can find a value corresponding to a given item. For example Sales of x. But what if you have multiple sales for each item and you want the last value?
Today lets understand how to find the last date of an activity, given data like above.
Like everything else in Excel, there are multiple ways to finding last date. If cats can use computers, they would hate Excel. You see, Excel is overflowing with unlimited ways to skin a cat.
How to make a Spoke Chart
Have you ever wanted to make your own Custom Chart type ?
MarnieB was asked by her boss to make a Spoke Chart !
This post will explain how you can make a custom Excel Spoke Chart and introduce you to techniques that can be used to make other custom chart types.