D.L. Smith

HARRY POTTER 20th Anniversary Thai Edition - cover art by ARCH APOLAR

Soulmates~ 

This comic might be a bit sad (It made me sad to TOT) BUT it has a happy ending!! That counts right?

This is my first time drawing drarry as girls, it was a fun experience lol

more Drarry in our life

I tell everyone this and I mean it. Buy a journal. Carry it with you everywhere you go. And I mean everywhere. Write about your favorite moments, your least favorite moments, ideas, grocery lists, people you’ve met, strangers you’ve walked past on the street, favorite quotes, words to remember, what the sky looked like at 7pm, new songs you’ve discovered and what they mean to you, your childhood, places you want to go or places you’ve been, write about your passions, how you feel in this exact moment, draw out the mountains, scribble all over the pages. And when that one gets full, buy a new one. Reread it in 2 years, 20 years, when you need a good laugh, when you’re crying on your bathroom floor, read it to your children. You need to remember these moments in your life. They are so important.

omg at the ellie wardrobe ask this what her closet looks like in my head low-key

omg i wish it looked like this in my head… like she’d look so good 💗 unfortunately this is how i see her dressing 😐

I want you all to know that an Arab Muslim from Tunis proposed the Theory of Evolution near 600 years before Charles Darwin even took his first breath. Don’t let them erase you.

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

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.

Harry describing Draco: that gleaming white-blond hair tho. those glittering pale grey eyes tho. that smirk and that swagger and that drawling voice tho. that pale skin tho. that faint blush tho. 

Harry describing Ginny: red hair 

Reblog if you're a Ravenclaw.

gryffindor | hufflepuff | slytherin