Tech News

To subscribe to our "Tech News" blog, click here and complete the form.

Thank you.

Work smarter in Sheets with several new features for objects

posted May 2, 2019, 5:43 PM by ITS Website

Google is launching several new features and tools that will help you create more compelling and stylized reports in Sheets:
  • Guides
  • Multi-Selecting Objects
  • Enhanced Pivot table Insertion
  • Copy and Paste images into Sheets
  • Formula backed charts inserted from Answers
These tools will help you make more engaging and informative reports by making it easier and faster to format charts, pivot tables, images and more.

Guides
  • You can use guides to help you align, size and position various objects within your sheets. Guides are also helpful in making sure multiple objects within the same sheets are in proportion to one another.
Multi-selecting objects
  • To select multiple charts, drawing and images to move, resize or delete in bulk, hold down the Control or Shift key and select.
Enhanced pivot table insertion
  • When adding a new pivot table, you'll now have the option to either place it in a new sheet or in a custom location on an existing sheet.
    • To create a new pivot table, go to Data > Pivot Table and select a data range.
    • In the dialogue box, under Insert to, select New Sheet or Existing Sheet, and click Create. Note that if you select existing sheet, you'll have to select a specific cell location for the pivot table.

Copy and paste images into Sheets
  • Recently, Google made it easier to add images to your spreadsheet by inserting images into cells. Now you can copy images from other websites and paste them directly into your sheet.
  • Simply right click on an image and hit copy, then in Sheets wight click and hit Paste to insert the image over the grid.
Formula backed charts inserted from Answers
  • Now, when you use Sheets Explore to create charts, the charts you insert from the Q&A feature (Answers) will be backed by formulas. This means that charts will automatically update if the underlying data changes, ensuring you always have a fresh chart with the latest information.

Work anywhere with Google Docs, Sheets, and Slides in new Offline Mode

posted Apr 29, 2019, 7:46 PM by ITS Website

It's now possible for users to work on Docs, Sheets, and Slides files when your device is offline or have a bad internet connection with Google Drive. You can also preview which files are available offline with a new offline preview mode.

Right click on Docs, Sheets, and Slides files from within Google Drive to make those files available offline.

You can preview which files are available offline using the Offline preview mode

It is important for users to access and work on their files while traveling or when there's low connectivity. With offline mode, it's now possible to create, edit, and comment on Docs, Sheets, or Slides files. Any changes made to files while offline will then sync in Drive once the user is connected again.

To work with your files offline, you'll need to enable offline access in your Drive settings:
  • From Google Drive, click the hear icon at the top right corner, select Settings > General and select Sync Google Docs, Sheets, Slides, and Drawings files to this computer so that you can edit offline.
  • Once offline access is enabled, a check mark icon will appear in the top right next to Settings (gear icon) and Support (question mark). When you click this icon, you can find the offline preview toggle.

To make files available offline in Google Drive, right click on any file and toggle Available offline from the menu while connected.

When offline access is enabled, Google Drive also automatically and intelligently makes a certain number of Google Docs/Sheets/Slides files available offline based on how recently you accessed them. You can preview which files are already available offline, automatically using the offline preview mode. You can also mark a file available offline, so that it always remains available offline, while in offline preview mode as long as you are connected.

The Google Docs Offline extension, which is made available by default to all Chrome users, is still required.

Write now, send later with Schedule send in Gmail

posted Apr 22, 2019, 10:19 PM by ITS Website

You can now schedule your emails in Gmail to be sent at a later date and time. Google are launching this feature on Android, iOS and Gmail on web.

Just write your email as you normally would, then schedule it to be sent at a more appropriate date or time. This gives you greater control, allowing you to shift your work tome to wherever and whenever is most convenient to you and your recipients. Additionally, it's even easier to collaborate globally, allowing you to work across time-times while still respecting everyone's digital well-being.



When drafting an original email or reply in Gmail, you'll now see an arrow next to the "Send" button.
  • Clicking this arrow now gives you the option "Schedule send" option.
  • After clicking "Schedule send", you can pick the specific date and time you'd like the message to be delivered.

Also, you will noticed an additional folder named "Scheduled" will be added on your Gmail. Scheduled messages will appear in this folder while queued to be sent.



