Notification

Bring your best ideas to life with Gemini for Google Workspace. Get tips & real-life use cases for using gen AI at work.

Week 4: Run efficient projects

Stay on top of projects, manage your time, and make the most of Google Sheets and Slides

Expand all  |  Collapse all

Manage to-do lists

Checkbox.Manage your to-do lists with Tasks

Manage your tasks and project lists with Google Tasks. Tasks is a simple way to create personal lists of daily tasks with due dates. It integrates seamlessly with Gmail and Calendar, and syncs on all your devices.

Open Tasks

You can add tasks to the side panel in some Google Workspace apps.
  1. Go to Gmail, Calendar, Chat, Drive, or a file in Google Docs, Sheets, or Slides.
    • Important: If you can't see Tasks app, click the arrow in the bottom right of the screen to expand the panel.
  2. On the right, click Tasks Tasks.
Checkbox.Drag an email to your Task list

You can drag an email to Tasks, and it appears as a task in a list. You can then edit the task, add details, and schedule recurring or one-time reminders.

  1. Go to Gmail.
  2. On the right, click Tasks Tasks.
  3. Find the email you want to save as a task.
  4. Drag and drop the email to the side panel.
  5. To add a date and time, click Date/time​.
Checkbox.Create and assign tasks in a space

As a member of a space in Google Chat, you can create and manage group tasks and assign tasks to other space members. You can view tasks in the space where they're created. If a task is assigned to you, it appears in your personal task list in Google Tasks. When someone creates or updates a task, a notification appears in the space.

Tip: If you use a work or school account and don't have the “Tasks” tab in a space, contact your Google Workspace administrator to turn on this feature

  1. On your computer, open Google Chat or Gmail.
    • In Gmail: On the left, click Chat.
  2. Select the space where you want to create a task.
  3. On the top, click the Tasks tab and then Add space task.
    Tip: In Gmail, you might have to expand the space to view the Tasks tab.
  4. Enter the task title.
  5. Optional: To add a description or more details, click Add details and enter the information.
  6. Optional: To add a date and time, click Add date/time and then Make selections and then click OK.
    Tip: If you add a date and time to your task, you get notifications at the scheduled dates and times.
  7. Optional: To assign the task to a member of the space, click Assign and then click the name of the person. To assign the task to someone who isn't a member of the space, invite them to the space first.
    Tip: If the assignee leaves the space, the task remains in the space and in their personal task list in Google Tasks.
  8. Click Add.

After you create a task, a notification displays in the space to let everyone know.

Learn more at the Google Tasks Help Center

Checkbox.Set recurring reminders in Tasks

You can set deadlines for Tasks and add recurring reminders. Adding a due date also adds the task to Calendar.

  1. Go to Gmail, Calendar, Chat, Drive, or a file in Google Docs, Sheets, or Slides.
  2. On the right, click Tasks Tasks logo.
  3. Click an existing task or create a new task.
  4. To add a date and time, click Date/time.
  5. Next to “Date/time,” click Repeat .
  6. Under “Repeats every,” select day, week, month, or year.
  7. Under “Ends,” select an option to create a recurring task:
    • With no end date, select Never.
    • With a specific end date, select On, then choose a date.
    • That ends after a certain number of occurrences, select After, then select a number of occurrences.
  8. Click OK.

 

Want more Tasks basics? Get started with Tasks in Google Workspace

Become a spreadsheet expert

Checkbox.Add checkboxes to your spreadsheets
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select the cells you want to have checkboxes.
  3. In the menu at the top, click Insert and then Checkbox.
  4. To remove checkboxes, select the checkboxes you want to remove and press Delete.

Learn more at the Google Docs Editors Help Center

Checkbox.Create graphs and charts from your data
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select the cells you want to include in your chart.
  3. Click Insert and then Chart.

Learn more at the Google Docs Editors Help Center

Checkbox.Create custom tab colors

Change the color of tabs on a spreadsheet to quickly tell them apart.

  1. On a sheet tab, click the Down arrow .
  2. Click Change color and select a color.
  3. (Optional) To choose a custom color, click Custom and select a color using the sliders or by entering a color number.
Checkbox.Remove duplicate data

You can easily remove duplicate values from your sheet, without having to write an app script or manually removing the data.

  1. In Sheets, open a spreadsheet.
  2. Select the data range that you want to remove duplicate data in.
  3. Click Dataand thenRemove duplicates.
  4. Select which columns to include and whether the data has headers.
  5. Click Remove duplicates.
  6. In the status window, click OK.
Checkbox.Automate tasks with macros
 

