Youtube daily May 19 2017

Hello everyone and welcome to a

Ebm computer tutorial lesson today

30th course Excel 2016 from scratch

well today I'll explain how

hide errors in formulas, what

I mean sometimes just make a

operation and as we have no arguments

it gives us some sort of error as

value or 0 but divided

that is fixed at the time I

enter the appropriate value but

meanwhile it makes me ugly I'll do

an example to see what I

I mean

For example, I have here a series of

products to a number of

units each and a number of

people among whom I have

then deliver just what

I would be making an equal and

divide here between c4 b4

While filling out

I get down all well but these two

Latest tells me error, split / 0

here I still have no values ​​in the

time you have values ​​for

It works well then what I

prevent this error appears

I'll fill it but then I have because

submit that sheet

I will hide errors

then what I do is what

Next I will delete this part

I just did and I'm staying with

these two empty will delete

some more

so then what I do now

It is to find a function that is to

mixing in the previous versions

IF function and function

mistake and now have a role to

We do that in which it is called IFERROR

Activity fx and here I

I give to accept and

I have two boxes,

I put value in this case I'm going to

let me say this

b4 between C4

would be good and what if no error

Well, then I say yes no

Error I have no values ​​because I'm going to

say for example that leave empty

as I say quotes quotes space

I write well then I'll accept

fill down and then the

good but here is wrong not

We have no problem because we

He has left the empty box or

apparently empty and so does not do so

ugly when we get value

Well, he

then arranges the same but without

so ugly that annoying bug that leaves us

in the leaves well as whether it is

today's tutorial here but sencillito

very useful function of IFERROR

and how to hide the

errors in any formula very well if they

I liked can give is like

They can subscribe to my channel already know

where you put down there and subscribe

you're so informed about the video or videos

to climb every day I can follow in

social networks and websites

EBM computing and Garret EBM

any comments or suggestions or

request put me under I

He answered all well many

and thanks to the video tomorrow

For more infomation >> COURSE OF EXCEL 2016 FROM ZERO, LESSON 30, HOW TO HIDE ERRORS IN FUNCTIONS, IF.ERROR - Duration: 3:46.

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

A City Gone Mad: Mommy's Home | Season 3 Ep. 17 | GOTHAM - Duration: 3:32.

- Testing.

Testing.

What you are about to see is very graphic.

In a bizarre turn of events, Gotham is on high alert today.

In the darkness, there are no rules.

Our city is being invaded by monsters.

The former mayor of Gotham city

is alive and dressed in a bizarre costume.

She's going to make a big splash all right.

You just wait.

Ain't got time to [inaudible], or I start killing people.

Calling himself Azrael.

Mr. Freeze.

Fish Mooney barricaded.

Edward Nygma remains at large.

I want to report a crime.

Who will defend the people of Gotham?

Another escapee from Indian Hill.

Who killed Gallivan?

Which time?

Guilty!

Gotham, A city gone mad.

[laughing]

Hey, kitties.

Mommy's home.

What's he told us?

Nothing useful.

Well I guess I should have come earlier, then.

Hi.

Hi.

So a little birdie has told me you

and your crew have been talking to a lot of people around town,

asking a lot of questions.

So I'm going to need you to tell me everything

you know about the court.

How they're related to doc nine c.

How this shadowy organization has been operating.

Oh, and what this ones been saying about me.

I already tried all that, Barbara.

Yes, well sometimes getting information out of someone

requires pulling teeth.

Ah, yeah.

I've been on these big jobs before.

I'm sorry.

Don't you mean it's like pulling teeth?

No.

Well, obviously I need to keep on top of you

about these things.

No.

You just like to hover.

Well, I wouldn't need to if you got better results.

Well, what are we going to do now?

We have to figure out a way to get him to talk.

Or maybe we won't have to.

They've been shooting interviews around town.

They've been talking to a lot of different people.

We just take the raw footage.

We'll know who they've been talking to, what they said,

and how it fits into the bigger picture.

No. Wait.

I have an obligation to protect my sources.

Shut up.

You there.

Do you know where all the footage is?

Yeah.

Good.

Road trip.

What are we going to do about these two?

Not this music again.

Well it's better than the sad, mopey music you play

the Sirens Club all the time.

It's mood music.

Yeah.

If you're in the mood to throw yourself off a cliff.

Call the Sirens Club.

Calling Sirens Club.

Yo, Zeen.

Hey, Butchie.

Ladies.

Tabby and I have left you a little

present at the warehouse.

The usual spot.

What did you have in mind?

Have fun with this one.

You deserve it.

Yup.

Bye.

Shall we?

[music playing]

