New feature from Google Sheets, you can convert a block of cells into a table with only one click.
When you want to collect data and prepare a report, how will you organize your information and format? How long does it take to convert a group of cells into a well organized table? Would you like to try a new way of creating blocks of data in a spreadsheet? With tables, it simplifies and accelerates spreadsheet building by providing format and template to unorganized ranges. You can be more confident to share proper data tables to your team.
*You can convert a block of cells into a formatted table with just one click.
Source: Google Workspace Update
To start using, simply select your data range, then click the “Format” menu on the navigation bar, choose “Convert to table”. It enables a block of your highlighted cells to be turned into a table with filters and design automatically. This includes changing the color of the filter headers, and alignment of the data in a cell. You are able to adjust the type of each column to suit the data inside for instance column types, filters, color coding, dropdown menus.
*The above photo shows the feature “Create group by view”, you can view data based on the selected column or condition.
Source: Google Workspace Update
While you are using tables, Google Sheets supports “Create group by view” to where it aggregates data into groups based on a selected column. You can group all data at the same priority level in one place. Additionally, there are “Pre-built tables” features providing several formatted templates that you can input common data on task templates such as team planner, event planning, product roadmap, or project management etc. It can reduce time spent on template building on your own.
*You can choose “Pre-built table”; a well organized template to fill data upon your requirement.
Source: Google Workspace Update
According to the new table feature in Google Sheets, it enhances data management and analysis by simplifying data organization using table templates in Google Sheets. They also support teams to confidently share data widely while maintaining its consistency, allowing them to be more efficient for several aspects from tracking progress to project management. In addition, users can apply pre-built tables and fill data on their daily task templates. It saves time and effort to create new work templates.
If you have any inquiry, please feel free to contact us here
Source: Google Workspace Update