Recent comments in /f/LifeProTips
Aretemc t1_j9abt01 wrote
One piece of advice I’m not seeing: switch all the time pieces you own (that you can) to the 24hr clock. You don’t want to glance at a clock and get a shot of adrenaline thinking you’re late for work, but you just confused am with pm because you’re sleep deprived. 17:00 is quicker to read than 5:00 pm.
keepthetips t1_j9aboxn wrote
Reply to LPT request: how to feel happier and more upbeat when waking up super early? by FoxCharacter5108
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.
shastaxc t1_j9abnf1 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
I agree on the budget idea. I was just updating mine yesterday. I like to tag each expense with the account name that will pay it. I split my expenses to different accounts for different reasons, like shared expenses with my partner get paid from a joint account. I also think it's not fair to split joint expenses 50/50 because we make very different salaries so we split it according to the proportion of our post-tax income. So I have a formula that does all the math and then tells me how much money I need to deposit into the joint account each paycheck to cover those expenses, and same for my partner. I get paid twice a month whereas she gets paid every 2 weeks, so even if we split the bills 50/50 our deposit amounts per paycheck would be different.
It does a lot of other stuff too. This could all be done as quickly by hand the first time, but where spreadsheets really shine is reusing them later. Now, whenever I need to change an expense amount (prices for stuff change over time), add/remove expenses, or change income (which happens every year), all the info I need is recalculated instantly.
Blocky_Master t1_j9aaqvj wrote
Asisreo1 t1_j9aapoe wrote
Reply to comment by Trickycoolj 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
I took macro-econ in uni, but they never taught me excel. The most excel lwarning I got was from engineering finances class.
shastaxc t1_j9aakw9 wrote
Reply to comment by Septopuss7 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
Yeah you might wanna get a new job. Having a short-sighted boss is a pretty clear indication that the place is never going to expand and flourish.
keepthetips t1_j9aahge 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.
shastaxc t1_j9aad45 wrote
Reply to comment by Trickycoolj 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
Kinda not really the point. Excel should be taught in gen ed
[deleted] t1_j9a9no8 wrote
[removed]
scarlett1263 OP t1_j9a8znq wrote
Reply to comment by VVG8 in LPT request: how to get rid of spider nests? by scarlett1263
I just moved in lol
VVG8 t1_j9a8vzy wrote
Move to another house
thequicknessinc t1_j9a8ugh wrote
Reply to comment by carjo78 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
No, yikes that you talk about your co-workers like that.
Good-Astronomer-1138 t1_j9a8hqd wrote
Reply to comment by tomistruth 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
You can also denote a value for blanks and select a search order at the end : so like xlookup(value, search range, return range, “”, 1) would default all blanks to blank and sort in the default way
wristpins t1_j9a87jq 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
I will warn you, people will pawn their excel work off on you. I showed a coworker my sheet that had simple stuff like sumifs or match, now I get asked a bunch of stuff. It's cool people want to learn, but people really have very little understanding of excel outside basics
RobertJ93 t1_j9a7d47 wrote
carjo78 t1_j9a73s7 wrote
Reply to comment by thequicknessinc 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
Lol. Im dealing with one right now. I may have to hit him with my keyboard....
tuhn t1_j9a6p7m wrote
Reply to comment by schmancie-2 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
Horizontal lookup (hlookup) instead of Vertical lookup (vlookup).
It just looks from columns instead of rows.
aqxea2500 t1_j9a6i2i 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
When I went to trade school I remember taking a spreadsheet class, and was honestly amazed at what you can do with excel. I seriously feel like an idiot for not learning it better in school.
tuhn t1_j9a6gpe wrote
Reply to comment by [deleted] 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
Python is much harder. Also you can't just run Python everywhere.
Being an Excel wizard takes about 2 weeks of studying, being a Python wizard takes years.
gargravarr2112 t1_j9a6e3a wrote
Reply to comment by Katzeye 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
When you consider Excel auto-formats data basically as it likes, whether it makes sense or not, this explains a LOT about the world's economy...
gargravarr2112 t1_j9a6aeh wrote
Reply to comment by hacktheself 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
Remy's 0th Law of Software Development:
> At the end of the day, all the user really wants is Excel.
maurinet79 t1_j9ac8zc wrote
Reply to LPT request: how to feel happier and more upbeat when waking up super early? by FoxCharacter5108
Some people consider themselves "morning" people because they naturally wake up in a good mood, some people just can't get in a good mood in the morning. Having said that, it's all in your attitude, it depends how you confront that situation, but you can help it by: Playing some cool upbeat music (i.e.: James Brown - I feel good), get enough sleep, have enough time to prep so you're not in a hurry (stressor), warm shower, coffee, etc.