#studytna

[studythenight-away]

9.22.2020 | How are we doing? I hope you’re hanging in there. I’m trying to. I’m now well into my fifth week of law school and starting to feel less overwhelmed, but it’s still so stressful! But as long as we’re trying our best!

[studyburst]

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.

[howl97s]

0909 // 11 pm

finally put up some prints on my wall! i spent the entire day reorganising things n cleaning my room now i’m tired but the good kind of tired... hope everybody had a nice day too!! tell me about your day? what have you been up to lately?

[aadarya]

{8.18.19} 

The academic year is starting in a couple weeks! I’ll be taking electricity + magnetism, an astrophysics course, a differential equations course, upper-level german, and an english seminar. I’m trying to read a few books before I go back because I don’t think I’ll have a lot of time for pleasure reading once the semester starts 😅

[sodiumstudies]

studyblr intro

hii I’m Lina, a first year law diploma student. I started this blog during circuit breaker when I was bored but haven’t really posted anything.

some things about me:

my main languages are English and Chinese (Mandarin for some of you) and I understand the teochew dialect but can’t speak it well :(

I’m 17 and just started a 3-year diploma course in April (hope to go to uni afterwards)

I really like music (my faves are punk, alt and kpop/khiphop) and can somewhat play guitar and string bass

also like making things with my hands!! like beaded jewellery and knitted/ crocheted clothing!!

absolutely hate being bored and unproductive so I try and pick up extracurriculars or do online courses or read books

hopefully from now on I’ll remember that this blog exists and actually post things hehe

[increasingly-awesome]

03.30.2020 |  02 of [100 days of productivity 2020]

After a morning workout, I studied immunology and pathology, but couldn’t finish the chapter yet. This afternoon, I had some time for creative writing, and to write an essay for an online course I’m doing. Still got two chapters to read for a class tomorrow.

Do you have any inspiring place to study?

[night-flight-studies]

Introductory post!!

Hey! So I’ve recently joined the studyblr community, to motivate myself and study harder.

Basic info:

I’m 18

Graduated high school with honours

On a gap year, preparing for uni entrance exams

Tutor at Army academy (@/armyacademics on Twitter!)

Pretty sure coffee runs in my veins!

Subjects:

Physics

Chemistry

Math

Korean (self-study)

Computer Science

Likes:

Reading

K-pop: especially BTS

TV shows ranging from law and order to k-dramas!

Organizing things (just realized how boring it sounds! )

Goals:

Studying smarter and staying productive

Actually sticking to the fancy schedules I make

Acing the entrance exams to get into my dream uni

Making new friends (I’m shy 🥺)

Studyblrs that inspire me ->  @emmastudies, @studyign, @studyquill, @the-diary-of-a-failure, @thecosmicstudyblr, @quantumheels, @tbhstudying, @justjasminestudying and so many more! (I low-key stalked so many studyblr..)

[studythenight-away]

I cannot believe I am only on week two of law school and already halfway through some of my notebooks. Excuse me???