Author Archives: Ryan Weber

Think macro: record actions in Google Sheets to skip repetitive work

Since their debut nearly 40 years ago, spreadsheets have remained core to how businesses get work done. From analyzing quarterly revenue to updating product inventory, spreadsheets are critical to helping companies gather and share data to inform quicker decisions—but what else can you do if they’re in the cloud?

We’ve been focused on making Google Sheets better for businesses for this reason, which is why we’ve recently added new features to help teams analyze and visualize their data. Today we’re adding more updates to Sheets, including a way to record macros in the cloud to automate repetitive tasks, as well as more formatting options. Check it out.

Record macros in Sheets, skip mundane tasks

We want to help companies automate work by approaching macros differently: cloud-first. Starting today, you can record macros in Sheets. Let’s 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, but the Sheets macro recorder lets you record those actions and play them back on command without having to write any code.

Here’s how it works: when you record a macro, Sheets converts the macro actions into an Apps Script automatically. If you want to update your macro, you can simply edit the script directly instead of having to re-record the macro from scratch. You can also write your own Apps Script functions and import them as new macros.

The best part about Sheets Macros is that they’re built for use in cloud-based files, which means that teams can run macros at the same time that others are working in the sheet without interrupting them. For example, a finance team having a budget meeting can run macros while reviewing the same spreadsheet. It also means that coworkers or clients won’t be forced to download sensitive files to use your macros. Since your Sheets files are in the cloud, you can keep tighter controls over who can view and re-share your data.

More updates to Sheets

You may have noticed that over the past few years we’ve put effort toward building Sheets features to help businesses view, analyze and share their data more easily. This includes adding new chart types (waterfall and 3D), ways to embed charts while keeping data up-to-date in Docs and Slides (even if you move files), more functions (up to 400+ now), additional formatting, print options and more.

Today, we’re adding even routinely requested features, including the ability to add printing page breaks, custom paper sizes, more options for row and column grouping and a way to add checkboxes in cells. We’ve also made it possible for you to group your data by time frame (like week, month or year) when you create pivot tables.

Speaking of pivot tables, our engineering team has also been hard at work bringing the power of Google’s artificial intelligence into Sheets to help teams know what their data knows. You might have noticed that we recently added intelligent pivot tables in Sheets to help analyze and find new insights, no matter how skilled you are at data analytics.

Pivot tables

Companies like Whirlpool Corporation and Sanmina are using Sheets for more collaborative data analysis. These latest additions are designed to make Sheets a go-to resource for businesses and will roll out over the next few weeks. Learn more about Sheets on our Learning Center.

Five new ways to reach your goals faster with G Suite

One of the core promises of Google Docs is to help you and your team go from collecting ideas to achieving your goals as quickly and easily as possible. That’s why last month we launched Explore in Docs, Sheets and Slides — with machine intelligence built right in — to help your team create amazing presentations, spreadsheets and documents in a fraction of the time it used to take.

Today, we’re introducing five new time-saving features designed to speed up and simplify the way you work, so you can focus on bringing your team’s ideas to life.

1. Spend less time figuring out who owns what with Action Items

According to research by the McKinsey Global Institute, employees spend about 20 percent of their work week — nearly an entire day — searching for details internally and tracking down colleagues for answers.  This can be especially true when a document is full of ideas, requests and comments, making it difficult to get a clear sense of who’s responsible for what.

To help keep your projects moving, when you type phrases like “Ryan to follow up on the keynote script,” or “Andrea to schedule a weekly check in” on desktop, Docs will intelligently suggest an Action Item to assign to the right person, thanks to Natural Language Processing (NLP).
G Suite Bundle: Image 5

You can also manually assign an Action Item to someone in the Docs, Sheets and Slides desktop and mobile apps by mentioning their name in a comment and checking the new Action Item box. The assignee will get an email notification and see the Action Item(s) clearly highlighted with a blue bar when they open the file.

G Suite Bundle Image 1

2. Spend less time searching for the files that need attention

Once Action Items have been assigned, it’s easy for team members to identify documents, spreadsheets and presentations that need their attention. The next time they visit Docs, Sheets, Slides (or Drive) from their laptops or mobile apps, they’ll see a badge on any files with Action Items assigned to them, plus any unresolved suggestions that others have made to their files.

G Suite Bundle: Image 2

3. Spend less time building questions with smarter Forms

