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!
Here is a quick tip on how to change the order of your series from an Excel chart.
After playing around with Excel and PowerPoint 2007, I was very impressed at the way you can format your objects to look very Web 2.0ish, but as I use 2003 at work a lot I wanted to see if I could replicate this.
Here is a quick tutorial on how to change your objects in an Excel 2003 worksheet or PowerPoint 2003 presentation into Web 2.0 style objects.
This is a quick tutorial on how you can populate the blank row area cells which are created by a Pivot Table.
Can’t perform any date formatting on a cell because Excel doesn’t recognise its contents as an ‘actual’ date? Using the DATE() formula can help you convert a text field to a date field!
Here is a quick tip on how to browse multiple worksheets in Excel. It’s great if you have too many sheets to display on the screen and have to keep clicking on the next arrow!
Ever wondered how you can remove those annoying dashed print area lines from an Excel worksheet?
Recent Comments