Excel introduction - Onboarding tutorial - CodinGame

July 16, 2020

Topics:

Instead of Excel, you can use “LibreOffice Calc”.

Variable type: String/Text (left aligned).

Variable type: Number (right aligned).

Variable type: Date (right aligned).

Variable type: Boolean (aligned to the centre).

Cell name.

Formulas (usually begin with =).

Solving the CodinGame Onboarding puzzle in Excel: inputs, outputs.

Rearranging data from vertical to horizontal, and creating groups of four.

Copy & “paste-special”, with transpose.

INDEX(group_of_cells, pointer), cell I6 = INDEX($D$6:$D$65, $H6 * 4 + I$4)

Copying formulas and blocking rows / columns with $

Copying formulas horizontally / vertically by dragging with mouse.

Formula to calculate the outputs.

Converting from string/text to number: the why and the how-to.

IF(condition, outputIfTrue, outputIfFalse).