Author: admin
June marks the beginning of the monsoon season in India, which leads to numerous deals on various services such as travel packages, hotels, and guides, all offered at discounted prices. If you are fond of monsoons, Maharashtra, particularly Mahabaleshwar, is an ideal destination to visit in June as part of the India tour packages. The hills are stunning, and the area is less crowded compared to other times of the year, allowing you to relish the serenity without the hassle of long lines and queues. Furthermore, during June, the monsoon has not fully arrived yet, so you can still enjoy…
Angus owns a beautiful apartment near the university campus. With the new semester around the corner, he wants to create brochures to attract students as tenants. But here’s the challenge: the university has students from all over the world who speak different languages. Angus needs to create brochures that speak to everyone—from students from Japan to those from France, and everywhere in between. While he could create PDF brochures in multiple languages manually, that process would be both time-consuming and error-prone. This guide explains how you can automate it all with the help of Google Sheets, Google Slides and the…
June is the time when summer vacations in India reach their peak and it is the best time for family vacations in India. The summer season is at its peak in North India at this time, but the rains have already started in the South. Therefore, it is a great time to travel to the hill stations in the North, especially in the Leh-Ladakh region, as the mountain passes are open for visitors. During this period, many people go on a trek to the sacred Amarnath cave to enjoy its beauty. For an unforgettable vacation, check out the list of…
The Mail Merge and Document Studio add-ons let you send personalized emails with the help of template markers. The markers automatically create a mapping between the column names in the Google Sheet and the variable fields in your email message. When the email is sent, the marker fields in the email message are replaced with the values from the respective columns of the sheet. Let’s say you have a column titled First Name in your Google Sheet and your email message body has a marker that says Dear {{First Name}}, (also notice the comma in the end). Fill-in Fields If…
With Document Studio, you can create employee badges, event tickets, school tags and other types of documents that contain QR Code images. To get started, go to your source spreadsheet and create a column that will the QR Code. Give it a title, say QR Code Image, and add a formula QRCODE in the first empty cell of that column as shown below. This will add the QR Code image link to all the cells of your spreadsheet where the source cell is not empty. Add QR Codes in Google Documents Click anywhere in the Google document where you wish…
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,…