Discover Top Posts Tagged with #looklatte!

Friday, October 1st // I swear it started pouring 5 minutes after I took these pics

-currents-

🎧: Alone again (Naturally) - Gilbert O’Sullivan

📖: As I lay dying - William Faulkner

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.

Sunday, January 30 // I watched Licorice Pizza yesterday and now I want Paul Thomas Anderson to direct my whole life. I also seem to finish my coffee within 3 minutes of ordering.

-currents-

🎧: Vienna - Billy Joel

📖: Numero Cero - Umberto Eco

Saturday 16 October // the weather this month has had these surprising bursts of sunlight around midday (pic on the right is from a couple weeks ago, but you get the point).

-currents-

🎧: Chattanooga Choo Choo - Glenn Miller and Easy on Me - Adele

📖: As I lay dying - William Faulkner

Wednesday, June 24 // Definitely odd to start studying at cafes again.

Music 🎶: Golden Hour - Kacey Musgraves. Breezzy and sweet. This is the first song I listened by her - I clicked on it by accident but her voice completely melted on me. Perfect for the bike rides after studying.

29.06.2020 // it’s getting more and more difficult to concentrate, most probably bc the exams are coming closer and closer.

Music 🎧: Now I’m in it - HAIM . This and Summer girl are in constant repeat.

06.07.2020 // this is my last week and then exams are over!! excited but overwhelmed bc there is still so much to do. I have been following some trainings on portfolio theory so now I’m much more confident about the course than I was before.

Music 🎧: Are you bored yet? - Wallows ft Clairo. still surprised how Dylan Minnette can be a good actor AND have such a great voice.

January 11, 2021 // Both refreshed and stressed out for the new year, since this one has high stakes. But happy new year!! I have an essay deadline for international relations tomorrow so i guess it will be an all-nighter for me. Other than that, I’m reading a LOT which always makes me happy, and my workouts are showing progress!

🎧: Lancaster nights - Charlie Burg. Kinda obsessed with this guy. Also, evermore by The Swift, obvs. I’m playing right where you left me on repeat.