All articles in 'Quick Tip' Category
Over the last month we have seen some Excel Tips, Tricks, Cheats & Hacks presented by some of the best Excel practitioners on the internet.
In this final post of the series we highlight the Readers Contributions.
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…
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
Learn some of the Microsoft Excel MVP’s favorite Excel Tips, Tricks, Cheats & Hacks in this post
Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition
Here is an interesting scenario.
Let’s say you are looking at a time, like 9:42 AM and want to know which 15 minute slot it fits into. The answer is 9:30 – 9:45. But how would you get this answer thru Excel formulas?Continue »
Did you know you can use Excel 95-03 Color Names or Color Numbers in your Custom Number Formats in all Excel versions up to an including Excel 2013?
This post will show you how.Continue »
Learn how to Count Text, Blanks and Non-Blank cells with this Countif() Quick TipContinue »
Excel contains an often overlooked function
The Excel = Function
Today we quickly review what it can do for us.