Tag Archives: sheets

English county council saves millions switching to G Suite and Chromebooks

A day in the life of an employee at Northumberland County Council in northern England involves everything from running schools, repairing roads or literally putting out fires. It’s work that never stops and that stretches across a rural area the size of Greater London with 330,000 citizens and three million sheep.

Two years ago, the Northumberland IT team started to notice strain in their service infrastructure which connects 380 locations across the region, and recent budget cuts made that system feel increasingly unworkable.

"We had a very big legacy setup that was costing us a fortune in licensing and devices,” says Neil Arnold, Chief Information Officer at Northumberland County Council. “We decided to bring people together in a central hub to make teams more agile."

Creating G Suite champions

After evaluation, Arnold and his team chose G Suite for its functionality and flexibility. The team relied on Netpremacy, a Google Cloud partner, to train 300 staff members to educate colleagues on how to use G Suite. Within months, 5,500 corporate users and 11,500 schools users had been set up with G Suite accounts. “Without the support of Netpremacy, we wouldn't have been able to implement as rapidly as we did,” says Arnold. “They recognised the cultural challenges. There was skepticism at first, but users really took the tools to heart when they could see the benefits.”

From different locations across the region, staff began working collaboratively on Docs and Sheets and inviting others to join. The team saved money by switching to Chromebooks and Arnold and his colleagues started using Hangouts to join meetings to stay synced on daily work.

Even firefighters, who were reluctant to try out Hangouts at first, started using it regularly. “Firefighters now use Hangouts at the scene of fires to communicate with central command, monitor the fire, and decide how many vehicles they need,” says Arnold. “The chief fire officer doesn't have to get in his car and drive out to the scene to help — he can do it all from wherever he is.”

Firefighters use Hangouts at the scene of fires to communicate to central command, so the chief fire officer doesn't have to drive to the scene. Neil Arnold
CIO, Northumberland County Council

Saving big by going cloud-first

Arnold expects switching to Chromebooks will help Northumberland County Council save close to £2.5 million on licensing and hardware, without sacrificing data security since Chromebooks have multiple protection layers.

The next step for Arnold and his team is to bring G Suite to the classroom. “We've got a lot of schools using Google Classroom successfully,” he says, “and we want to roll G Suite out to more schools. It’ll be a big efficiency for them, because many have small file servers on site, that they manage themselves or pay a third-party to manage. Drive will help them decommission that.”

Meanwhile, outdated exchange and file servers are being closed down across the council as data is seamlessly transferred to Google Cloud. The new central office for the county is set to open in 2019, and Arnold does not plan to have a datacenter at the new building: “That footprint’s going to reduce over the next three years to virtually nothing.” 

“I've been working in IT for over 30 years and this has been one of the most successful and satisfying projects I've ever been involved in,” says Arnold. “We’ve achieved more than we expected and using G Suite has been a tremendous catalyst for change.”

Source: Google Chrome


Visualize data instantly with machine learning in Google Sheets

Sorting through rows and rows of data in a spreadsheet can be overwhelming. That’s why today, we’re rolling out new features in Sheets that make it even easier for you to visualize and share your data, and find insights your teams can act on.

Ask and you shall receive → Sheets can build charts for you

Explore in Sheets, powered by machine learning, helps teams gain insights from data, instantly. Simply ask questions—in words, not formulas—to quickly analyze your data. For example, you can ask “what is the distribution of products sold?” or “what are average sales on Sundays?” and Explore will help you find the answers.  

Now, we’re using the same powerful technology in Explore to make visualizing data even more effortless. If you don’t see the chart you need, just ask. Instead of manually building charts, ask Explore to do it by typing in “histogram of 2017 customer ratings” or “bar chart for ice cream sales.” Less time spent building charts means more time acting on new insights.

Sheets GIF

Instantly sync your data from Sheets → Docs or Slides

Whether you’re preparing a client presentation or sharing sales forecasts, keeping up-to-date data is critical to success, but it can also be time-consuming if you need to update charts or tables in multiple sources. This is why we made it easier to programmatically update charts in Docs and Slides last year.   

