Category: Technical
How to export Outlook events to Google Calendar
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…
Microsoft Outlook Web Access (OWA) keyboard shortcuts
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…
How to limit results returned by Query function in Google Spreadsheet
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…
Auto Replace feature in Google Docs
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…
How to validate an email addresses in Google Spreadsheet
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…
Always Keep headings visible in Google Spreadsheet
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…
How to enable autocomplete in Google Docs Spreadsheet
Autocomplete feature helps users by automatically filling the content of cell when users starting entering the first couple of letters in the Cell. The automatic entry is picked from the previously entered values for the same column. Let us say you have got the following list of entries in one of the column Arizona Alabama…