Save time with new scheduling features in Calendar

posted Apr 21, 2019, 4:39 PM by ITS Website

Calendar we're updating the creation flow for meetings to help you save time with an easier way to schedule. You will see several changes when creating a meeting such as:

  • Peek at calendars and automatically add guests - Now, when you add a calendar in the "Search for people" box, you can temporarily view coworkers' calendar. Creating a new event then automatically adds those people as guests to your meeting and might suggest a title for the meeting.
  • More fields in the creation pop-up dialog -  The Guest, Rooms, Location, Conferencing, and Description fields are now editable directly in the meeting creation pop-up dialog. Once you add coworkers' calendars, they'll load right right in the background, making it even easier and faster to find an available time for everyone.


Upcoming changes to Google Classroom

posted Jun 26, 2018, 5:07 PM by ITS Website

In preparation for the upcoming school year the Google Classroom team has announced a new Classwork and People page for the students and educators on your G Suite for Education account, as well as updates to the Classroom Stream. This notice alerts you to those changes.

The new Classwork page lets educators better organize assignments and questions and improves planning. Teachers can group work into units or modules, and reorder work to match their class sequence. This helps simplify the class stream so it can be used as a conversational hub between educators and students. Teachers will be able to sign up for early access to the new features.

Actions to take:

  • Teachers who are using Google Classroom, you can now sign up for early access to the Classroom features like Classwork, People and Settings beta.
  • General Access to the new Classwork page will be available from August 2018.

Once available, the class owner will be able to opt-out of using the new Classwork page; this opt-out setting will be available for a limited period of time.

In addition to the Classwork page, the Classroom team has announced the following features also to come this Fall:

  • People Page: We’re consolidating information to help educators and students get to what they need quickly. All information about class members - students, co-teachers, guardians - now appear in the new People page.
  • Settings Page: On this page, educators can control all the settings for their classes, from updating basic class information, to controlling how students post in the stream, to resetting the class code.
  • Stream Updates: With the addition of the Classwork page, the Stream’s purpose can shift to that of a conversational hub where educators can notify their students about upcoming deadlines, post announcements and more.
  • Quiz integration: We’re making it easier to create formative assessments directly from Classroom. Teachers will be able to create a Google Forms Quiz from Classroom, and even lock the quiz for more secure and distraction-free testing on Chromebooks.

Google Drive desktop sync client now shutting down on May 12th, 2018

posted Apr 11, 2018, 12:48 AM by Apps Admin

Last year Google announced that the Drive desktop sync client for Mac and PC - a feature officially known as "Google Drive for Mac/PC" - would shut down completely on may 12th, 2018. 

They are encouraging enterprise organizations like us who are still using Drive for Mac/PC to transition to Drive File Stream.

IMPORTANT: this shutdown has no impact on other Google Drive services.

How it works:

With Drive File Stream, you stream your Drive files directly from the cloud to your Mac or PC, freeing up disk space and network bandwidth. Because Drive files are stored in the cloud, any changes you or your collaborators make are automatically updated everywhere. You'll always have the latest version.

You can also make Drive files available for offline access. These cached files sync back to the cloud when you're online, so the latest version is available on all your devices.

You can use Drive File Stream on these operating systems:
  • Windows: Windows 7 and up. Windows Server editions are not supported.
  • Mac: El Capitan (10.11) and up, For High Sierra (10.13).
How to Install Drive File Stream on each user's computer:
  • For Windows
    1. Download GoogleDriveFSSetup.exe or go to your Google Drive click on the gear Settings and click on Download Drive File Stream for Windows
    2. Run the installer in silent mode: GoogleDriveFSSetup --silent
    3. (Recommended) Uninstall Drive for Mac/PC and 
    4. (Optional) Delete the Google Drive folders at \Users\%USER%Google Drive. Use caution deleting this folder, as it may contain content that has not yet been saved or synced.

  • For Mac
    1. Download GoogleDriveFileStream.dmg
    2. Run the installer in silent mode: hdiutil mount GoogleDriveFileStream.dmg; sudo installer -pkg /Volumes/Install\ Google\ Drive\ File\ Stream/GoogleDriveFileStream.pkg -target "/Volumes/Macintosh HD"; hdiutil unmount /Volumes/Install\ Google\ Drive\ File\ Stream/
    3. (Recommended) Delete the Drive for Mac/PC and Backup and Sync applications.
  • To use Drive File Stream on macOS 10.13 (High Sierra):

    1. Open Drive File Stream.
    2. At the top left, go to Apple menu and then System Preferences and then Security & Privacy.
    3. Next to "System software from developer 'Google, Inc.' was blocked from loading," click Allow.

