Tags » Microsoft Excel 2010

Microsoft Excel – changing date format dd.mm.yyyy to dd/mm/yyyy

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

Microsoft Excel

Microsoft Excel - Conditionally format blank cells

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

Microsoft Excel

Microsoft Excel 2010: Set a password to modify file

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


Microsoft Excel – Using conditional formatting to highlight the minimum number on each row

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

Microsoft Excel

Microsoft Excel – showing field names as headings rather than “Row labels” in Pivot tables

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

Microsoft Excel

The HR Metrics I use the most

I’ve been using Excel for 18 years now and in that time it has probably been my most used piece of Office productivity software. From collecting data to producing graphs and reports. 141 more words

Human Resources

Microsoft Excel – using INDEX and MATCH with a Risk Matrix

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

Microsoft Excel