Now, we’re making it simple to keep tables updated, too. Just copy and paste data from Sheets to Docs or Slides and tap the “update” button to sync your data.

Sheets bundle - still

Even more Sheets updates

We’re constantly looking for ways to improve our customers’ experience in Sheets. Based on your feedback, we’re rolling out more updates today to help teams get work done faster:

  • Keyboard shortcuts: Change default shortcuts in your browser to the same spreadsheet shortcuts you’re already used to. For example, delete a row quickly by using “Ctrl+-.”  
  • Upgraded printing experience: Preview Sheet data in today’s new print interface. Adjust margins, select scale and alignment options or repeat frozen rows and columns before you print your work.
  • Powerful new chart editing experience: Create and edit charts in a new, improved sidebar. Choose from custom colors in charts or add additional trendlines to model data. You can also create more chart types, like 3D charts. This is now also available for iPhones and iPads
  • More spreadsheet functions: We added new functions to help you find insights, bringing the total function count in Sheets to more than 400. Try “SORTN,” a function unique to Sheets, which can show you the top three orders or best-performing months in a sales record spreadsheet. Sheets also support statistical functions like “GAMMADIST,” “F.TEST” and “CHISQ.INV.RT.”

These new features in Sheets are rolling out starting today. Learn how Sheets can help you find valuable insights.

Source: Google Cloud


Visualize data instantly with machine learning in Google Sheets

Sorting through rows and rows of data in a spreadsheet can be overwhelming. That’s why today, we’re rolling out new features in Sheets that make it even easier for you to visualize and share your data, and find insights your teams can act on.

Ask and you shall receive → Sheets can build charts for you

Explore in Sheets, powered by machine learning, helps teams gain insights from data, instantly. Simply ask questions—in words, not formulas—to quickly analyze your data. For example, you can ask “what is the distribution of products sold?” or “what are average sales on Sundays?” and Explore will help you find the answers.  

Now, we’re using the same powerful technology in Explore to make visualizing data even more effortless. If you don’t see the chart you need, just ask. Instead of manually building charts, ask Explore to do it by typing in “histogram of 2017 customer ratings” or “bar chart for ice cream sales.” Less time spent building charts means more time acting on new insights.

Sheets GIF

Instantly sync your data from Sheets → Docs or Slides

Whether you’re preparing a client presentation or sharing sales forecasts, keeping up-to-date data is critical to success, but it can also be time-consuming if you need to update charts or tables in multiple sources. This is why we made it easier to programmatically update charts in Docs and Slides last year.   

Now, we’re making it simple to keep tables updated, too. Just copy and paste data from Sheets to Docs or Slides and tap the “update” button to sync your data.

Sheets bundle - still

Even more Sheets updates

We’re constantly looking for ways to improve our customers’ experience in Sheets. Based on your feedback, we’re rolling out more updates today to help teams get work done faster:

  • Keyboard shortcuts: Change default shortcuts in your browser to the same spreadsheet shortcuts you’re already used to. For example, delete a row quickly by using “Ctrl+-.”  
  • Upgraded printing experience: Preview Sheet data in today’s new print interface. Adjust margins, select scale and alignment options or repeat frozen rows and columns before you print your work.
  • Powerful new chart editing experience: Create and edit charts in a new, improved sidebar. Choose from custom colors in charts or add additional trendlines to model data. You can also create more chart types, like 3D charts. This is now also available for iPhones and iPads
  • More spreadsheet functions: We added new functions to help you find insights, bringing the total function count in Sheets to more than 400. Try “SORTN,” a function unique to Sheets, which can show you the top three orders or best-performing months in a sales record spreadsheet. Sheets also support statistical functions like “GAMMADIST,” “F.TEST” and “CHISQ.INV.RT.”

These new features in Sheets are rolling out starting today. Learn how Sheets can help you find valuable insights.

Build with G Suite

Today wraps our annual Google I/O conference. Thousands of developers from around the world gathered to learn about our latest developer products and share best practices, including how to build next-gen business applications using G Suite. In case you need it, here’s a list of the various developer tools you can use to customize app your G Suite experience at your organization.

