spreadsheet design
A digital rock star
There is a lot of great software that powers all kinds of different applications across every industry in profession. But none is more powerful and ubiquitous than spreadsheets, especially Google Sheets.
The extensibility & customisation of Google Sheets is off the charts. There isn't a more versatile type of software available. It is a digital rockstar.
However, most organisations only use a fraction of the features, formulas & functionality.
The extensibility & customisation of Google Sheets is off the charts. There isn't a more versatile type of software available. It is a digital rockstar.
However, most organisations only use a fraction of the features, formulas & functionality.
Features & Formulas:
- Protected ranges - allows you to set permissions across a sheet, range or cell level (great for data validation)
- Name ranges - allows you to provide a unique name across a range or cell (idea for writing complex formulas)
- =sumifs() - sum values that meet multiple conditions
- =unique() - summarizes all unique values in a range (ideal for data cleanup)
- =vlookup() - looks up values in different ranges
- =query() - create complex summaries and formulas