Some countries have their date format as dd.mm.yyyy and if they send you a workbook containing dates, you may want to format them as dd/mm/yyyy for your own purposes. 130 more words
Tags » Microsoft Excel 2010
To conditionally format blank cells:
Select the data range that you want to format.
From the Home tab, click the Conditional Formatting dropdown and click… 71 more words
Click the Save As button, and on the bottom of the Save As dialog, click Tools.
On the Tools menu, click General Options. The General Options dialog opens. 44 more words
Someone on a recent Excel course said that he had been looking at comparing prices from different suppliers for different products and wanted to find minimum prices for each product and highlight them. 167 more words
In Microsoft Excel 2007 and 2010, by default if you create a pivot table, instead of showing the field names, it will say row labels and column labels. 60 more words
A risk matrix may look something like
with likelihood of risk occurring being related to the severity of the risk.
If we have two columns of data, one representing the likelihood of the risk and the other the severity of the risk, then a third column should be able to use a formula to give the relevant rating. 127 more words