For more infomation >> A City Gone Mad: Mommy's Home | Season 3 Ep. 17 | GOTHAM - Duration: 3:32.

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

Olli's Jealous Gods Tour Video Diary (Part 3/6 - "On the Buses") - Duration: 5:42.

All right, day 10 is almost over, and the show...

...in Cologne was really good! A sold out show, full house, we had a great time!

For the first time during this tour, we're hanging out here in the back lounge of our bus, enjoying some whiskey -

which seems to be kind of a tradition for us.

What else about this day...

Everything worked really well, I think we had a pretty good show.

Everyone is pretty much healthy again, and we are starting to feel more relaxed and enjoy our free time.

Tomorrow we'll play in Nuremberg, the usual procedures...

Here's to hoping that all our equipment will work OK and everything goes well!

Yes! Day 11 is almost over. Today we played in Nuremberg and -

it was a really nice show, probably the best one so far!

Right now we're just spending the evening. Our bus doesn't leave until 1,5 hours from now since our driver needs his rest,

so we are just hanging out here in front of the venue and killing time.

Feeling relaxed! It's really warm outside, earlier it was 21 degrees and sunny,

so here we are, just feeling good and enjoying ourselves.

Getting a little tired, so I guess I'll soon hit the bed.

Tomorrow we'll have a day off in Berlin, and we'll probably buy a laptop, an iPhone 6, a suitcase, a tie clip...

and all kinds of basic items that you might need on a tour… so, we are good to go! Right?

Hello... yeah...

Got it... Thanks, bye!

I have to say, the fingerprint recognition works really well in this new iPhone 6+.

Soooo... The show in Berlin is done, we are now on our way to Hamburg.

Our last night on the bus, and making the most out of it.

As you can see, we have a wild party going on, the bus is full of people...

Super loud party music...

People are naked...

So yeah. Tomorrow we have our last show in Germany, and from there we'll continue to London.

We've been on the road for almost two weeks now.

We had a nice show tonight, I felt pretty confident.

I might have played a couple of wrong notes in the solos, which bugs me a little...

I'll try to play them correctly tomorrow.

We'll have a day off in London, which I'm really looking forward to!

We have spent many nights on the bus, but last night we got to sleep in a hotel, which was wonderful.

Our last night on the bus, so we'll just chill and enjoy!

Here we are in London, day 16!

We didn't get much material from Hamburg and yesterday's travel day, due to our hectic schedule and tiredness...

Everything in London is great so far, the place is sold out, so it can't really go any better!

Soundcheck is about to start... It's warm outside, really nice to be here.

It's my first time in London, so I'm pretty excited.

It's always fun to do things for the first time.

Tonight we'll play a good show and have fun!

For more infomation >> Olli's Jealous Gods Tour Video Diary (Part 3/6 - "On the Buses") - Duration: 5:42.

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

SEE THE FILE BROWSER HIDDEN ON WINDOWS 10 CREATORS UPDATE - Duration: 2:34.

Hello everyone and welcome to a new tutorial

of computer Ebm well today I'm going to

show the new browser

next hidden files in Windows

10 creators update is a modern browser

fairly clean and functional if

we do we can use it

Next press windows key + r

and here we will paste this sentence

I leave them in the description of

video we give and we accept and

has opened it teaches us what

correspond to this equipment and is

fairly clean because it has no drawings

It is white and has just folders

So we can go going to go watching

we left here to go

by units

cd, HDDs

dvd and a memory card and this

team would again leave me here

then all by

here we have this arrow so far

to do is take what we have

left and here we have to

selectable grid that

how you could copy paste or what I

I would be once I give

here I have copy options I have

options and then

and also the option to search

we get a little more

up and we would be one last

This is good choice

changing the view

two types of view and from here as

upgrade would select all

and file properties as

They see a browser as I told you

cleaner before they can well be used if

They want very well as far the

Today's video if they liked me can

give like you can subscribe to my

Channel already know where you put down there

Subscribe and so they will be

informed of the video or videos that we got

every day I can follow

social networks and websites

EBM computing and attic of EBM

any comments or suggestions or

request put me under I

I answer all very well thank you very much

and even video tomorrow

For more infomation >> SEE THE FILE BROWSER HIDDEN ON WINDOWS 10 CREATORS UPDATE - Duration: 2:34.

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

HOW TO CREATE A ROUND LOGO, IN FEW STEPS - Duration: 5:58.

Hello everyone and welcome to another tutorial

Ebm computer now section

Photoshopearte

Today we will make a quick tutorial

which we are going to make a logo

Corporate round type and no longer

You need to use many steps to do

While we get into photoshop

we catch a canvas the size you want, in my case

1920 x 1080 and I'll do a background

