Google Sheets - Use Named Ranges to Simplify your Formulas
Learn how to use named ranges to describe a cell or range of cells and make your formulas easier to read.
More info and link to the template: https://sheetshelp.com/named-ranges/
Timestamps:
0:00 Intro and setup
1:30 Without named ranges
3:25 Naming ranges
4:53 Using named ranges in formulas
6:33 Improving the names with specificity
9:26 Fixing and naming one cell
11:28 Extending the ranges to catch new values
#googlesheets #spreadsheets #prolificoaktree
