Reporting

How to Spawn Excel Models, Analyses, Forecasts, and Reports for Many Categories, Part 1 of 3

by Charley Kyd on February 25, 2011

How to Select Dates and Regions in a Dynamic Excel Report Linked to an Excel Database

by Charley Kyd on February 6, 2011

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

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

by Charley Kyd on November 29, 2010

← Previous Entries

Next Entries →