Auto news on Youtube Jan 7 2019

Hi. In this Excel tutorial, we'll go over what an array formula is in Excel, how to use one and end with some tips to keep in mind when

using array formulas. First, in Excel an array refers to a group of values – they could be in a row, column or both. An array formula is a

formula that will perform calculations on the array. This probably sounds weird given that the purpose of all formulas is to calculate

something, so, let's take a quick look. On my screen is some sales data by month. So, let's say I want to figure out the total dollars sold in

that month. I could multiply the data in each row separately or I could use an array formula.

To do this, we first need to highlight all the cells where we want the array formula to be in, then type the equal sign,

and highlight the first column that we want to multiply -

and I'm using columns here, but you can just as easily do this for rows – then, we'll do an * to multiply, and highlight the next column we

want to multiply by, and then press Ctrl+Shift+Enter. And, FYI, to create an array formula,

you have to press Ctrl+Shift+Enter. Otherwise, you'll just create a regular formula.

You'll know you created an array formula when you see these curly brackets.

And notice how our data is multiplied for each month. And then, to cross check it, you can just multiply your quantity sold by your average

dollar sold. And notice that's exactly what the array formula did, except with less strokes. Let's delete this.

Ok, so, why is this helpful to use when, really, we could have just multiplied and copied the formulas down? Well, for starters, you're using

only one formula instead of 12. So, each time you add a formula to your spreadsheet it uses up just a little bit more memory. And if

you're working with a large data set this can affect how much time your spreadsheet will need to recalculate and refresh.

And, because you are typing just one formula, this can save you time as you're working. And, by the way, if you find this tutorial helpful

please make sure to click Like and subscribe to the channel so you catch new tutorials right as they come out.

We can also use other functions in array formulas. So, we just input an array formula across multiple cells to get the total sold

by month, but what if we need to figure out the total for the year?

This involves multiplying each row and then summing the totals...OR we can combine these calculations by using an array formula.

