All articles in 'Excel Howtos' Category

Writing “Either Or” formula in Excel [Formula Howtos]

Published on Mar 2, 2010 { 4 Comments }
Writing “Either Or” formula in Excel [Formula Howtos]
Continue »

Find and Remove Blank Items from a Range of Cells [personal experience]

Published on Feb 23, 2010 { 13 Comments }
Find and Remove Blank Items from a Range of Cells [personal experience]
Continue »

How do you consolidate data from multiple sheets in to one? [open thread]

Published on Feb 19, 2010 { 19 Comments }
How do you consolidate data from multiple sheets in to one? [open thread]
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 »

Conditionally Formatting Dates in Excel [Part 1 of 2]

Published on Jan 5, 2010 { 6 Comments }
Conditionally Formatting Dates in Excel [Part 1 of 2]
Continue »

Print Worksheets in One Page Across [Quick Tips]

Published on Dec 22, 2009 { 1 Comment }
Print Worksheets in One Page Across [Quick Tips]
Continue »

The 1000th Post

Published on Dec 21, 2009 { 18 Comments }
The 1000th Post
Continue »

How to Print Excel Comments

Published on Dec 16, 2009 { 4 Comments }
How to Print Excel Comments
Continue »

How to hide “0″ in chart axis [quick tip]

Published on Dec 14, 2009 { 8 Comments }
How to hide “0″ in chart axis [quick tip]
Continue »

How to pick a random date? [Formulas]

Published on Dec 8, 2009 { 3 Comments }
How to pick a random date? [Formulas]
Continue »

Format Charts Faster in Excel 2007 [quick tips]

Published on Nov 30, 2009 { 3 Comments }
Format Charts Faster in Excel 2007 [quick tips]
Continue »

Reverse a List using Formulas [Using Excel INDEX() Formula]

Published on Nov 19, 2009 { 7 Comments }
Reverse a List using Formulas [Using Excel INDEX() Formula]
Continue »

Transpose Excel Rows and Columns [Quick Tip + Video]

Published on Nov 18, 2009 { 2 Comments }
Transpose Excel Rows and Columns [Quick Tip + Video]
Continue »

10 Tips to Make Better and Boss-proof Excel Spreadsheets

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

Switch Rows and Columns in Charts [Quick Charting Tip]

Published on Nov 2, 2009 { 4 Comments }
Switch Rows and Columns in Charts [Quick Charting Tip]
Continue »
Page 1 of 5[1]2345