Hacker Newsnew | past | comments | ask | show | jobs | submit | captainill's commentslogin

Does anyone have a good resource for learning to write beginner through advanced formulas?


Not to be snarky but, Just start. Pretty much every excel user is self taught. You can google for the name of the formula that is helpful for your use just like you would programming.

Most of what separates a power user from an average joe is having an approach to the problem and laying the foundation in a way to be a “model”.

I’m seen as a power user even within my peer group of finance folks. I just have a way of laying things out and breaking up the problem from data/inputs to print ready outputs. I’m not usually doing anything fancy like using obscure formulas. But when I do, I like these;

* Use -- to convert Boolean to integer * Use index/match instead of vlookup (you can more easily insert/delete columns without breaking) * make yourself a style guide (so you know what a color means; hard value, input, etc) * avoid volatile functions. Learn what functions are volatile * get good at auditing formulas/debugging. It's really just takes experience


Not quite what you want but try this anyway. "You suck at Excel" by Joel Spolsky

https://www.youtube.com/watch?v=0nbkaYsR94c


You can look at a few of the sheets people link to here and just fiddle around with changing things too to see what happens


This is not a good experience. Very bizarre choice.


Props to the OP/author for both the article and receptivity to critique regarding UX here in comments.


Thank you! Just added a scroll toggle.


This. Would love to know but am not willing to scan photos of excrement to do my own analysis. I have my own personal experience of living in SF for 10 years, in the Mission. I’ve seen a lot of human looking fecal matter.


Been really enjoying workona as well. Have found myself recommending to folks on my team. I organize my tabs into their “workspaces” which map to the strategic and tactical projects I’m juggling. Helps me switch btwn contexts


-Apps, mega niches, are the future! (Yeap)

-Don't let any one app to be the sole place a user gets his content (I'm with you here as I didn't create Facebook)

-Parse is no more (I read that somewhere too)

-Now you can focus on leveraging an existing platform to bring engaging content to your users. (What if I want to service a mega niche that doesn't exist or generally wish to be foolish enough to believe I can compete with my idea? Wouldn't it be convenient to leverage a Backend as a service like parse? Shame they shutdown)


If you've ever taken antibiotics for an extended period and ended up with a fungal infection due to the loss commensal bacteria this is pretty intriguing. There is a lot of new literature proposing links between gut disruption and neurodegenerative disease.


Maybe antibiotics cause Alzheimer's.


He's using -webkit-font-smoothing: antialiased; With this sort of font it looks terribad. You see this way to often. I've been guilty of it by proxy when another dev comes in and applies this style to the <body>


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: