Youtube daily google Aug 7 2018

In this video we look at using the INDEX MATCH functions to find data from one tab and put

it into another.

We want to find the birthdate for the person named Betsy in the tab to the right.

First, we'll start by writing the INDEX function out.

For the reference [range], we're going to be using the Brown family columns: "A", "B", and

"C".

For the row, we're going to be setting up our MATCH formula.

We'll use the MATCH [formula]; for the search criteria we'll select the cell where Betsy's

name is located.

We'll use the comma after that.

We'll select the range where it should look.

And, we'll use a zero after that for the MATCH function.

Next, since we know the birthdays are in the third column, we'll use a 3.

This gives us back our birthday.

This is how you use the INDEX MATCH functions to get data from one tab to another.

For more infomation >> How to extract data from a spreadsheet using MATCH and INDEX in Google Sheets - Duration: 0:55.

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

khesanh.net - [Hướng dẫn] Google Home Mini kết nối Bluetooth với Smartphone - Duration: 1:02.

For more infomation >> khesanh.net - [Hướng dẫn] Google Home Mini kết nối Bluetooth với Smartphone - Duration: 1:02.

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

How to QUERY multiple ranges in Excel or Google Sheets - Duration: 1:00.

In this video we're going to look at running a QUERY on two tabs

We have a tab with the family of the Browns, and we have a tab with the family of the Smiths

We'll go to our summary page and we'll start out by writing the QUERY function.

Now, we to write an array, so we'll use the brackets. We'll select the Browns and

then we use a semicolon and select the Smiths.

We'll close the bracket

and then we'll write our SELECT command. Instead of using "A", "B" or "C"

We'll use C - o - l for column. We'll select column one, column

two and column three. We only want to collect the rows where there's data

So we'll use column one: all cells that are non blank, order by date of birth

which is in column three

We'll do that descending

We'll add a "1" at the end for one row header and we'll add a "2" next to the Smiths for "A2"

to make it select just rows below the header.

Here we have a combined query of two different tabs

For more infomation >> How to QUERY multiple ranges in Excel or Google Sheets - Duration: 1:00.

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

Google "Being Evil" in China? - Duration: 12:00.

On this episode of China Uncensored,

I miss Ask Jeeves.

Welcome back to China Uncensored,

I'm your host Chris Chappell.

Good news, everyone!

Google has finally taken the chains off.

Back in May,

Google removed its famous "don't be evil" motto

from its code of conduct.

Google's new motto is:

Don't let anyone find out that you're evil.

Moral relativism is cool.

What is evil, anyway?

Don't be unprofitable.

Don't learn from your mistakes.

No, history never repeats itself.

Or at least that's what I assume from this article from the Intercept.

It turns out, there's a tratorious Google employee who still hasn't

gotten the hang of being evil but hiding it per company policy.

Because that employee revealed Google's top secret project:

making a censored Android app for China that uses their search engine.

The secret project is called Dragonfly,

and it's allegedly been in the works among a select number of employees

since the spring of 2017.

We reached out to Google for comment about their search engine in China.

Their "Google Spokesperson" said they do have mobile apps in China,

but they don't comment on speculation about future plans.

It's like if your wife asks,

"You're not going to eat that entire box of Cheez-Its

in one sitting, are you?"

And you reply,

"There are things I'm going to eat,

but I don't comment on specific future eating plans."

So China has a pretty big internet market:

750 million Internet users.

That's bigger than the entire population of Europe.

And it seems like,

well there's a ton of money Google could be making in China.

And now that Google isn't concerned about not being evil,

they can finally tap into it.

With the help of an "unnamed" Chinese partner company.

As you know, the Chinese Communist Party

likes to keep a tight grip on the Internet.

Otherwise Chinese citizens might learn dangerous things,

like how their government was totally willing to massacre

a bunch of students in Tiananmen Square.

With the new Google search engine app for Android,

Chinese people don't need to know all that.

Because they won't even be able to find links

to troubling informational websites with y

ou know, facts—

like the BBC or Wikipedia.

Now you might be concerned that Google's

new alleged Chinese search engine would create

some kind of bad precedent.

That, if the biggest search engine in the world

is willing to cave to Chinese censorship demands,

why should any company resist?

It's a fair point, but may I remind you

HOW MUCH MONEY IS ON THE LINE HERE, PEOPLE!

In fact, maybe Google's new motto is actually:

Don't be unprofitable.

After all, being evil can make you so much more money.

