hamsterelderberry
113245
8916
449
May 7, 2016 3:30 AM
hamsterelderberry
113245
8916
449
maximuminnovationstevejobs
If you touch the mouse using excel more than once per hour you're a filthy peasant
CoffeeBaagel
This has been posted sooooooooooooooooooooo many tiiiiiiiiimes
Haemogoblink
Hey cool, I hadn't seen this this week yet. Thanks.
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
Roiniel
Thanks OP! I haven't seen this post here at all and this will help me get prepared for my new job!! +1
Caylin
Missed the perfect opportunity to title it "Excell in Excel"
donaldcocster
No
ExerNemesis
*Heavy Breathing* I...made it to the comments....
Mollehbuscus
Imgur needs to stop learning Excel and start learning common repost sense. This shit. On the fp. Every day.
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
finstad4
*Become a repost ninja
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/
Kaokenx10
Saving for never use
ThisIsGerbilReportingLiveFromRichardSimmonsAnus
Who keeps upvoting this shit?
mildblobfish
Wow this has been posted more times then Refugees have been allowed into Canada
aazak
.
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.
ijustwanttoplayhalflife3
This is so long I'm pretty sure it's just the manual that's been converted to infographics
CurlySpire
Scrolling to the comments section like I just finished a marathon
sublimedub
How many more times are we going to see this repost? Is there a formula???
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.
tiphlos
Commenting for later
PizzaFarts
How to become real ninja plz
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.
JakeSlager
Yeah, sure, but can you tell me why the Google Spreadsheet turns all my cells light green permanently?
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/
nameisunavailable
Why is this posted so much? are there really that many people on this site who use excel every day?
Keydan
As an engineer I use advanced Excel and some home-made macros to calculate heat and cooling loads for small-medium houses.
Aerolfoz
Lot of people that work in offices and browse while working? Apparently in those jobs excel is so ridiculously useful.
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.
Lexsteel11
All day erry day.
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
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
4Endymion
Yes, the people with jobs.
GoAheadAndCallMeG
I used to use sheets!
blzbob
I am so sorry.
Pyrohawk
I do.
missmurphay
I can't remember a day in probably 10 years that I haven't used excel
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).
Natara93
I make around 5-10 excel spreadsheets a day for work
bloobaloo2
What's in them?
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/