All articles in 'Excel Howtos' Category

Copy Data Validations from one cell to another [quick tip]

Published on Oct 28, 2009 { 6 Comments }
Copy Data Validations from one cell to another [quick tip]
Continue »

Prevent Duplicate Data Entry using Cell Validations

Published on Oct 26, 2009 { 13 Comments }
Prevent Duplicate Data Entry using Cell Validations
Continue »

How to get Excel 2003 Toolbars in Excel 2007 [productivity hack]

Published on Oct 19, 2009 { 14 Comments }
How to get Excel 2003 Toolbars in Excel 2007 [productivity hack]
Continue »

Making a chart with dynamic range of values

Published on Oct 15, 2009 { 6 Comments }
Making a chart with dynamic range of values
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 »

Make a Bubble Chart in Excel [15 second tutorial]

Published on Oct 5, 2009 { 7 Comments }
Make a Bubble Chart in Excel [15 second tutorial]
Continue »

Use Cell Styles to Make your Spreadsheet Models User-friendly [Quick Tip]

Published on Oct 1, 2009 { 6 Comments }
Use Cell Styles to Make your Spreadsheet Models User-friendly [Quick Tip]
Continue »

Calculate Elapsed Time in Excel [Quick Tips]

Published on Sep 22, 2009 { 9 Comments }
Calculate Elapsed Time in Excel [Quick Tips]
Continue »

Excel Check Boxes, Even Simpler Way

Published on Sep 15, 2009 { 7 Comments }
Excel Check Boxes, Even Simpler Way
Continue »

How to get tick marks in Excel? [custom cell formatting]

Published on Sep 15, 2009 { 9 Comments }
How to get tick marks in Excel? [custom cell formatting]
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 »

Make a Pivot Table in Excel [15 Second Tutorial]

Published on Aug 25, 2009 { 3 Comments }
Make a Pivot Table in Excel [15 Second Tutorial]
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 »

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 »

Hide Grid Lines [Quick Tip]

Published on Aug 13, 2009 { 13 Comments }
Hide Grid Lines [Quick Tip]
Continue »
Page 2 of 51[2]345