APP
  • Home
  • Music
  • Spreadsheets

spreadsheet design

Picture

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.
Picture
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
#Hats&Habits
#Workphoria
#ShareWell&Prosper
#Moximise

  • Home
  • Music
  • Spreadsheets