This article will try to explain some of the differences between Access and SQL Server. It is not an exhaustive list, and in no means should be considered an ultimate authority.
This is a great Excel technique for cleaning up data in a pivot table. Pivot tables are wonderful tools. But what if your pivot table is just an intermediate step in your data manipulations and you want to make further use of the summarized data in the pivot table? The author of this piece used to regularly receive 5000 rows of data from a legacy mainframe system. This data has columns for product, month, region, status and quantity. He needed to summarize the data in a pivot table with months going across the top, product, region and status going down the rows. Pivot tables make this a snap.
Infographics have become an incredibly popular way to display bite-sized bits of information in easy to consume forms of charts, graphics and more. It usually takes quite a bit of designer know-how, patience and some pretty pricey software to get the job done, but thankfully there are quite a few services that aim to make that process a little easier.