by Wyn Hopkins

SquareWars – A Fun Way to Learn Excel 365

Here’s a fun way to learn a few Excel 365 functions and challenge a colleague to a friendly game at the same time..

Aim

Leave your opponent with the last square and you win!

Rules

Take turns to enter your sequence of numbers using the SEQUENCE function
=SEQUENCE( Row, Col )
If your formula spills over the edge or into another range you lose

New Game

Click New Game then press Delete to clear the board
Watch the video to see it in action…

 

Functions Used

SEQUENCE

FORMULATEXT

ISEVEN

COUNTBLANK

IFERROR

ISERROR

Other Techniques

Dynamic Arrays

Linked Images

Conditional Formatting

Named Ranges

Hyperlinked Images

 

See how it works and challenge your colleague to a game!

SquareWars for Desktop

 

 

SquareWars for Web (the Excel for web version only differs in that it currently can’t display the linked Images nor page background)

 

 

Happy gaming!