Author: admin
Vim, or Vi Improved, is a powerful text editor that lets you do almost everything using keyboard shortcuts. You can replace text in a document, move or delete lines, automate edit actions, and more, without ever reaching for the mouse. Vim is the favorite source code editor of programmers but there’s no reason why you cannot use this editor for writing documents or composing long emails. Vim can be confusing for people who are used to working inside visual editors like Microsoft Word or Google Docs but spend some time with Vim and it will be difficult for you to go…
When people submit your Google Form, a new row is inserted in the Google Sheet that is storing the form responses. This spreadsheet row contains a Timestamp column, the actual date when the form was submitted, and the other columns in the sheet contain all the user’s answers, one per column. You can extend the Google Forms sheet to also include formula fields and the cell values are automatically calculated whenever a new row is added to the sheet by the Google Form. For instance: You can have an auto-number formula that assigns an auto-incrementing but sequential ID to every…
Renowned for its vibrant culture, historical significance, and varied traditions, India boasts a unique array of festivals and fairs across its regions and religions, celebrating the birthdays and remarkable achievements of deities, heroes, and saints. Similar to other months, June is also filled with numerous thrilling festivals that are celebrated with immense joy, enthusiasm, rituals, and fervor, drawing many devotees and tourists from around the world as part of India tour packages. Furthermore, these festivals not only foster unity and closeness among people but also educate them about the country’s characteristics. If you wish to partake in these celebrations, consider…
Regular Expressions, or RegEx, are used for searching patterns in text. For instance, a RegEx like iP(hone|ad|od)s? will find mentions of any iOS device in a document. Knowledge of Regular Expressions is essential for programmers, but they can also be an excellent skill for non-developers – people who use Microsoft Word or spend hours inside Google Spreadsheets. Why Learn Regular Expressions? Regular Expressions are extremely powerful, and no less intimidating, but even a basic understanding of RegEx will save you time and make your everyday computing tasks easier. For instance, you can quickly find & replace text that matches complex…
One of the nice benefits of having Microsoft Office is that you get access to tons of royalty-free stock photographs, illustrations, animations and clip art to enhance your Word documents and PowerPoint presentations. These images can be accessed directly from any of the Microsoft Office programs or you may download them online from the Microsoft Office website at office.com. Office Clip Art & Images – Permitted Usage An oft-asked question is can you use these photos and clip art files outside Microsoft Office for a commercial or non-commercial project? For instance, would it be legal to use the Office images on a…
Voice Recognition is magic. You turn on the microphone, say something and watch as your speech is magically transformed into text on the computer screen. Speech Recognition has long been available for English and latin languages but you now use for Hindi, the most popular language in India, as well. To get started, open dictation.io in your web browser. This is an online voice recognition software that works in Google Chrome on the desktop and mobile phone. You say something, the audio is sent to Google Servers for transcription and the words are printed on screen. Go to the language dropdown…
Gmail is very effective at filtering spam emails but spammers seem to have figured out a new way to bypass the spam filters and send emails that land right in the user’s inbox. The emails are sent through Google Forms and because the messages originate from Google’s own email servers, they do not get caught in the spam filters. Here’s how spam emails are sent through Google Forms. A public form is created with Google Forms. The form creator uploads images for the various question fields and also adds links to spam websites in the form. Inside the Form settings,…
You are organizing an online event – maybe a meeting on Zoom or a training session hosted on Google Meet – and you would like the attendees to add the event to their own calendars. Once added to their calendar, the event will act as an automatic reminder and attendees will get a notification when the conference is about to start. There are two way to go about this: You can create a new meeting in your online calendar (Google, Outlook or any other calendar) and add the individual attendees as guests so the event automatically gets added to their…
Gmail Plus Address is a very useful trick to save your mailbox from spam. And if you ever get spammed, you know exactly which website / online service leaked your email address to spammers. Gmail Plus Address So what is a Gmail Plus address? Say you have an email address like billgates@gmail.com. If you append a “plus” sign to your email username, Gmail will ignore anything written between the + and @ sign in the email address and still deliver the message to the same mailbox. So any email address sent to billgates+microsoft@gmail.com or billgates+blog@gmail.com or billgates+website@gmail.com will still reach…
You are working inside a Google Spreadsheet where a formula needs to copied down to the last row of the sheet. You also need the formula to be added automatically when a new row is added to the Google Sheet. There are several ways to solve this problem. Copy Formula Down in Google Sheets The easiest approach to copy down formulas is to use the fill handle in Google Sheets. Write your formula in the first row of your spreadsheet, and then point your mouse to the lower right corner of the formula cell. The pointer changes into a fill…
Websites can determine the visitor’s geographic location using their IP address and serve more relevant content. For example, a weather website may use your IP address to estimate your approximate location and provide weather forecast for your current city automatically. A currency exchange website can determine your default currency based on your country which is detected from your IP address. There are free web IP lookup services, ip2c.org for example, that will reveal the country of your client’s IP address with a simple HTTP request. We internally use that service at Digital Inspiration to determine the payment service provider on…
Google Developer Expert Google awarded us the Developer Expert title recogizing our work in Workspace ProductHunt Golden Kitty Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards Microsoft MVP Alumni Microsoft awarded us the Most Valuable Professional title for 5 years in a row Google Cloud Champion Google awarded us the Champion Innovator award for technical expertise