Fast and easy to understand explanation. Hoping this becomes a series of similar quick clips. It would also be neat to have a video compiling pet peeves, favourite formulas, pro tips from the top competitors.
@FMWC2 жыл бұрын
Thanks for your feedback, Maddy! Stay tuned for more, we already have this planned.
@CadetFord23452 жыл бұрын
Agreed, more tips from the pros would be amazing! I'd love to hear about the early pitfalls/traps, advantages, etc. they don't discuss much during competition or briefly during the post-interview. I just recently bought one of Bill's books and am slowly reading through it. I may not use much of what I learn in my line of work, but still excited to uncover and possibly utilize more within Excel.
@tiffaniemaddox59722 жыл бұрын
Agreed Maddy! And I would like a sample question to try on my own.
@Riles1719 ай бұрын
Andrew Ngai the GOAT 🐐🐐
@WorldWideSk8boarding Жыл бұрын
this dude is the real deal
@skyiscubing699 ай бұрын
What are the headphones for?
@horschj4 ай бұрын
think its easier to name a range "lookupCol" in row1 of the column and then do =iferor(vlookup(value, fullTable, column("lookupCol"), false),"n/a") . its annoying to have to use two different column ranges with xlookup assuming you set your key value pair properly as in the "name" column. wouldnt have the need to lookup via "birthday"