Google Docs tips and tricks

Ruth G. | October 26, 2020
41 mins

Thanks to Google Docs, the days of paying through the nose for Microsoft Office are gone. Google’s version offers capabilities that make writing, editing, and sharing content infinitely easier. Best of all, it’s free.

There is often some confusion between Google Docs vs. Google Drive. Google Docs is a bunch of apps (similar to Microsoft Office) that interact with the online storage system: Google Drive. Signing up for a free Google account is all you need to do to use Google Drive storage, and get access to a suite of office-based apps. It’s that easy.

Google doc is simply one of these applications — available across desktop and other devices. But, chances are you might not be using it to its full potential. There are are a lot of tricks that even experienced users might not be aware of it. Did you know that you can upload Microsoft documents and work on them in Google's software, for example?

We’ve set out to demystify the most popular and little-known Google apps features. With these tricks at your disposal, you no longer have to wonder if “there must be an easier way to do this.”

Before we get started, make sure you’re using the Google Chrome browser. To get the most out of Google Docs, use the Google Chrome browser. Many of the following features require it.


Universal tips to get started with Google Drive apps

Google Drive is a cloud storage system. In a nutshell, this means instead of storing your work on to your computer, free up your hard drive by storing files online.

On first glance, it might seem a little different from other software. The central Drive binds all the apps available to Google account holders (including Docs, Sheets, and Slides) together and gives you a common area for your files. You can even create folders just like you would on your home computer. All things considered, Drive is one of the most powerful, user-friendly and versatile cloud storage systems available.

Unless stated, the following time-saving tricks will work the same whether you’re working in Google Docs, Slides or Sheets. We’ll cover tips specific to each tool as we get to them.

Set yourself up for a smooth ride

The following tips are things you can do before you start creating content in Google Apps. Setting up Offline editing and adding Customized shortcuts mean less friction when you’re focused on your work.

Work without WIFI

What happens when your WIFI at home is playing up when you board a plane or travel to an area with limited access? Thanks to Google Docs Offline, your work doesn’t have to suffer when you lose internet access. With ‘Offline Sync’ you can keep working uninterrupted. Your updated document is automatically uploaded to your Google Drive account once you get a connection.

  1. From your Google Docs home screen, select the Menu icon in the top right-hand corner (three lined icon).
  2. Click settings
  3. In the general settings, scroll to the ‘Offline’ option. Select this option. You’re now ready to work when you have no internet.

Note: Prepare the mentioned steps in advance as you can’t decide when you are offline that you want to use this feature.

Extend your font library.

Sick of the same tried and tested fonts? Use this tip to add more fonts in Google Docs and Slides.

  1. Open any Google document or select fonts from the menu bar, click More Fonts (the last option).
  2. The next screen will display all the fonts available. Select the ones you wish to use. You’ll see a blue checkmark next to your selections.
  3. When you’re happy with your new Fonts, select ‘Ok.’You can now choose your new fonts from the Font box.

Once added, the fonts will be available in any Google doc you create.

Note: that you’ll need to add each font to the application that you want to use it in. To add new fonts to Google Slides, add a Text Box, and follow the same instructions.

Make life easier with customized shortcuts

Taking a moment to set this up will pay off - especially if you’re someone using special characters like the ™ or © symbol often. To set up customized shortcuts that fit your content.
Click on Tools and head to Preferences. From here you can manage your style shortcuts. You’ll also find options to disable automatic word capitalization - a must for content publisher describing companies, products, and services with quirky spelling.

Maintain a personal dictionary

There’s a lot of slang and technical jargon that hasn’t made it to the Google Docs dictionary. You may even encounter a red line under the text every time you type your name or your business’s name. If you’re tired of hitting ‘ignore’ during spell check, you can quickly add your words to the dictionary.

There are two ways to go about this.

  1. During spell check, right-click the underlined text and click ‘Add to dictionary.’
  2. From ‘Tools,’ select Spelling, click on Personal dictionary, enter the word(s) you need to use and click ‘Add.’

Check notification settings to avoid a crowded inbox

Do you work with multiple people on the same document? If you’ve got a bunch of editors, bloggers and clients all chiming in, this tip is for you. Instead of having a crowded email inbox of Google Doc notifications, update your preferences. To experience a clutter-free mailbox, follow these steps;

  • Click the comment bubble that features next to the share icon on all Google drive apps
  • Select Notifications.
  • Choose from receiving no alerts at all, notifications for comments directed at you, or, all comments in the doc.