two colors, gradient, this is not

Logo necessary but it is

more beautiful

we are here as the tool

I have degraded and here these two

colors can use those who want

in my case this first 6c187e colors

the second is black well then

lame from the top left to

the bottom right well that's

the bottom I'll leave

I do then I'll do

a new layer and will draw a

circle marked with the tool

Elliptical and I was quite

round locking shift and

well what do my circle would

and now I'll make a gradient but I

it takes two colors red Cogen

for example this wanting

from here and the other

want is black and I'll make a

demoted top left hand

lower right about and pulled

down to

what I'll do is go by

selection change and I'll say

contract and I will put more or less

about 10 pixels and give you ok

now with the same gradient and

I have'll make the lame backhand from

the bottom to the top and

loose well then now is whether

we remove the selection

how an effect that looks like a

button is enabled then that

It is very good because it can not serve

as a logo we can move where

we want

and now we're going to do two things

let's take text tool

Text tool puts mascara

Horizontal and we will do the following

we will take the source

like and a size and such

72

I'll click over here and I'll

write to put the first in

case the other two in

lowercase

I do this and what I will do now

I'm with the move tool I will

carry

well then now I'll put a

I grab me letters Tool

horizontal test mask and more or

least I'll catch I click here

the size you want and the type of

lyrics wishing well then more or

but I'll put over here and I'll

to say I want to put here a

uppercase letters but in

two in Vienna and lowercase

I have was lame button to move to or

and so leave more or less where

want

then that way as I see it

this makes a doublet that is quite

well worth going to do next step

one thing we will duplicate this layer

control + j

and we're going to get by fx and options

melting and will last the

that was in place drop shadow

I get like a shadow and we have

fact remains it directly

pretty good and here only because

I can play with the colors I

wants to achieve clearer less

clear this option

Let's assume I look for a

these so here I'll give

and now I have the opacity

play with and more or less then I

to also play with distance, with

extension

I believe

that we will leave out there and we

to give

ok well here and then here and

see how we have left our

logo very easy to do and that

any time as we can

modify a bit for example is

I can top you'll remove a

little opaque and thus recovers a

little color it had before

I'm trying

I can play with modes

fusion come by and say

effect

multiply that as is also seen

very nice effect or weft

we have here we'll see plot

they can leave the

that they like

well as far tutorial

today if they liked they can give me a

like you can subscribe to my channel and

They know down there where it says subscribe and

so they will be informed of the video or

videos we got every day I can

follow on social networks and the

websites and computer Ebm

Ebm garret any

comments or suggestions or requests me

I put it under answer all

very well thank you very much and even video

in the morning

For more infomation >> HOW TO CREATE A ROUND LOGO, IN FEW STEPS - Duration: 5:58.

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

Neurosurgeon, nurses child sex abuse case timeline - Duration: 2:27.

HT.

SHE'S HERE WITH MORE.

LAUREN: THIS IS THE SEARCH

WARRANT THAT IS GIVING US MORE

INFORMATION ABOUT THIS HEINOUS

CHILD SEX ABUSE CASE.

TODAY, WATSONVILLE POLICE ALSO

RELEASING NEW DETAILS

SURROUNDING THE DOCTOR AND TWO

NURSES.

THE COMPLEX, TWISTED TALE ENDS

WITH A LONGTIME SANTA CRUZ

NEUROSURGEON, JAMES KOHUT, A

DOMINICAN HOSPITAL ICU NURSE,

RASHEL BRANDON, AND A SECOND

NURSE, EMILY STEPHENS, BEHIND

BARS, ACCUSED OF RAPING AND A

SODOMIZING THREE CHILDREN UNDER

THE AGE OF 10 INSIDE A SCOTTS

VALLEY HOTEL ROOM BACK IN MARCH.

THE STORY SPANS THREE STATES,

CALIFORNIA, ARIZONA, AND

ARKANSAS.

STARTING IN CALIFORNIA, KOHUT

MEETS BRANDON WHILE WORKING AT

DOMINICAN HOSPITAL.

BEFORE THAT, BRANDON WORKED AT

NATIVIDAD MEDICAL CENTER AS A

STAFF NURSE FROM 2005 TO 2016.

THE MARRIED DOCTOR IS ALREADY

INVOLVED IN A RELATIONSHIP WITH

STEPHENS, A TRAVEL NURSE FROM

ARIZONA, FOR SEVERAL YEARS

BEFORE MEETING BRANDON.

THE THREE HAVE SEXUAL ENCOUNTERS

WITH EACH OTHER AND THAT'S WHERE

POLICE SAY CHILDREN WERE ABUSED

AND FORCED TO ENGAGE IN SEXUAL