1. Build and deploy custom apps using App Maker 

App Maker is a low-code, application development tool in G Suite that helps developers quickly build and deploy custom apps securely. It comes with built-in templates, a drag-and-drop UI and point-and-click data modeling. Plus, you can customize your app to connect with a wide range of APIs using Apps Script. App Maker is currently available as part of an Early Adopter Program for G Suite Business customers. Learn more.

2. Create seamless integrations with the G Suite APIs

Speaking of APIs, G Suite offers a number of ways for developers to integrate their app with ours and create a seamless experience for users. Here are a few of our favorite G Suite APIs.

  • Try the Sheets API which lets your developers read, write and format data in Sheets. Plus, you can automatically generate and update charts, pivot tables and more.
  • The Slides API helps you access and update presentations programmatically, pulling in data from various sources (including popular third-party apps) and producing polished template-based presentations in a fraction of the time.
  • Leverage the Gmail API to access and organize your Gmail inbox. You can program your application to read and send messages, create filters to automatically label, forward and archive messages, or even update vacation responders.
  • Finally, the Drive API allows you to manage Google Drive files and/or folders as well as leverage new Team Drive features programmatically. Developers can also use the Drive SDK to create Drive-enabled apps that handle custom files.

3. Customize your G Suite experience with Add-ons 

Using Apps Script, G Suite's native JavaScript-based development platform, developers can easily customize their favorite apps like Sheets, Docs, and Forms by adding menu items, sidebars or editing files programmatically directly within these apps. We also recently introduced Gmail Add-ons in developer preview, so that third-party developers can bring the power of their apps directly into Gmail. Better yet, developers need only write their Gmail Add-on once, and it’ll run natively in Gmail on web, Android and iOS right away.

To learn more about how you can integrate and better customize your business applications for G Suite, check out the G Suite Developers blog or the G Suite Developers show. You can also subscribe to the G Suite Developers newsletter for updates.

Source: Gmail Blog


Build with G Suite

Today wraps our annual Google I/O conference. Thousands of developers from around the world gathered to learn about our latest developer products and share best practices, including how to build next-gen business applications using G Suite. In case you need it, here’s a list of the various developer tools you can use to customize app your G Suite experience at your organization.

1. Build and deploy custom apps using App Maker 

App Maker is a low-code, application development tool in G Suite that helps developers quickly build and deploy custom apps securely. It comes with built-in templates, a drag-and-drop UI and point-and-click data modeling. Plus, you can customize your app to connect with a wide range of APIs using Apps Script. App Maker is currently available as part of an Early Adopter Program for G Suite Business customers. Learn more.

App Maker GIF

2. Create seamless integrations with the G Suite APIs

Speaking of APIs, G Suite offers a number of ways for developers to integrate their app with ours and create a seamless experience for users. Here are a few of our favorite G Suite APIs.

  • Try the Sheets API which lets your developers read, write and format data in Sheets. Plus, you can automatically generate and update charts, pivot tables and more.
  • The Slides API helps you access and update presentations programmatically, pulling in data from various sources (including popular third-party apps) and producing polished template-based presentations in a fraction of the time.
  • Leverage the Gmail API to access and organize your Gmail inbox. You can program your application to read and send messages, create filters to automatically label, forward and archive messages, or even update vacation responders.
  • Finally, the Drive API allows you to manage Google Drive files and/or folders as well as leverage new Team Drive features programmatically. Developers can also use the Drive SDK to create Drive-enabled apps that handle custom files.

3. Customize your G Suite experience with Add-ons 

Using Apps Script, G Suite's native JavaScript-based development platform, developers can easily customize their favorite apps like Sheets, Docs, and Forms by adding menu items, sidebars or editing files programmatically directly within these apps. We also recently introduced Gmail Add-ons in developer preview, so that third-party developers can bring the power of their apps directly into Gmail. Better yet, developers need only write their Gmail Add-on once, and it’ll run natively in Gmail on web, Android and iOS right away.

Quickbooks GIF
Image credit: Intuit and Prosperworks

