If possible I always use pivottables to create reports in Excel. Pivottables need well formed, normalized data tables as source, which are usually not suitable for data entry. In this post I describe two techniques to bridge the gap between userfriendly and pivotfriendly data structures.
[Read more…] about Normalize data: from Userfriendly to Pivotfriendly
Table
Excel and XML: four observations and two bugs
I have been working with Xml files in Excel for some time now, and thought it is time to share some observations. [Read more…] about Excel and XML: four observations and two bugs