Recent comments in /f/LifeProTips
TwinkleSprinkle27 t1_j99azh8 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
Recommendations, please!!!
(…ideally, free & geared more toward beginners)
What is the best explainer or “how-to” guide for Excel’s most useful functions?
BIessthefaII t1_j998l3s 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
Now I need a YSK of where to go to better learn them
JethroFire t1_j9960df wrote
Reply to comment by jj-reeder 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
Fuuck, I came here to say this and you beat me to it. I like Index and Match, too. Also MaxIfs and MinIfs are super cool functions.
Phx86 t1_j98zrj8 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
Excel can both run or ruin a business, at the same time.
sometimeagreatnotion t1_j98ytma 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 think if teachers and professors started creating tasks/work that surround excel usage it’s a great way to learn by doing and showing the value of excel both in high school and Uni/college. Its such a key skill employers are looking for and not too difficult to pick up on your own.
It is amazing how so many people marvel or claim “you’re a wizard” when you can demonstrate basic and intermediate excel functions that help automate work tasks, and you’re like, “uh no I just watched a video to learn how to do it.” But also I’ve also been amazed at the resistance to learn how to continue using excel in more effective and advanced ways by co-workers.
Good-Astronomer-1138 t1_j98y572 wrote
Reply to comment by textris 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
This has been replaced by XLOOKUP now
PatrickKieliszek t1_j98xyao wrote
Reply to comment by textris 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
Index Match is good if your data set is large and you're worried about execution time.
For small data I almost exclusively use xlookup.
turtleheadmaker t1_j98vzaq wrote
TheShaggyRogers23 OP t1_j98vvur wrote
Reply to comment by turtleheadmaker in LPT: Condense a thought or an idea down to a single word, and make a mental list of these Individual words until they can be recorded elsewhere and cleared from the mind. by TheShaggyRogers23
"Why waste time say lot word when few word do trick?"
turtleheadmaker t1_j98vm5g wrote
Reply to comment by TheShaggyRogers23 in LPT: Condense a thought or an idea down to a single word, and make a mental list of these Individual words until they can be recorded elsewhere and cleared from the mind. by TheShaggyRogers23
TL;DR: one word summaries help retain ideas
TheShaggyRogers23 OP t1_j98ve1v wrote
Reply to comment by turtleheadmaker in LPT: Condense a thought or an idea down to a single word, and make a mental list of these Individual words until they can be recorded elsewhere and cleared from the mind. by TheShaggyRogers23
TL;DR: When you can't immediately write down your recent ideas, reduce them to one-word summaries and keep a mental record of these words. Not only will this approach enable you to retain more ideas, but it will also allow you to navigate between them effortlessly.
[deleted] t1_j98t5vy wrote
sadiesaysit t1_j98sfxp wrote
Reply to comment by VDubDJ 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
Thanks for the information!
sadiesaysit t1_j98sd75 wrote
Reply to comment by Just-Take-One 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
Thanks for your advice! I’ll start with a simple budget and start playing around with it.
trymypi t1_j98qpid wrote
Reply to comment by pedrodteixeira 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 put a class together for exactly this last semester. Most students were pretty happy but one thought it would be better for me to have taught Photoshop haha. (There's already a class for this)
turtleheadmaker t1_j98qmuo wrote
Reply to LPT: Condense a thought or an idea down to a single word, and make a mental list of these Individual words until they can be recorded elsewhere and cleared from the mind. by TheShaggyRogers23
Take your own advice and shorten the post.
textris t1_j98qeoo wrote
popejubal t1_j98pxqf 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
Knowing the phrase “pivot tables” wasn’t the sole reason I was hired for my current job, but it was a big factor.
Just-Take-One t1_j98p8b0 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 Web is good enough for most users. You don't even need to learn any fancy commands, just simple mathematics is, again, good enough for most users. Google sheets will have all the same basic commands, just in a slightly different interface.
I've always found a personal budget to be a good learning tool. Write some expense labels on the rows, months in the columns, fill in a dollar amount in the middle and have a total column at the end. Formulas all follow the same general layout "=A1+B1+C1+D1". You can use mathematical functions too like "Sum" and "Average" etc which would look like "=SUM(A1:D1)".
Basically, just use it as a fancy calculator while you're learning.
mikelwrnc t1_j98kr97 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
But also learn when you need a more advanced tool. Do not use it for anything but the most trivial data analysis for example. Move to R or Python for that.
FoghornLegday t1_j98kgjz wrote
Reply to LPT: Condense a thought or an idea down to a single word, and make a mental list of these Individual words until they can be recorded elsewhere and cleared from the mind. by TheShaggyRogers23
I don’t think the way your mind works is anything comparable to the way my mind works. Like, at all.
roodypoo29 t1_j98jo7p wrote
Reply to comment by jlav18 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
Seems like you're winning the workplace hourly system
VDubDJ t1_j98h2gw 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
W3schools is free and has a bunch of great intro stuff
TheShaggyRogers23 OP t1_j99c3ud wrote
Reply to comment by FoghornLegday in LPT: Condense a thought or an idea down to a single word, and make a mental list of these Individual words until they can be recorded elsewhere and cleared from the mind. by TheShaggyRogers23
Are you like really good at remembering things?