Thursday, 10 May 2012

Type in English and create Hindi/Kannada/Marathi Documents in Word

Here's an easy way to type in English and create documents in Hindi/Kannada/Marathi (transliteration) in MS-Word.  An advantage of this method is no font installation or additional software (other than Word and Google) are required. The receiver too can read it in Word without need for any additional fonts installation at his end.

(Government Departments insist on  correspondence in the official language of the State.Public Notices are displayed in Offices/Hospitals etc in multiple languages for public convenience or on account of the Official Languages Policy. For such requirements too this howto will be useful.)

1. Go to

2. In the language selection box (see red rectangle above), select the language (e.g. Hindi). Some other languages available are : Kannada, Marathi, Telugu, Tamil, Malayalam, Gujarati, Bengali etc.

3.  For example, to get
in Hindi, you need to type Mujhe Bangalore jaana hai 
in the space below the language selection box in the Google Transliteration website. 

4.  Type mujhe and press the space key. On pressing the space key, mujhe is tranliterated into Hindi. Type all the four words and you get something like this:

(Notice that Bangalore (in Hindi) has not been typed correctly.) 

5. To rectify the spelling, click in the middle of the second word and you get spelling variations (see below):
Click on the correct spelling variation needed (4th word in the displayed list) and the original word is replaced. 
(Note: Try variations in English to get the other language word right (E.g Bangalore, Bengalore etc)
6. The above text is just an example. You can type several sentences and paragraphs. You can also transliterate into two languages simultaneously by selecting a different languages before typing: 

6. Next open a blank Word document.  Select all the text in the Google transliteration website, then right-click and click on Copy.  Click in the Word document, right-click and click on Paste.  The pasted text may look like this:

7. In the Word Document, press Ctrl + a (to select all text). Then, in the Home Tab, select the Arial Unicode MS font (see below). 

7. The text should now be correctly displayed as shown below. Save the document for printing or sharing. 

Tuesday, 8 May 2012

Bring Your Own Device (BYOD) and Blackberry Balance

Employees nowadays bring their own Mobile devices to the office and use them to access company resources like email, files and programs. This trend is called "Bring Your Own Device".  In such cases, the company saves the money that would have been spent on providing mobile devices to the employees, while the employees get to use their preferred mobile technology.

What appears to be a win-win situation is not so for the following reasons:
Companies struggle to manage and secure business information residing in/accessible through the phones.

To address these concerns, Blackberry has recently introduced Blackberry Balance ("work-life balance") technology.

Using this technology, IT Departments can set business rules to prevent copying of business information. Business data will not be share-able in personal apps and any attempt at violation will be detected and the employee notified. When the employee leaves the company, the IT Department will be able to remotely wipe all business information in the phone. Similar action can be taken when the phone is lost.

The announcement on the Blackberry website:

BlackBerry® Balance™ technology enables BlackBerry smartphones and tablets to be used for business and personal purposes without compromise.

Boost job satisfaction by supporting employee-owned smartphones
Offer greater BlackBerry smartphone choice flexibility to your workforce while retaining full control over business data security
Allow use of personal apps while restricting copy-and-paste functionality to prevent business information from being shared

Saturday, 5 May 2012

Filling up blank cells in Excel

Compare the two screenshots below:

Sales data ( as shown in the picture at the Left) is entered in an Excel sheet.  The problem with this type of data entry is that Excel functions like SUMIF or COUNTIF will not work correctly. SUMIF, SUMIFs, etc are useful for finding the sales of a particular Salesman, say Govind, from the entire list of data.  For that we need data like the one at the right. So how do we quickly/automatically fill up the blanks?

Fill up a sheet with the incomplete data as shown above.
( "+" in the steps below indicates "and")
1. Click any cell with data in it. Example, B5 with "Govind"
2. Press Ctrl + * keys to select the block of data. (If you are pressing the * (asterisk) key in the QWERTY part of the keyboard, then press Ctrl + Shift + *), This will select the entire block of data.
3. Press Ctrl + g (g can be capital or small).  Go To box will appear.
4. Click on the "Special " button
5. Next, click on radio (option) button: "Blanks"
6. Click on Ok.
7. Press the = key
8. Press the ↑ (up arrow) key
9. Press the Ctrl + Enter keys.
The blank cells will be filled with the value in the cell above.
10. Select the entire block again.(See step 2 above.)
11. Press Ctrl + C to copy
12. Click on Paste Values (in the Home Tab-->Clipboard Group) - see graphic below

(Note: "Paste Values" is done because the blank cells are filled up using formulas and unless the formulas are replaced with values they can mess things up when the data is sorted, etc.).

If the dates in Column A are not displayed correctly and are displayed as numbers: Click cell A2 which has the correctly formatted date. Next click on the Format Painter  (in the Home Tab-->Clipboard Group)(see graphic below). A paint brush symbol will be attached to the mouse.
Drag the mouse over the cells with dates in Column A to apply the correct format.