Error checking is part of Excel’s auditing tools. It is set up to check your formulas for errors. Like spellcheck, the Error checker tool won’t necessarily find all errors, but it is a useful auditing tool as it works through your document to flag up the errors it spots. In the Formula tab, you have […]
The convert function is used to change data from one unit type to another in Excel. It’s often used to convert dates, but it can do so much more as there is a range of conversion units that you can use to make your life easier. The convert function is an engineering function. In Excel […]
This is a quick function to try out and can add a bit of fun to a worksheet. I’m creating a worksheet listing different forms of marine life for a quiz for some children visiting the local aquarium. It will make the screen look more inviting if I have a photo behind the worksheet to […]
Above is an example of a standard pivot table in Microsoft Excel 2010. It is set up with financial quaters as column headers and products as Row labels. I’m interested in seeing the results for the combined sales for the first half and the second half of the year. As you can see I have […]
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 […]