The Chess Game of the Century in a Single Google Sheets formula
In 1956, a 13-year old Bobby Fischer announced his chess genius to the world, winning one of the finest games in chess history - a game Chess Review called “The Game of the Century“.
In a game full of beauty and surprise, Fischer overcame his much older, more experienced opponent, the International Master Donald Byrne.
Learn how I used the MAKEARRAY, LET, CHAR and other functions to create a single formula that plays through this Game of the Century.
📚 Additional resources:
Template to follow along: https://docs.google.com/spreadsheets/...
Chess Formula written tutorial: https://www.benlcollins.com/spreadshe...
Turning checkboxes into buttons: https://blog.atylerrobertson.com/read...
📖 Chapters:
0:00 - Introduction
1:22 - Backstory
3:47 - CHAR function to show chess pieces in Google Sheets
5:20 - LET function to name pieces
7:21 - MAKEARRAY function to generate 8 by 8 board
9:39 - IFS function to arrange pieces
13:37 - Combine functions to display full board
16:24 - Make the pieces move with IF function
24:17 - Automate the moves with NOW function or checkboxes
✉️ Google Sheets Tips Newsletter, my free weekly newsletter:
https://www.benlcollins.com/google-sh...
🎓 Join 68,000+ professionals in my courses: https://courses.benlcollins.com/
#googlesheets #googlesheetstutorial #spreadsheet
Смотрите видео The Chess Game of the Century in a Single Google Sheets formula онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Ben Collins 25 Январь 2024. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 1,344 раз и оно понравилось 54 посетителям.
