Just Excel

Excel’s SUMIFS or SUMPRODUCT…Which is faster?

by Charley Kyd on January 1, 2011

An Excel Date Conversion Formula

by Charley Kyd on December 15, 2010

Excel’s Best Lookup Method: INDEX-MATCH

by Charley Kyd on December 15, 2010

The Limitations of VLOOKUP and HLOOKUP

by Charley Kyd on December 8, 2010

How to Use Exact Matches with Excel’s VLOOKUP and HLOOKUP Functions

by Charley Kyd on November 29, 2010

How to Get False Results from Excel Lookup Functions

by Charley Kyd on November 21, 2010

Excel’s VLOOKUP vs INDEX-MATCH Functions

by Charley Kyd on November 15, 2010

Showing Off With Excel…An Excel Color Wheel

by Charley Kyd on November 3, 2010

Error Handling in Excel Spreadsheets

by Charley Kyd on October 31, 2010

Dashboard gauges are still a terrible idea

by Charley Kyd on October 27, 2010

← Previous Entries

Next Entries →