Recent comments in /f/LifeProTips

4Ozonia t1_j9a59f6 wrote

Reply to LPT: Take a few days to familiarize yourself with a spreadsheet app (e.g., MS Excel, Google Sheets). The uses are endless for school, the office, life, and other people will think you're a wizard. by tophswanson

Debating whether to buy Office for our new laptop, or just learn Google Sheets better. Retired, so this is for home things like Christmas card lists, and other spreadsheets. I will look on YouTube to see how to sort, add, etc.?

2

Jill_X t1_j9a4ils wrote

Reply to comment by sadiesaysit in LPT: Take a few days to familiarize yourself with a spreadsheet app (e.g., MS Excel, Google Sheets). The uses are endless for school, the office, life, and other people will think you're a wizard. by tophswanson

Excel is probably the most wide-spread tool in offices.

My favourite is Google Spreadsheets / Docs, as it runs on almost any device with a browser and in an app on my Android phone. It also allows multiple users to view, comment on and edit the same document.

Then you have open office / libre office, which are open source clones of excel. They however use open document file formats, which are not supported by Excel.

Overall, they all work very similarly with slight differences in how to format formulas.

So, learning any of them gets you half-way to knowing the other.

2

Heyhihello04 t1_j9a4489 wrote

Reply to LPT: Take a few days to familiarize yourself with a spreadsheet app (e.g., MS Excel, Google Sheets). The uses are endless for school, the office, life, and other people will think you're a wizard. by tophswanson

Where I work you're punished with more work if you admit to knowing how to use these programs because you're suddenly the only person in the office who knows how to use them right so everyone comes to you to do anything that involves these programs to no benefit to you.

2

Able_Kaleidoscope_61 t1_j9a3ocb wrote

Reply to LPT Request: How to best adjust to the night shift? by Vidableek

You can shift your sleep schedule to fool your circadian rhythm to match your work schedule. It takes about a week or two. As other comments have mentioned, blackout curtains are a must. A white noise machine is very helpful too. Sunlight keeps you entrained to the usual day night cycle; But block your eyes from getting 440-460 nm blue white light, and your body will think it's night. You should also get some blue light blocking glasses to wear the drive home to block the same light. Get 15-30 minutes of bright sun when you wake up in the afternoon to clue in your circadian rhythm.

Bonus tips:

  1. It's easier to advance your circadian rhythm (staying up later each night)than delay you circadian rhythm (trying to go to bed early each night).

  2. Tell your healthcare provider. They can get you special medication to help with alertness & mood. It does nothing for your circadian rhythm, but is nice to have for those day you don't get much sleep before work due to daytime obligations.

5

tinkersdamn t1_j9a31pj wrote

Reply to comment by BIessthefaII in LPT: Take a few days to familiarize yourself with a spreadsheet app (e.g., MS Excel, Google Sheets). The uses are endless for school, the office, life, and other people will think you're a wizard. by tophswanson

Right? Like 'Google some videos' gets me nowhere. I need a curriculum.

Edit: I just google 'best indie online courses to learn excel', read the first six articles (Eg 'Top 10 courses to learn Excel) and there was literally not one single duplicate among them. The consensus does seem to be that you really don't need to pay to learn.

3

keepthetips t1_j9a26i5 wrote

Reply to LPT request: how to get rid of spider nests? by scarlett1263

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

esp211 t1_j9a11st wrote

Reply to LPT: Take a few days to familiarize yourself with a spreadsheet app (e.g., MS Excel, Google Sheets). The uses are endless for school, the office, life, and other people will think you're a wizard. by tophswanson

Anything that has to do with numbers, I use Sheets. I think in terms of spreadsheets and I have all of our finances on one document.

I planned out our life to age 100 with all expected income, investments, pension, social security, etc. including pessimistic and optimistic outcomes.

Knowing how to to do spreadsheets is probably the single best skill in any job.

1

CheeseMakingMom t1_j9a0xr4 wrote

Reply to LPT Request: How to best adjust to the night shift? by Vidableek

I work 6:30pm-5am. I’ve invested in a blackout curtain for the bathroom/en-suite and a well-fitting sleep mask for darkness. A low dose of Melatonin helps me get back to sleep (I’m an extremely light sleeper.) I frequently use white noise to distract me from the neighbors’ motorcycles, parties, classic cars, and other neighborhood sounds - I particularly like rain.

My bed is comfortable. I keep the room temperature a little lower so I can snuggle and curl up in my covers. This is easier in cool months than, say, August.

I generally plan my meals by my body clock, so I’m eating oatmeal or an English muffin with coffee at 4pm, a sandwich or leftovers at 11:30pm, and a larger meal when I get home as my dinner. My slow cooker is amazing for that, I dump the ingredients in before I leave for work, and get home to a wonderful-smelling house and virtually zero prep.

I try to stay on my night schedule when I’m on my weekend, which is why it’s 3:45am and I’m listening to classical music as I’m working on my class in Employment Law.

Good luck!

35