Save time by automating repetitive tasks with macros in Google Sheets. Say you need to format new data imports or build the same chart across multiple sheets of quarterly data. Repeating the same steps manually can take hours. Use a Sheets macro to record these actions and easily use them again without having to write code.

Find the "Record macro" option  in a sheet by clicking "Macros" under "Extensions".

  1. On your computer, open a spreadsheet at sheets.google.com.
  2. At the top, click Extensions and then Macros and then Record macro.
  3. At the bottom, choose which type of cell reference you want your macro to use:
  • Use absolute references: The macro will do tasks on the exact cell you record. For example, if you bold cell A1, the macro will only ever bold cell A1 regardless of which cell you clicked.
  • Use relative references: The macro will do tasks on the cell you select and its nearby cells. For example, if you record bolding cells A1 and B1, the macro can later be used to bold cells C1 and D1.
  1. Complete the task you want to record. When you’re done, click Save.
  2. Name the macro, create a custom shortcut, and click Save.
  • Note: When you create a macro in Google Sheets, an Apps Script is created. To edit this Apps Script, at the top, click Tools and then Script editor.

To perform a macro, click Extensions and then Macros and then the macro you want.

Learn more at the Google Docs Editors Help Center

Checkbox.Limit what people can see or edit with protected ranges and sheets

Prevent others from making changes to sheets and ranges

  1. Open a spreadsheet in Google Sheets.
  2. Click Data and then Protect sheets and ranges. A box will open on the right.
  3. Click Add a sheet or range or click an existing protection to edit it.
  4. To protect a range, click Range. To protect a sheet, click Sheet.
    • Range: To change or enter the range you’re protecting, click the spreadsheet icon and highlight the range in the spreadsheet.
    • Sheet: Choose a sheet to protect. If you want a set of cells to be unprotected in a sheet, check the box next to "Except certain cells."
  5. Click Set permissions or Change permissions.
  6. Choose how you want to limit editing:
  • To show a warning when anyone makes an edit: Select "Show a warning when editing this range." It doesn’t block people from editing, but they’ll see a message asking them to confirm if they really want to make an edit.
  • To choose who can edit the range or sheet: select "Restrict who can edit this range." Choose:
    • Only you: Only you (and the owner if you’re not the owner) can edit the range or sheet.
    • Only domain: If you use Google Sheets for work or school, only people in your domain can edit the range or sheet. This option is only available when everyone in your domain can edit the spreadsheet.
    • Custom: Only the people you choose can edit the range or sheet.
    • Copy permissions from another range: Reuse the same permissions you set up on a different set of cells or sheet.
  1. Click Save or Done.

To see protected cells, click View and then Show and then Protected ranges. A striped background will appear over the cells.

Hide a sheet

  1. Open a spreadsheet in Google Sheets.
  2. Click the sheet you want to hide.
  3. On the sheet tab, click the Down arrow Down arrow.
  4. Click Hide sheet. This option won’t show if your spreadsheet doesn’t contain two or more sheets.

Note: People with Edit access can unhide a sheet. People with View access won't see the sheet, but they can make a copy of the spreadsheet and can unhide the sheet.

Learn more at the Google Docs Editors Help Center

Checkbox.Sort and filter your data

Filter your data without changing what others see

On a computer, you can filter data so the filtered data only applies to your view of the spreadsheet. Your filter view changes are automatically saved.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click Data and then Filter views and then Create new filter view.
  3. Sort and filter the data.
  4. To close your filter view, at the top right, click Close Close.
  5. Your filter view is saved automatically.

You can also filter data in ways other people can see.

Learn more at the Google Docs Editors Help Center

Learn more:  Google Sheets productivity guides

Give impactful, interactive presentations

Checkbox.Create a presentation with Docs editors templates
Whether you're creating a template that your team can reuse or keeping your external branding consistent, use templates to help your presentations look sharp and professional.
  1. On your computer, go to Google Docs, Sheets, SlidesForms, or Sites.
  2. At the top right , click Template Gallery.
  3. Click the template you want to use.
  4. A copy of the template opens.

Tip: If the template you choose has "Add-on" next to it, you may have to install an add-on to use it. Learn more about add-ons.

Learn more at the Google Docs Editors Help Center

Checkbox.Copy text formats or themes

Copy text formatting

You can quickly copy the formatting of text you like to other areas.

  1. In a Sheet, Doc or Slide, format your text or cell the way you want it. 
  2. Highlight the text or cell and click the paint roller icon in the top left corner. 
  3. Click a cell or highlight text. The cell or highlighted text will pick up the same formatting. 

Copy a theme to a new presentation

You can also copy a Slides theme you like to an existing or new presentation.

