All articles in 'Analytics' Category

Pareto Charts – How to do pareto analysis using Excel?

Published on Sep 2, 2009 { 30 Comments }
Pareto Charts – How to do pareto analysis using Excel?
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 »

Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]

Published on Oct 29, 2008 { 10 Comments }
Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]
Continue »

Making Pie-charts look Sexy – The CNN’s tax burden analysis chart

Published on Oct 29, 2008 { 8 Comments }
Making Pie-charts look Sexy – The CNN’s tax burden analysis chart
Continue »

Sorting Text in Excel using Formulas

Published on Oct 22, 2008 { 19 Comments }
Sorting Text in Excel using Formulas
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 »

Sorting a list of items in random order in excel – using formulas

Published on Sep 23, 2008 { 6 Comments }
Sorting a list of items in random order in excel – using formulas
Continue »

Creating KPI Dashboards in Microsoft Excel [Part 2 or 6] – Adding One Click Sort

Published on Aug 27, 2008 { 48 Comments }
Creating KPI Dashboards in Microsoft Excel [Part 2 or 6] – Adding One Click Sort
Continue »

Quickly process text using split() spreadsheet function in google docs

Published on Aug 25, 2008 { 4 Comments }
Quickly process text using split() spreadsheet function in google docs
Continue »

Doing the NY times Olympic medals by country year visualization in excel

Published on Aug 6, 2008 { 28 Comments }
Doing the NY times Olympic medals by country year visualization in excel
Continue »

Excel Bullet Graphs

Published on Jul 21, 2008 { 13 Comments }
Excel Bullet Graphs
Continue »

Bingo / Housie Ticket Generator in Excel

Published on Jul 16, 2008 { 35 Comments }
Bingo / Housie Ticket Generator in Excel
Continue »

Partition Charts in Excel – alternative to pie charts [visualization hack]

Published on Jul 9, 2008 { 14 Comments }
Partition Charts in Excel – alternative to pie charts [visualization hack]
Continue »
Page 1 of 2[1]2