How To Instantly Create New Items in Google Drive - 6 Useful Keyboard Shortcuts

posted Feb 28, 2017, 3:51 PM by ITS Website   [ updated Feb 11, 2018, 5:16 PM ]

Here are some great keyboard shortcuts in Google Drive to make creating new items easier and quicker than ever before.

Head to drive.google.com. To create a new…

Doc: Shift + t

Sheets spreadsheet: Shift + s

Slides presentation: Shift + p

Drawing: Shift + d

Form: Shift + o

Folder: Shift + f


How to link to a specific paragraph in Google Docs

posted Feb 12, 2017, 3:52 PM by ITS Website

If you ever have a Google Doc that’s tens or hundreds of pages long, it can be difficult to find a specific section of text that someone has asked you to reference. To save time, it can be valuable to provide a direct link to a specific paragraph in your document. Here’s how.

  • Put your cursor at the start of the paragraph that you want to link to.
  • Head to the Insert menu at the top of the page, and choose Bookmark.
  • You will see that a ribbon gets inserted into the document where your cursor was previously.
  • Click the ribbon icon.
  • You’ll see that you have the option to get a link, or to remove the bookmark. Right-click on the word Link, and choose Copy Link Address. (If you ever decide you no longer want the bookmark to be there, you would just remove it by clicking Remove.)
  • Now, when you send that link to anyone, the Doc will be opened right at the paragraph that you bookmarked earlier.

YouTube Video


Add Images to Questions and Answers in Google Forms

posted Sep 8, 2016, 8:31 PM by ITS Website

A few weeks ago, Google released a new update for Google Forms. With this new feature, you can now insert images into survey questions or add images as multiple choices options.

Adding images to a question

  • For example, let’s say you have a question like, “Give me five adjectives you think of when looking at this picture.”
  • In the past, if you were using images in Forms, you would have used this button on the right-hand toolbar.

Google Forms update 1_final

  • But now, if you want to insert images directly into questions or answers, you need to access your images from a different place. When you type out your question, click the image icon on the right side.

Google Forms update 1b_final

 

  • You can upload an image, take a snapshot, direct the form to a URL, browse your Albums or your Drive, or do an online search for an image.
  • Once you upload or select your image, it will be incorporated right into the question.

Google Forms update 1c

 

Adding images as multiple choice answers

  • For example, let’s say you have a question like, “Which of the following images do you think best represents our brand?” and you want your answers to all be images.
  • Click into the first answer space, and then click the image icon on the right-hand side. Upload or select your image.

Google Forms update 1d_final

 

  • Repeat for the other answers. By doing this, you’re inserting the various image options as the answers in your multiple choice question, so that each answer is a different image.

Google Forms update 2

These Two Buttons in Google Drive will help you keep you oragnized

posted Sep 1, 2016, 4:50 PM by ITS Website

These buttons will appear when you are in Shared with meRecentStarred, or looking at Search results in Drive. When you select a document in one of these views, the below bar will appear at the top of your Drive page.

add to drive button

For example, if you are in the Shared with me page, the documents in this folder may not all be stored on your Drive. To fix this, Google has introduced the Add to Drive button
. Click this button to add the document to your Drive and move around to a folder where you can easily find it.

Speaking of moving a document, a second button that has been added to the top bar of Drive is Move to. If you have selected a file and it is already stored in your Drive, then this button will appear. Additionally, if you’ve recently clicked the Add to Drive button, the Add to Drive button then converts to the Move to button.

These two buttons will be available in the top bar of Google Drive in the coming weeks. Keep an eye out for the Add to Drive button in top bar of the Drive homepage, as well as in the top bar of the preview window.

You can find the Move to button in the bar at the top of Drive homepage, or it may also be located under the “…” button, as highlighted below.


1-10 of 52