Pivot Tables are a great tool for manipulating your data but when it comes to choosing which data source you want to manipulate the list is almost endless, especially with any flat text file, and yes, WITHOUT VBA! Here is a cheat sheet to get you started!
So I just picked up a new laptop, the Dell Studio 15″ which looks and performs great but as I’m in a brick walled apartment I had issues with streaming video over a wireless connection from my Linux file server. The symptoms were stuttering, hitching and skipping but with VLC I was able to fix this issue!
After working in the ‘analyst’ field for a while now I have come accross a lot of tools which can be helpful to squeezing that extra piece of data out or creating a whiz bang report. Here is a list of free tools which should help you along the way!
Coming from a SQL programming background you might find it difficult trying to adapt the AND / OR operators to your Excel formulas, so here is a method that I use to solve this problem.
A lot of people have been trying to download a copy of Windows Home Server 2008 but (like myself) could only find the 120 day trial available by ordering the CD to be delivered via snail mail. So here is how you can download an evaluation copy and avoid the wait!
After installing Vista I had some issues with my HTPC (Home Theater PC); whenever the HTPC ‘awoke’ from being ‘asleep’ (sleep mode) it was locked, even when I had supplied no password for my user! So here is a quick tutorial on how you can disable this option in Vista.
The other day I was handed an Access database, after waiting a couple of minutes for it to open I was dumbfounded with the monster it had grown into (check out the screen shots below). The funny thing was that this database somehow produced a report which a lot of ‘important’ people used and after the builder departed it was left up to me to get it back up and running.
So to prevent any future mishaps here are some tips that I use to keep my Access database organized…
Here is a quick tip on how to change the order of your series from an Excel chart.
This is a quick tutorial on how you can populate the blank row area cells which are created by a Pivot Table.
Just like Access can create a linked Table to a text file, Excel can do the same using a very quick and simple method.
Recent Comments