To learn more about how you can integrate and better customize your business applications for G Suite, check out the G Suite Developers blog or the G Suite Developers show. You can also subscribe to the G Suite Developers newsletter for updates.

Source: Gmail Blog


Build with G Suite

Today wraps our annual Google I/O conference. Thousands of developers from around the world gathered to learn about our latest developer products and share best practices, including how to build next-gen business applications using G Suite. In case you need it, here’s a list of the various developer tools you can use to customize app your G Suite experience at your organization.

1. Build and deploy custom apps using App Maker 

App Maker is a low-code, application development tool in G Suite that helps developers quickly build and deploy custom apps securely. It comes with built-in templates, a drag-and-drop UI and point-and-click data modeling. Plus, you can customize your app to connect with a wide range of APIs using Apps Script. App Maker is currently available as part of an Early Adopter Program for G Suite Business customers. Learn more.

App Maker GIF

2. Create seamless integrations with the G Suite APIs

Speaking of APIs, G Suite offers a number of ways for developers to integrate their app with ours and create a seamless experience for users. Here are a few of our favorite G Suite APIs.

  • Try the Sheets API which lets your developers read, write and format data in Sheets. Plus, you can automatically generate and update charts, pivot tables and more.
  • The Slides API helps you access and update presentations programmatically, pulling in data from various sources (including popular third-party apps) and producing polished template-based presentations in a fraction of the time.
  • Leverage the Gmail API to access and organize your Gmail inbox. You can program your application to read and send messages, create filters to automatically label, forward and archive messages, or even update vacation responders.
  • Finally, the Drive API allows you to manage Google Drive files and/or folders as well as leverage new Team Drive features programmatically. Developers can also use the Drive SDK to create Drive-enabled apps that handle custom files.

3. Customize your G Suite experience with Add-ons 

Using Apps Script, G Suite's native JavaScript-based development platform, developers can easily customize their favorite apps like Sheets, Docs, and Forms by adding menu items, sidebars or editing files programmatically directly within these apps. We also recently introduced Gmail Add-ons in developer preview, so that third-party developers can bring the power of their apps directly into Gmail. Better yet, developers need only write their Gmail Add-on once, and it’ll run natively in Gmail on web, Android and iOS right away.

Quickbooks GIF
Image credit: Intuit and Prosperworks

To learn more about how you can integrate and better customize your business applications for G Suite, check out the G Suite Developers blog or the G Suite Developers show. You can also subscribe to the G Suite Developers newsletter for updates.

Source: Gmail Blog


Build with G Suite

Today wraps our annual Google I/O conference. Thousands of developers from around the world gathered to learn about our latest developer products and share best practices, including how to build next-gen business applications using G Suite. In case you need it, here’s a list of the various developer tools you can use to customize app your G Suite experience at your organization.

1. Build and deploy custom apps using App Maker 

App Maker is a low-code, application development tool in G Suite that helps developers quickly build and deploy custom apps securely. It comes with built-in templates, a drag-and-drop UI and point-and-click data modeling. Plus, you can customize your app to connect with a wide range of APIs using Apps Script. App Maker is currently available as part of an Early Adopter Program for G Suite Business customers. Learn more.

2. Create seamless integrations with the G Suite APIs

Speaking of APIs, G Suite offers a number of ways for developers to integrate their app with ours and create a seamless experience for users. Here are a few of our favorite G Suite APIs.

  • Try the Sheets API which lets your developers read, write and format data in Sheets. Plus, you can automatically generate and update charts, pivot tables and more.
  • The Slides API helps you access and update presentations programmatically, pulling in data from various sources (including popular third-party apps) and producing polished template-based presentations in a fraction of the time.
  • Leverage the Gmail API to access and organize your Gmail inbox. You can program your application to read and send messages, create filters to automatically label, forward and archive messages, or even update vacation responders.
  • Finally, the Drive API allows you to manage Google Drive files and/or folders as well as leverage new Team Drive features programmatically. Developers can also use the Drive SDK to create Drive-enabled apps that handle custom files.

3. Customize your G Suite experience with Add-ons 

