Technical

Autocorrect in Word – Replace text as you type

December 8, 2015 By Ravi Shankar Leave a Comment

Autocorrect in Microsoft Word 2016, Word 2013, 2010 and 2007 has a feature called replace any text as you type. This tutorial provides an example for replacing text with text and image in Word document.

Replace text as you type in Word 2016, Word 2013, Word 2010 and Word 2007

In Word 2013 and Word 2010 you can access Proofing section by clicking File menu –> Options. To access AutoCorrect option in Word 2007 click on the Word Options and navigate to Proofing section.

And on clicking the AutoCorrect Options the following dialog box would be displayed. Under Replace text as you type, you can add the text which needs to be replaced it is typed in the Word Document.

For example if you want dato be replaced with Digital Answers in word document, then add da to the left hand side and Digital Answers to right hand side then click Add button.

How to use autocorrect for replacing text with picture

Step 1: Navigate to Insert menu, click Pictures under illustrations section

Step 2: Using the Insert Picture dialog, select and add image to the document.

Step 3: Click File menu, select Options from the menu list.

Step 4: In Word Option window, navigate to Proofing section and click AutoCorrect Options.

Step 5: Now enter the name under Replace text and make sure Formatted Text radio option is selected. (If you have not selected any image then this option will not be displayed)

Step 6: Click Add button to add the entry to AutoCorrect list. Then OK button on the AutoCorrect and Word Options to close the windows.

Now whenever you type the replace text, it will be automatically replaced with the image. If you are frequently going to insert company logo or your signature then you try this feature.

Also See: Find Autocorrect entries file in Word 2010

How to export Outlook events to Google Calendar

August 12, 2015 By Ravi Shankar 3 Comments

This tutorial explains the steps required to export Outlook Calendar events to Google Apps Calendar. In order the transfer events from Outlook 2013 and 2010 to Google Calendar, you need to do the following

Export Outlook events in to CSV file.
Import CSV file with Outlook events in to Google Calendar.

Export Outlook Calendar Events

Let us take the following example with two calendar events in Outlook.

To export these events in to a CSV file, click the File menu then navigate to Open menu.

Click the Import option, and select Export to a file in Import and Export Wizard and click the Next button.

Choose the file type as Comma Separated Values (Windows)

Select the Calendar from which you want to export the events and click the Next button.

Enter a name for the export file and click Next button.

Then click the Finish button.

The following message window will be displayed for setting the date range and events that fall between these dates will alone be exported. Click the OK button to complete the export.

Import Calendar Events in CSV to Google Apps Calendar

Login to your Google Apps Account and launch the Google Calendar page. Click the Option icon and select Calendar settings from the list of available menus.

In the Calendar Settings page, click the Calendar tab and navigate to Create new Calendar section.

Click the Import Calendar link and select the CSV file that has the Outlook Calendar Events. Then click the Import button.

The following confirmation message with the Processed and Successfully imported events will be displayed as shown below.

When you navigate back to your Google Calendar, the imported events should be displayed.

Microsoft Outlook Web Access (OWA) keyboard shortcuts

June 21, 2014 By Ravi Shankar 22 Comments

These are some of the useful outlook web access shortcut keys

Del – Delete a message

Enter – Open any outlook item (Message, Appointments, Notes etc.)

Ctrl+N – Create a new outlook item (Message, Appointments, Notes etc.)

Ctrl+R – ‘Reply to’ a message

Ctrl+Shift+R – ‘Reply to all’ message

Ctrl+Shift+F – Forward a message

Alt+S – Send mail

Esc – Close a window

Ctrl+K – Resolve recipient name using address book

F7 – Spell Check

Ctrl+Q – Mark the message as read

Ctrl+U – Mark the message as unread

Ctrl+r – To Refresh

How to password protect workbook in Excel Mac 2011

September 29, 2011 By Ravi Shankar Leave a Comment

Excel for Mac 2011 users can password protect the workbook using the option provided as part of the File menu. Click the File menu and select Passwords from the displayed menu list.

This would display the following File Passwords window with different password option.

You can set a password for opening the excel workbook using the Password to open field. Similarly to set a password for modifying the content in the excel workbook, you can use the Password to modify. If you want to make the workbook as readonly then mark the check box labelled as Read-only recommended.

How to limit results returned by Query function in Google Spreadsheet

September 5, 2011 By Ravi Shankar Leave a Comment

We had already seen brief introduction about using Query function in Google Spreadsheet. Let us see how to limit the number of rows returned using Query Function with the following sample data of batsman with maximum runs in test cricket.

Now if you want to get the top 3 batsman with maximum number of runs scored, then you can use

=QUERY(C3:G13,”select C,G limit 3″)

The limit keyword will reduce the number of results returned to 3.

But say if you want to get the list of top 3 batsman with maximum averages then need to use the Order by clause.

=QUERY(C3:G13,”select C,F order by F desc limit 3″)

The above query would first sort the list using Order by clause and then uses the limit keyword to get the Top results.

Auto Replace feature in Google Docs

August 30, 2011 By Ravi Shankar Leave a Comment

This tutorial talks about the Auto Replace feature available in Google Docs. Using this feature, Google Docs users can add abbreviation and their corresponding words. For example, if you want to the entry da to be replaced with digianswers then you can do the following

Click the Tools menu and select Preferences from the displayed menu list.

In the Preferences Window, make sure to mark the check box with label as Automatic substitution.

And type “da” in Replace text box and the corresponding entry “digitalanswers” in With text box. Click OK button which is available at the bottom of the Preferences window to save the changes. Now when you type “da” in the document, it would be replaced with “digitalanswers”

How to validate an email addresses in Google Spreadsheet

August 25, 2011 By Ravi Shankar Leave a Comment

In Google Spreadsheet you can check whether the value entered is a proper email address by creating a data validation rule. This rule does a simple validation and checks for the @ symbol in the entered value. Let us say you have a column in your spreadsheet that needs to accept only email addresses, then you can do the following to add the validation.

Select the Column values, click the Data menu and select Validation from the menu list.

In the Data Validation window, select Text, Contains for the Criteria drop down and specify the value as @

And if you want to display a message to the user then type the message in Help text some thing like “Enter proper email address example [email protected]”. Click on the Save button to save the changes.

Now when you enter a value in the email address column without the @ symbol then it would display the message as shown below.

Always Keep headings visible in Google Spreadsheet

August 24, 2011 By Ravi Shankar 1 Comment

When you are working with lot of data in a Spreadsheet, the headings would disappear when you start scrolling down the rows. Google Docs Spreadsheet provides users with the option for keeping the headings always visible even when you scroll down the Sheet. This can be done by using the menu option available as part of the View menu. To explain, let us take the take following sample data

Now when the users scroll down below Row no 26, the heading rows would disappear as shown below.

And it will be difficult for the users to find out the column under which the values fall. This problem can be addressed using the Freeze rows feature. Navigate to View menu then Freeze rows and select Freeze 1 row menu option.

This would always Keep the heading rows always visible in a Google Docs Spreadsheet.