You are about to action:

Object being modified by the action

Do you want to proceed?

Share Video Link

https://www.bitchute.com/video/kv5xSBZNLQyN/

Click to copy, then share by pasting into your messages, comments, social media posts and websites.

Embed Video HTML

Click to copy, then add into your webpages so users can view and engage with this video from your site.

Share to Social Media

Share to social media by clicking on the quick share links.

Report Content

Reason

Please select the most appropriate reason from the list provided.

Note: For a more detailed description of each reason, see our Community Guidelines.

Additional Comments

Please add any additonal comments that will help with the assessment of your request.

Note: Copyright claims must contain all the items specified within the Copyright Policy.

Email Submissions

We also accept reports via email. Please see the Guidelines Enforcement Process for instructions on how to make a request via email.

Thank you for submitting your report

We will investigate and take the appropriate action.

Add to Playlist

Excel introduction - Onboarding tutorial - CodinGame

Next video playing soon

Click to cancel

Autoplay has been paused

Click to watch next video

First published at 21:32 UTC on July 26th, 2020.

#excel
#tutorial
#codingame

Kodindonesia

subscribers

BitChute Advertisement

Tutorial files: https://drive.google.com/drive/folders/1Q8lhUA0cFAMwwpNJcs2ja9ecddsk6jFE
Topics:
03:32 instead of Excel, you can use "LibreOffice Calc".
05:49 variable type: String/Text (left aligned)
06:20 variable type: Number (right aligned)
06:49 variable type: Date (right aligned)
07:02 variable type: Boolean (aligned to the centre)
07:13 cell name
08:19 formulas (usually begin with =)
12:05 solving the CodinGame Onboarding puzzle in Excel: inputs, outputs
14:42 rearranging data from vertical to horizontal, and creating groups of four
15:19 copy & "paste-special", with transpose
16:25 INDEX(group_of_cells, pointer), cell I6 = INDEX($D$6:$D$65, $H6 * 4 + I$4)
17:34 copying formulas and blocking rows / columns with $
17:41 copying formulas horizontally / vertically by dragging with mouse
19:28 formula to calculate the outputs
19:39 converting from string/text to number: the why and the how-to
23:11 IF(condition, outputIfTrue, outputIfFalse)