Using Apps Script, G Suite's native JavaScript-based development platform, developers can easily customize their favorite apps like Sheets, Docs, and Forms by adding menu items, sidebars or editing files programmatically directly within these apps. We also recently introduced Gmail Add-ons in developer preview, so that third-party developers can bring the power of their apps directly into Gmail. Better yet, developers need only write their Gmail Add-on once, and it’ll run natively in Gmail on web, Android and iOS right away.

To learn more about how you can integrate and better customize your business applications for G Suite, check out the G Suite Developers blog or the G Suite Developers show. You can also subscribe to the G Suite Developers newsletter for updates.

Source: Drive


Build with G Suite

Today wraps our annual Google I/O conference. Thousands of developers from around the world gathered to learn about our latest developer products and share best practices, including how to build next-gen business applications using G Suite. In case you need it, here’s a list of the various developer tools you can use to customize app your G Suite experience at your organization.

1. Build and deploy custom apps using App Maker 

App Maker is a low-code, application development tool in G Suite that helps developers quickly build and deploy custom apps securely. It comes with built-in templates, a drag-and-drop UI and point-and-click data modeling. Plus, you can customize your app to connect with a wide range of APIs using Apps Script. App Maker is currently available as part of an Early Adopter Program for G Suite Business customers. Learn more.

App Maker GIF

2. Create seamless integrations with the G Suite APIs

Speaking of APIs, G Suite offers a number of ways for developers to integrate their app with ours and create a seamless experience for users. Here are a few of our favorite G Suite APIs.

  • Try the Sheets API which lets your developers read, write and format data in Sheets. Plus, you can automatically generate and update charts, pivot tables and more.
  • The Slides API helps you access and update presentations programmatically, pulling in data from various sources (including popular third-party apps) and producing polished template-based presentations in a fraction of the time.
  • Leverage the Gmail API to access and organize your Gmail inbox. You can program your application to read and send messages, create filters to automatically label, forward and archive messages, or even update vacation responders.
  • Finally, the Drive API allows you to manage Google Drive files and/or folders as well as leverage new Team Drive features programmatically. Developers can also use the Drive SDK to create Drive-enabled apps that handle custom files.

3. Customize your G Suite experience with Add-ons 

Using Apps Script, G Suite's native JavaScript-based development platform, developers can easily customize their favorite apps like Sheets, Docs, and Forms by adding menu items, sidebars or editing files programmatically directly within these apps. We also recently introduced Gmail Add-ons in developer preview, so that third-party developers can bring the power of their apps directly into Gmail. Better yet, developers need only write their Gmail Add-on once, and it’ll run natively in Gmail on web, Android and iOS right away.

Quickbooks GIF
Image credit: Intuit and Prosperworks

To learn more about how you can integrate and better customize your business applications for G Suite, check out the G Suite Developers blog or the G Suite Developers show. You can also subscribe to the G Suite Developers newsletter for updates.

Source: Drive


Build with G Suite

Today wraps our annual Google I/O conference. Thousands of developers from around the world gathered to learn about our latest developer products and share best practices, including how to build next-gen business applications using G Suite. In case you need it, here’s a list of the various developer tools you can use to customize app your G Suite experience at your organization.

1. Build and deploy custom apps using App Maker 

App Maker is a low-code, application development tool in G Suite that helps developers quickly build and deploy custom apps securely. It comes with built-in templates, a drag-and-drop UI and point-and-click data modeling. Plus, you can customize your app to connect with a wide range of APIs using Apps Script. App Maker is currently available as part of an Early Adopter Program for G Suite Business customers. Learn more.

App Maker GIF

2. Create seamless integrations with the G Suite APIs

Speaking of APIs, G Suite offers a number of ways for developers to integrate their app with ours and create a seamless experience for users. Here are a few of our favorite G Suite APIs.

  • Try the Sheets API which lets your developers read, write and format data in Sheets. Plus, you can automatically generate and update charts, pivot tables and more.
  • The Slides API helps you access and update presentations programmatically, pulling in data from various sources (including popular third-party apps) and producing polished template-based presentations in a fraction of the time.
  • Leverage the Gmail API to access and organize your Gmail inbox. You can program your application to read and send messages, create filters to automatically label, forward and archive messages, or even update vacation responders.
  • Finally, the Drive API allows you to manage Google Drive files and/or folders as well as leverage new Team Drive features programmatically. Developers can also use the Drive SDK to create Drive-enabled apps that handle custom files.

