Sheets
Google Sheets is a great alternative to Microsoft Excel. This week we'll unlock additional features of Sheets to show how Sheets can become your default spreadsheet application. Let's start by reviewing some important types for using Sheets more effectively.
Tip #1 - Keep headings or labels in place when scrolling through large spreadsheetsWhen you scroll through a large data set, sometimes the headings disappear and you lose context. To keep your headings from disappearing in Google Sheets, just freeze them in place.
https://apps.google.com/learning-center/tips/sheets/#/show-tip/keep-headings-or-labels-in-place
Tip #2 - Filter data in shared spreadsheets without changing what collaborators see
Ever wish you could save a particular filter in your spreadsheet? Create a filter view that only you can see and reuse.
https://apps.google.com/learning-center/tips/sheets/#/show-tip/filter-data-in-shared-spreadsheets
Tip #3 - Get Instant Insights into your data
A spreadsheet full of data can be daunting. Get summaries and charts of your data in the click of a button with Google Sheets. As you select different ranges of cells or columns, the charts update in real time. It’s kind of like having an expert in data analysis sitting next to you.
Tip #3 - Get Instant Insights into your data
A spreadsheet full of data can be daunting. Get summaries and charts of your data in the click of a button with Google Sheets. As you select different ranges of cells or columns, the charts update in real time. It’s kind of like having an expert in data analysis sitting next to you.
