Microsoft Excel has the Named Ranges feature that allows users to give a name to a cell or range of cells that can make it easier to refer to in formulas. The naming of the cells can be tedious if there are numerous ranges to be named on the sheet. Here’s a quick way of […]
A new feature introduced in 2010 version of Excel is the Slicer tool. Used to visually and quickly filter data within a Pivot Table. Although the Pivot Table feature makes it extremely easy to manipulate the layout of data lists in Excel, we have found most attendees of our Excel 2010 training Courses are excited […]
Ever closed an Excel workbook and clicked the “Don’t Save” option, then realised you should have saved it! Microsoft Excel 2010 now has a file recovery option for just such an occassion. This has proved invaluable in our Microsoft Excel Training Courses in London. Always check the AutoRecover time in the Excel options. To do […]