Rumours are starting to circulate, in the technology news, that Microsoft may be developing a version of Office for the Apple iPad. However, it looks as if Google may have pre-empted the idea. Google have recently announced a free version of Quickoffice for editing Word, and Excel and Powerpoint documents. Don’t get too excited just yet – Google are keen to stress this free version is only available to paying customers.
In this how-to we will talk about the problem of trying to compare two lists of values, in Microsoft Excel, to find values in one list that DO NOT appear in a second list. There are quite a few approaches that work, for this scenario, and we will take a look at implementing several of them.
Here is a curious context menu I recently found whilst playing around with Microsoft Excel 2010.
By selecting a cell, or range of cells, then right-clicking on the border of the range and dragging the mouse, upon …
Whilst looking around Microsoft Excel 2010 you may notice a new charting function called Sparklines which is a useful new data trending visualisation tool – one of a number of new visualisation tools available in the latest version of Excel.
The beauty of Sparklines are that they give more immediate impact to information and can help visually identify trends even quicker before.