All articles with 'data' Tag

Preparing Profit / Loss Pivot Reports [Part 2 of 6]

Published on Feb 10, 2010 { 1 Comment }
Preparing Profit / Loss Pivot Reports [Part 2 of 6]
Continue »

P&L Reporting using Excel [Part 1 of 6 on Excel & Accounting]

Published on Feb 4, 2010 { 7 Comments }
P&L Reporting using Excel [Part 1 of 6 on Excel & Accounting]
Continue »

Fix Incorrect Percentages with this Paste-Special Trick

Published on Jan 29, 2010 { 6 Comments }
Fix Incorrect Percentages with this Paste-Special Trick
Continue »

Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations

Published on Jan 4, 2010 { 36 Comments }
Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations
Continue »

Grouping Dates in Pivot Tables

Published on Nov 17, 2009 { 20 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 »

Another Reason why Tables are so awesome [quick tip]

Published on Oct 8, 2009 { 4 Comments }
Another Reason why Tables are so awesome [quick tip]
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 »

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 »

The New Poor – Internet Penetration Rates by Country

Published on Oct 16, 2008 { 12 Comments }
The New Poor – Internet Penetration Rates by Country
Continue »

Clean up Incorrectly Formatted Phone Numbers using Excel

Published on Sep 30, 2008 { 6 Comments }
Clean up Incorrectly Formatted Phone Numbers using Excel
Continue »

Changing Sort Orientation in Excel – Sorting across columns instead of rows

Published on Jul 22, 2008 { 5 Comments }
Changing Sort Orientation in Excel – Sorting across columns instead of rows
Continue »

Skip weekends while autofilling dates in excel

Published on Jun 30, 2008 { 14 Comments }
Skip weekends while autofilling dates in excel
Continue »
Page 1 of 2[1]2