Clearly that important point was lost on the Google employee

who leaked the secret plan.

He told The Intercept,

"I'm against large companies and governments collaborating

in the oppression of their people,

and feel like transparency around

what's being done is in the public interest,"

and that "what is done in China will become a template f

or many other nations."

What?

Are you saying that this will embolden

other authoritarian nations

to further limit free information?

Well, don't worry,

because other authoritarian nations don't have

750 million internet users.

Cha-ching.

Google is a company with 88,000 employees.

You can't expect them all to have jumped on

the evil is okay bandwagon.

So to minimize the chance of leaks,

only "a handful of top executives and managers,"

knew about project Dragonfly.

Executives like the current CEO.

Last December, he travelled to China

and met with top Communist Party officials,

who had great money-making ideas,

as communist officials always do.

That same month,

Google opened an artificial intelligence

research center in Beijing.

In May, they brought their file management app

to the Chinese market.

And in July, they launched a fun game

for the popular Chinese messaging app WeChat.

Let's just say there are some privacy concerns about WeChat.

Clearly not a concern for Google, though!

In fact, I wouldn't be surprised if Google's unnamed

Chinese partner company is Tencent,

the maker of WeChat.

I wonder if this new app will also give user data

directly to the Chinese government,

just like WeChat does!

Now some people have compared Google's move to

the shameful history of IBM in Nazi Germany.

I mean, I'm not making that comparison.

I'm just saying, some people have—

and now you know that.

But giving in to the Chinese regime

isn't actually new for Google.

They were in China before.

In 2006, Google set up

a highly censored version of their search engine

for the Chinese market.

And Google got slammed for it.

Here's a clip from a 2006 Congressional hearing about

American tech companies.

US Congressman Chris Smith was not too happy with Google.

"When a user enters a forbidden word,

such as 'democracy' or 'Chinese torture' or 'Falun Gong,'

the search results are blocked,

or you are redirected to a misleading site,

and the user's computer can be frozen

for unspecified periods of time…"

"...It is hard not to draw the conclusion that Google

has seriously compromised its 'Don't Be Evil' policy."

Well guess what, foolish politician actually trying to call out

a big corporation for it shady behavior?

Google doesn't have the "don't be evil" policy anymore.

Take that!

Problem solved.

So what happened to that censored Chinese version of Google

that Congressman Smith was complaining about in 2006?

Four years later, Google backed out.

In a 2010 official blog post, they said:

Guess what?

The Chinese Communist Party hacked us.

And they targeted the gmail accounts of human rights activists.

Curse your sudden but inevitable betrayal.

Google stood up to the evil Chinese regime.

They announced that they were uncensoring their search engine,

and if that meant the regime kicked them out of China,

so be it.

And so it was.

Google co-founder Sergey Brin,

who partly grew up in the Soviet Union,

told the Wall Street Journal that he was worried about

China's totalitarianism.

And, at the time,

I praised Google for doing the right thing.

It turned out later,

their pull-out might have been about

more than just doing what was right.

It was also maybe because they were

hardly making any money in China.

But don't worry.

Google is under new leadership now!

And their new motto is:

Don't learn from your mistakes.

Because, the lesson from this should have been:

It's really hard for Google to make money in the Chinese market

because the Chinese regime will always

stack the cards against you in favor of Chinese companies

while also hacking you and stealing your intellectual property.

But the lesson the new Google CEO took was:

If at first you don't succeed,

try, try again.

But now with more evil.

The sad part is,

Google is hardly alone in wanting to be in China:

Bing and Yahoo already have censored search engines there,

although they have a fraction of the market share

of Chinese companies like Baidu.

Apple has made a huge investment in China.

And we all know that Mark Zuckerberg

will literally run through the Beijing smog

to get Facebook there.

But at one point, Google was alone

in standing up to the Chinese Communist Party.

Which makes this new search engine thing

so much more disappointing.

And now the question on my mind is,

if Google does get back into the Chinese market,

and is desperate to make money there,

what happens if someday the Chinese Communist Party

decides it doesn't like how Google operates outside China?

Like they do with, I don't know,

international airlines that call Taiwan a country.

To get into the Chinese market,

would Google be more evil outside China, too?

As someone who hosts the world's

most important English-language satirical news show

about China on YouTube,

which is owned by Google,

I'm a little bit concerned.

When you have a moment, try this.

Do a search for China Uncensored.

"China uncensorship pollution"!?

That's a funny autocomplete!

