Monday, June 27, 2016

Show Sums and More in Google Sheets!

Sometimes you want to quickly calculate numbers in Google Sheets without entering a formula or adding the information to your sheet. It's so easy to do in Sheets!




Show Sums in Google Sheets


  1. Open a spreadsheet in Google Sheets.
  1. Select the cells you want to calculate.
  1. In the bottom right corner of your browser, the "Sum" button will show the total.
  1. Click Sum to see other calculations such as:
  • Average
  • Minimum
  • Maximum
  • Count
  • Count numbers

Here's a brief video that shows this tip in action:



Monday, June 20, 2016

Multi Forward for Gmail

One of the few things I miss about Outlook is the ability to forward multiple emails at once. Gmail does not have a built-in tool to handle multi forwards. Fortunately, there is an extension that solves that shortcoming in Gmail.

Multi Forward for Gmail


1. To install the extension, click here. Choose Add to Chrome.
2. A prompt should appear asking if you really want to add the extension to your browser. Click on “Add” to allow the extension to be added.

3. The extension should be added to your browser. You can see it's icon in the browser’s menu bar. In order for it to work properly, you need to close the browser and then re-open it. When the browser re-opens, click on the little arrow icon for the extension in your menu bar.It should ask you to allow it to access your Gmail account. To do that, click on the button that says “Sign In.”




4. You should be taken to the Google panel where you can authorize the extension to use your Gmail account information. Click on the “Continue” button to move forward with the authorization process.


5. On the screen that follows, you need to click the “Allow” button to provide the extension the information it needs to help you forward emails in your Gmail account. You may need to scroll to the bottom of the window to see the "Allow" button.



6. You should now be greeted with a message along with the instructions on how you can use the extension. You can now simply close that tab in your browser as it is no longer needed.

Thanks ltody@cusd50.org for using the Multi-Forward Gmail extension. You can now proceed to Gmail and continue forwarding your emails.

How to use -
1) Go to Gmail and select the emails that you intend to forward.
2) Click on the Multi-Forward button that appears on the Gmail website.
3) Authorize the extension if you haven't already done so.
4) Enter email recipients.
5) Wait till the forwarding completes.

Some notes about this extension-
1) Whenever you forward a thread(a group of related emails clubbed together in Gmail) using this extension, the
extension will forward the last/latest message of that thread. Since this may be confusing to some users, it is
recommended that users turn off the Conversation View in Gmail.

2) The extension adds the label "multi-forward" to the forwarded threads. This allows you to easily find the forwaded
emails in the Gmail web interface.

Please share and review this extension if you like it!

Developed by karan173
Contact - karan173@gmail.com

7. Now you are ready to begin the actual forwarding procedure. Open your Gmail inbox and select the multiple emails that you wish to forward. Click on the little arrow icon appearing beside the regular email options on the top.


8. Enter the recipients for the emails. You can enter a single or multiple email addresses, and when you are done, simply click the “Multi-Forward” button to start the forwarding process.


9. It will take some time to forward the selected emails. You will get the following screen while it is processing your emails. Do not close this window.


10. When it is done forwarding all the emails, you will see the following success message. It indicates all the selected emails have been successfully forwarded to the specified recipients.









Monday, June 13, 2016

Google Docs: Easy Accents Add-on


Anyone who writes in different language formats, will love this Google Docs add-on. Easy Accents enables you to easy insert accents for different languages directly in your Google Doc. The add on supports 20 languages with new languages added on a regular basis.


To start using Easy Accent, you need to install it from this page. After granting it permission to access your Google Docs, you simply click on “Add-ons” and select “Easy Accents” and "Easy Accents - Start" and then click the language you are using. Accents of that language will be displayed on the sidebar of your Google doc from which you can directly insert them into your paper.

Watch this short video to see how the Easy Accents add-on works.




Monday, June 6, 2016

Boomerang for Gmail


Did you ever think it would be really helpful to schedule an email in Gmail? Today we are going to look at another great organization tool, Boomerang for Gmail. The Boomerang add-on allows you to control the time email messages are sent and received and more!

Boomerang allows you to:

  • Schedule messages to send later
  • Remind you if you don't hear back
  • Return messages to inbox so you can act on them later

Installing Boomerang

Step 1:

Download and install Boomerang from the Chrome Web Store.



Step 2:

Next, you will see a notification window. Click Add extension.


Step 3:

Refresh your Gmail tab.
You will now notice that you have a Boomerang icon in your extensions list, and there will also be a Boomerang icon in your menu bar at the top right of the Gmail window.


Step 4:

Click on the compose button in Gmail. A new message dialogue appears. You can go through the tutorial or skip it and get started with Boomerang right away. The tutorial is always available by clicking on the Boomerang icon at the top right of the Gmail window and choosing the gear icon.



How to use Boomerang

Thanks to the Boomerang people, I have 2 short and sweet tutorial videos to get you started.

How to Send Later with Boomerang for Gmail


How to Schedule Reminders with Boomerang for Gmail