Formula Forensics No. 026 – Highlight Only Duplicate Entries
Today Formula Forensics looks at a formula that Highlights Only the Duplicate Entries in a range.
Making your dashboards interactive [Dashboard Essentials]
Everyone likes to be in control. Even my 2 year old daughter jumps with joy when she lays her hands on TV remote. She pushes the buttons and assumes it is working. It is another story that we rarely watch TV at home.
By adding an element of control, we can make our dashboard reports fun. Interactive elements like form controls, slicers etc. invite users to play with your dashboard, get involved and understand data by asking questions. That is why I recommend making dashboards interactive.
Today lets understand how you can make dashboards interactive.
Visualize Excel salaries around world with these 66 Dashboards
Ladies & gentleman, put on your helmets. This is going to be mind-blowingly awesome.
See how many different ways are there to analyze Excel salary data. Look at these 66 fantastic, beautifully crafted dashboards and learn how to one up your dashboard awesomeness quotient.
Analyzing 20,000 Comments
On 14th July, evening 4:51 PM (GMT), Chandoo.org received its 20,000th comment. 20,000!
The lucky commenter was Ishav Arora, who chimed, “Like super computers…Excel is a super calculator!!!!” in our recent poll.
It took us 8 years & 15 days since the very first comment to get here. And it took just 1 year 7 months & 23 days to add the last 10,000 comments (we had our 10,000th comment on 21st November, 2010).
Out of curiosity, I wanted to understand more about these 20,000 comments. So I downloaded our comment database, dumped it in Excel and start analyzing.
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.
Highlight Employees by Performance Rating – Conditional Formatting Challenge
So who is up for an Excel challenge?
Shelly, who is an HR Manager sent this distress call last week,
“I have a group of employees- lets say 100 employees. Each employee has a performance rating attached to them. I want to divide the group by 5%, 15%, 65%, 10%, 5% based on their performance rating.”
And that is our challenge today. Read on & help Shelly.