All articles with 'Analytics' Tag

Grouping Dates in Pivot Tables

Published on Nov 17, 2009 { 18 Comments }
Grouping Dates in Pivot Tables
Continue »

Chart this Sales Data and get an iPod Touch [Visualization Challenge #2]

Published on Nov 11, 2009 { 57 Comments }
Chart this Sales Data and get an iPod Touch [Visualization Challenge #2]
Continue »

Product Recommendation – Excel Lookup Toolbox

Published on Nov 5, 2009 { 3 Comments }
Product Recommendation – Excel Lookup Toolbox
Continue »

Want to become a Data God? Learn Excel Data Tables

Published on Sep 10, 2009 { 15 Comments }
Want to become a Data God? Learn Excel Data Tables
Continue »

Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one

Published on Aug 19, 2009 { 16 Comments }
Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one
Continue »

Create a number sequence for each change in a column in excel [Quick Tip]

Published on Jun 29, 2009 { 4 Comments }
Create a number sequence for each change in a column in excel [Quick Tip]
Continue »

Tweetboards – Alternative to traditional management dashboards

Published on May 7, 2009 { 16 Comments }
Tweetboards – Alternative to traditional management dashboards
Continue »

One more method to find unique values in excel and you can call me a dork

Published on Feb 3, 2009 { 23 Comments }
One more method to find unique values in excel and you can call me a dork
Continue »

Visualizing Search Terms on Travel Sites – Excel Dashboard

Published on Jan 19, 2009 { 10 Comments }
Visualizing Search Terms on Travel Sites – Excel Dashboard
Continue »

Featured Visualizations – Jan 09

Published on Jan 10, 2009 { 3 Comments }
Featured Visualizations – Jan 09
Continue »

Automatically insert timestamps in excel sheet using formulas

Published on Jan 8, 2009 { 36 Comments }
Automatically insert timestamps in excel sheet using formulas
Continue »

Generating Random Phone Numbers

Published on Nov 20, 2008 { 7 Comments }
Generating Random Phone Numbers
Continue »

Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]

Published on Nov 6, 2008 { 2 Comments }
Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]
Continue »

Management Dashboards – Compare 2 Decision Parameters [Part 5 of 6]

Published on Oct 9, 2008 { 16 Comments }
Management Dashboards – Compare 2 Decision Parameters [Part 5 of 6]
Continue »

Handling spelling mistakes while searching your data using excel

Published on Sep 25, 2008 { 8 Comments }
Handling spelling mistakes while searching your data using excel
Continue »
Page 1 of 2[1]2