iiotenki

The Tony Hawk of Tokimeki Memorial

A most of the time Japanese>English game translator and writer and all the time dating sim wonk.



i'm more or less completely self-taught when it comes to excel outside of extremely basic stuff i learned in school growing up and lord knows, translation agencies can't otherwise be assed to offer people training courses or even basic manuals to learn how to use it well as it relates to our line of work, so for as much as this is probably child's play to the people whose life work it is to write vbasic macros or whatever, not gonna lie, i feel like a god damn wizard making increasingly liberal use of conditional formatting lately to, say, automatically highlight cells if i type content into them, or change a cell's color based on the character count of an adjacent cell (ie: to alert me of an overage)

does this make me want to crack open an excel for dummies book and actually figure out more advanced stuff? god no as much as it probably should, but at least when i talk to work colleagues about this stuff, i can pretend slightly less that i know what i'm doing than i had to before

and if that ain't professional growth, i dunno what is, gamers


You must log in to comment.

in reply to @iiotenki's post:

vbasic is not any more satisfying than nice conditional color coding in my opinion lol - i’m glad you’re learning as you need to, that’s how i learned too and now i’m an “analyst” (booing). there are a lot of generous excel wizards who post templates for free, too, which is really nice.

i once put together a vba macro to translate a massive excel spreadsheet into a similarly massive word document to replace a manual process done like… once a year, and i think that was the swift kick in the rear i needed to never do that again if i could help it. i’ve immediately purged all knowledge of vba from my mind. xlookups and pivots only from now on baybeeeeeee

in all seriousness though, hell yeah to getting those functions down! even a little bit of automation feels great and being able to put in quick little visual checks like that is pure magic