Keep things confidential

Working on sensitive material such as invoices, and confidential customer data meant for your eyes only? Google’s got your back with its adjustable privacy and sharing settings.

To adjust privacy and sharing parameters, click ‘Share’ from the top right-hand corner in any Google Drive app. Select ‘Share with others’ and then select ‘Advanced.' From here you can toggle who can copy edit, share, download, print or change access to the file you’re working on.

Start a new document in one click

Place bookmarks for the apps you use regularly and add them to your bookmarks bar for quick access. Use the following URLs to create bookmarks for Docs, Sheets, and Slides.

  • docs.google.com/ to launch a new document
  • Sheets.google.com/ to land on a new sheet
  • Slides.google.com/, the homeplace for launching a new slide.

This way, in one click, you can open documents, Slides, and Sheets without launching Google Drive.

Tips to make your work easier

Make your life easier while working in Google apps. Things like using templates and asking Google for help can even learn how to dictate text with your voice if you feel like it.

Use Help to find what you need

Forgot the name of a feature? Tired of scrolling through menus and settings to find what you need? It sounds like you need some Help. Google help offers the most thorough advice you could ask for, and it’s easy to navigate. To find what you are looking for, browse Google extensive Help feature, or use the handy, search function.

To begin quizzing Google Help, select Help from the toolbar at the top of your page.
In the drop-down box, type in the name of the feature you want. For example, type in ‘Spellcheck’ to find a link to use the Spell Check tool.

Save time with templates

Pre-made templates are available for all Google apps. These are great if you’re suffering from writer's block. Find ready-made versions of everything from resumes to budgets and invoices. There are even pre-made Slides to help deliver a flashy presentation.

  1. On your computer, head to Google Drive, select ‘New’ and click the arrow next to Google Docs, Slides, Sheets and click ‘From a template.’
  2. At the top right-hand corner, click Template Gallery
  3. Select the template you want to work with
  4. The template will launch in a new tab.

Use keyboard shortcuts

Keyboard shortcuts can seem awkward at first, but they become second nature and are a huge time saver. Plus, Google has plenty of them to make using the software even better. You can find all of the Keyboard Shortcuts from the Help menu dropdown. Here's a cheat sheet of our favorites.

Windows/ Chrome OSMac shortcuts
Basic commands
CutCtrl + XCommand + X
CopyCtrl + CCommand + C
PasteCtrl + VCommand + V
Paste Without FormattingCtrl + Shift + VCommand + Shift + V
UndoCtrl + ZCommand + Z
RedoCtrl + Shift + ZCommand + Shift + Z
Insert or edit linkCtrl + KCommand + K
PrintCtrl + PCommand + P
FindCtrl + FCommand + F
Text formatting
BoldCtrl + BCommand + B
ItalicizeCtrl + ICommand + I
UnderlineCtrl + UCommand + U
StrikethroughAlt + Shift + 5Option + Shift + 5
Copy text formattingCtrl + Alt + CCommand + Option + C
Paste text formattingCtrl + Alt + VCommand + Option + V
Clear text formattingCtrl + backslashCommand + backslash
Increase font sizeCtrl + Shift + >Command + Shift + >
Decrease font sizeCtrl + Shift + <Command + Shift + <
Tools
Open research toolCtrl + Alt + Shift +ICommand + Option + Shift + I
Define selected word in research toolCtrl + Shift + YCommand + Shift + Y
Word countCtrl + Shift + CCommand + Shift + C
Start voice typing (Chrome browsers only)Ctrl + Shift + SCommand + Shift + S
Move to next misspellingCtrl + 'Command + ' [apostrophe]
Move to previous misspellingCtrl + ;Command + ;

Configure for Microsoft Office

If you’re just more comfortable with working Microsoft Office, install the Office Editing for Docs, Sheets & Slides extension. With this add-on, you can preview, edit and share documents you create with Microsoft Word, PowerPoint and Excel without needing Office installed on your computer. You can leave the files in MS Office format and then do light editing with a helpful extension. This practice can be useful for people who do not own MS Office or cannot run MS Office (like on a Chromebook).

After installing the extension, you can open any Microsoft Office file in the Google app. When you double-click on a file to open it, you will no longer get a preview, but instead, it will open in a light web-based version of your Office doc. When you save the file, it will simply save and update the Office file in your Drive.

