Spreadsheets

Full spreadsheet functionality with built in querying from various database technologies (including: MySQL, MS-SQL, Postgres, Snowflake & others.. but not Oracle)

Spreadsheet Functions

  • WEEKNUM
  • WEEKDAY
  • NETWORKDAYS
  • DAY
  • DATEDIF
  • UPPER
  • LOWER
  • PROPER
  • IF
  • IFERROR
  • IFNA
  • SWITCH
  • FILTER
  • RANDARRAY
  • SEQUENCE
  • SORT
  • SORTBY
  • UNIQUE
  • XMATCH
RAnge-based CONditional functions
  • COUNTIF
  • COUNTIFS
  • AVERAGEIF
  • AVERAGEIFS
  • MAXIFS
  • MINIFS
  • SUMIF
  • SUMIFS
  • SUM
  • SUMIFS
  • SUMPRODUCT
  • MIN
  • MAX
  • MAXIFS
  • MINIFS
  • VLOOKUP
  • XLOOKUP
  • QUERY

Spreadsheet Formatting

  • Row Manipulation (Add/Delete)
  • Column Manipulation (Add/Delete)

Charts

Spreadsheet Metadata

Other

Spreadsheet Alternatives

Full spreadsheet functionality with built in querying from various database technologies (including: MySQL, MS-SQL, Postgres, Snowflake & others.. but not Oracle)

Bibliography