Me to VLOOKUP: Who are you and what do you want from me?!

by Staff | Jul 28, 2020 | Data hack, Excel

Why are Excel functions like the worst thing to admit to not knowing? It’s one of those topics where if you already know it – then it’s SO EASY – but if you don’t it’s like just smile and nod and try not to look...

Is there, like, a shortcut for that?

by Staff | Jul 28, 2020 | Data hack, Excel

Here’s our hack to getting that much closer to freeing the mouse in Excel ? We all have our go-to little mouse clicks in Excel. For some of us it might be clicking to apply a specific border style and for others it could be constantly turning...

Ladies, Drop It Down

by Staff | Jul 28, 2020 | Data hack, Excel, Uncategorized

? and no, not in the dance floor way Have you ever had a form with blanks to fill out… and you send it to someone and their answer for Favorite Color is “Pink.. no, blue – but blue with glitter! Actually, I don’t know, I don’t have a favorite!”...

Double the Fun

by Staff | Jul 28, 2020 | Data hack, Excel

This week’s data hack: Weird Problem. You have data. It’s in a spreadsheet. It’s FINE! Then for whatever reason, your boss… co-worker… bride-to-be (with extra opinions to spare)… disagrees. The spreadsheet is as we like to say “single spaced” and needs to be...

Get Your [Data] Ducks in a Row ?

by Staff | Jul 28, 2020 | Best Practices, Data hack, Excel

Hello DBD crew! We are thrilled to release our v first data hack. Yes, yes… data hack sounds like typical blogger mumbo jumbo. BUT in the spirit of what Dumb Blonde Data is all about, these will be APPLICABLE tips either covering a data best practice or a how-to for a...