While this extension to be a handy tool for minor edits, it is not a full-featured Microsoft Word editor (and the same goes for Excel and PowerPoint). You can make minor formatting changes to the text and edit the content, that’s about it. For anything else, you’re best off converting your Office file to a Google Doc. This way, you have full editing capabilities, and, save on storage.

The main advantage of converting to a Google file is that they take up no storage on your hard drive. Google Docs, Sheets and Slides are stored as a web page using in the cloud -unless you choose to download them as another file type. Google grants us all unlimited storage of Google Docs on Google Drive, but only a limited amount of space for other file formats. Because of this, it makes sense to convert other formats to Google Docs if possible. You can import and export all types of files to Google Drive including .csv, HTML and .PDF to name a few.

To convert an Office file to a Google version, do the following:

  • Double-click the Office file to open it in the light editor.
  • Next, click the "File" menu in the top left.
  • Finally, click "Save as Google Docs" (or Sheets or Slides).
  • Congrats, you have made a Google version of your file!

When you’re finished editing online, you can download your Google doc as an Office document so that it has a standard Microsoft Office extension. However, you need to export your Google Docs files to Microsoft Office. Bear in mind that these documents take up more room on your Google Drive.

even Locate the Office file in your Google Drive.

  • Right-click on the file and choose "Open with" and then choose the corresponding Google tool for that file type (Docs, Slides, or Sheets)

Dig deeper into a subject with “Explore”

One of the big perks of using Google’s suite is that you can perform Google searches without leaving the file you’re working on. If you need more information on any term, topic or idea, highlight the text and click Explore from Tools in the menu bar. A sidebar will launch with Google results for your query. This action also works on links. If you want to link to Namecheap, you can just select, type "create link" and type "Namecheap" and the search will auto-populate! It is the same convenience technology that Google uses when it predicts what you might be looking for when you start typing a search query.

Copy formatting from one area to another

The best Google apps tips are the ones that save you serious time. That's why the Format Painter is one to remember. Take words or cells that are already formatted and paint those same styles into other words or cells. The trick lies within that paint roller icon in the upper-left corner of the Docs toolbar (directly to the right of the print icon).

  1. Highlight the cells you want to copy the format from
  2. Click the painter roller icon. This turns your cursor into a paintbrush
  3. Drag the paintbrush over the text you want to apply the formatting to. The font, color, and size will change immediately.

If you want to apply the formatting to more than one area of text, double-click the paint roller at the start of the process. That’ll force it to remain active through numerous applications.

Turn spoken words into text

Broken your wrist snowboarding? Struggle with touch typing? If you‘re not in a position to type or simply prefer to dictate your draft, try voice typing. To activate, select Voice Typing from the Tools bar or use the shortcut ⌘+Shift+S. Don’t forget to give commands for punctuations such as “comma”, “period,” “new line,” and “new paragraph."

Add photos and images

No matter how compelling your written content, pictures can make the difference between a good and a great page. If you want to add images to your Google Docs document, there are several ways to do that:

  1. Click on the point in the document where you want the picture to go.
  2. From the toolbar at the top, select the Insert tab. If you’re working in Sheets, click the Image option. A pop-up window will open with various options, select one of the options at the top of the window. To add an image to Docs and Slides, choose one of the following options from the drop-down box. The options available to all apps include
    • Upload from computer to use an image stored on your computer
    • Search to search the web for images. A sidebar search option will open where you can search for images without leaving your document. Most images here are for “commercial use with modification,” meaning you can use and edit these images in your projects. To double-check whether an image is ok to use commercially, click on the magnifying glass to see it’s licensing terms.
    • Google Drive to use an image saved to your Google drive
    • Photos to add picture files straight from your Google drive Photos folder
    • By URL to use a link. Be sure to use the image address for this to work - to find the image address, right-click on an image, and select ‘Copy Image Address.’
    • Camera to take a snapshot with your computer’s webcam. (You will only see this option if you have a device with a camera)
  3. Follow the instructions that correspond with your choice. Click Insert, Open, or Select. The picture is now available in your Word document.

Crop and edit images within your document

Editing image offers the ability to add a professional touch to your content and presentations. There’s no need for any Photoshop wizardry or advanced skills. Do simple cropping, add a border or even mask an image into shape all without leaving the app.

Resize

To resize images, select the image and click and drag the blue squares until you have the desired size. To keep the image in the same proportion ratio, hold the SHIFT key while you click and drag.

