All articles in 'Featured' Category

Pivot Table Tricks to Make You a Star

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

Flu Trends Chart in Excel [Yes, we can edition]

Published on Jan 22, 2010 { 11 Comments }
Flu Trends Chart in Excel [Yes, we can edition]
Continue »

Dr. Scroll-bar Mortgage Calculator or: Why you should not be borning and use form controls

Published on Jan 20, 2010 { 14 Comments }
Dr. Scroll-bar Mortgage Calculator or: Why you should not be borning and use form controls
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 »

Best Charts to Compare Actual Values with Targets – What is your take?

Published on Dec 18, 2009 { 12 Comments }
Best Charts to Compare Actual Values with Targets – What is your take?
Continue »

2010 Calendar – Excel Template [Downloads]

Published on Dec 11, 2009 { 14 Comments }
2010 Calendar – Excel Template [Downloads]
Continue »

What is Excel SUMPRODUCT formula and how to use it?

Published on Nov 10, 2009 { 32 Comments }
What is Excel SUMPRODUCT formula and how to use it?
Continue »

10 Tips to Make Better and Boss-proof Excel Spreadsheets

Published on Nov 3, 2009 { 27 Comments }
10 Tips to Make Better and Boss-proof Excel Spreadsheets
Continue »

The Project Management Bundle for Excel is Here, Download your copy today

Published on Oct 14, 2009 { 5 Comments }
The Project Management Bundle for Excel is Here, Download your copy today
Continue »

Project Management Dashboard / Project Status Report using Excel [Part 6 of 6]

Published on Oct 6, 2009 { 13 Comments }
Project Management Dashboard / Project Status Report using Excel [Part 6 of 6]
Continue »

Master Excel 2007 Ribbon with this Free Learning Guide

Published on Sep 17, 2009 { 12 Comments }
Master Excel 2007 Ribbon with this Free Learning Guide
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 »

Issue Trackers & Risk Management using Excel [Project Management using Excel - Part 5 of 6]

Published on Sep 8, 2009 { 16 Comments }
Issue Trackers & Risk Management using Excel [Project Management using Excel - Part 5 of 6]
Continue »

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 »

29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]

Published on Aug 24, 2009 { 7 Comments }
29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]
Continue »
Page 1 of 5[1]2345