Memory Game - Pattern Matching

Posted on 10 November 2009

I saw this memory game a few days back. The website promised an instant boost in the players memory if they played this game for a 4 week period. So if you've been wondering how to get that 'excel'-ent memory, here's the prefect game for you. The Memory Game The game is pretty straightforward. You are shown a grid of cells, some of which are colored and some are left blank. Once you've memorized the pattern of the colored cells, the ... Continue Reading

Comments     

Why do Women Shop

Posted on 09 November 2009

Of all the mysteries in the world, one of the most profound is - why do women shop. A man can probably go through most of his adult career with a pair of conservatively stitched suits and matching ties. My old man still takes great pride in a dark, striped one that he got stitched when he had just been commissioned into the forces. I remember the time when he even had a slightly worn one handed over to me ... Continue Reading

Comments     

OLAP Cube in Excel and Pivot Table From External Data

Posted on 05 November 2009

OLAP Cubes provide a convenient way to crunch data in Excel. Imagine a Pivot Table pulling information from thousands or millions of data points with hundreds of columns and you being able to share this humongous data set with colleagues using an Excel spreadsheet that weights nothing more than a few Kilobytes. Add to this the ability to update the source data while the users get to look at that information real time. That’s what a Pivot Table based on ... Continue Reading

Comments (6)

Pivot Table Quick Tip - Group By Year, Quarter, Month and Date Field

Posted on 02 November 2009

It's monday morning and you've got a pivot table on your hands - its source data consisting of three columns – product, date and sales volume over a preiod of time. A pivot table created using this as underlying data may typically have the date running across rows, the product category as the column or page field and finally the sum of sales appearing in the data field in ... Continue Reading

Comments     

Halloween Special - 3 Wicked Things You Can Do with Excel

Posted on 30 October 2009

I reckon that today would be the last working day before Halloween and it might be your only chance to get even. So here are a few Excel tricks especially for you this Halloween - each one getting progressively meaner. Send somebody a Workbook that just doesn't Scroll the Right Way This one is for your super boss (I mean boss's boss). Now wish as you may, you really can't do too many bad things to him, right - so this one's ... Continue Reading

Comments (2)

Scatter Chart with Highlight Box to Group Data Points in Chart

Posted on 28 October 2009

A scatter chart helps to plot data with two or more variables. One great advantage that a scatter chart has is the ability to show a relatively large number of data points in a small area. However, as the number of points plotted within the same space increases, it sometimes becomes difficult to distinguish individual data sub-sets. One quick solution to group all the points within the desired data sub-set is ... Continue Reading

Comments