Crop

Double-click the image you wish to crop or select the ‘Crop’ button from your toolbar. Notice the black cropping bars? Click and drag the sides and corners using the bars to crop your image. When you’re happy with the look, press Enter on your keyboard or click the crop button in the toolbar once more.

Add a border

Borders give a more professional look and are light work with Google Docs. First, select an image, next choose a color from the drop-down tool next to the pencil tool. Then, choose the size of the line. The next tool along lets you change the border to dashes or dots.

Image options for Google Docs and Slides

Right click on an image in Google Docs and Google Slides. Notice “image options”? Select that to open a sidebar menu where you can add color filters to your image. For finer control over your image, you can also toggle the brightness, contrast, and transparency, right inside Google Docs. Play around with this tool to transform your images, like the one below using filter ‘light 3’.

Collaboration and sharing

If you work with multiple people, in the same file, you need to get your head around collaboration tools. Similarly, If you wish to share your progress with others, such as clients -there are many ways to do that. The following pointers are essential for efficient project management and setting a tone for professional communication.

The share feature

Want to share your work with others? Easy. To get started, hit the bright blue SHARE button in the top right-hand corner or your Doc, Slide or Sheet. From here you can control who accesses your work. Invite anyone with a Google account to collaborate. Use the share feature to control whether each user can edit, comment on, or simply view your work.

Tag users to get their attention

With Google Docs, you can tag other users to get their attention while collaborating. This way, your comments won’t go missing.

To add a comment click the Insert tab, then Add Comments. In the comment bubble, add “+” followed by their email address to tag the user. They will receive an email notifying them that a comment needs their attention.

Review version history

It’s now possible to retrieve content from an older version of your Doc, Sheet or File using the Version History tool. To discover your version history, open a doc, sheet, or Slide, select ‘File,' ‘Version History,' then select ‘See Version History.' The panel on the right displays earlier versions. Click the timestamp of an earlier version, then ‘Restore this version.’

Identify who made an edit

Want to give kudos for a specific edit, need to critique a section, or add notes and feedback? First, you need to figure out who made the edits. To find out, click Version History. Now, you’ll see a page splashed with color. Each editor is assigned a highlight color for their changes. Similarly, if you want to track what everyone is up to, select an editors name to see their edits throughout the doc.

Email an attachment to a collaborator

It’s possible to send the document that you are working on as an e-mail attachment to one of the collaborators. From the File menu, look for Email collaborators. Note: all emails sent within Google apps come from the email address associated with your Google account.

Share a copy of your document to someone (without adding them as a collaborator)

There are times when you need to share your work with someone that’s not a collaborator. Sending a proposal for a client to review for example. To do so, follow these steps.

  1. From the toolbar click File, then Email as attachment. A pop-up window will open.
  2. The first option ‘attach as’ lets you choose how you would like to send the file. Options include PDF, .html, and a Microsoft Word document.
  3. Enter the person's email address you want to send to, a subject line so they know what to expect, and a message if you wish to.
  4. Click ‘Send’ to complete.

Turn your doc into a template

With this simple trick, you can turn your work into a template for someone else to use. Each user receives a version of their own to work on. To create a template, open the relevant document and follow these instructions.

  1. Copy the full URL in your browser’s address bar, change the “/edit” at the end to “/copy” ( without the quotation marks).
  2. Send that link to anyone with whom you’ve shared the file, and when they open it, they’ll be prompted to make a copy in their own Docs storage and then work on it from there.

Turn your doc into a template

This feature is pretty neat. With a click of the mouse, you can publish text content, spreadsheets, and slides to the internet. You don’t need a website or a CMS to feature your articles on the web. With this function, Google Docs becomes a WYSIWYG editor instantly. Use it to bring a well-formatted resume online. Fancy impressing your colleagues? Use your spreadsheet or table as a live dashboard immediately without any web development or coding skills.

If you want to see what you work looks like as a functioning web page that you can share or embed as you wish, simply click “Publish on the web” from the File menu. For professional looking results, check out this free tool ‘Gdoc.'

What if you want to share your Sheet with anyone that you give the URL to? You can easily do that in Google Sheets. Jump back to the same Share window, from here click the Get Shareable Link in the upper right corner. That's it! Anyone with the link can work in your document.


Google Docs hacks

Discover the Google Docs features that makes writing, editing and sharing easier. Let’s dive into the Google hacks that will save time and create efficiencies all around.

