Celebrate 'The VLOOKUP Book' birthday with us. Get 50% discount on the e-book today & tomorrow (30 & 31 October only).

Click here for details

All articles with 'howtos' Tag

One more method to find unique values in excel and you can call me a dork

Published on Feb 3, 2009 in Excel Howtos, Learn Excel
One more method to find unique values in excel and you can call me a dork

Use Excel Pivot tables to find and extract unique items in your data. This method is very fast and easily scalable.

Continue »

Conditional Formatting in Excel – 5 Tips to make you a Rockstar

Conditional Formatting in Excel – 5 Tips to make you a Rockstar

Excel conditional formatting is a hidden and powerful gem that when used well, can change the outlook of your project report / sales budget / project plan or analytical outputs from bunch of raw data in default fonts to something truly professional and good looking. Better still, you dont even need to be a guru […]

Continue »