Tweetboards – Alternative to traditional management dashboards
Here is a fun, simple and different alternative to traditional dashboards. Introducing….
One more method to find unique values in excel and you can call me a dork
Use Excel Pivot tables to find and extract unique items in your data. This method is very fast and easily scalable.
Visualizing Search Terms on Travel Sites – Excel Dashboard
Microsoft excel bubble chart based Visualization to understand how various travel sites compete search terms
Featured Visualizations – Jan 09
Check out user journeys and other cool visualizations in this weeks edition.
Automatically insert timestamps in excel sheet using formulas
Often when you use excel to track a particular item (like expenses, exercise schedules, investments) you usually enter the current date (and time). This is nothing but timestamping. Once the item is time stamped, it is much more easier to analyze it. Here is an excel formula trick to generate timestamps.
Generating Random Phone Numbers
Often when you are writing code or testing an application, it might be helpful to have random phone numbers generated for you. Here is an excel formula that I use: =value(left(substitute(rand(),”0.”,””),10)) try these 2 instead (thanks to John) =RAND()*(9999999999-1000000000)+1000000000 =RANDBETWEEN(1000000000,9999999999) [needs analysis toolpack add-in or excel 2007] Even though it works most of the time […]
Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]
Often I wish Microsoft had spent the effort and time on a data genie (and a set of powerful formulas) that can automate common data cleanup tasks like extracting duplicates, makings lists unique, find missing items, remove spaces etc. Alas, instead they have provided features like clippy which are intrusive to say the least. So […]