A | B | C | D | |
---|---|---|---|---|
1 | ||||
2 | About this sheet | |||
3 | The first two tabs contain contextual information via the comments on how to use the feature described below. | |||
4 | The rest of the tabs are templates that you can copy and use for your own projects | |||
5 | ||||
6 | What you will learn | |||
7 | Feature | Description | ||
8 | Conditional Formatting | Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. For example, if they contain a certain word or a number. | ||
9 | Data Validation | The role of Data Validation is to ensure data quality by applying validation logic into Spreadsheet cells. With data validation, you can control the types of values entered in a cell or range of cells. It includes in-cell drop-down lists, validation checkboxes aka tick boxes, customs data validation formulas, conditional data validation, etc. | ||
10 | Filtering | To see and analyze data in a spreadsheet, use filters. Filters let you hide data that you don’t want to see. You’ll still be able to see all your data when you turn the filter off. | ||
11 | Functions (Formulas) | Use formulas to manipulate data and calculate strings and numbers. Simple yet useful formulas include: SUM, AVERAGE, COUNTIF | ||
12 | Freezing row/column | To pin data in the same place and see it when you scroll, you can freeze rows or columns. | ||
13 | ||||
14 | Feedback? | |||
15 | Leave a comment in the medium story | |||
16 | Or | |||
17 | Email me | |||
18 |