android qvga

(Cross-posted from the Official Google Blog)

Whether you’re crunching big data or tracking your family budget, you don’t want to waste time waiting for files to load or re-doing edits that were lost because your Internet connection dropped. You can now get more done by switching to the new version of Google Sheets. It’s faster, supports larger spreadsheets, has a number of new features, and works offline.
Bigger, faster spreadsheets
The new Sheets supports millions of cells and kicks many of the old size and complexity limits to the curb. Scrolling, loading and calculation are all snappier, even in more complex spreadsheets.

New features based on your feedback and requests 

Filter views is a new feature unique to Google Sheets that lets you quickly name, save and share different views of your data. This comes in handy when you’re collaborating so you can sort a spreadsheet without affecting how others see it.
Whether you’re new to formulas or a whiz at running complex functions, it’s now easier to set up and perform calculations. New function help and examples guide you as you type, and error highlighting and coloring make it easy to spot and fix mistakes.
As another time-saving improvement, text now automatically flows into empty adjacent cells—no manual merge needed.
With the improved conditional formatting, you can add rules to change the colors and styles of cells in your spreadsheet based on custom formulas.

No internet connection? Work offline with Chrome 
You shouldn’t have to think about whether you have a WiFi connection when you want to work. So just like Google Docs and Slides, you can now make edits to Sheets offline. When you reconnect to the Internet, your edits will automatically sync. If you've edited Docs or Slides offline in the past, then you’re already set up to edit Sheets offline. If not, follow these one-time instructions for setting up offline in Chrome.

Ready to try it out? 
Turn on the new Sheets by checking the “Try the new Google Sheets” box in Google Drive settings. From then on, all new spreadsheets you create will work offline and include these new features. We’ll be adding a small list of missing features in the coming months, so if you rely on any of them, you may want to wait a little longer before opting in.

We hope you enjoy these and the many other updates that come along with the new Google Sheets, including colored sheet tabs, custom number formatting, paste transpose and more. Let us know what you think on our Google+ page!

Posted by: Zach Lloyd, Software Engineer

Starting today, things are about to get cleaner—and more colorful—in Docs, Sheets, Slides, Drawings, Forms and Apps Script. First, you’ll notice each editor’s product icon displayed in the header, which doubles as a quick link back to all your files in Drive. Next, you’ll see that the header is more streamlined and compact, helping you to focus on what matters most—your content.

We hope these updates make your creation and collaboration experience just a bit more delightful. Enjoy!

Posted by Sarah Cooper, User Experience Designer

Posted by guest blogger Wendy Gorton

Wendy Gorton is an education consultant for organizations around the world. She’s a former classroom teacher, Google Certified Teacher and Trainer, and is passionate about creating learner-centered environments using tools like Google Apps for Education. 

Follow the Drive Google+ page this and next week for daily tips and suggestions for using Drive in the classroom.

Google Drive is the all-in-one tool I wish I had my first year of teaching. It not only keeps all of your lesson plans, activities, and research organized, but it's an outstanding way to engage your students, give them feedback, and give their writing a real audience—like their peers or classrooms around the world.

Here are 3 tips to help teachers prepare for going back to school with Docs, Sheets, Slides, and Forms. 

1. Use Slides to get to know your students 
A great first-week introductory activity is to create a single slide deck, and then invite each of your students to share a bit about themselves on their own personal slide. It’s a fantastic get-to-know-you activity for the first week of school and you’ll be amazed by the creativity that comes out of your students! 

The screenshot below shows how Google Student Ambassadors from 9 different countries used Slides to introduce themselves before gathering to meet each other at an event in Indonesia this summer.

Want to get this going with your students? Easy—create a new Slides deck on the first week of school, click the blue Share button to invite your students, and give them a little direction for their individual slide by adding comments.

2. Use Docs to create a classroom “Bill of Rights” 
The first week of class is that precious transition from the “honeymoon” period of angelic children to learning the norms of your classroom culture. Help start the year off right by inviting students to co-create their ideas of citizenship and a happy learning environment, Docs style.

Start by creating a copy of this template and then invite students to join in with you to add their ideas, ratify by adding a comment, and use their editing prowess to come up with a final copy to live by for the coming year.

3. Use Forms to get to know your students (and their prior knowledge!) 
Get to know your classroom as soon as possible, using Forms to gather information about their needs, interests, and abilities beforehand. Consider creating a simple Form for a survey for your students (and for your parents!) and have fun showing the data on your projector and learning about your class as a whole.

Forms can be used as a very quick getting started activity before any lesson as well—take this example from a social studies classroom before talking about population. By placing a quick Form on your classroom site or emailing your students the Form, you can quickly grasp your students' prior knowledge—before you start teaching.

In this case, our team was a bit off, but helped us not only talk about population but estimation and numbers in general (answer? 7.1 billion and counting. My favorite answer? One ‘goggle.’)
One last tip: Google Apps for Education
You know this is way easier when your school has its own Google Apps for education set up, right? It’s free, and no technical expertise is needed to get started.

I hope you give one of these ideas a try and let me know how it goes on my Google+ page.

Chances are that many of you lucky readers will be unwrapping new computers, mobile phones, and tablets this holiday season. Here are a few quick tips on how you can smoothly transition all of your stuff from old devices to new ones using Google Drive.

For laptops & desktops 
First, you’ll want to get all your files from your old computer into Google Drive. To do this, download Drive for Mac or PC on your existing computer. To upload your files to Drive, simply drag-and-drop all your files and folders (up to 5GB free) into the new Drive folder on your desktop. Then you’ll be able to access everything on the web from any computer, including your new one. Or you can download Drive again on your new computer to sync your files and automatically store them on your new computer.
For mobile phones & tablets
Upload all of the photos and videos on your old device with the Drive mobile app for Android or iOS. Install the Drive mobile app on your new device and all your stuff will be there -- and also available to you on the web from any device.

More holiday tips & tricks 
For those of you planning to do any holiday cooking, here are a few other ways Drive can help you in the next few weeks:

• Scan or snap a photo of a classic family holiday recipe and upload it to Drive for safe keeping and sharing. 
• Search for recipes that you’ve already stored in Drive. You can even search for keywords inside PDFs and photos. 
• Jot down a new delicious recipe right from the kitchen with Docs in the Drive mobile app for Android and iOS. 
• Use Sheets for your grocery shopping list. Create it on your computer at home, then pull it up on your phone at the grocery store and cross of items as you go. 
• Create a quick form to invite friends to your holiday get together and figure out who’s coming, what they’re bringing, etc. 

Happy holidays!

Posted by Michael Bolognino, Product Marketing Manager