Since its launch in 2008, more than a billion questions have been asked in Forms, allowing us to identify common patterns, like question types and the response options that usually go with them. With the help of neural networks, we can now predict the type of question you’re asking and suggest potential responses for you to choose from, giving you back about 25 percent of the time you used to spend creating a Form.

Let’s say you’re planning an all-day event at the office and need to know which day works best for your team. When you type “What days are you available next week?” Forms will intelligently determine that “Checkbox” is the ideal question type, and generate related response options that you can add one by one or all together.
G Suite Bundle: Image 3

Also debuting today is a top-requested feature from our business and education customers — the new “File upload” question type. Your respondents can now upload files from their computer or Drive — all of which are neatly collected for you in a new Drive folder.  Note: This feature is only available for G Suite customers in Forms shared within their organization.

G Suite Bundle: Image 4

4. Spend less time typing with a set of new voice commands

Last year, we launched Voice typing in Docs on the web to help you capture ideas, big and small, without lifting a finger. Today, we’re adding more ways to format and customize content with commands for changing text color, deleting words, inserting links and comments, plus a number of other ways to format, hands-free.

5. Spend less time switching between apps to get things done

We want you to be as productive and collaborative as possible, regardless of the tools you choose to work with, so we’ve partnered with Slack to make it even easier to work with Google Docs files.

With a click of the "+" button in Slack, you can bring files from Drive directly into a conversation with your team, or create new Docs, Sheets and Slides files right from Slack. You can check out more details on Slack’s blog.

G Suite Bundled: Image 7

With the  introduction of Explore, and more and more updates to products that build in machine intelligence, taking back time spent on mundane, repetitive tasks will only get easier with G Suite. Now, you can focus your energy on creative and strategic work, not busy work.

Source: Drive


Five new ways to reach your goals faster with G Suite

One of the core promises of Google Docs is to help you and your team go from collecting ideas to achieving your goals as quickly and easily as possible. That’s why last month we launched Explore in Docs, Sheets and Slides — with machine intelligence built right in — to help your team create amazing presentations, spreadsheets and documents in a fraction of the time it used to take.

Today, we’re introducing five new time-saving features designed to speed up and simplify the way you work, so you can focus on bringing your team’s ideas to life.

1. Spend less time figuring out who owns what with Action Items

According to research by the McKinsey Global Institute, employees spend about 20 percent of their work week — nearly an entire day — searching for details internally and tracking down colleagues for answers.  This can be especially true when a document is full of ideas, requests and comments, making it difficult to get a clear sense of who’s responsible for what.

To help keep your projects moving, when you type phrases like “Ryan to follow up on the keynote script,” or “Andrea to schedule a weekly check in” on desktop, Docs will intelligently suggest an Action Item to assign to the right person, thanks to Natural Language Processing (NLP).
G Suite Bundle: Image 5

You can also manually assign an Action Item to someone in the Docs, Sheets and Slides desktop and mobile apps by mentioning their name in a comment and checking the new Action Item box. The assignee will get an email notification and see the Action Item(s) clearly highlighted with a blue bar when they open the file.

G Suite Bundle Image 1

2. Spend less time searching for the files that need attention

Once Action Items have been assigned, it’s easy for team members to identify documents, spreadsheets and presentations that need their attention. The next time they visit Docs, Sheets, Slides (or Drive) from their laptops or mobile apps, they’ll see a badge on any files with Action Items assigned to them, plus any unresolved suggestions that others have made to their files.

G Suite Bundle: Image 2

3. Spend less time building questions with smarter Forms

Since its launch in 2008, more than a billion questions have been asked in Forms, allowing us to identify common patterns, like question types and the response options that usually go with them. With the help of neural networks, we can now predict the type of question you’re asking and suggest potential responses for you to choose from, giving you back about 25 percent of the time you used to spend creating a Form.

Let’s say you’re planning an all-day event at the office and need to know which day works best for your team. When you type “What days are you available next week?” Forms will intelligently determine that “Checkbox” is the ideal question type, and generate related response options that you can add one by one or all together.
G Suite Bundle: Image 3

Also debuting today is a top-requested feature from our business and education customers — the new “File upload” question type. Your respondents can now upload files from their computer or Drive — all of which are neatly collected for you in a new Drive folder.  Note: This feature is only available for G Suite customers in Forms shared within their organization.

G Suite Bundle: Image 4

4. Spend less time typing with a set of new voice commands