Fast track editing

We’ve all been there. You’re taken the time to draft an impressive blog, white paper, or whatever else you’ve poured your heart in to. Now you’re at the finish line, and it’s time to tidy thing up--but you’re running out of steam. The following tips call on Google to step in and lend you a hand.

Organize your document with an outline

As you write your material, create sections using the Style drop-down as you go. Once complete, go to Tool and select “Document Outline." Google will automatically generate a table of content. Look to the left of your doc. You’ve not got an outline based on the headers you’ve applied. This is essential when you are working through a large document. Now you can click through sections with ease.

Perform advanced edits via spoken command

Dictation can mean some real swift editing. Lucky for us, Google’s voice command system supports a huge range of functions. Ask for specific phrases, words, paragraphs. You name it.

With your voice alone, you can apply different formatting types to the text, cut, copy, past, and even scroll through the documents or jump to parts of a page, all without lifting a finger. To become a pro at editing the lazy way, check out Google’s guide to all possible voice commands.

Enrich your work

If you’re struggling for inspiration, and your work is feeling a bit flat, listen up. These tips are designed to enrich your creations in Docs. Take inspiration from Google or your own notes.

Call on Google to clarify definitions

For any content publishers reading, it’s worth hammering home again how convenient the explore feature is. All you have to do is highlight the text you’re pondering over, right click for more options and hit explore to rack Google’s brain (Google search). You’ll soon get to the bottom of anything and everything within Goggles extensive grasp. The Explore button can also be found on the bottom right-hand corner of your doc. It’s the icon of a star inside a small speech bubble.

This feature provides instant suggestions based on the content in your document, including related topics to learn about, images to insert, or more content to check out in Docs. You can also find a related document from Drive or search Google right within Explore.

View Keep notes while working in Google Docs

To access your Keep notes, head to the Google Doc Tools menu. You should see an entry for Keep Notepad. The first time you open this, you will be prompted to enable the feature. Click on “TRY IT” to log in, and the Keep notepad will open as a sidebar in your document. If you’re already using keep, you’ll notice all of your notes arranged in a linear fashion. Scroll through the notes to find what you need. Note that the addition of Google Keep only works in Docs, it won’t cross over to Sheets.

Collaboration in Google Docs

For a project that involves more than one pair of eyes, you need to learn to collaborate. With the following. Did you know that you can add up to fifty users per collaboration, and everyone can view and edit at the same time? While this might sound overwhelming, there’s a trick or two to organize people suggestions.

Go into suggestion mode

In Suggestions mode, anyone with permission to edit a document can suggest edits to the document owner (instead of simply making changes). The document owner has a chance to review the suggestions and accept or reject each edit, and keep track of who changed what. As you make changes to a document in Suggestions mode, everything you type becomes bracketed, and anything you delete gets a strike-through.

Suggestions mode is only available for Google Docs. To turn it on follow these instructions.
First you need to enable tracked edits. To do this, click the pencil icon on the right hand side of the toolbar and select ‘Suggestions’. Now, when you type, or make changes, they appear with colour coded highlighting visible to anyone viewing the document. what you’ve added are visible in the document.

Click Tools, then Review Suggested Edits. A ‘Suggesting’ box will appear in the top right-hand corner of your document. Now, when you add any new text or delete any existing text.

When it is time to review the document, click on a suggested edit to activate it’s bubble in the right column. To accept an edit, click the checkmark to accept, to reject a suggestion, click the ‘X’. If you’re unsure about a suggestion, it’s possible to leave a comment for the editor. Just reply within the edit bubble.

When there are many suggestions on a document, it can be difficult to follow the flow of the text. To preview what your text will look like with or without suggested edits, click ‘Viewing’ mode.

Google doc features to boost your productivity

Who doesn’t want to save time in the working day? Dismiss these productivity boosts tips at your peril.

Use templates to save time

Yes, we covered the benefits of using templates earlier. How about templates specific for Google Docs. These are handy for recurring projects such as customer invoices and meeting proposals to save you starting from scratch each time. Find templates for everything from project proposals, onboarding notes, job-offer letters you can modify to your needs. More templates for things like statements of work and sales of work are available as add-ons.

Use apps to take away the heavy lifting

Does making conference calls from within a doc, adding an e-signature to a contract, or sending a fax without a fax machine sound good to you? Of course, it does. For more of these exciting add-ons, check out the best productivity boosting Google Docs apps.