Oddly enough, our newer, much smaller podcast,

China Unscripted, does come up.

We've also had fans of the show tell us

that they've stopped seeing China Uncensored

in recommended videos.

That they get no notification of new episodes,

even when they have the notification bell turned on.

We're constantly having videos get demonetized.

And get this:

Some viewers have told me they were suddenly

unsubscribed from China Uncensored.

That even happened to Shelley,

who you know,

is on the show.

And I'm sure all of these problems will get much better

once Google has serious financial stakes in China.

There's no evidence that Google

is intentionally targeting China Uncensored.

It could just be that Google is inept.

And that is completely possible.

You see, China is no less totalitarian than it was back in 2010,

when Google initially pulled out.

In fact, they are increasingly using online surveillance

to control Chinese people.

But even if Google doesn't care about being evil anymore—

even if all they care about is making money for their shareholders,

or if they're just drooling over the idea of getting a piece of

750 million internet users—

going in to China is a bad idea.

Having a Chinese partner company

may help Google make more money,

but there's definitely a price to pay.

And it might be higher than they think.

Which is why Google should really change their motto to:

Don't be stupid.

What do you think about Google's re-entry into China?

What should their new motto be?

Leave your comments below.

And now, it's time to answer questions from fans

who support the show on the crowd funding website Patreon.

Alfred Schneider aks,

"Chris, I've heard that PRC have built

some delightful vacation resorts

in the South China Sea.

Which one would you like to visit the most, and why?"

Oh Alfred, that is probably the toughest question

I've been asked so far.

There are so many; how can I choose?

Yes, the Chinese Communist Party is developing

a booming tourism industry in the South China Sea.

Particularly in disputed territories.

I mean, my favorite Chinese state-run media the Global Times

makes a vacation there sound so appealing.

Look at that beachfront view.

"Since 2013, around 10,000 Chinese tourists have been able

to enjoy the natural beauty of the Xisha Islands."

Otherwise known as the Paracel Islands,

territory claimed by China, Vietnam, and Taiwan.

The best part about vacationing in these wonderful resorts

is probably the flybys from Chinese nuclear capable bombers.

Now if that doesn't sound like a vacation,

I don't know what does.

Just like the tourists in this Global Times article,

I too would love to travel to the Xisha-slash-Paracel Islands

on the Coconut-fragrance Princess,

watch a flag-raising ceremony

as the Chinese National Anthem is played over the water,

and talk about never giving up an inch

of China's territorial integrity.

Thanks for your question Alfred.

And before we wrap up,

this is a good time to make a plug for your support.

This show is funded mainly not through Google ads,

but through contributions from viewers.

You can contribute a dollar or more per episode

through the crowdfunding website Patreon.

You'll get cool rewards,

including a chance to have your questions for me

answered here on the show.

And even if you can't support China Uncensored on Patreon,

you can make a huge difference by just

sharing the show with your friends and family.

Since Google is going to make that as hard as possible.

Thanks for watching this episode of China Uncensored.

Once again I'm your host Chris Chappell.

See you next time.

You know China Uncensored isn't just on YouTube.

We have half-hour episodes

you can watch on cable in New York,

San Francisco, and Los Angeles.

Check your local listings.

You can also download our China Uncensored app

on Apple TV, Roku, or FireTV.

Or just visit www.ChinaUncensored.tv.

For more infomation >> Google "Being Evil" in China? - Duration: 12:00.

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

Kids in India are Learning with Google Earth & Local Guides - Duration: 3:20.

For more infomation >> Kids in India are Learning with Google Earth & Local Guides - Duration: 3:20.

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

Meet UX Content Strategists at Google - Duration: 1:57.

My name is Angela Park. My name is Linda Barth. I'm Laura Napolitano. My name is

Jen Schaefer, and I'm the UX content strategy lead for the travel team. So as

part of the user experience team, I think about who's using our products all the

time. Being a content strategist means making sure content contributes to a

great user experience. Video, photo, text, anything that adds that little extra bit

to a consumer-facing product, that's probably related to content strategies.

The editorial role within a tech company I think is a particularly unique

position to be in. We are at the forefront of a lot of new products,

including Google Home and the Assistant, writing content for augmented

reality and Daydream. So I work really closely with product managers and

designers and engineers, so it's really collaborative and fun and mostly based

on true problem solving. A small text tweak can mean literally millions of dollars

in a revenue boost. Sometimes I just can't believe the impact we can have

