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: flesh casino (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715644) |
Date: November 18th, 2017 6:51 AM Author: Azure Swashbuckling Hospital Twinkling Uncleanness (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715645) |
|
Date: November 18th, 2017 7:29 AM Author: flesh casino (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715780) |
|
Date: November 18th, 2017 7:31 AM Author: fear-inspiring dopamine space 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: white stirring idiot 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: Excitant Coral State Idea He Suggested Link? (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715866) |
|
Date: November 18th, 2017 7:53 AM Author: white stirring idiot 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: fear-inspiring dopamine space 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: white stirring idiot 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: garnet unholy roast beef 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: white stirring idiot Agree 100% (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715939) |
|
Date: November 18th, 2017 7:46 AM Author: garnet unholy roast beef 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: flesh casino 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: appetizing office elastic band 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: garnet unholy roast beef 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: Concupiscible Sticky Abode Toilet Seat 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: flesh casino 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: Concupiscible Sticky Abode Toilet Seat 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: flesh casino jfc (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715927) |
|
Date: November 18th, 2017 8:10 AM Author: Concupiscible Sticky Abode Toilet Seat 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: flesh casino sales (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715947) |
|
Date: November 18th, 2017 8:11 AM Author: garnet unholy roast beef 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: flesh casino (((hehe))) (http://www.autoadmit.com/thread.php?thread_id=3801409&forum_id=2#34715972) |