...let's come down here... And, to do that, we'll type =SUM( and we'll select all the quantity sold,

multiply

by all the average dollars per sale,

and then press Ctrl+Shift+Enter again.

And this gives us our total dollars sold for the year. ...just format all these...

So, what's important to keep in mind when working with array formulas? Well, first Ctrl+Shift+Enter is important. If you don't

press it to exit your formula, you will not have an array formula. 2. If you step into your formula, like when using F2, and don't press

Ctrl+Shift+Enter to exit, you will erase the array formula.

In the case that your calculation is in a single cell, like in our total here, and you accidentally exit without pressing Ctrl+Shift+Enter, all you

need to do is just step back into the formula and press Ctrl+Shift+Enter to exit and this will fix it.

3. When you're applying an array formula across multiple cells, like we did here to figure out the dollars by month, you can't edit just one

cell. Notice an error if I try to step into a cell and make an edit.

Now, what you can do is edit the range, ...let's get out of this... making sure to press Ctrl+Shift+Enter

when you're done.

And notice that this changed the range for all of them, giving us an error down here because this is now outside of the range.

Let's undo this. 4. To delete an array formula in multiple cells, you'll need to select all of the cells that contain that array formula and

click Delete. And let's undo this. 5. In case you're curious, no, you can't just use the keyboard to type curly brackets,

you have to press Ctrl+Shift+Enter. And, lastly, consider your audience. If you'll be sharing your spreadsheet with others who may want to

make edits to it, consider whether or not they're familiar with and know how to use array formulas -

and you can always just send them a link to this tutorial - but if they do not know what they are, they may accidentally break the formula,

affecting results displayed for the data. If you enjoyed this tutorial on how to use array formulas in Microsoft Excel, please make sure

to Like the video and don't forget to subscribe to this channel. Thanks!

For more infomation >> What is an Array Formula in Excel??? - Tutorial - Duration: 5:12.

-------------------------------------------

What I Bought When I Was Travelling | Travel Souvenir Haul | TheKingBeth - Duration: 6:25.

Hello everybody, welcome back to my channel! Today I'm gonna be showing you

a couple of bits that I've picked up on my various travels over the last couple of months.

I have family staying with me at the moment. My mum's sister is Australian and she has come to stay with us.

So, at the moment it's her and my cousin. While they are in England and on this side of the world, they wanted to

see a bit of Europe, so we went away last week to Paris for two nights.

I think you know how much I just love Paris. I just enjoy the culture of just sitting there,

and drinking little tiny cups of coffee, and looking out into the world.

I love how all the tables in restaurants face onto the street so you can just people watch. I think that's so cool.

Anyway, I got myself a few little souvenirs and I was thinking I haven't actually made a haul video for so long

because I was doing monthly hauls up until I think like July or August.

But then, as you know, I had my really busy month in August where I went on three separate holidays

with basically the three people in my life who care about me enough to want to spend like an extended period of time with me.

So one with my mum, one with my dad and, one with Jacob.

I bought one souvenir from each of those trips and then since being back I have not bought anything really

so I've just not been needing to make my monthly haul videos.

But, because I've now got like four trips worth of souvenirs, I thought, you know, I will show you.

So let's go chronologically. The first trip I went on was to New York with my mom and my sister,

which was like our joint birthday present, cos I turned 21 this year, she turned 18.

What I decided to do was to buy a pin badge on each trip because I feel like they're just a really good

little memento of the trip. They don't take up too much space, they have some kind of purpose other than just

looking nice or potentially just looking really tacky. And I already have a sort of mini collection of pins going on.

And to be honest I don't really use them. I don't put them on my jackets or anything. They just kind of sit there and look pretty.

So I admit maybe this isn't the best use of my money because it's not something I'm getting a lot of use out of

and eventually my collection will build up to the point that it's just too much and I'll want to chuck it out.

I know that. I know that's gonna happen. But for the time being I'm really enjoying my little pin collecting.

I'll probably put some on my denim jacket once it's actually warm enough to just wear a jacket outside again

but for now I'm happy enough just looking at them. I think they look pretty and that's enough for me.

So as I said, first of all I went to New York and this is the pin that I got from New York.

I got it at the top of the Rockefeller Center. It just called to me and I love the sort of monochrome design.

It's got a picture of the Rockefeller Center and then around it it says "I've been to the top of New York"

and then it says 'Top of the Rock" at the bottom. I'm really pleased with this one,

I think it looks super cool, I love how shiny it is. And it cost me $6.95.

So next over summer I went to Amsterdam with Jacob, and at this point I knew I was looking out for pins.

But they didn't really have that much choice. I was looking in all the tourist shops and it was a lot of just...

marijuana things... which is fine. But I didn't want that on the pin badge.

So I eventually found this one which I think is quite cute. It's got a picture of a little bike with some flowers in, I guess they must be tulips.

It's got a really bright yellow background and then it says Amsterdam in red down the bottom.

The quality doesn't seem amazing. It was only a couple of euros and I bought it from a tourist shop

so that's kind of what you'd expect. But as long as it doesn't fall off and I don't lose it it'll be fine.

My next destination was Crete, so this time with my dad and my sister. It was quite hard to find pins in Crete

because we were staying in this quite touristy place. It was kind of a village that was only built for tourists,

but it wasn't like crazy touristy at the same time. It was quite a strange one. They didn't really have any shops

and the shops that were there didn't really sell souvenirs as such, especially of the place we were staying.

They were just kind of more general Greece or Crete things. On one of our day trips I managed to find this pin which has a

little tiny map of Crete on it. We stayed somewhere around here. We flew into Chania

which is this little sticky out bit. We only really got to see sort of northwest parts of Crete

but there you go, that is the pin that I managed to find.

So that was my summer done and then, as I said, like last week I went to Paris with my family.

And they had quite a lot of pins to choose from there but a lot of them had a really tacky text on or they just looked

a bit naff. But eventually I chose this one. So this pin is the Eiffel Tower,

it's got Paris written in the colors of the French flag then round the bottom it's got loads of cute little red hearts.

It is a really sort of cliche touristy design, but I do still think that it's really really cute.

As well as that pin badge I got two other little souvenirs from Paris because I just couldn't resist them.

First of all, at the top of the Eiffel Tower, I was in the gift shop looking for pin badges, which they didn't have.

As I was leaving I saw this postcard and I just had to buy it.

So here it is, it's a scene of Paris rooftops with the Eiffel Tower in the background in sort of gold foil.

It's really pretty! And then these two cats down here are the exact spitting image of my cats Penny and Tiddles.

They're both so accurately like them, like, some of the markings are exactly the same it's really weird.

Obviously I had to buy thisand you know... Tiddles passed away in April.

I never talked about my channel I don't think, but I spoke about it online.

It's really sad. But now I'm gonna put this on like my pin board or something, maybe the pin board behind me there?

And it'll be a little cute artwork thing of Penny and Tiddles, it's like they're still together, it's really nice.

So the final purchase in Paris was kind of just like... I was feeling the vibe and

I wanted to buy a beret. Obviously I got a pastel pink one! I got it from one of the

tourist shops outside Notre Dame for like five or six euros. They had cheaper ones

but they were made of acrylic and polyester and this one is 95% wool, 5% polyester.

So I thought, like, it's better quality, it's gonna last me longer.

But the problem is, because it's mostly wool, it doesn't really seem

to have that much stretch in it, and this seems to be quite small.

I got my sister one as well because she wanted one. I got her a sort of rusty red

coloured one, and it was the same design, same price and everything, but hers is

a lot bigger than this. And I just want to point out... I have quite a small head.

You may not realise this, it's probably something that only I notice. But I've got a little pea head, right!?

And this is kind of a bit too small on me. It won't quite..... Like, if it just had a little bit of stretch in, it would be a bit better.

But I just felt too awkward to try it on in the shop because they kind of

hound you and if I tried it on he would've come up to me like "buy this buy this buy this",

so I just kind of picked it up and bought it which maybe was a mistake, but I was just trying to avoid interacting with people you know?!

I'm not really a souvenir person. The beret was pushing the boat a bit too far for me I think.

So those were the things that I've bought on my various trips over the last couple of months.

I hope you enjoyed this little video, and I will see you very soon!

For more infomation >> What I Bought When I Was Travelling | Travel Souvenir Haul | TheKingBeth - Duration: 6:25.

-------------------------------------------

What If SCP-017 Was Real? - Duration: 7:13.

Shadow - the antithesis of luminosity.

The absence of light.

The form that is cast when everything else is snuffed out - when darkness descends.

But - what if that same darkness was a creature in and of itself?

An entity that had the motivation to consume all that surrounds it, to wrap it beneath

it's black curtain - unless light held it under control.

How would humanity deal with such a threat?

How would our civilization control such a cosmic force?

Well, as is the same with many things - the SCP Foundation has got us covered, and deep

within it's secret vaults - exists a creature of pure shadow.

Let us introduce you to SCP-017.

Hello internet - and once again, welcome back to the most inquisitive channel on YouTube

- Life's Biggest Questions.

As per usual, I'll be your disembodied floating voice Jack Finch - as today we peer back into

the dusty archives of the SCP Foundation - slip on our hypothetical hats - and curiously ask

the question, What If SCP-017 Was Real?

Ah - everyone loves Vin Diesel as Riddick, right?

But - I hate to break it to you, not even he would be safe if SCP-017 got it's shadowy

tendrils around him.

Poof, he'd be dead.

As would the rest of us, unless we could ensure that humanity had a way to bathe themselves

entirely in bright light.

Which, would lead to a much, much different way of life for you and I - and everyone else

on the planet fortunate enough to not be consumed by the shadow.

Or - unfortunate enough, it depends which side of the pessimistic fence you're sitting

on.

Well, strap on your hypothetical thinking caps - because we're about to fall through

a literal black hole of how to survive in a post SCP-017 world.

In the moment that we've all been waiting for.

The beacons are lit.

As the record states, SCP-017 - otherwise known as Shadow Person - is a keter class

anomalous entity that very much wants to get out of it's box.

It is a humanoid figure approximately 80 centimeters in height, anatomically similar to a small

child, but with no discernible identifying features.

This anomalous entity seems composed of a shadowy, smoke-like shroud - and yet, while

no attempt has been successful - it remains unknown as to whether there's anything actually

beneath it's shadowy shroud - or if it's completely comprised of darkness.

I mean, I wouldn't really want to be the one to find out, right?

If I've learned anything - it's don't go poking a finger at an abyssal cosmic void.

There's a life lesson in that I think.

To keep it under wraps, the Foundation goes to great lengths.

Well, actually - it doesn't really, it's kind of the lowest maintenance skip when you

boil it all down - and all it takes is a few well placed flashlights.

Let me explain.

SCP-017 is contained in an acrylic glass cage, centrally suspended in a concrete room.

Attached to the walls, ceiling and floor of the room are high-intensity arc lamp spotlights

pointed directly at the acrylic cage, to ensure that SCP-017 is constantly exposed to light

from every angle.

Personnel assigned to the SCP-017 control room are to monitor the functionality of the

spotlights and the emergency generator system, and call for maintenance immediately upon

knowledge of a burnt-out lamp or an issue with the generator.

The only circumstance under which personnel are allowed entrance is to replace lamps.

When entering the skips containment room - they're required to wear a designated fully-body reflective

suit - and under no circumstance can step in front of a spotlight.

Because - of course, they'd cast a shadow - and to SCP-017, that's a high-speed highway

to take over the planet.

Keep that suit in mind for a minute, because it's important - and possibly our only line

of defence in a post-apocalyptic SCP-017 world.

The only way to answer this question is to envisage a scenario where SCP-017 had enough

darkness to break out from it's containment.

A power cut, which - granted - would take an absolutely catastrophic cock up on the

Foundation's behalf - but hey, we've got to get this ball rolling some how, right?

And let's make it happen at the worst time imaginable - during the dead of night.

Within seconds - the spotlights would cut out - and before we know it, the entire containment

area for SCP-017 is engulfed in it's shadow.

Poof.

Gone.

Now, we don't know for certain how quickly this skip would spread - but let's give

the Foundation the benefit of the doubt and say that they had the foresight to put this

particular containment site in a remote location - and so - within minutes, SCP-017 has consumed

the entire isolated area.

Also - it's the dead of night, so let's say this area is in Washington state - falling

under the Pacific Time Zone, where a dark evening lasts between 9 PM until roughly 4

AM.

So for the vast majority of people in the Pacific states there's a good chance they're

tucked up in bed, in a nice - dark room - ripe for the picking by SCP-017.

Poof - millions of people gone - without anyone even realising - becoming part of the darkness,

back to whence they came.

Woah, sorry - got a bit archaic there - but you get the jist, right?

The real answer to this question is - SCP-017 would spread as quickly across the planet

as it takes for one full rotation of the Earth - and if the supporting document SCP-017-1

is anything to go by, pretty much the entire population of Earth would be wiped from existence.

Not even dead - they'd, just cease to BE.

Gone.

The slate wiped clean.

But - what about the survivors?

Of course, the Earth takes 24 hours to fully rotate across it's time zones - so depending

on how lucky you are geographically, that's potentially 24 hours to prepare for the shadow.

Remember that reflective suit?

Yep.

Get yourself one of those.

And then stand in a large concrete bunker with enough artificial light to make the cosmetic

aisle in Macy's look dim.

But what then?

Build yourself a suit full of heat lamps and roam the wasteland looking for supplies?

What about a power source?

What do you do when your suit runs out of battery?

The world's population has been consumed by shadow, and you've got 24 hours to make

sure your body never crosses a shadow again.

Utilizing infrastructure is going to be pretty low on your list of priorities.

Ah - I hate to be the pessimist in this one, but SCP-017 really is the final goodbye.

Eventually, inevitably, we'd all succumb to the void.

But hey - you know what my girl Joni Mitchell said - you don't know what you've got

till it's gone.

Well - sorry to leave that on such a bum note, but not everything has a happy resolution

in the SCP Foundation.

Unfortunately, that's all we've got time for in today's video - but before we depart,

let's take a look at some of your more creative comments from over the past few days.

Digital Glitch says - What will happen if you read this comment but i have one question

what if bagel have no hole.

-- Hold on a hot minute, what if bagel have no hole?

I can't even comprehend that one.

I'm still hung up on why do bagel have hole.

Why DO bagel have hole?

Aesthetic memes says - To be honest you are the best dude, sometimes are ur vids i imagine

a movie about the scp.

Well aesthetic memes - you're the best dude, and I'm glad you're enjoying our SCP movie.

As so far as the SCP movie goes - I'm sure you're not alone in that one.

I'll see what I can do.

Someone get me Guillermo del Toro on the line.

Well - there we have it questioneers, cheers for sticking around all the way to the end.

If you were a fan of this video make sure to hit that thumbs up button - as well as

that subscribe bell, and we'll be seeing you in the next one.

As always, I've been your disembodied floating voice Jack Finch, and until next time - you

take it easy.

For more infomation >> What If SCP-017 Was Real? - Duration: 7:13.

-------------------------------------------

What Is Japanese Water Therapy and How It Can Keep You Healthy - Duration: 2:29.

Many people drink water as soon as they wake up in the morning.

It might be in the form of tea or with lemon, but the fact is that this simple habit can

bring you many health benefits.

Some people, like the Japanese, find this to be very important because they believe

that water therapy can cure many evils.

Japanese people tend to drink 4 to 6 glasses of water in the morning, on an empty stomach.

They believe that this practice not only activates their metabolism but also helps their bodies

in its detoxification process, which can aid weight loss and improve overall well being.

The premise behind water therapy is that most diseases arise due to digestive system problems.

In fact, numerous studies have shed light on the health benefits of water, which go

far beyond weight loss.

Water contributes to the renewal of our cells, balances our lymphatic system, cleans our

colon, and prevents constipation.

But, in order for you to notice notice a change, consistency is very important.

If you drink water every morning on a regular basis, you'll most likely feel more energized,

and you may also notice improvements in conditions such as:

High blood pressure and diabetes (within 30 days);

Gastritis and constipation (within 10 days);

Do you want to integrate water therapy into your routine as well?

Here's how:

As soon as you wake up in the morning, drink 4 to 6 glasses of water, between 160 and 200ml

each.

You should not eat anything before hand, and always drink room temperature water.

If you can not drink them all at the same time, try to wait a few minutes between each

glass.

If you prefer, you can add a little lemon in order to make it taste better.

After drinking the water, brush your teeth and wait about 45 minutes.

Do not eat anything before the time is up.

It's recommended that older or sick people start with only one glass of water and increase

the amount gradually.

It can also be beneficial not to drink liquids until two hours after meals.

Had you already heard about this tip?

Have you ever tried it?

Tell us about it in the comment section!

For more infomation >> What Is Japanese Water Therapy and How It Can Keep You Healthy - Duration: 2:29.

-------------------------------------------

What is the Lawyer's Role When Working For the Seller? - Duration: 2:20.

For more infomation >> What is the Lawyer's Role When Working For the Seller? - Duration: 2:20.

-------------------------------------------

Modern vs contemporary interior design: What to know for your next home - Duration: 6:22.

In this video, we talk about modern versus contemporary design styles.

We also talked about transitional versus traditional. That's starting right now.

Welcome to Homebuyer's School,

brought to you by Brookfield Residential.

Hi everyone I'm Karl Yeh, and welcome to another Homebuyer's School video,

a channel where you get the latest strategies, tactics, and tips from home

buying experts and remember, if this is your first time on this channel and you

want to get the latest strategies from the experts, hit the subscription button

below, hit the little notification about so you don't miss anything.

So today I'm joined by Deborah Armstrong,

Senior Interior Designer with Brookfield

Residential and today we're gonna do a little bit of - I guess, classroom activity,

not that this is Homebuyer's School but - but the question I wanna answer is:

What is the difference between modern

versus contemporary interior design?

So modern is a time period,

typically known as mid-century modern.

It's any design that's - you know, you

could see in the 50s and the 60s. Okay.

A contemporary is ever-changing,

whereas modern you can't change it,

it's always - you know, the 50s and 60s you know.

So what does the - what does that mean?

Like 50s and 60s design, can you give a couple examples?

yeah in the 50s and 60s if you look back, I mean, I can remember those days,

but they're - you know, very clean lines. Everything's very, very clean.

The furniture was raised - you know, off the floor, no skirts on sofas, a lot of wood, teak.

Would hardwood floors be an example?

Absolutely yeah, they were the narrower boards,

they were site finished, but yes, definitely hardwood floors, area carpets.

And then the type of furniture,

what kind of - how would you define modern type of furniture?

Again very, very straight clean lines.

There was a molded furniture whether it

be wood or plastic that we saw back in

those days. Accessories were very clean lined as well, not fussy at all.

Okay and would - and what is the difference between that and

contemporary interior design?

So contemporary is ever-changing.

It is what is current today. So five years

ago, what was contemporary then is not

contemporary today.

so I - so like you said it was ever changing, so let's go back to modern. So what -

what is in a modern home and I think you

talked about that but like - what type of

materials did they use?

A lot of wood, metals, a lot of chrome,

glass, leather, leather yeah.

Leather was very, very popular back - back then too and and even plastic - like to look like leather.

And so there's another thing that I want to talk about too is

in traditional versus transitional, so

how does traditional and transitional go

together with contemporary versus modern?

well they don't really, again because

modern is a time period set on its own in the fifties and sixties,

contemporary is what is current now.

Maybe what transitional you could mix what is

current now with very traditional furniture

so you get a blend of

contemporary and traditional and that's called transitional.

So let's talk about traditional: what is -

first of all what is traditional?

Traditional is usually based on the airs between in the 18th century and the 19th century.

It's quite fuzzy furniture, elegant, heavy draperies, beautiful fabrics. Woodwork was

very ornate - you know, heavy crown mouldings. The furniture itself too - it was

very heavy and ornate. You had certain areas, particularly the Chippendale, the

Sheridan, the Queen Anne furniture. Very common during that

transitional time - traditional period.

So when you say traditional, what in my

mind that brings about like royalty

would that be correct?

It has a - yeah, you could say that, very fussy, very elegant

So like something you probably see in Buckingham Palace?

Yes, yes. Okay.

And today, so what - I guess - in today's

interior design world what is, I guess popular?

Right now we're seeing a lot of

come back with the modern furniture known as mid-century or some people

refer to retro. So again, we're starting to see those really clean lines again,

minimalistic looks.

So I guess you could say that

modern has become contemporary?

Yes you could. And most, I guess most - do most home builders now

appeal to that like contemporary

designer or are there like - not that we want to

name any of them, but like are there any ones - any that are very specific to a

traditional look or transitional look or or is it mostly all contemporary nowadays?

I think most of it's contemporary

nowadays and - and how people are changing the look of their

home is how they decorate it. They're putting their stamp on it

through - through their decorations and maybe some of their interior selections

whether it be carpet or tile, to work around those and in design aspects.

And does this design actually impact how

the house is actually built or no?

No not at all. If you're looking for a modern home exact, it will. Yes, you will build

a home that has the look - much more clean lines yes you know for that modern

feel. Clean, very straight clean lines on the outside. And we are seeing that, we

are seeing some builders, not specifically - I mean it's the home owner's

you know, custom design that's dictating that. Okay perfect, anything else to add in

terms of modern contemporary interior design? No, just have fun with it all

they're all great, you know - and everybody likes a little something different so

anything goes nowadays.

Thank you very much for joining us and we'll catch you next time.

That's another edition of Homebuyer's School.

Tune in next time for more expert tips and tricks

and visit www,homebuyersschool.ca to bring

you one step closer to finding your dream home.

As with everything it would be great if you like

and share our videos.

Also, please let us know if you have any

home buying questions you want us to answer.