with words. At Google I think the culture and the people are as important as the

products we build. Googlers tend to be really passionate, really smart, and

really driven. I wanted to come and work for Google because it's so great to be

at a company whose beliefs are aligned with my own, that supports all people,

very supportive of diversity and really it wants to reach everyone in the world,

the world is the audience. For a time I was running a team both in New York and

London and I had the flexibility to take meetings from home when I needed to meet

with my London team and that allowed me to take my kids to school before I come

in. That makes a huge difference. At every turn it feels like the company

is taking care of you.

For more infomation >> Meet UX Content Strategists at Google - Duration: 1:57.

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

Meet Developer Programs Engineers at Google - Duration: 2:01.

My name is Nadine Sundquist, I'm a Developer Programs Engineer. My name is

Silvano Luciani and I'm a Developer Programs Engineer. My job is to mostly

work with the community of developers to make sure that our

products have a successful adoption amongst them, see what questions

developers are asking about the products, what problems are they having, and we

bring back that type of feedback to the product teams. I spend half my time

coding, half my time working with people, and I get to actually work more on

design decisions at my level. The kinds of projects that I work on at Google are

various APIs and what I do is I spend half my time working on client libraries

that sit on these APIs and the other half of my time supporting customers. So

that could be anything from writing forum posts and answering questions, to

going to a workshop. It's half people person, half engineer and that's exactly

what I wanted to do.

There is a lot of guidance in general. We have a lot of trainings

provided by Google about anything that might be related or non related to our

job. I probably in six years I have attended at least 50 or 60 classes. It's

another pretty good opportunity to get better at what I'm doing. I love my

teammates, my teammates are pretty darn awesome.

We're actually spread across the world and multiple offices, but what's great

about them is that being so international we tend to really

understand each other. We understand where each person is coming from what I

love the most about them is that when you ask for something to be done, they

just get it done. There's no having to ask anybody a second time. Everybody is

so good at what they do that it just gets done and I love that about it.

For more infomation >> Meet Developer Programs Engineers at Google - Duration: 2:01.

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

Adding Animations to Your App - The Boring Flutter Development Show, Ep. 5 - Duration: 57:45.

For more infomation >> Adding Animations to Your App - The Boring Flutter Development Show, Ep. 5 - Duration: 57:45.

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

5 Cool Google Play Store Features And Tricks - Duration: 4:05.

Hey Guys my name is Kashif and in this video I'm going to show you some simple Google Play

store tricks and features which you might not have bumped into yet.

It's possible you may be aware of some or all the Google Play store tricks mentioned

below, but a recap would be perfect for refreshing your memory.

So, here are the most helpful tips and tricks for the Google Play Store:

Test And Refund Apps

Did you know that you can get refunds for paid apps in the Play Store?

Google is pretty lenient regarding what you can refund and reasons for claiming a refund,

and the process is fast and straightforward.

And yes, you can return an app if you "later decided you didn't want it."

Learn more in the official website on Google Play Store refunds.

Once you've purchased an app, on its Play Store page you'll see options to Install or

Open.

In addition, a Refund option should appear to the left of it.

Tap the refund button within two hours of your purchase to get your money back, no questions

asked.

For paid apps and games, you have two hours after your purchase to request a refund (or

48 hours if you make your refund request on the web instead of through the Play Store

app).

The only exception is for unauthorized purchases, which have a limit of 65 days.

Put A Parental Lock On Google Play

The Play Store offers three distinct ways to "lock down" app installations, which

come in real handy if you regularly let your kids play games or stream videos on your device:

Fingerprint Block: If your device has a fingerprint scanner, you can restrict purchases to your

fingerprint by going to Settings ➜ User Controls ➜ Fingerprint authentication.

Parental Control PIN: You can also restrict purchases by going to Settings ➜ User Controls

➜ Parental controls.

Turn it on, set a PIN, and you're good to go.

Mature Content Filter: You can set when the PIN is necessary by going to Settings ➜ User

Controls ➜ Parental controls ➜ Set content restrictions.

Disallowing Teen, Mature, and Adults Only apps should be enough in most cases.

Device Manager

You can now easily find out your lost android mobile with the help of Device Manager.

Go to the link Google Drive Manage and log in your Google ID.

With this amazing feature, you can find out your lost device.

Install An App That Isn't Available In Your Country:

If you're really keen to get an app that's not available in your country then you can

still get your hands on it by using a VPN.

