Archive for the ‘Ms Office’ 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

How to Split Text into Multiple Columns in Excel 2010

November 9th, 2011 by @HKw@! | 2 Comments | Filed in Ms Office, Ms Office 2010

I found a very useful feature in Excel that allows you to split your data in one column into multiple columns based on a simple condition. This useful feature is ‘text to columns’ which is a option under the Data menu that allows information in a cell or range of cells to be split into columns.

Below is a simple tutorial to show you how to use this useful Excel feature.

Example:

I have a product list that represents product model and serial number. How do I split the product number (Sample A) into two separate columns (Sample B) by using excel? (more…)

Share

Tags: , , ,

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: , ,

« Older Entries
BlogCatalog