Tag Archives: docs

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.”

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: Drive


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


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


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.”

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.”

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.”

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.