Excel is often case insensitive (as in, it thinks A and a are the same thing), but sometimes not, and it's easy to get tripped up on the differences.
By the way, I forgot to mention in the section on case sensitive / insensitive functions: the modern Excel additions (TEXTSPLIT and friends) can be either, but they default to being case sensitive, which has tripped me up before!
This video is part of a bootcamp for people interested in trying out the Excel esports battles - or just improving their Excel skills. You can find the intro video for the course here:
• Excel esports boot cam...
And the playlist, which will include all the videos from the course, is here:
• Excel esports boot camp
====================================
Here's a link to the workbook with the exercises I went through in the video if you want to give them a try (I didn't really have any extra nerd challenges today...):
1drv.ms/x/s!Aryypvyx4xIO7E7dg...
====================================
If you want to download some of the cases I talked about today and will be talking about over the next couple of weeks, the ‪@FMWC‬ team has kindly made a selection of them free to people following our course. You can get cases 2 to 6 from last year's series (Bear Island by Harry Seiders, Laundry Time by Peter Scharl, What's My Flight Number by Patrick Chatain, Battle Royal by Harry Seiders, and Fantasy Excel by Peter Scharl) for FREE between now and the first battle of this year's series (Jan 26) with the code BOOTCAMP.
They're the first four cases here, and the last one on the page before:
fmworldcup.com/product-catego...
====================================
If you want to get the workbook Giles prepared that walks you through the basics of all the main functions we'll be talking about in the next couple of weeks (including explanations, examples, and exercises), you can get that here:
drive.google.com/drive/folder...