Pivot Tables are an interactive table that allow the user to group and summarize large amounts of data in a concise, tabular format for easier reporting and analysis. They can sort, count, and total the data, and are available in a variety of spread sheet programs. One advantage of this feature in Excel is that it allows you to rearrange, hide, and display different category fields within the Pivot Table to provide alternate views of the data. Read on to find out how to create your own pivot table in Excel.Found this neat article which illustrates 3 examples.
Sunday, 11 October 2009
Sunday, 4 October 2009
Sunday, 27 September 2009
Microsoft Excel Web Queries
Pulling data from an external website to an Excel spread sheet can be easy with Excel Web Queries. Web Queries fetches html tables from the web page that you specify and lets you select the ones containing data you want to put into your worksheet.
Web scraping without writing c0de that is!!
More Illustrations Here
Saturday, 19 September 2009
Obfuscating .Net Assemblies and more..
Smart Assembly – “The powerful and user-friendly solution for .NET assemblies' efficient merging, pruning, obfuscation and automatic exception reporting for easy post-deployment debugging.”
Profiling .Net Apps
A few interesting reads that i bumped into..
The hidden memory allocation cost
-------SQL Server Related-------
Subscribe to:
Posts (Atom)