Important: Your imported theme must be from an existing Google Slides or PowerPoint presentation. You can also use your own image as the background for the entire presentation

  1. On your computer, open a presentation in Google Slides. 
  2. At the top, click Slide Change theme.
  3. In the bottom right, click Import theme.
  4. Double-click the presentation you want to use. 
  5. Click the theme you want. 
  6. Click Import theme.

Learn more at the Google Docs Editors Help Center

Checkbox.Add a data chart from Sheets

If your Slides presentation has a lot of data, help your audience easily visualize it by turning your information into charts. Just create a chart in Sheets and add it to your presentation. Your chart is linked to your Sheets data, so any changes you make to your data automatically update in your presentation.

Insert a chart

  1. On your computer, open a document or presentation in Google Docs or Google Slides.
  2. Click Insert and then Chart and then From Sheets.
  3. Click the spreadsheet with the chart you want to add, then click Select.
  4. Click the chart you want to add.
    • If you don't want the chart linked to the spreadsheet, uncheck "Link to spreadsheet."
  5. Click Import.

 Edit the chart directly from your presentation

  1. On your computer, open a document or presentation in Google Docs or Google Slides.
  2. Click Insert and then Chart and then From Sheets.
  3. Click the spreadsheet with the chart you want to add, then click Select.
  4. Click the chart you want to add.
    • If you don't want the chart linked to the spreadsheet, uncheck "Link to spreadsheet."
  5. Click Import.

Update the chart to match the original in Sheets

If you make a change on the fly, you might want to make sure any data is updated.

  1. On your computer, open a document or presentation in Google Docs or Google Slides.
  2. In the top right corner of the chart, table, or slide click Update.
Learn more at the Google Docs Editors Help Center
Checkbox.Create flow charts with drawings

Create a flowchart, diagram, or other type of drawing

  1. On your computer, open a document.
  2. In the top left, click Insert and then Drawing and then New.
  3. Insert shapes, lines or text with the editing tools.

Add your drawing to a document or presentation

  1. On your computer, open a document.
  2. In the top left, click Insert and then Drawing and then From Drive.
  3. Click the drawing you want to insert. 
  4. Click Select.

Insert other types of diagrams

Important: You can insert a diagram in any language that uses the Latin alphabet.

  1. On your computer, open a presentation in Google Slides.
  2. Go to the slide where you want to add the diagram.
  3. At the top, click Insert and then Diagram.
  4. Choose your style, number of levels, and template.
  5. The diagram will get added to the slide. You can change it how you want.
Checkbox.Add speaker notes

You can add speaker notes to presentations that only you will see when you present. People you share the presentation with will be able to see the notes. When you present your slides, your speaker notes show in a separate window.

  1. Open a presentation in Google Slides.
  2. In the top right corner, next to Slideshow , click the Down arrow .
  3. Click Presenter view.
  4. Click Speaker notes.

You can then add your text below the slide.

Learn more at the Google Docs Editors Help Center

Checkbox.Hold a live Q&A

You can start a live Q&A session in your Google Slides presentation and present questions at any time. Viewers can ask questions from any device.

Start your Q&A and get questions from viewers

  1. Open a Google Slides presentation.
  2. At the top, next to Slideshow , click the Down arrow .
  3. Click Presenter View.
  4. In the new window, click Audience tools.
    • To start a new session, click Start new.
    • To resume a recent session, click Continue recent.
    • To end Q&A, click the on/off switch in the Q&A window.
      • Tip: Even if you don't turn off Q&A, the Q&A view closes shortly after you end your Google Slide presentation.

When you start the session, a short URL for the presentation shows up at the top of the slides as you're presenting. Viewers can enter the URL in their browser to submit a question. You'll see questions in the Presenter view window.

Display a question to viewers

Presenters can display audience questions in a presentation:

  1. Under "Audience Tools," find a question to display.
  2. Click Present.
    • To change the question, find a different question and click Present.
    • To hide the question, click Hide.

Learn more at the Google Docs Editors Help Center

 

Learn more:  Tips for great presentations

Next steps


               

Want advanced Google Workspace features for your business?

Try Google Workspace today!

 

 


Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.

Was this helpful?

How can we improve it?
true
Get help from Small Business Advisors

Want to receive one-on-one guidance and tailored recommendations on how to make the most out of Workspace? Try booking an appointment with Small Business Advisors.


Important: This service cannot troubleshoot issues, including Workspace troubleshooting, billing, advanced account management and legal/compliance issues.

Search
Clear search
Close search
Google apps
Main menu
8615087525026717073
true
Search Help Center
true
true
true
false
false