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.
What a kid is taught, is what a kid becomes
Mr. Turner (via girlmeetsworldfanblog)
a set if hp bookmarks i’ll have for melbourne supanova next weekend! one (1) boy for each book
1. Get your electronics out of the way. I’m a huge advocator of technology in the classroom. But no so when you’re in your bedroom. I remember I had a chemistry exam the next day and I slept at midnight reading a novel. Even though I knew the material and the answers, I couldn’t finish the test on time because I was slower than usual and couldn’t concentrate. SLEEP IS IMPORTANT. So get your phone, tablet, laptop all out and just sleep. Learn from my mistakes people.
2. Take a day off and meal prep the shit out of your week. When I’m in exam week, I forget to eat. My bodily needs go on vacation to a dark corner of my mind and I simply forget about them until I’m at the verge of collapse from hunger and dehydration. What I did last year to avoid this is to have healthy food at hand all times by meal prepping inexpensive, light and nutritious snacks that can survive in the fridge.
3. Have your professor’s email or phone number. We are not perfect so from time to time, we are bound to cram everything in a day. In these days, it’s very beneficial to have your professor’s contact info to ask relevant questions. Be bold and ask right away if they have past tests so you can train with them in those lasts couple of hours. When cramming, it’s best to practice instead of reading. Your professor can make a huge difference in this game.
4. Make an efficient summary. If your professor isn’t willing to help (I see you Law Prof), then I recommend you to take notes using the chapter outline. You know that one page where they outline the chapters paragraph and give it numbers? It’s been extremely useful to me. Why? Because the paragraphs are usually named after the main ideas of the subject. Let me give you an example. One of my introductory classes was Marketing. The first chapter is named Wat is Marketing? The first paragraph is The definition of marketing, the second The marketing concept and the last one The role of marketing in a corporation. So knowing the answer to these 3 paragraphs should give you a strong idea of what marketing really is. A 20-page chapter was easily summarized in only 3 paragraphs. This saves me lots of time and I’m able to identify the most important info right away.
5. Organise a study session with your classmates. I have saved and have been saved by these. Just gather around 4-6 people from your class. Then make sure each one of you has mastered a part of the study material. Then teach what you’ve learned from the others. At the same time, you get to learn too without doing a lot of research.
6. Search it up. If you understand something, the esier it is for you to remember. So if you don’t understand the explanation the professor gave you, ditch him and go look on the internet for a video or article that explains it easier (or slower) for you.
7. Don’t cram it at the last minute. Yes, don’t do it. It’s likely not going to stay in your mind and it will only give you more stress. I would rec to stop learning all together some 5 hours before the exam and take a nap instead so you feel more fresh and relaxed.
8. Once you get your test, write all formulas, mnemonics and models. I like to do this before even reading the first question. This way I get all the tools I need out of my mind right away. Therefore I’ll have more space in my mind to think about the actual questions instead of thinking “what was the formula for that again?” and enter in panic.
ALRIGHT. LISTEN UP.
So recently, I got calls from the phone number, (937) 353-8319. They claim to be a job service, and one of their “employees”, Carrigan, is friends with whoever the call recipient is, and that Carrigan has recommended you for this $15.00/h “job”. I also got a text message from (937) 607-1493, claiming to be Carrigan, and that they need stuff to “win a scholarship”. I do not know anyone by the name of Carrigan and I know very well that this is a very dangerous scam. If you receive a call from a number, and they ask you if you would like a job for $15.00/h, HANG UP IMMEDIATELY. If you accept the “job” offer, and you go in for an interview, they will give you a drugged bottle of water and you will wake up somewhere you don’t want to be. These phone calls & texts are from a human trafficking service, and if you oblige to them, you will be sold to people and you will be raped, no doubt about it. So PLEASE PLEASE DO NOT ANSWER THESE CALLS OR TEXTS. I have listened to the voicemails, and allowed my dad to do the same, and he learned that anyone offering a $15.00/h “job” is a human trafficker. PLEASE SIGNAL BOOST THIS ALL OVER TUMBLR
I’ve met a lot of people who struggle with sticking to a schedule - myself included - so here’s one way you can get things done without restricting your spontaneity.
Linked: The ABCDE Method: Accomplish Tasks More Efficiently
Hope this helps!
Waiting like ....
Happiness Will Come To You.
Billie Lourd as Gigi in Booksmart (2019)
aka the crazy girl representation i´ve been waiting for
Here is a list of some YouTube ASMR ambiences/soundscapes (they’re all hyperlinked, so click away!) Unlike traditional ASMR, these videos do not feature any people. Talented YouTubers have used software to create rendered environments with layered sounds, with many of these ambiences inspired from fantasy to others based in reality. I find music with lyrics to be distracting sometimes, but these are great background noises for focusing, studying, doing homework, and even for relaxing. Enjoy and good luck ♡
1. Royal Library | Rain and Thunderstorm Sounds on Study Ambience with Crackling Fireplace
By New Bliss
2. LIBRARY AMBIENCE: Writing Sounds, Whispering, Pages Turning, Rain, Fireplace
by Autumn Cozy
3. Ambience/ASMR: Writer’s Library from the 1930s, 4 Hours
by Ambience of Yesteryear
4. Study Ambience / Library Sounds / 3 Hours #241
By Winter Whale ASMR
5. Harry Potter inspired ASMR - Hogwarts Library REMAKE - Animated ambient soundscape cinemagraph
By ASMR rooms
1. Rainy Day at Coffee Shop & Jazz Music | ASMR Ambience 4K
By Cozy Corner
2. [ASMR/Ambience]cafe after closing on a rainy urban night
By Sound Forest
3. Coffeehouse ASMR Ambience
By Miracle Forest
4. 1 Hour of Tea Shop Ambience | Background Noise | Cafe Ambient Sounds
By Nocturnal House
5. ASMR Increase Concentration Tokyo Cafe Study Ambience for Homework & School
By asmr soupe
1. 🎧 Cozy Ambience Bedroom - Rain on the Windows of the Rainy Night View of the City 10 Hours | Sleep
By The Relaxing Town
2. Cozy Cabin Ambience - Writer’s Room with 8 Hours of Rain, Thunder and Fire Sounds
By Calmed by Nature
3. Bed Breakfast ☕ Snowy Morning [ASMR] Cozy Cabin Ambience ❄️️ Winter Day with Little Bunny friend 🐰
By ASMR Weekly
4. Rain sounds | cozy cabin | Sleep, Study, Meditation 10 hours
By White Noise Tranquility
5. Cozy Winter Cottage | Snowstorm and Fireplace Sounds | blizzard | 10hours
By dreamy sound
1. ASMR Mystical and Noble Atmosphere of Slytherin Common Room●Harry Potter 3D Ambient Sound
By asmr soupe
2. Lord of the Rings Inspired ASMR - the Green Dragon Inn - Medieval Tavern Ambience and Animations
By ASMR rooms
3. ⛩ Spirited Away’s Dormitory - 1 Hour - Ghibli ASMR Soundscape
By Vibrating Art
4. Twin Peaks Double R Diner Ambience - 8 Hours of Smooth Jazz Music, Rain Sounds, & Cozy Cafe Ambience
By Calmed by Nature
5. A Moving Castle Type ASMR Ambience
By Miracle Forest
… But then I realized that alcohol existed.
Blaise Zabini, after hearing Draco “complain” about Hermione for hours (via its-hp-bitch)
Yessss
Hi all, this is werelivingarts, a new post about time management method: TIME BLOCKING! Time blocking allows you to divide your day into big blocks and helps you to complete similar tasks in one-go without any interruptions!
You can do your time blocking on:
Google Calendar (simple and easy to use)
Plan (drag your to-do list and organize them in blocks)
TickTick Premium (offer pomodoro timer)
Hope you find this helpful! ⭐️