Category archive for ‘Microsoft Excel’ 
-
Vlookup, Excel and social media.
Somebody is always doing a study on how much lost productivity is costing companies when people do something other than work at work. It used to be that the business intelligence companies were always going on about how much time people "wasted" using excel- now a days it's the huge cost of employees using social [...]
-
The Microsoft Version Skip- XP Mode
Microsoft has announced that they will include a license of XP, running on a "seamless" virtual environment that can be run inside Windows 7. It's being dubbed "XP Mode". They have decided not to include a "Vista mode", citing lack of demand. This is a very smart move on the part of Microsoft. Aside from [...]
-
MS Access query example and comparision to Datamartist
Microsoft Access allows users to create complex queries and analyze large data sets. However, it can be complicated to use compared to Excel. In this post, I'll talk about ms access queries and the equivalent way to perform the same data transformation in the Datamartist tool- visually and simply. Microsoft Access has a clear role [...]
-
Excel auto formating is getting into your genes
We often give Excel our data, and trust it to do the right thing. There was a link posted on meta-filter today that sparked some lively discussion amongst the crowd. The Excel auto formating "feature" loves to scramble common genetic nomenclature. It turns out that in the genetics field, common codes get converted to incorrect [...]
