davantrask

[davantrask]

I LOVE Excel! I took an Excel class during University and I’ve never stopped using or learning about it since. During my summer internship, I would literally use Excel functions and macros for hours every single day. Even if you don’t want to be an Excel fanatic, learning a few basic functions will make your life easier (and even impress a few managers along the way!).

I’ve outlined below some of the most useful Excel functions to learn. Some of these functions are very basic but can make a huge difference. These functions save time, automate procedures, and make your life easier! And if you need some help on how to learn them, I’ve listed some helpful resources to get you started. With all of us social distancing at home, now is as good of a time as any to add a skill to your resume. 

Excel Functions to Know:

SUM: returns sum of cells selected

SUMPRODUCT: multiplies ranges or arrays together and returns the sum of product

IF: return one value for a TRUE result and another for a FALSE result

SUMIF: returns the sum of cells if the cell meets a single condition

AVERAGEIF: computes the average of the numbers in a range that meets a certain criteria

VLOOKUP: lookup and retrieve data from a specific column in a table can be exact or approximate match

LEFT: returns a given number of characters from the left side of text string

RIGHT: returns a given number of characters from the right side of text string

CONCATENATE: joins the text of cells together and returns the joined text in one cell

LENGTH: returns the given number of characters in a text

Resources:

Excel Jet: Very useful as a type of Excel dictionary to look up syntax and specific formulas you don’t know

Excel Easy: almost like on online textbook for Excel (great resource for those who have no knowledge of Excel at all!)

Udemy: paid excel course with lots of videos, assignments, and downloadable resources

Coursera: self-paced learning option, quizzes and assignments, and a course certificate

Excel Youtube Course by Technology for Teachers and Students

Datacamp (7/12/20 edit thanks anon for the suggestion!)

Prologue to my Excel series

I’ll also be posting Excel tips, tricks, function explanations, and some basic Excel tutorials so if you’d like to see more appear on your dash in the future, follow my blog and look for my Excel series.

[davantrask]

get you a man who can do both

[davantrask]

I am mad about cellphone cameras hiding the processing they do, and I am glad about software that lets me control it and opt in and out, and I dictated this rant on insta so I am resharing the images here and will attempt to turn this into a useful text post on my blog in future, when my hand is working better 🤘👍

[davantrask]

oh. my. god.

I have never been so thoroughly called out in my life.

people love to complain about sex scenes in tv shows and violence in movies when the real danger is scenes that make you feel second hand embarrassment.

[davantrask]

(Bruce Wayne voice) I’m Bruce Wayne, from Gotham City, I’m participating in Nailed It! because for years I’ve tried to learn how to bake to impress my father [cuts to old pic of baby Bruce trying to whisk in a bowl, wearing a crooked chef hat, Alfred trying to help him with a really loving look on his face], and- (someone in the background yells LIAR!!) (Bruce covers his face, the background music stops) fine I lost a bet to one of my kids and they thought it would be hilarious for me to participate because I’m terrible in the kitchen [cuts to picture of grown Bruce with a pan on fire, looking absolutely frantic, sad trombone sound] [the people behind the camera laugh]

[davantrask]

SCREAMPT

[davantrask]

What do normal people who haven't had half their personality shaped by the lord of the rings think about when they are scraping butter across bread?

[davantrask]

5 simple exercises to awaken dormant muscles

{source}

[davantrask]

The Dungeon Meshi renaissance is making me want to share the resources that taught me how to cook.

Don’t forget, you can check out cookbooks from the library!

Smitten Kitchen: The rare recipe blog where the blog part is genuinely good & engaging, but more important: this is a home cook who writes for home cooks. If Deb recommends you do something with an extra step, it’s because it’s worth it. Her recipes are reliable & have descriptive instructions that walk you through processes. Her three cookbooks are mostly recipes not already on the site, & there are treasures in each of them.

Six Seasons: A New Way With Vegetables by Joshua McFadden: This is a great guide to seasonal produce & vegetable-forward cooking, and in addition to introducing me to new-to-me vegetables (and how to select them) it quietly taught me a number of things like ‘how to make a tasty and interesting puréed soup of any root veggie’ and ‘how to make grain salads’ and ‘how to make condiments’.