3. Customize your G Suite experience with Add-ons 

Using Apps Script, G Suite's native JavaScript-based development platform, developers can easily customize their favorite apps like Sheets, Docs, and Forms by adding menu items, sidebars or editing files programmatically directly within these apps. We also recently introduced Gmail Add-ons in developer preview, so that third-party developers can bring the power of their apps directly into Gmail. Better yet, developers need only write their Gmail Add-on once, and it’ll run natively in Gmail on web, Android and iOS right away.

Quickbooks GIF
Image credit: Intuit and Prosperworks

To learn more about how you can integrate and better customize your business applications for G Suite, check out the G Suite Developers blog or the G Suite Developers show. You can also subscribe to the G Suite Developers newsletter for updates.

Source: Gmail Blog


Bring your idea to life with G Suite

You know that feeling when you present on a project after working on it for too many months? It’s great. Perhaps the most gratifying part of wrapping a project (besides finally being done), is reflecting on how your idea came to be more than just an idea.

For most of us in the workplace, ideas take shape in many forms—and G Suite can help you along the way. Here’s a snapshot of how you can bring an idea to life using G Suite’s intelligent apps:

1. You mention an idea to a teammate over lunch

Some of our best ideas happen outside the confines of the office. You mention an idea to a teammate in passing and they tell you, “Hey, that’s not a bad thought, but we should meet to flesh this out.”

Take your idea to the next level by getting your group together with Find a Time and Find a Room features in Calendar. Find a Time intelligently suggests times that you and teammates are available to meet and books a time for you. Find a Room takes over the hassle of finding an available meeting room. All you have to do is show up and brainstorm.

Find a Time gif

2. Step into a meeting room and map out your idea 

Now that you’ve booked a room, you can put more structure behind this “thing” you’re creating with Jamboard—our collaborative, digital whiteboard for sharing ideas in real-time and mapping out your project plan. Check it out:

If you used legacy systems in the past, you probably brought documents, sticky notes or other prep materials to a brainstorm. With Jamboard, you securely access all of those files directly in the cloud within your “jam.” Simply use the sticky notes tool, pull information and images from the web, or add files from Docs, Sheets or Slides to your brainstorm directly from Drive.

3. Give your brain a rest and come back to your work later

Sometimes the best thing you can do for a project is take a break and revisit it with fresh eyes. Jamboard makes this easy because it saves your work directly to Drive. If you’re on the go and want to revisit a file, you can rely on Drive’s Quick Access feature to automatically find files for you. And if you use Team Drives, you can add relevant files to securely share access and edit rights with others that need to weigh in.

team drives transparent

4. Make final edits and present your idea

Once you’ve put the final touches on your “jam,” you can present your work through Hangouts, which integrates seamlessly with Jamboard. Add team members to the Hangout to see your work, and they can even use the Jamboard companion app to make edits from their mobile phones or tablets. 

For a presentation you really want to polish, you can also import your work from Jamboard into a presentation in Slides. If you don’t like to fuss with formatting, use Explore in Slides, powered by machine intelligence, to make your presentation look top notch. Choose from dozens of design recommendations and apply them instantly with one click. Now you’re ready to sell your idea.

Explore in Sheets

5. Track your progress

Coming up with the ideas is the fun part. Executing and tracking success is often more difficult. G Suite can help with that, too. Use templates in Sheets to create detailed project trackers or manage employee shift schedules. Sheets can also help you quantify results at the end of your project. Use Explore in Sheets (powered by machine intelligence) to get insights instantly. Just ask questions—in words, not formulas—and get actionable insights from your data. And once you’re finished, create a Form to solicit feedback on how to improve for the next time.

These are just some of the ways that G Suite can help you create—and execute—your best work. For more tips on how to use G Suite products, check out the G Suite Show.

Source: Drive