Hackers and Slackers
Author image

Max Mileaf

Down the block from a literal battleship
One of three therapists in the known universe who knows how to use a computer. Finds meaning in highly protected data, in a cave, utilizing nothing but a box of scraps.

I Owe My Job to Mr. Robot

Entering the Dataverse

What's up data gang? If you've been reading along throughout this journey, you'll realize that all of my posts have something in common (other than Excel...smartass), they all assume that you're already working with data...even if it's just

Data Author imageMax Mileaf Author imagesnacks Aug 14
Read

Active-X Gonna Give it to Ya

Named Ranges and the Active Xs who Love Them

Hi there dear reader, we've now reached a crossroads in your ability to use Excel as a means of data analysis. If you've been following along, you've learned how to use basically every tool that an Excel analyst would need

Excel Author imageMax Mileaf Author imagesnacks Aug 10
Read

Your Invitation to the Pivot Party

Adventures in Excel

I know its been a while, but you'd be surprised how little time an energy you have when you're building a plane while you're flying it...or perhaps, if you've been reading along with this series, you won't.

Before jumping

Excel Author imageMax Mileaf Author imagesnacks Jul 21
Read

Slicing Excel: The Way of The Knife

Adventures in Excel

If you've been following along with the posts in this series, and you've been putting some of the scenarios into practice, you've now crossed a crucial juncture in your never ending quest to master the bloated beast that is Excel.

Excel Author imageMax Mileaf Author imagesnacks Jul 05
Read

Yes...If(And))

Adventures in Excel

If you've been following along on our proverbial Hogwarts for budding Excel wizardry, you would know that we recently crossed an important Rubicon upon which all Excel, and indeed all computer programming languages are built: The mighty IF statement. Remember,

Excel Author imageMax Mileaf Author imagesnacks Jun 20
Read

Getting Iffy With it

Adventures in Excel

If you've been following along, we discussed in the last several posts of this series how, if you're not working in a very "tech forward" organization (like my two compatriots on his site), but you have the same title, you're

Excel Author imageMax Mileaf Author imagesnacks Jun 10
Read

Taking Out the Trash

Dealing With Dirty Data Pt 2

In my last post, we explored the organizational structure of many large companies and how this pertains to one's duties as a fledgling data analyst. I highly recommend you go back and read the first post on "dirty" data, but

Excel Author imageMax Mileaf Author imagesnacks Jun 05
Read

Dealing with Dirty Data

Adventures in Excel

In my last post, we discussed what separates a true analyst (read: technical) from a project manager wearing the mask of an analyst like some Scott Snyder era Joker (I figure that there's a solid overlap between fans of comic

Excel Author imageMax Mileaf Author imagesnacks May 31
Read