Grains for Every Season: Rethinking Our Way With Grains by Joshua McFadden: in addition to infodumping in grains, this codifies some of the formulas I picked up unconsciously just by cooking a lot from the previous book. I get a lot of mileage out of the grain bowl mix-and-match formulas (he’s not lying, you can do a citrus vinaigrette and a ranch dressing dupe made with yogurt, onion powder, and garlic powder IN THE SAME DISH and it’s great.)

SALT, FAT, ACID, HEAT by Samin Nosrat: An education in cooking theory & specific techniques. I came to it late but I think it would be a good intro book for people who like to front-load on theory. It taught me how to roast a whole chicken and now I can just, like, do that.

I Dream Of Dinner (so you don’t have to) by Ali Slagle: Ok, look, an important part of learning to cook & cooking regularly is getting kinda burned out and just wanting someone else to tell you what to make. These dinners work well as written and are also great tweakable bases you can use as a starting place.

If you have books or other resources that taught you to cook or that you find indispensable, add ‘em on a reblog.

[davantrask]

(found here, if anyone has an actual source I’d love to link it properly, as I can’t decipher the signature)

[davantrask]

how crazy do you think the AO3 authours notes are in gotham?

"Joker killed my grandma with a reindeer whilst playing 'grandma got run over by a reindeer' and i don't think i can continue to write this JokerBat fic anymore guys sorry :/ it just feels disrespectful."

“Look, I get if Batman/Clark Kent isn’t your cup of tea, but the guy writes more about Batman than anyone else outside of Gotham. There’s got to be a reason, is all I’m saying.”

“And here I am, jumping on the Batman/Bruce Wayne train like the rest of our beloved hellhole. Anyway, if you’re not from Gotham you can keep your criticisms to yourself or I will not be held responsible for the bloodshed that will occur should you insult our beloved sunshine child and his goth sugar baby. You don’t know them like we do.”

“Hey, sorry I haven’t updated in awhile. I died and then got caught up in this whole my-father-didn’t-avenge-me angst thing. Which was completely justified in my opinion. Anyway…”

“Let’s be honest, this entire series is dedicated to the fact that Red Hood could crush any of us with his thighs and we’d say thank you.”

“I just read a fic shipping Nightwing/Superman and I mean, come on. The author is clearly not from Gotham but I can never unsee that and I think I should be entitled to financial compensation.”

“Sorry it’s been awhile, I just got a new job! With the Best Boss™️ (if you know, you know). Also, my boss said he’d give a hundred bucks if I wrote a Batman bashing fic? Thoughts? Ngl I don’t think it’d even be that hard.”

“‘WHy aRE yoU WriTIng ABouT FakE SupERheROes WHen THe rEAl oNEs aRE riGHt tHEre?’ Uh, because it’s Gotham and they’re all a disaster? And also because I don’t want to be haunted by the venegeful spirits of robins past idk. Thinking of doing a crossover though. Batman in the Avengers? Thoughts?”

“I just want my husband Nightwing to be happy, is that too much to ask?”

“I came across Harley Quinn and Poison Ivy on my way home from school today and will now be hyperfixating on that ship, thanks.”

“Leave me and my 235k word fic of Prince!Bruce/Knight!Batman alone you Metropolis and Superman-loving traitors. This is not for you.”

[davantrask]

this is targeted tumblr content

[davantrask]

I've always disliked the "I Am No Man" moment in Peter Jackson's Return of the King because it fails to capture the fact that when the Witch King threatens Eowyn with horrific unimaginable torment, she responds by making him soil his ghostly britches.

[davantrask]

I was making chitchat with the woman who works at the plant nursery and I mentioned that two baby trees I bought the other day aren't doing too well, their leaves are yellowing, maybe I'm watering them too much? what could be behind this phenomenon? and she looked like she was trying to find a gentle way to phrase it but then gave up and just said plainly, "Autumn."

another social interaction that will come back to haunt me at 3am five years from now

[davantrask]

Do any of you know about that one painting with Aphrodite being born out of lava with a black swan by her side or did i completely hallucinate that? Been searching for a while but i can’t find it for shit.

[davantrask]

put your number (0-20) in the tags!!!!!! i think i got 14!!

anyone who comments that finding ways to enjoy the brief time we have on this bitch of an earth is cringey will be blocked ^_^ <3