The most prestigious law school admissions discussion board in the world.
|
 |
 
|
i would literally kill if i was forced to make spreadsheets all damn day
Poast new message in this thread
Date: November 18th, 2017 6:50 AM Author: mischievous antidepressant drug (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715644) |
Date: November 18th, 2017 6:51 AM Author: bonkers pocket flask patrolman (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715645) |
|
Date: November 18th, 2017 7:29 AM Author: mischievous antidepressant drug (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715780) |
|
Date: November 18th, 2017 7:31 AM Author: Bronze gaping eh playing around in excel can be fun and at least its mindless. (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715790) |
|
Date: November 18th, 2017 7:45 AM Author: Flirting bossy trailer park The main thing to do is properly normalize your tables then use Access to run spiffy reports. (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715851) |
 |
Date: November 18th, 2017 7:49 AM Author: Apoplectic casino police squad Link? (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715866) |
|
Date: November 18th, 2017 7:53 AM Author: Flirting bossy trailer park MS Access, part of MS Office but no one uses it. Or when they do they focus on how they want the final report to look and try to base the tables off of that, but that's ass-backwards. Gotta gitcho tables right.
Wikipedia has articles on database normalization, with examples of what it is.
Like if you're listing a bunch of different people's results on the same events that each occurred on the same days, then you need to put the events + dates in a separate table from the names + results and give each event a code that is referred to in both tables. Stuff like that. Normalize yo shit. Most n*ggaz ain't normalizin'. |
|
Date: November 18th, 2017 7:56 AM Author: Bronze gaping Access is 180 but i have no fucking idea how to use it. (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715897) |
|
Date: November 18th, 2017 7:59 AM Author: Flirting bossy trailer park I read lots of posts on database forums and stackexchange questions. The key issue is people focus too much on formatting reports but you need to focus on your table setup and join queries etc. That's where you need to understand normalization. It takes time but then becomes an A ha thing. (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715908) |
|
Date: November 18th, 2017 8:07 AM Author: chartreuse french telephone lettuce I'd assert it's very simple and except for syntax can be picked up in an afternoon, the problem is people are not used to thinking in clean categories, everything is all ajumble. (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715929) |
|
Date: November 18th, 2017 8:09 AM Author: Flirting bossy trailer park Agree 100% (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715939) |
|
Date: November 18th, 2017 7:46 AM Author: chartreuse french telephone lettuce I much prefer fucking around with spreadsheets to writing, which is 90% of what I do. The dolts at my office don't even know vlookup let alone hlookup, index(match), or the ALMIGHTY SUMPRODUCT. (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715854) |
|
Date: November 18th, 2017 7:51 AM Author: mischievous antidepressant drug what you just wrote makes me want to punch a wall (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715871) |
|
Date: November 18th, 2017 8:14 AM Author: coiffed deep love of her life Excel is so fucking prole, clunky, and verbose.
Chill aesthetic math bros: a . b
Prole industry fags: SUMPRODUCT(A$1:A$23, B$1:B$23) |
|
Date: November 18th, 2017 8:15 AM Author: chartreuse french telephone lettuce Intuitionism is a lie and axiom of choice is bullshit. Keep chasing skydreams you hippie. (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715958) |
|
Date: November 18th, 2017 8:00 AM Author: marvelous sick shitlib I'm in Excel all day but my final work product is PowerPoint. I just use Excel to crunch the numbers and then make a deck about what the numbers tell us. (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715913) |
|
Date: November 18th, 2017 8:02 AM Author: mischievous antidepressant drug how is this even "work" (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715918) |
|
Date: November 18th, 2017 8:05 AM Author: marvelous sick shitlib Oh, I also attend meetings. I'll make a big spreadsheet where the rows are all workstreams within a big project, and at the meeting I'll ask everyone for a status update on their part of the project and I'll update the spreadsheet with new info about how the project is going.
then I go make a PowerPoint deck summarizing what's new on the project, which I present to a C-suite exec |
|
Date: November 18th, 2017 8:06 AM Author: mischievous antidepressant drug jfc (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715927) |
|
Date: November 18th, 2017 8:10 AM Author: marvelous sick shitlib lol brother what would you rather do? be a lawyer who gets yelled at for minor punctuation errors in a written memo? (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715943) |
|
Date: November 18th, 2017 8:11 AM Author: mischievous antidepressant drug sales (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715947) |
|
Date: November 18th, 2017 8:11 AM Author: chartreuse french telephone lettuce You need to automate your workflow hehe (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715945) |
|
Date: November 18th, 2017 8:19 AM Author: mischievous antidepressant drug (((hehe))) (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715972) |