Last year, we launched Voice typing in Docs on the web to help you capture ideas, big and small, without lifting a finger. Today, we’re adding more ways to format and customize content with commands for changing text color, deleting words, inserting links and comments, plus a number of other ways to format, hands-free.

5. Spend less time switching between apps to get things done

We want you to be as productive and collaborative as possible, regardless of the tools you choose to work with, so we’ve partnered with Slack to make it even easier to work with Google Docs files.

With a click of the "+" button in Slack, you can bring files from Drive directly into a conversation with your team, or create new Docs, Sheets and Slides files right from Slack. You can check out more details on Slack’s blog.

G Suite Bundled: Image 7

With the  introduction of Explore, and more and more updates to products that build in machine intelligence, taking back time spent on mundane, repetitive tasks will only get easier with G Suite. Now, you can focus your energy on creative and strategic work, not busy work.

Source: Drive


Five new ways to reach your goals faster with G Suite

One of the core promises of Google Docs is to help you and your team go from collecting ideas to achieving your goals as quickly and easily as possible. That’s why last month we launched Explore in Docs, Sheets and Slides — with machine intelligence built right in — to help your team create amazing presentations, spreadsheets and documents in a fraction of the time it used to take.

Today, we’re introducing five new time-saving features designed to speed up and simplify the way you work, so you can focus on bringing your team’s ideas to life.

1. Spend less time figuring out who owns what with Action Items

According to research by the McKinsey Global Institute, employees spend about 20 percent of their work week — nearly an entire day — searching for details internally and tracking down colleagues for answers.  This can be especially true when a document is full of ideas, requests and comments, making it difficult to get a clear sense of who’s responsible for what.

To help keep your projects moving, when you type phrases like “Ryan to follow up on the keynote script,” or “Andrea to schedule a weekly check in” on desktop, Docs will intelligently suggest an Action Item to assign to the right person, thanks to Natural Language Processing (NLP).
G Suite Bundle: Image 5

You can also manually assign an Action Item to someone in the Docs, Sheets and Slides desktop and mobile apps by mentioning their name in a comment and checking the new Action Item box. The assignee will get an email notification and see the Action Item(s) clearly highlighted with a blue bar when they open the file.

G Suite Bundle Image 1

2. Spend less time searching for the files that need attention

Once Action Items have been assigned, it’s easy for team members to identify documents, spreadsheets and presentations that need their attention. The next time they visit Docs, Sheets, Slides (or Drive) from their laptops or mobile apps, they’ll see a badge on any files with Action Items assigned to them, plus any unresolved suggestions that others have made to their files.

G Suite Bundle: Image 2

3. Spend less time building questions with smarter Forms

Since its launch in 2008, more than a billion questions have been asked in Forms, allowing us to identify common patterns, like question types and the response options that usually go with them. With the help of neural networks, we can now predict the type of question you’re asking and suggest potential responses for you to choose from, giving you back about 25 percent of the time you used to spend creating a Form.

Let’s say you’re planning an all-day event at the office and need to know which day works best for your team. When you type “What days are you available next week?” Forms will intelligently determine that “Checkbox” is the ideal question type, and generate related response options that you can add one by one or all together.
G Suite Bundle: Image 3

Also debuting today is a top-requested feature from our business and education customers — the new “File upload” question type. Your respondents can now upload files from their computer or Drive — all of which are neatly collected for you in a new Drive folder.  Note: This feature is only available for G Suite customers in Forms shared within their organization.

G Suite Bundle: Image 4

4. Spend less time typing with a set of new voice commands

Last year, we launched Voice typing in Docs on the web to help you capture ideas, big and small, without lifting a finger. Today, we’re adding more ways to format and customize content with commands for changing text color, deleting words, inserting links and comments, plus a number of other ways to format, hands-free.

5. Spend less time switching between apps to get things done

We want you to be as productive and collaborative as possible, regardless of the tools you choose to work with, so we’ve partnered with Slack to make it even easier to work with Google Docs files.

With a click of the "+" button in Slack, you can bring files from Drive directly into a conversation with your team, or create new Docs, Sheets and Slides files right from Slack. You can check out more details on Slack’s blog.

G Suite Bundled: Image 7

With the  introduction of Explore, and more and more updates to products that build in machine intelligence, taking back time spent on mundane, repetitive tasks will only get easier with G Suite. Now, you can focus your energy on creative and strategic work, not busy work.

Source: Google Cloud