Reporting

How to Select Values from a List in Excel

by Charley Kyd on February 2, 2011

Introducing Dynamic Excel Reports

by Charley Kyd on January 31, 2011

What the heck is an Excel database?

by Charley Kyd on January 6, 2011

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