Excel is really an useful tool and I think I’m just getting started to learn some of its most useful features. Most people (included myself) always thought that complex data are best stored and processed through relational database such as MySQL, Oracle, SQL Server, DB2, Firebird etc. But apparently you can still run relational queries from data which are stored on excel workbooks and fetch required data using MS Query. This feature itself is pretty useful for me when I’m analyzing large datafeeds from affiliate networks/merchants.
For people who are still wondering what this is all about, I recommend that you read this tutorial. The demo was done on a “sales and customers” xls but the same steps to getting the dta through MS Query can be applied to any kind of data you have (for me I have datafeeds).
It was really an eye opener for me and I’m sure it will improve your productivity while dealing with data and reporting in excel. BTW, here are a list of excel shortcuts.