ACTS.

THE VICTIMS INCLUDE A

THREE-YEAR-OLD BOY, A

FIVE-YEAR-OLD GIRL, AND A

NINE-YEAR-OLD BOY.

WATSONVILLE POLICE SAY A TAPE

WAS RECORDED.

BRANDON'S HUSBAND FOUND THE TAPE

AND TURNED HIS WIFE IN TO

POLICE.

SHE WAS ARRESTED MAY 9 AT THEIR

HOME ON CIRVELO STREET IN

WATSONVILLE.

KOHUT WAS TAKEN IN MAY 14 AT HIS

HOME ON 4TH AVENUE IN SANTA

CRUZ

TURNING TO ARIZONA, EMILY

STEPHENS IS ARRESTED MAY 12 AT

HER HOME ON NORTH DECHELLY LOOP

IN TUCSON.

PIMA COUNTY SHERIFF'S DEPUTIES

SERVE A SEARCH WARRANT AT HER

HOUSE AND FIND HANDWRITTEN

LETTERS FROM KOHUT, BILLS PAID

FOR BY KOHUT, AND COPIES OF THE

CHILD SEX VIDEOS THE TWO WOMEN

WERE CREATING AND SENDING TO

HIM.

DEPUTIES BELIEVE THE CHILDREN

WERE ALSO SEXUALLY ABUSED IN

ARIZONA, AS WELL AS CALIFORNIA.

THE THIRD STATE IN THIS WEB IS

ARKANSAS.

WHEN KOHUT WAS FIRED FROM HIS

JOB AT DOMINICAN FOR UNWANTED

SEXUAL ADVANCES TOWARD NURSES.

HE WAS HIRED AND MOVED TO SPARKS

HEALTH SYSTEM IN FORT SMITH,

ARKANSAS.

HE WAS FIRED THERE FOLLOWING HIS

ARREST

A TOTAL OF SEVEN CHILDREN WERE

TAKEN INTO PROTECTIVE CUSTODY.

IF CONVICTED OF THE CHARGES

AGAINST THEM, BRANDON STEPHENS,

AND KOHUT ARE FACING LIFE IN

For more infomation >> Neurosurgeon, nurses child sex abuse case timeline - Duration: 2:27.

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

RED BALL 4 RED BALL VS. EVIL BLACK SQUARES battle for the moon #15 - cartoon game for kids - Duration: 10:05.

For more infomation >> RED BALL 4 RED BALL VS. EVIL BLACK SQUARES battle for the moon #15 - cartoon game for kids - Duration: 10:05.

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

2 killed in possible DUI crash on Hwy. 99 in Yolo County - Duration: 1:17.

UARD RAIL, IT

SHOWS THE IMPACT OF THIS CRASH.

JUST AFTER 6:00 P.M., A MALE WAS

DRIVING THIS PICKUP TRUCK

TRAVELING SOUTH ON HIGHWAY 99.

CHP SAYS THE DRIVER CROSS OVER

THE DOUBLE YELLOW LINES INTO THE

NORTHBOUND LANES HITTING THIS

DODGE NEON HEAD ON.

IN THAT CAR, A MAN IN HIS 60'S

OR 70'S.

>> WE BELIEVE DRUGS AND ALCOHOL

ARE A FACTOR.

>> CHP SAYS BOTH DRIVERS WERE

NOT WEARING SEAT BELTS.

THE DRIVER IN THE OTHER CAR HAD

TO BE EXTRICATED.

BOTH DRIVERS DIED ON THE SCENE.

>> THE PICKUP TRUCK, AFTER IT

ROLLED OVER, IT DID CATCH FIRE.

>> A FRIEND OF THE TRUCK DRIVER

SAYS HE WAS THINKING BEFORE THE

COLLISION AND THERE WERE ALCOHOL

CONTAINERS INSIDE THE TRUCK.

>> THE MESSAGE IS THE SAYING IT

HAS BEEN IS TO NOT DRINK AND

DRIVE.

NOT ONLY DO YOU PUT YOUR OWN

LIFE AT STAKE, BUT YOU ALSO PUT

THE LIVES OF THE INNOCENT PUBLIC

ON THE ROAD AS WELL.

>> THE DRIVER WHO CAUSED THIS

CRASH IS FROM SACRAMENTO.

IT IS UNCLEAR WITH THE VICTIMS

FROM.

For more infomation >> 2 killed in possible DUI crash on Hwy. 99 in Yolo County - Duration: 1:17.

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

777888999 A number of death calling? Full Janch padtal my opinion #Viral Hindi Urdu Sachin saxena ki - Duration: 5:29.

Hi Friends Please Subscribe My youtube channel