'VPN' means 'virtual private network'.

It gives you a secure internet connection via private networks in locations outside

of your current one.

Basically, a VPN service can make it look like you're accessing the internet from a

different location.

It's important that you choose a credible VPN.

We regularly feature VPN deals in our AndroidPIT Store if you're looking for a good one at

a low price.

Once you've downloaded a VPN, select the country whose Play Store you want to access in the

VPN app, get the VPN up and running, then open the Play Store app.

It should land on the Play Store homepage of the country you selected.

Now you can get the app you desire.

Unlock Early Access And Beta Apps

Sometimes you'll hear of an upcoming app that's generating a lot of buzzes but hasn't

been released to the public yet.

You can check if it's available as an "early access" app, and if it is, you may be able

to try it out ahead of time.

Beware that early access apps are often buggy, glitchy, poorly optimized, and prone to crashes.

The Play Store also allows developers to offer separate beta versions of already-released

apps.

These beta apps often have more features and other improvements, but may not be quite ready

for public release due to crashes, bugs, glitches, etc.

That's Pretty much it guys for this one if you liked this make sure to press the like

button and subscribe for more content like these Thank for watching and I'll see you

in the next one.

For more infomation >> 5 Cool Google Play Store Features And Tricks - Duration: 4:05.

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

google map பை பார்த்து வண்டி ஓட்டுபவரா நீங்கள் ! இந்த விடியோவை பாருங்க Tamil Cinema News - Duration: 1:06.

For more infomation >> google map பை பார்த்து வண்டி ஓட்டுபவரா நீங்கள் ! இந்த விடியோவை பாருங்க Tamil Cinema News - Duration: 1:06.

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

Ibn Sina Google Doodle - Duration: 1:13.

Today The Search Engine Google is showing a Doodle for Ibn Sina or Avicenna.

Today in a few countries Google celebrate Ibn Sina's 1038th Birthday.

Ibn Sina or Avicenna was a Persian polymath who is regarded as one of the most significant

physicians, astronomers, thinkers and writers of the Islamic Golden Age.

He has been described as the father of early modern medicine.

Of the 450 works he is known to have written, around 240 have survived, including 150 on

philosophy and 40 on medicine.

His most famous works are The Book of Healing, a philosophical and scientific encyclopedia,

and The Canon of Medicine, a medical encyclopedia which became a standard medical text at many

medieval universities and remained in use as late as 1650.

In 1973, Avicenna's Canon Of Medicine was reprinted in New York.

Besides philosophy and medicine, Avicenna's corpus includes writings on astronomy, alchemy,

geography and geology, psychology, Islamic theology, logic, mathematics, physics, and

works of poetry.

For more infomation >> Ibn Sina Google Doodle - Duration: 1:13.

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

Google Pixel 3 release date may have leaked - this is when new flagship could launch ● Tech News - Duration: 2:05.

GOOGLE Pixel 3 is one of the most eagerly anticipated Android flagships of the year,

but now it appears the release date of the hardware may have been leaked.

Google Pixel 3 is expected to bring a host of improvements when it launches later this

year.

In addition to addressing a blue tint issue on the Pixel 2 XL's OLED screen, the device

is expected to feature an improved camera, turbocharged internals and come pre-installed

with Android P.

But it appears fans looking to upgrade to the new Google flagship may not have to wait

long at all.

A new leak suggests Google is going to stick to tradition by launching the Pixel 3 and

Pixel 3 XL on October 4.

It is unknown whether the post was created by Google itself, an external marketer or

someone unrelated entirely."

The posting declares the Pixel 3 is "launching" on October 4, but it does not clarify whether

this is simply an announcement by Google itself or when Android lovers will be able to get

their hands on the prized flagship.

Google announced its original Pixel and the Pixel 2 on October 4, so the company choosing

to announce its third generation device on the same date would line up with tradition.

Notable tipster Evan Blass previously declared Google is set to have a "hardware event" towards

the end of the year showcasing a slew of new products, including the Pixel 3 and Pixel

3 XL.

The Google Pixel 3 also appears set to pack enough power to challenge a host of other

flagships on the market.

Last week the Google Pixel 3 XL appeared on Geekbench's database, showcasing the potential

internals of the device.

Originally spotted by WinFuture, the post declares the Pixel 3 XL will come packing

a Snapdragon 845 processor and 4GB of RAM.

Android fans will not have to wait long to see if the latest Google Pixel 3 leak is true

with October only being a couple months away.