click here to download the Tutorial Files Topics: Rules of the sudoku puzzle. CodinGame puzzle’s inputs and expected outputs. How to show arrows indicating the ‘precedents’ (the input cells for the current cell’s formula). How to convert input text into many Excel cells (“space separated” information). COUNTIF(). INDEX() to re-arrange cells (like we did in the Onboarding tutorial).

click here to download the Tutorial Files Topics: CodinGame “Show Testcases” button, to see inputs and outputs of many puzzles. MID() to get part of a text. FIND() find the position of a text inside another text. UPPER() to convert a text to upper case.

Topics: Thor puzzle explanations, inputs, and outputs. Giving a unique code for each board’s cell: string & string. Locking rows and columns of a formula with $ and the F4 key. Showing the goal/light on the grid: IF(condition, valueIfTrue, valueIfFalse). Moving Thor step by step towards the goal. CodinGame OUTPUT: choose(index, valueIf1, valueIf2, valueIf3). Beyond the solution: let’s also show the path of Thor in the board. MATCH() formula. How to find an element in a group.

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)