Google recently released one of their largest updates ever to Google Spreadsheets, bringing some desperately needed features. There’s a lot you need to know about the new Google Sheets, so check out this video before you get started!

First of all, Spreadsheets finally have a feature that was available for Docs, Slides and Drawings for quite a while — offline creation and editing. While this is still only available in the Chrome browser, it’s still a much needed addition.

One major point of contention with Google Spreadsheets was a limit on size limit on cells, functions, columns, etc. Google has removed those limits giving users much more flexibility. It’s important to note that even though the limits have been lifted you still may experience some delays as Sheets grow in size and complexity.

There’s a ton of new features available in this latest update, including:

• Filter views
• Enhanced function help
• New functions
• Advanced conditional formatting
• Colored Sheet tabs
• New find-and-replace features

Click here to watch this video on YouTube.