Google Sheets tips

Keyboard shortcuts

Shave precious time off editing by using shorts for Google Sheets. Refer to Google’s guide to shortcuts to navigate, format and use formulas in PC, Mac, and Chrome OS spreadSheets.

Grab data from other Google Sheets

The Importrange functions let you pull data from one spreadsheet to another. This function is one of the easiest in Sheets and can be extremely useful. To learn how to use Importrange in Google SpreadSheets, follow this guide.

Formulas made simple

Some shy away from one of the best Sheets features - Formulas. Gone are the days of boldly trying out a formula, only to be greeted with a # ERROR! message. Now, you just start typing a function and Sheets will display the ‘syntax’ usage, as well as tips on how to use it. With this handy feature, you can tackle the learning curve with ease.

  • To use this feature, click the cell you wish to apply the formulae to
  • Type an equals sign (=) into a cell, then the name of the formula you want to use.
  • Select the ‘parenthesis’ you want to use from the suggestions box. You’ll now see a popup box teaching you how to use it as well as a link to a more detailed Docs Editors guide like this one for the popular ‘Sum’ syntax.

Connect Sheets with other services

If you’ve ever wondered why you can’t have the tools that make up your digital life, all playing nicely together. Now, your Trello cards, or Dropbox files, all kinds of apps can connect to a spreadsheet to analyze and review. If you’re looking to centralize your apps and log everything in a spreadsheet, follow this tutorial to learn just how to do that using IFTTT (If This Then That) technology.

Protect entire Sheets or cells from edits

There are times a spreadsheet is available to multiple people, such as a weekly shift rota - When you don’t want them to be able to modify it, you might want to consider protecting specific cells or entire tabs. This way, you can control who makes changes to your Sheets worksheet.

  • Lock cells This is particularly useful if you plan to share your spreadsheet with a large audience. By locking key cells, you can ensure that they aren't accidentally modified.
    • Highlight a cell or range of cells that you want to protect.
    • Click the ‘Data Protected Sheets and ranges’ menu.
    • The ‘Range editing permissions' message pops up. Select the ‘restrict who can edit this range’ option.
    • Now, choose who is allowed to edit this range; Only you, or Custom. With custom, you can specify which collaborators can edit the selected range.
    • Click ‘Done’ to apply your restrictions.
  • Sheets If your sheet contains calculations for general observation, such as a timesheet, and under no situation, is it to be amended, simply lock the entire sheet from public editing. To protect your entire worksheet, head back to Data and select the Protected Sheets and ranges menu. This time, you don't have to choose any cells before you start. Just click on ‘Sheet,' and then choose the spreadsheet to protect from the dropdown menu.
  • Show a warning on particular cells Use this feature when you don’t want to totally restrict a cell from editing. A warning appears each time someone edits the cell. To add a warning, follow the steps above, except, at the Range editing permissions window, select the ‘Show a warning’ option before you press Done. Now, every time a user tries to edit the cells, they will see a warning message, warning that the cell or cells aren’t intended to change. Although, this option still allows them to do so.

Clean up your text

When your Spreadsheets are looking a bit messy, the last thing you want to do is retype each cell individually.

If your text needs a cleanup, use the add-on tool, Change Case. Highlight the text you want to format, select Change Case from the Add-ons menu, and choose from Uppercase, Lowercase, First letter capitals and so on.

Find specific data with filters

Filtering is a real lifesaver when you're an enormous spreadsheet with reams of datasets to sift through to find what you’re looking for. To start filtering data in a table, hit the filter button to add filters to your table like the example below.

Select the button on the column you want to apply it to, and refine what’s shown by selecting the values you want to display.

Explore in Sheets

Google Explore is a fantastic way to decipher data, this time using words, not formulas to get an answer. You can get answers to questions like, "How many units did I sell on Black Friday?" or "Where do I sell the most products?"

Use AI to create your charts and reports

