hamsterelderberry
113255
8916
449
May 7, 2016 3:30 AM
hamsterelderberry
113255
8916
449
oddworldcrash
Favourite and forget? Nah, this is probably already three times in my favourites. Enough is enough.
notaballoon
Anyone who works in Excel knows your boss thinks a monkey could do your job despite that they don't even know how to drag fill date lists
Haemogoblink
Hey cool, I hadn't seen this this week yet. Thanks.
CoffeeBaagel
This has been posted sooooooooooooooooooooo many tiiiiiiiiimes
finstad4
*Become a repost ninja
Mollehbuscus
Imgur needs to stop learning Excel and start learning common repost sense. This shit. On the fp. Every day.
sublimedub
How many more times are we going to see this repost? Is there a formula???
donaldcocster
No
tiphlos
Commenting for later
PizzaFarts
How to become real ninja plz
CurlySpire
Scrolling to the comments section like I just finished a marathon
aazak
.
Caylin
Missed the perfect opportunity to title it "Excell in Excel"
dmbelafan
I generally just move past posts I don't want to upvote cuz I always feel a little bad downvoting...not today. Not today.
maximuminnovationstevejobs
If you touch the mouse using excel more than once per hour you're a filthy peasant
Papagelos
Favorited. Now I gotta figure out a scenario where I have this open while my boss walks in and I lie, telling him Im almost done reading it.
turimbar
I don't know if this is Ninja level. I would expect 90% of this to be known by anyone at entry level in any office setting.
sinbios
VBA macros? Joining spreadsheets to database tables through ODBC? No? What's it got then? Oh... oh it's got flash fill... ಠ_ಠ
turimbar
I would argue against VBA macros at my work, since R will usually do it better. Having "expertise" in Excel isn't really marketable, IMO.
theeconomistnonotthatone
I don't know about entry level, but I agree that this wouldn't qualify one to be an expert.
anobledenby
Cheat sheets like this help SBO like me from wasting time staring blankly at #'s, Fx's and gobbledygook of the like. Here's an up vote
JakeSlager
Yeah, sure, but can you tell me why the Google Spreadsheet turns all my cells light green permanently?
ijustwanttoplayhalflife3
This is so long I'm pretty sure it's just the manual that's been converted to infographics
ThisIsGerbilReportingLiveFromRichardSimmonsAnus
Who keeps upvoting this shit?
ExerNemesis
*Heavy Breathing* I...made it to the comments....
Greeneyeddevil
I'mma have to reapply for my current job in the next few weeks and this just might come in supremely useful for me. Thanks.
Roiniel
Thanks OP! I haven't seen this post here at all and this will help me get prepared for my new job!! +1
GlacialFlour
Why did I have to scroll so far to favourite this? I have no time, I need to waste my time on other things.
Kaokenx10
Saving for never use
theeconomistnonotthatone
I say this every time. If you don't understand time series econometrics, don't use "Forecast". It doesn't give you any goodness-of-fit 1/
theeconomistnonotthatone
of statistics, so you have no clue how well the model fits the data. If you did know TS econometrics, you wouldn't want to use it anyway. 2/
nameisunavailable
Why is this posted so much? are there really that many people on this site who use excel every day?
ConcreteInterface
If my company took Excel away from me, I would just quit. Straight up "Fuck you dudes! Meowt!"
thzknee5nfriedchkn
I use excel every day. Every. Single. Damn. Day.
4Endymion
Yes, the people with jobs.
Aerolfoz
Lot of people that work in offices and browse while working? Apparently in those jobs excel is so ridiculously useful.
Keydan
As an engineer I use advanced Excel and some home-made macros to calculate heat and cooling loads for small-medium houses.
andthenwhatdoiknowaboutdiamonds
I use excel all day to track my power plant's budget and to compile emissions and output data for reports. This is helpful to me
Natara93
I make around 5-10 excel spreadsheets a day for work
bloobaloo2
What's in them?
Pyrohawk
I do.
missmurphay
I can't remember a day in probably 10 years that I haven't used excel
TairaMai
A lot of people are forced to use Micro$oft office at work because it's "the standard[tm]": meaning it was forced on them by IT.
sinbios
Or, I dunno, because all the alternatives blow?
TairaMai
Open Office, Libre Office, them's free. Wordperfect is expensive and teh suck since Corel refuses to make any changes
GoAheadAndCallMeG
I used to use sheets!
blzbob
I am so sorry.
thewurstbrat
I use excel 8 hours a day and browse imgur 3 hours a day. Sometimes at the same time. That being said, I don't need this stupid post.
idelta777
What about a post on how to become an imgur ninja?
thewurstbrat
Step 1: open important looking excel file. Step 2: open imgur app on phone. Step 3: set phone down when boss approaches. Step 4 : repeat
Grahamdalf
I use it every day. It's good for changelogs and predicting and managing benchmark data (I design simulator software).
Lexsteel11
All day erry day.
sinbios
Would someone who uses Excel every day already know all this crap? Who is actually making use of this?
blzbob
The person who just had to start using Excel everyday like the rest of us. :)
Sensino
Use Libre Office instead (it's the Open Office source code but it's still being developed, since Open Office was bought)
theeconomistnonotthatone
Libre/Open Office are acceptable alternatives if you are doing elementary excel tasks or only need the spreadsheets for internal use. 1/
theeconomistnonotthatone
I use very powerful commercial statistical software plugins and my spreadsheets have to be used or reviewed by people outside of my 2/
theeconomistnonotthatone
company. Software like that is typically (inlc. the program I use) not available in Libre/Open Office, and the wide spread use of MS Excel3/
theeconomistnonotthatone
means that I don't have to worry about compatibility issues as much as I would with a less widely used spreadsheet program. 4/
Scratch777
Curious. I want to type into a cell a thing and have it highlight certain cells based on what I type, is there any way to do that WITHOUT
Scratch777
Including text in the cells, like hidden attributes?
theeconomistnonotthatone
Trying to understand the question: So you want, for example, cell A1 to become highlighted green if you type "Buy" into it?
Scratch777
Sorta yeah that sounds about right.
Scratch777
It's for a spellbook, type in a thing like NECROMANCY and it highlights all of the NECROMANCY spells in the sheet.
theeconomistnonotthatone
Okay, what you want is conditional formatting. So, first highlight the column that lists spell types. Then go Home>Styles>Conditional... 1/
theeconomistnonotthatone
Formatting>New Rule>Format Cells that Only Contain> ... Then in the section "Edit the Rule Description" choose "Specific Text" and 2/