Tags » Microsoft Excel 2010

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

Windows

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

Bekerja Cepat Dengan Auto Fill pada Ms Office Excel 2010

     Sebuah fitur pintar bernama Autofil pada Microsoft Excel dapat dimanfaatkan untuk mempercepat pekerjaan anda, terutama ketika anda sering menuliksan data yang berurutan. Contohnya adalah ketika anda menuliskan data berupa nama-nama bulan, mulai dari Januari hingga Desember, nama hari mulai dari Senin hingga Minggu, atau angka 1 hingga 100. 67 more words

Microsoft Office 2010

Memeriksa Teks di dalam Sel pada Ms Office Excel 2010

     Di dalam pekerjaan sehari hari anda sebagai seorang akuntan atau pegawai kantor yang senantiasa berhubungan dengan penggunaan data spreadsheet tidak jarang anda akan menemui data yang merupakan dat niumerik atau teks. 94 more words

Microsoft Office 2010