Google is flexing their muscles with this feature. Instead of creating reports and charts from scratch, simply type the instructions in plain English, and let Google do the heavy lifting. To use AI to generate charts and reports in your own Spreadsheets, click Explore (located in the lower right corner of the sheet. Browse the suggested data points including pivot tables, bar charts and graphs.

Alternatively, type out the chart you have in ‘Ask a question about your data’ box. Watch in awe as an answer is generated for you - based on the information in your Google Sheet.

Convert excel files to Sheets

If you’re wondering how to convert your files from Microsoft Excel into a Sheets friendly format, this tip is for you. You can even convert .XLSX files to Sheets and start working on them right away. Messing with file formats might sound daunting - it’s not. The process is beginner-level and only requires some dragging and dropping. To get started, follow the instructions >here.

Use pivots to analyze data easily

We’ve all been there, staring at a huge data set and struggling to pull together a report. This is a tip for the power user of Microsoft Excel. If pivots won’t convince you to make the switch to Sheets, nothing else will. Pivot tables take huge tables of data and help you find meaning in them.

Pivots are a drag and drop tool to build reports with finesse. To get started with pivots, take some time to this guide. Walk through the steps and you’ll find meaning in even the largest datasets.

Use Sheets as a CRM

Google Sheets can be effectively transformed into a Customer Relationship Management (CRM) system, offering an affordable and straightforward alternative to traditional CRM software. By utilizing a free template provided by Softr, businesses can easily set up and customize their own CRM within Google Sheets, streamlining the management and analysis of customer interactions and data.

This approach not only simplifies the CRM process but also leverages the familiar interface of Google Sheets, making it user-friendly and adaptable to specific business needs. Whether using the provided template or integrating with an interface for enhanced functionality, Google Sheets offers a unique and efficient solution for managing customer relationships and driving business growth.

You’re just about done with your Spreadsheet, hit the Print button, and the printer chucks out a table printed over 3 sheets, or with the end cut off. We’ve all been there. Spreadsheets are notoriously hard to print; You’re asking to print limitless columns and rows on a page that’s limited in size. To make sure your spreadsheets print correctly, every time, follow this guide.

Google Slides tips

Save time with Master Slides

There are times when we need to update or modify something in all Slides. One function most people don’t notice is the “Edit Master” option. With the Master template editor, you can edit all the Slides in your deck, simultaneously, without visiting them individually. This feature is great for when you want to do things like changing the background or add branding to your Slides, and much more.

When you edit a master slide to change your slides corresponding layouts, the editing appears in slide master view. To learn how to customize your entire Slideshow in a few clicks, refer to this straightforward guide.

Present with Chromecast

Picture this. You're presenting to an important client. They've shown interest in your product, but everything lies in your presentation to seal the deal. You've built the perfect Google Slides presentation that informs and convince them. Oh wait, you forgot your laptop. So, you’ve got no equipment to play the presentation though. Or have you?

With Google Slides, all you need is the Chromecast app and simple mobile device you can use your smartphone as a remote control. Now you can deliver your Google Slides presentation on a projector, a TV, or a monitor.

To use your phone as a backup plan. Install the Google Cast extension in Chrome. Then just connect to the same Wifi network as your Chromecast device, click the small drop-down arrow on the Present button in your presentation, and select your Chromecast device from the options. That’s it. Your presentation will now how on your Chromecast ready device.

Add sounds to Slides

Tired of being the only voice in the room? Add some snap, crackle, and pop to your presentation. Add music from any streaming device from Apple Music, Spotify, and more and it will automatically play the sound in the background. Learn how to do that in this video.

Explore in Slides

Using the explore feature in Slides makes light work of designing a presentation. As you create your Slides, Explore suggestions a range of designs based on the content of your Slides. If you like the look of a design and want to apply it, simply click on the suggestion. There’s no need to reformat any of your work. It couldn’t be more simple.

Edit videos

Thanks to the Video Options feature, there’s no need to leave your document to edit a video. You might want a video to start at a certain point for example, rather than playing in its entirety. Here’s how to go about that.

  1. Start by clicking ‘Insert’ in the Toolbar, then ‘Add video.' This opens the ‘Insert Video’ pop-up window.
  2. Notice three tabs ‘Search,' ‘By URL,' and ‘Google Drive.' These are the places you can pull a video from. If you don’t have a video in mind, you can ‘Search’ Google videos. If something from Youtube caught your eye, simply paste a YouTube URL into the By URL option. Alternatively, upload a video from your Google Drive. Click Select to add the video to your slide.
  1. To edit your Video, right-click on the video and select ‘Format Options.' This will launch a new panel to the right of your screen. From here you can make some simple edits. Click the ‘Video playback’ tab to trim, autoplay and mute your video. Select ‘Size and position’ to toggle the how it appears on your slide. Finally, add a ‘Drop Shadow’ for dramatic effect
  1. Notice a small version of your video in the ‘Video playback’ tab. Directly underneath, you can set when the video starts and when it stops. There’s also the option to ‘Autoplay when presenting’ which means the video will automatically play when you open the slide, or to ‘Mute Audio’ entirely.
  1. There’s no need to save when you’re done. Simply close the panel and the changes you’ve made will be live when you present.

While this tool hasn’t got as many options as an independent video editing app, it’s certainly enough to save you time drafting an interactive presentation.

Make a stand out Q and A session

Question and answers sessions can be pretty mundane. With Slides Q&A, you can raise the bar. In slides, you can make an interactive session that's fun and time-saving. Participants can go to the URL of your presentation and add their questions, anonymously if they like. Simply share a link with your audience to automate the whole process.

Once they’ve had some time to add their questions, go to Presenter view to check out the questions. Your audience members can vote up or down questions as well. Learn how to implement an interactive presentation in this tutorial.

Using slide templates

Again, we’ve mentioned how great templates are. If you’re interested in drafting a visually stunning presentation in less time, let’s take a look at your options with Google Slides. If you’re not impressed with the default templates, upload one. Sites like SketchBubble and SlideModel offer a variety of options for Google Slides templates to help you up your game.

Mask (Google Slides only)

Once you’ve added an image to your presentation, there’s a trick called masking to make it stand out. This feature can be used to put your image into the shape of your choice. Masking an image is simple. Select an image, click on the arrow icon as in the example below.

Browse a variety of Shapes, Arrows, Callouts, or Equation symbols. Select the design you would like to mask your image with. The example below is an oval shape.

If you are working on a large presentation, it can be helpful to link to Slides in the presentation. This way you can from one slide to another, easily. To add a link to your Slides follow these instructions.

Share individual Slides

To share a specific slide in a Google Presentation, open your presentation and go to the slide you want to share. Copy the URL from your browser's address bar. Each slide in a Slideshow has its own unique, permanent URL that loads when you change Slides. Share the link via IM, Email or however you like.


Useful Google Docs Add-ons

Add-ons are companion apps for G Suite that allow you to perform a variety of tasks. There are a lot of useful add-ons available for Google Docs, all accessible from the toolbar. Depending on your needs, you might find it worthwhile to browse through Google Docs add-ons library. When you use these hacks to extend your abilities, you can get more done in less time.

  • Extensis Fonts - Bored of the same old fonts? Up your font game with this add-on. Access and use thousands of fonts from the Google Fonts collection in your documents.
  • Consistency Checker - Struggle to keep text consistent? To make the best impressions you have to make sure your document is free from consistency mistakes. Issues with hyphenation (e.g. ‘parttime’ and part-time) and spelling (e.g. ‘centre’ and ‘center’), capitalization (‘WIFI,' and ‘WiFi’). can become more apparent when working with multiple authors. The online consistency checker looks for errors to deliver a document that makes the best impression with your text.
  • PandaDoc- Get proposals out of the door faster. Create, send, track and eSign documents with PandaDoc. Look like a multimillion-dollar business without spending a fortune thanks to a plethora of business and marketing templates. Use PandaDoc to create impressive, interactive sales documents with embedded media and custom designs. This software even notifies sales when deals are signed on the dotted line.
  • HelloFax - Tired of your clunky fax machine? Ditch it thanks to HelloFax. With this add-on, you can send faxes from your own computer. HelloFax is an incredible tool that lets you send and receive faxes online. Use your current fax number, or get a new one. To send a fax, open a Google doc, select the ‘Hellofax’ add-on, enter the fax number of the recipient, and hit send. Add an optional cover letter if you wish.
  • Uberconference - Use this add-on to make conference calls within a Google application. Let's say you're collaborating on a Google doc. The UberConference add-on lets you book a conference call with your collaborators right from the sidebar.

Conclusion

Though some of these short-cuts may seem like minor details, combined, they will make a major difference in productivity! Keep in mind, the more you use Google’s Apps—and encourage your staff, colleagues, and clients to do so, the more efficiencies you create that aren't possible with Microsoft Office.


Biography

Picture of Ruth G.

Ruth G.

More content by Ruth G.


Small Business Management

For running things smoothly

From site security to email service providers, here’s what you need to manage your online business.

See more
Join Our Newsletter

Stay inspired

Get all the latest offers, articles, and industry news straight to your mailbox every month.

Need help? We're always here for you.

notmyip