#i actually think arial is the only acceptable font for excel but recognise that's brainwashing

[patrice-bergerons]

fire emoji about SPREADSHEETS

Miss Lemonistas you don't know what you have done 😂 So here, have 3.5 wholeass opinions about spreadsheets-

Merging cells (especially across two or more columns) is a capital sin that should be punishable by death. It messes up formulas, it makes it very difficult to select the data properly, it breaks the fabric of the spreadsheet itself and it is so wholly unneccessary, when you can instead select the cells you were going to merge, right click > format cells > alignment (tab) > select "Center Across Selection" under the Horizontal menu to make the content look centered without merging them like a caveman 😤

The other issue I run into the most often with junior employees is that sometimes they will just hardcode their values into exhibits which makes me go, GIRL did these numbers spring wholly formed from your mother's womb? where are they coming from?? you gotta display them calculations and vlookup (or index/match) your data from a source tab so whoever opens your file can see what you've done without having to read your mind!!

Lastly - and this one is niche - when I started on the job, I was raised to always use index/match to lookup data but actually vlookup is perfectly serviceable and easier as long as your lookup id is on the leftmost column of the source tab. There is no need to make life unneccessarily difficult lol

And then: it takes a real chaos merchant to use Georgia in a spreadsheet. We have one school in the firm which does this and every time I have to interact with their spreadsheets with the numbers drunkenly stumbling all over the place I lose a year of my life.