I LOVE Excel! I Took An Excel Class During University And I’ve Never Stopped Using Or Learning About

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.

More Posts from Queen-strawberry and Others

7 years ago

What a kid is taught, is what a kid becomes

Mr. Turner (via girlmeetsworldfanblog)

5 years ago
A Set If Hp Bookmarks I’ll Have For Melbourne Supanova Next Weekend! One (1) Boy For Each Book 
A Set If Hp Bookmarks I’ll Have For Melbourne Supanova Next Weekend! One (1) Boy For Each Book 

a set if hp bookmarks i’ll have for melbourne supanova next weekend! one (1) boy for each book 

5 years ago

Survival tips for exam week

TO SURVIVE EXAMS LIKE A BOSS

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. 

7 years ago
ALRIGHT. LISTEN UP.
ALRIGHT. LISTEN UP.

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

4 years ago
Flexible Time Blocking: A More Breathable Way To Get Things Done
Flexible Time Blocking: A More Breathable Way To Get Things Done
Flexible Time Blocking: A More Breathable Way To Get Things Done
Flexible Time Blocking: A More Breathable Way To Get Things Done
Flexible Time Blocking: A More Breathable Way To Get Things Done
Flexible Time Blocking: A More Breathable Way To Get Things Done

Flexible Time Blocking: A More Breathable Way to Get Things Done

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!

7 years ago
Waiting Like ....

Waiting like ....

Happiness Will Come To You.

5 years ago

Billie Lourd as Gigi in Booksmart (2019)

aka the crazy girl representation i´ve been waiting for

4 years ago
Here Is A List Of Some YouTube ASMR Ambiences/soundscapes (they’re All Hyperlinked, So Click Away!)

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 ♡

LIBRARY SOUNDSCAPES

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 

CAFE SOUNDSCAPES

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 

COZY SOUNDSCAPES

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 

INSPIRED BY SOUNDSCAPES

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 

7 years ago

… But then I realized that alcohol existed.

Blaise Zabini, after hearing Draco “complain” about Hermione for hours (via its-hp-bitch)

Yessss

4 years ago

time blocking method

image
image
image
image
image
image

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! ⭐️

  • demongrocer
    demongrocer liked this · 4 weeks ago
  • juniperpomegranate
    juniperpomegranate reblogged this · 4 weeks ago
  • maresources
    maresources reblogged this · 1 month ago
  • garliccave
    garliccave liked this · 2 months ago
  • small-wet-rat
    small-wet-rat liked this · 3 months ago
  • kirbylovr3
    kirbylovr3 liked this · 3 months ago
  • yun-neshel
    yun-neshel reblogged this · 4 months ago
  • rose-of-pollux
    rose-of-pollux liked this · 5 months ago
  • pkducklett
    pkducklett reblogged this · 5 months ago
  • lavieinterieure
    lavieinterieure reblogged this · 6 months ago
  • daenggs
    daenggs liked this · 6 months ago
  • cowboyjen69
    cowboyjen69 liked this · 6 months ago
  • tsumi-haiiro
    tsumi-haiiro reblogged this · 6 months ago
  • unit-1312
    unit-1312 liked this · 6 months ago
  • cremebru-lee
    cremebru-lee reblogged this · 6 months ago
  • h0ney8ee
    h0ney8ee liked this · 6 months ago
  • ourbastardofsorrows
    ourbastardofsorrows reblogged this · 6 months ago
  • everyoneisrat
    everyoneisrat liked this · 6 months ago
  • redsorceress
    redsorceress reblogged this · 6 months ago
  • deeper-vell
    deeper-vell reblogged this · 6 months ago
  • whybedennydifferent
    whybedennydifferent liked this · 7 months ago
  • secriden
    secriden liked this · 7 months ago
  • starwarslunchbox
    starwarslunchbox reblogged this · 7 months ago
  • doublespacingout
    doublespacingout liked this · 7 months ago
  • argentinyan
    argentinyan reblogged this · 8 months ago
  • 1nfodump
    1nfodump reblogged this · 8 months ago
  • yawshii
    yawshii liked this · 8 months ago
  • in-the-abyss
    in-the-abyss reblogged this · 8 months ago
  • timeywimeydemigod
    timeywimeydemigod reblogged this · 8 months ago
  • timeywimeydemigod
    timeywimeydemigod liked this · 8 months ago
  • leo-regulus
    leo-regulus reblogged this · 8 months ago
  • littlemouse44
    littlemouse44 liked this · 8 months ago
  • jugofraga
    jugofraga liked this · 8 months ago
  • thepluralmaster
    thepluralmaster reblogged this · 8 months ago
  • nevermore117
    nevermore117 liked this · 8 months ago
  • silverandebony
    silverandebony liked this · 8 months ago
  • commander-poedameron
    commander-poedameron reblogged this · 8 months ago
  • wujieozeon
    wujieozeon reblogged this · 8 months ago
  • parakeetchen
    parakeetchen liked this · 8 months ago
  • mysterysolver
    mysterysolver reblogged this · 8 months ago
  • viatrix-vulpes
    viatrix-vulpes reblogged this · 8 months ago
  • queerloquial
    queerloquial reblogged this · 8 months ago
  • autistic-dorian-pavus
    autistic-dorian-pavus liked this · 8 months ago
  • suilesbian
    suilesbian liked this · 8 months ago
  • heartattackmedication
    heartattackmedication liked this · 8 months ago
  • sixfuries
    sixfuries reblogged this · 8 months ago
  • sixfuries
    sixfuries liked this · 8 months ago
  • canis-arctos
    canis-arctos liked this · 8 months ago
queen-strawberry - Don't mess with me Cupcake
Don't mess with me Cupcake

85 posts

Explore Tumblr Blog
Search Through Tumblr Tags