ABCD
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
FeatureDescription
8
Conditional FormattingCells, 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 ValidationThe 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
FilteringTo 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/columnTo 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