Recent comments in /f/LifeProTips

jlav18 t1_j98cm22 wrote

I used to use to manually crunch the data (took a while to do) now using self taught pivot tables and VLookup what used to take all day, now takes me 30 mins to do…

I don’t know what to do with my free time now and feel weird like I am doing “less work” and tend to sit at my desk with nothing to do… am I cheating the work place hour system?

17

sadiesaysit t1_j984xb8 wrote

I never learned the skills but I’ve been wanting so bad to learn but confused on whether to learn Excel, googlesheets (isn’t that a thing?), or something else. What would I be using it for? I don’t know but let’s go with life and business information. What specific resources, YouTube or tutorials would you recommend?

8

PM_ME_FUNFAX t1_j97yjdk wrote

Oh yeah, at my last job I automated time tracking with production vs downtime... Every minute has to be accounted for. All I did was have it do the math with inputs and a few vlookups for other spreadsheets on the company network. Saves me, and eventually a lot of people, a whole lot of time. Haven't worked there in years and the operators are still using it.

15

bassbahl t1_j97yhdo wrote

Spent some time in the last year learning various filters, array formulas, and other ways to automate things I do every day. Such a massive time saver. I show things to others and like you said I’m looked at like a wizard.

Then I show them simple databases like Airtable…

Cheers fellow spreadsheet enthusiast!

44

keepthetips t1_j97tizj wrote

Hello and welcome to r/LifeProTips!

Please help us decide if this post is a good fit for the subreddit by up or downvoting this comment.

If you think that this is great advice to improve your life, please upvote. If you think this doesn't help you in any way, please downvote. If you don't care, leave it for the others to decide.

1

keepthetips t1_j979x9p wrote

Hello and welcome to r/LifeProTips!

Please help us decide if this post is a good fit for the subreddit by up or downvoting this comment.

If you think that this is great advice to improve your life, please upvote. If you think this doesn't help you in any way, please downvote. If you don't care, leave it for the others to decide.

1

Okay_Bluebird t1_j9516hv wrote

Be sure to put bras and anything delicate in a mesh bag. You also should sort your laundry by colour and hang it to dry. I also recommend not overlooking ironing. Having things not wrinkly and creased nicely in the right place makes them feel better to wear! I only use conditioner when I want something softer or if I’ve accidentally shrunk something. If that’s the case I hand wash with hair conditioner in the sink.

1

Flair_Helper t1_j94oxn7 wrote

Hello Jaques-Le-Tits, thank you for your submission! Unfortunately, it has been removed for the following reason:

Your post is not a life pro tip. Advice is any guidance or recommendation concerning prudent future action. An aphorism is a short clever saying that is intended to express a general truth or a concise statement of a principle.Try r/YouShouldKnow.

If you would like to appeal this decision please feel free to contact the moderators here. Do not repost without explicit permission from the moderators. Make sure you read the rules before submitting. Thank you!

1