Archive for the ‘Excel’ Category

« Older Entries

How to secure a workbook with a password

December 28th, 2011 by @HKw@! | No Comments | Filed in Excel, Ms Office, Ms Office 2010

Password protecting your Excel Worksheet can prevent others open your works with your permission. To allow only authorized users to view or modify your data, you can help secure your entire workbook file with a password.

To do it, just follow below steps:-

  • Open your Excel workbook, on the File menu, click Save As.
(more…)
Share

Excel Tutorial: How do I round up the number with multiple decimal point

October 20th, 2011 by @HKw@! | No Comments | Filed in Excel, Ms Office

In Excel, there are two method to round up the value into decimal point.

1st Method :

  • Highlight the cell that you need to round up.
  • Right click on the mouse and choose ‘Format Cells’.

(more…)

Share

Tags: , ,

Excel Tutorial: IF Function

September 27th, 2011 by @HKw@! | No Comments | Filed in Excel, Ms Office

How to create a formula to check whether a number is within the range and how to grade it into categories?

You may use IF function in the data. The If function returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE.

The syntax for the If function is:

If( condition, value_if_true, value_if_false )

  • condition is the value that you want to test.
  • value_if_true is the value that is returned if condition evaluates to TRUE.
  • value_if_false is the value that is return if condition evaluates to FALSE.

Let’s take a look at an example: (more…)

Share

Tags: ,

« Older Entries
BlogCatalog