formula beautifier — make a long formula readable
copy-paste-dump — find assorted special characters easily
undumb my data — my notes for handling data
column's letter to column number — find a column number or letter and the distance between two columns
column to comma seperated list — convert columns into a comma separated list or strings
proper table — only a meaningful table allows you to access the spreadsheet tools fully
clustering values — group values and keep them sortable
find and extract — get substring out if string in a complex operation
operator — a more formal form for +, *, > etc.
query — run a sql-like query in a sheet
rounding — round in different decimal places
subtotal — another way to calculate sums, averages etc.
trim and trunc — cut off values and clean up strings
unique identifier — create a unqiue key for a data set
min max — find minimal and maximal values
ordinal numbers — 1st to n-th in order
running aggregation — make sums or averages running
boolean algebra — see tables for and, or, not, xor
boolean to numeral — transform Boolean TRUE/FALSE to 1/0 in a jiffy
conditional count and sum — count and sums with conditions
conditional sumproduct — sum up, but a bit more complicated
distinct count — count values distinct
ifs and switch — do multiple ifs at once
indirect address — build a cell's address from a text string
look ups — different ways to look up cells from different locations
mapping — assign a value to a value via a map
filter — find values
average_percentage — calculate averages of percentages correctly
basic percentage — get an understanding of the very basis of percentages
less basic percentage — calculate from percentages
marginal tax — master the secrets of differential tax (Differenzbesteuerung) in German commerce
by row and column — change whole arrays at once
date time — construct and desconstruct timestamps with ease
quarter — calculate a month's quarter
fractional year or day — show a time span as a fraction of a year or of a day
decimal hours — change decimals hours into hours and minutes
time zone — zone in UTC
weeknumber year — a weeknumber might belong to a different year than the date indicates
days of week in month — find the ratio to see how many days a week shares in the month
calendar weeknumber — a calendar with the ISO-weeknumber
monthly calendar — a quick look at the month
date sequence — create a sequence of dates
brand colour— colours of different brands and companies
custom format colour codes — change the colour of a cell's value as you wish
colour palettes — more and less know colour pallettes
my favorite colours — colours I prefer
colour circles — wheels of colour
colour picker — find a colour's hex-value
colour scheme creator — create a colour scheme yourself
website to hex colour — grap a website colours
image to hex colour — grap a an images colours
corporate design — colours I use at work
reporting — the colours I use for reports
highlight value — mark values of importance in cells, rows, and columns
highlight doubles — find multipe values by colouring
heat map — use colours to show change
stripes and bars — format cells automatically in stripes or bars
cell's format — read out the cell's format, but not in Google Sheets, though
stripes and bars — format cells automatically in stripes or bars
custom number formats — change the display of a cell's value freely
custom format colour codes — change the colour of a cell's value as you wish
colour codes — change the colour of a cell's value as you wish
pivot table visualised — get a grip of pivot tables
look up pivot values — get data from a table the flexible way
hack the order — sort beyond the field
advanced calculated field — calculate with a distinct count
custom filter — set filter with changing custom value
unpivot a pivot table — reconstruct a data table from a pivot table with a Cartesian product
random data sheet — fool around with randomly generated data to train your abilities
one record — onne record table is easier to analyse
proper table — only a meaningful table allows you to access the spreadsheet tools fully
Google Sheets
connected data — see some basic examples
unpivot with Power Query
charts of all kind — discover the many way to plot and present your data in charts
bubble chart — use five values to blow up the bubble chart
histogram vs column chart — see the difference of categorical and numerical data
candle sticks and hisorgrams — see distribution
data and non-data — less can be more in visualisation and design
sparkline and progress bar — show value as a sparkline chart or progress bar
combination matrix — see how often something appear together with something else
confusing visualisation — manipulate the impression you make
statistics — average, media, variance, standard derivation
average — many kinds of means
average_percentage — calculate averages of percentages correctly
variance — find the standard derivation
regression — find the formula for a curve
confusing visualisation — manipulate the impression you make
faulty reasoning — mislead with abused logic
false reasoning — entrap with false logic
ranking — from first to last et vice versa
performance score — normalised multi criteria decision making
success ratio — meassure your success
similarity — find similar value combinations
instances — find the first and last instance
equation chart — see charts changing by changing variables
curve sketching — draw function and derivations for differential calculus
apps script — manipulate Google Sheets with macros and scripts
errors — handle an error correctly
formula to text — show a formula or function as text
hex numbers — turn numbers into hex numbers et vice versa
numerals roman and arabic — transform Roman numerals into Arabic numerals et vice versa
consecutive values — count cosecutively and build blocks
lambda — create and name functions
regex — use regular expressions
unique vs distinct — no unique opinion about what is what
character encoding — write a character by its code
repeat and pad — add characters to strings to make up for their length
random entries — generate random strings and values
random data sheet — fool around with randomly generated data to train your abilities
list from range — pick one value from a given list
tick box — select Boolean values with a click
augment letters — write your abc quickly
augment numbers — 1, 2, 3 and more
date sequence — create a sequence of dates
search by keyword — finde a topic in the table of content for Sheet Cheat Sheets
Sign in — access Google Drive with another email address
Functions
Basics
ETL tool Power Query
Expressions
w3schools
