All articles with 'pivot tables' Tag

31 Excel Tutorials – Learn and Be Awesome in Excel

Published on Mar 11, 2010 { 10 Comments }
31 Excel Tutorials – Learn and Be Awesome in Excel
Continue »

Exploring Profit & Loss Reports [Part 4 of 6]

Published on Mar 3, 2010 { 1 Comment }
Exploring Profit & Loss Reports [Part 4 of 6]
Continue »

Adding Calculated Fields to Pivot Table P&L [part 3 of 6]

Published on Feb 25, 2010 { 3 Comments }
Adding Calculated Fields to Pivot Table P&L [part 3 of 6]
Continue »

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 »

Data Validation using an Unsorted column with Duplicate Entries as a Source List

Published on Feb 2, 2010 { 7 Comments }
Data Validation using an Unsorted column with Duplicate Entries as a Source List
Continue »

Pivot Table Tricks to Make You a Star

Published on Jan 27, 2010 { 12 Comments }
Pivot Table Tricks to Make You a Star
Continue »

Product Recommendation – Excel Dashboard Training Kit

Published on Jan 14, 2010 { 11 Comments }
Product Recommendation – Excel Dashboard Training Kit
Continue »

What is PowerPivot? (and does it really wear underwear on top of pants !?!)

Published on Jan 8, 2010 { 8 Comments }
What is PowerPivot? (and does it really wear underwear on top of pants !?!)
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 »

10 Supercool UI Improvements in Excel 2010

Published on Nov 20, 2009 { 17 Comments }
10 Supercool UI Improvements in Excel 2010
Continue »

Grouping Dates in Pivot Tables

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

Excel Links of the Week [Excel Dashboards Edition]

Published on Nov 16, 2009 { 3 Comments }
Excel Links of the Week [Excel Dashboards Edition]
Continue »

Excel Links of the week [After a long time edition]

Published on Nov 9, 2009 { 1 Comment }
Excel Links of the week [After a long time edition]
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 »
Page 1 of 2[1]2