Auto news on Youtube Jan 1 2019

Shown is starting to feel a lot more confident about his Excel skills,

and that's just as well because he's been given his first assignment.

The bus has asked him to complete the help desk roster for the next two weeks,

one of the tools that can help a lot with this is the fill handle.

The fill handle is located at the bottom right-hand corner of a cell.

When you hover over it,

you should get a small black cross.

At its simplest, the fill handle allows us to quickly copy.

Let's have a look, so I'm going to click and drag down to row 17,

and release, and it has copied my days for me.

The fill handle can do some slightly clever things there was well.

So, I'm going to click on to B4 where I've got my record number,

and I actually want these to go R1001,

R1002, let's see what happens when I drag my fill handle.

Now, what has happened here is the fill handle's given us what's called a series,

where you have a combination of text and numbers,

it automatically adds one to the numbers,

well, that is interesting.

Let's see what happens with our dates.

So, I'm going to click on the first of the fifth,

this time however instead of dragging,

I'm going to try a shortcut,

I'm going to double-click my fill handle.

So, two quick licks, how good was that?

Again, we've got that series with adding one to each date, which is perfect.

Let's see what happens with days of the week.

So, I've clicked on Monday,

and again going to come to my fill handle, double-click.

Well, that is clever, and that will work with days of the week all months of the year.

Now, I've done each of those individually,

so that you can see how they work,

but to show you how quick this could have been,

I'm going to undo those last three changes,

I'm going to select all three of these,

and then double-click my fill handle,

and you can see you don't even have to do them one at a time.

Excellent. Now, each of my help desk shifts is eight hours.

So, really I just want to copy that number eight down.

Let's see what happens when we double-click the fill handle,

and there we go, so that's interesting.

With dates, we get a series,

but with numbers, we automatically get a copy.

Now, I need to number my shifts for the next two weeks,

but I know that when I double-click my one,

I'm just going to get a series of ones.

However, Excel does actually give you options.

Whenever you use the fill handle,

you should see a little icon come up at the bottom,

and if you hover over it you'll see it's called Auto Fill Options.

I'm going to click on the drop down arrow,

and you'll see it has done a copy,

but you do have the option to do a fill series.

Well, that's brilliant, I'm going to click on that and they you go.

Now, let's see what would happen with our options for our date.

So, I'm going to come back to date here, double-click,

come and have a look at my options,

and this time it is chosen fill series,

but I could choose a copy.

So, if you need to do that, you have that but dates as

well or you could do something quite fun,

so I could do fill weekdays or fill months,

but I'd like to get back to my fill series.

So, quite a rich selection of options,

the fill handle also allows you to do simple patterns.

So, for example, my cumulative hours,

total hours on help desk is going to go up in eights.

If I just copy the 16,

that's not going to work,

but if I select both the eight and,

so I tell Excel there's a pattern and then double-click,

there we go, counting in eights,

and Excel could do this for quite a range of fairly straightforward patterns.

Let's look at a slightly more complex one.

So, I have my five help desk staff here,

I'm going to select all of them,

and again double-click, and it has copied the whole group down.

Now, one really exciting feature that was added in 2013;

so this will only be available to 2013 and '16 users,

is something called flash fill,

which is an even more sophisticated pattern matcher.

If you have a look here, I have Rajesh's address,

which is made up of his first name,

a dot, his surname,

and then the company name.

Now, if I come and copy that down,

it just copies it, but if I come to my Auto Fill Options,

you'll see there's an option to do flash fill,

and when I click on that,

it spots the pattern,

and automatically creates addresses for all my staff.

Wasn't that quick? Have a go at using the fill handle yourself.

For more infomation >> Fill Handle - Excel Skills for Business: Essentials by Macquarie University #7 - Duration: 5:31.

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

Introduction to Excel Skills for Business: Essentials by Macquarie University #1 - Duration: 2:51.

[SOUND] Excel, let's make it real.

Sean has just had an internal transfer to a department that heavily relies on Excel.

It's been a few years since Sean has seen Excel, so

he has lost his confidence in his Excel skills.

Sean is also not familiar with the latest Excel user interface.

For Sean to be efficient, productive, and

analytical in his new role, Sean will really have to take charge of Excel.

Sean really wants to make a good impression on his manager, so

he has been going through Excel manuals and videos all night, and

he is now completely overwhelmed.

Sean realizes that Excel can store data, perform calculations,

data analysis, and even draw charts.

He needs a quick and efficient way that empowers him with the essentials of Excel

so that he can take charge.

In this course, we are going to cover the essentials of Excel so

that you are empowered from the very beginning without feeling overwhelmed.

Week by week, these essentials will give you the confidence to use Excel to

increase your efficiency, productivity, and analytics in your workplace.

To empower you to take charge of Excel,

this week we will be learning about understanding the Excel user interface.

Then we will go through the essentials of Excel terminology, so

you know what the various sections of the Excel screen are called.

We will show you how to confidently select data and navigate within Excel,

as well as viewing data in Excel and the different data types.

You will then take charge by entering data, as well as editing and

deleting data.

We will then end the week with a really great efficiency tool, the fill handle.

The only way to learn Excel is by practicing.

You have to do your work, and we are here to equip and empower you to do so.

We have a series of practice videos,

where each video will empower you with a new Excel functionality.

You will be empowered to take charge of Excel, so

you will need to follow alongside us and practice.

Download the Excel workbook, and work with us and your peers step-by-step.

Once you have done that, take a break, reset, recharge and

practice these skills again because practice makes permanent.

Let's breakdown this week's Excel functionalities for you by sitting down

with Nicky, and seeing how we can really help Sean and how we can really help you.

[SOUND]

For more infomation >> Introduction to Excel Skills for Business: Essentials by Macquarie University #1 - Duration: 2:51.

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

View Options - Excel Skills for Business: Essentials by Macquarie University #5 - Duration: 5:30.

Shawn is now navigating quite comfortably around his Excel workbook,

but when we have a really massive workbook like this,

it still does present a lot of challenges.

One thing that can help us are some of our view options.

We'll start by looking at the bottom of the screen,

on our status bar.

We have a small tool called a zoom slider,

and this allows us to quickly zoom in by clicking on the plus,

zoom out by picking on the minus,

or simply drag the zoom slider to get to exactly where we need it.

To the left of the zoom slider are three view options.

We are working in normal view,

but to the right of that you will also see the page layout view.

This gives us a good indication of how the Excel workbook sits on the page,

and is useful when we come to print.

To the right of that is the Page Break view,

and this is very good for getting an overview of a launch worksheet.

For the most part though,

we will work in normal view.

So, I'm going to click back on that.

Coming up to our ribbon now,

I'm going to click on the View tab.

You will notice a lot of the tools we've just looked at like the page breaks views,

and the zoom tools are also available on the ribbon tab.

If I needed to quickly zoom in for example to 100 percent,

I can just click on 100 percent.

If you find that tool really useful,

don't forget you can always add it to Quick Access toolbar.

So, I'm going to right-click and add Quick Access toolbar.

There are also several checkboxes which will allow you to

turn off and on some view options.

For example, if I'd like to hide my grid lines,

I can untick Gridlines and they're gone.

Usually, it's easier to work with them all.

One tool which can be quite useful, is the split.

This allows us to split our screen,

so we can view different sections simultaneously.

I'm going to click near the middle of my screen,

and click split, and where these gray lines have appeared,

my screen is actually being split into four sections.

I find this a bit difficult to work with,

so I'm going to double-click on the middle split to remove it.

Now just have a top and a bottom.

If I wanted to see some data at the top and compare it to data near the bottom,

I can come to my lowest scroll bar and scroll down until I get to near the bottom,

and you can see I look to different sections my screen simultaneously.

To turn split off,

I can double click back on this line or come back up to split and click it off.

Now while the split is quite useful,

even more useful, is the Freeze Panes.

Sometimes, I want to be able to simply scroll down

or scroll across and still be able to see my headings,

and you can see at the moment I can't.

I'm going to bring this little scroll bar backup,

and I'm going to come to freeze panes.

If I click the dropdown and say Freeze Top Row sounds good,

but you'll see it's only frozen

the top row which doesn't really help me in this situation.

So, to turn that off,

come back to freeze panes and click unfreeze.

Now, what I actually want to be able to do is freeze

the top three rows and my first three columns.

The trick to this is to click in the cell directly

right and directly below the columns and rows I want to freeze.

So, you can see are below row three and to the right of column three.

I now come up to freeze panes,

and I click Freeze Panes.

Some faint black lines appeared,

but you'll notice now when I scroll down,

my heading stay fixed.

When I scroll right,

my three columns on the left also stay fixed.

Again, to turn freeze panes off back to Freeze Panes and unfreeze.

Now the last quick option I want to look at,

is the option to switch windows.

This is useful when you have multiple workbooks open.

So, let's get another workbook open.

We've up to now looked at file open,

but I'm going to press Ctrl+O which is the shortcut,

and I'm going to choose W01-V02-Select and Navigate.

We're not looking at a different workbook,

but what about if I want to get back to the one I was working in previously?

I come to my View tab,

I come to Switch Windows,

and I now have a list of all my Excel workbooks that are currently open,

and I can just click to Switch.

There's also a useful shortcut key, it's Ctrl+F6.

So, I press Ctrl+F6,

and you can see I quickly switches me between my open windows.

So, that are some view options to help speed up

your workflow and make it easier to work with larger workbooks.

Get in that and have a play.

For more infomation >> View Options - Excel Skills for Business: Essentials by Macquarie University #5 - Duration: 5:30.

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

University Challenge - Christmas 2018 E06 Sheffield University v Manchester University - Duration: 28:40.

APPLAUSE

Festive University Challenge. Asking the questions, Jeremy Paxman.

Hello. We've reached the penultimate first-round match

of our seasonal series for grown-ups.

So we already know that we're going to see the University of Bristol

and King's College London again in the semifinals.

And if tonight's winners score 140 or more,

they'll definitely be playing again too,

which might be a Christmas present in questionable taste!

A dissertation on the sounds made by dinosaurs

crowned the academic career of the first player

for the Sheffield University team,

who then bounced into the Olympic arena.

She also works with schools

in her capacity as a mentor to young people.

Next to her is a winner of the Kathleen Ferrier prize,

who's been named by the Guardian as one of Britain's leading sopranos.

Her extensive CV includes playing Zerlina in Don Giovanni

for Covent Garden and Susanna in The Marriage of Figaro

for both Santa Fe and the Welsh National Opera.

Their captain is a novelist,

but is perhaps best known as a political journalist.

He is now a freelancer, having been Newsnight's business and later

economics editor before leaving for Channel 4 News.

Their fourth player spent eight years in Tony Blair's cabinet,

serving as Home Secretary for three of them.

He's now a peer and holds a professorship

in Politics in Practice at Sheffield University.

Let's meet the Sheffield team.

Hi, I'm Bryony Page.

I graduated from the University of Sheffield in 2015

with a degree in Biology.

Since then I have competed for Great Britain in the sport

of trampolining.

Hi, I'm Elizabeth Watts.

I graduated at the turn of the century from Sheffield

in Archaeology and Prehistory.

Since then, I decided my career didn't lie in ruins...

and I decided to make the obvious choice and become

an international opera singer!

And this is their captain. I'm Paul Mason.

I graduated from Sheffield University in 1981,

studying Music and Political Theory and Institutions

and I'm a writer and journalist.

And I'm David Blunkett and I studied Political Theory and Institutions

and graduated in the early '70s.

And I'm back now persuading students to learn from my mistakes!

APPLAUSE

Now, the team from Manchester University includes

a performer whose alter egos

have included the cheery but troubling Lee Nelson

and the uncomprehending footballer, Jason Bent.

He's also known for stunts such as handing Theresa May a P45

during her keynote speech at the 2017 Conservative Party Conference.

With him, a former president of the NUS

who became a broadcaster and journalist,

winning the Orwell Prize for Political Journalism in 2001 and

the What The Papers Say Columnist of the Year Award for 2003.

He now writes for The Times.

Their captain is one of the most prolific

of contemporary British playwrights,

having written extensively for the stage,

radio, and television, since the early '70s.

His work also includes adaptations such as the RSC's

ground-breaking production of Nicholas Nickleby in 1980.

Finally, a prolific journalist and broadcaster involved

in many television programmes including Rogue Traders,

Food Inspectors, and currently the BBC programme Watchdog.

Let's ask the Manchester team to introduce themselves.

I'm Simon Brodkin.

I studied Medicine at Manchester University,

where I graduated without honours,

and I'm now a comedian, prankster,

and almost certainly out of my depth here!

I'm David Aaronovitch.

I graduated from Manchester University in History in 1978 and

this is not actually the first time I've been on University Challenge.

But the first time didn't really go that well.

And this is their captain.

I'm David Edgar,

and I graduated from the University of Manchester in Drama in 1969.

And I'm now a playwright and I write on culture and politics

for newspapers and magazines.

Hi, I'm Matt Allwright, and I graduated from Manchester University

in 1991 in English, barely graduated, just about,

since when I've been a broadcaster and presenter-journalist,

specialising in having arguments in car parks!

APPLAUSE

Well, attentive viewers will be aware that Mr Aaronovitch's

allusion to his appearance first time round was the notable occasion

on which his team are said to have answered every question

with the name of a noted Marxist

in protest at the programme's supposed elitist tendencies.

Well, it was hardly the storming of the Winter Palace,

so 40 years on, we're delighted to welcome him back to the studio!

Same rules as the student series, though,

so fingers on the buzzers, here is your first starter for 10.

Where did you find those hats?!

Right, 10 points for this.

First transmitted on July 31, 1968,

which long running television comedy series...?

BUZZER Manchester, Brodkin.

I was going to say Coronation Street, and then you said comedy!

Erm, erm... Dad's Army.

That is correct. Yes.

APPLAUSE

Right, your bonuses are on Christmas markets in Germany, Manchester.

Which city on the Elbe has Christmas markets dating to 1434?

It boasts not only the world's tallest nutcracker,

but also a stollen festival held on the second Saturday of Advent.

Dresden or Leipzig.

Shall we go with Dresden, as you said it first?

OK. Dresden, we think.

Dresden is correct.

Secondly, its market focusing on traditional handcrafted wares

and culinary delights such as "plum men" - tiny figures

made from prunes - which city is the second-largest in Bavaria?

INAUDIBLE

We think Nuremberg. Correct.

Noted for its tall Christmas tree, which Rhineland city holds a market

in front of Germany's largest cathedral,

a UNESCO World Heritage Site constructed over a period

of 600 years?

That's Cologne. That is Cologne, yes.

APPLAUSE

Those hats do wonders for your authority! 10 points for this.

Which geometric shape connects the Zen concept of enso,

an 1841 essay by Ralph Waldo Emerson,

a 1948 play by Berthold Brecht, a group of leading...

BUZZER Manchester, Allwright.

Is it The Circle? It is, yes.

APPLAUSE

You get a set of bonuses this time, Manchester, on ghost stories.

Oh, Whistle, And I'll Come To You, My Lad, and The Tractate Middoth

are among the ghost stories of which writer born in 1862?

MR James.

MR James. Correct, yes.

Which ghost story by Henry James

concerns the governess of the country house of Bly

and her charges, Miles and Flora?

That's Turn Of The Screw. That's correct.

And finally, a close friend of Henry James, which US author's works

include the 1910 short story collection, Tales of Men And Ghosts?

INAUDIBLE

Is it Henry?

No, it's Edith Wharton. 10 points for this.

What two-word name is given to the area of New York City

that includes Washington Square Park?

It was associated with the Beat Movement...

BUZZER Sheffield, Mason.

West Village. No.

You lose five points, I'm afraid.

It includes Washington Square Park.

It was associated with the Beat Movement in the 1950s and was

the location of the Stonewall Inn,

the scene in June 1969 of an uprising that started

an international gay rights movement. You may not confer.

One of you may buzz.

BUZZER Manchester, Allwright.

Greenwich Village. Greenwich Village is correct, yes.

APPLAUSE

You get a set of bonuses this time, Manchester,

on the Swiss chemist Albert Hofmann.

Firstly, for five points,

in 1938, while working for a pharmaceutical company,

Albert Hofmann became the first person to synthesise

the hallucinogenic drug LSD.

For what does the letter L stand in this context?

It's lysergic. Correct.

Hofmann synthesised LSD by isolating compounds found

in Claviceps purpurea, a fungus that affects rye.

By what five-letter common name is this fungus known?

We think Ergot. Correct.

And finally, while researching in Mexico, Hofmann investigated

the properties of which species of cactus, the source of mescaline?

I need a six letter name.

Peyote. Can you answer that one?

I nominate you. Peyote.

Peyote is correct.

APPLAUSE

We're going to take a picture round now.

Your picture starter is a translation into French

of one of the gifts listed in the carol,

The Twelve Days of Christmas.

For 10 points, I want its equivalent in the English version.

And to make things a little harder, the relevant number is not included.

You can now turn over your braille card or look at the screen.

BUZZER Sheffield, Watts.

Drummers Drumming. Drummers Drumming is correct.

How many, do you remember? 10?

No, it was 12 Drummers Drumming.

But you got it right.

For your picture bonuses, we've translated three more gifts

from The Twelve Days of Christmas into various European languages.

Again, I want their English equivalents and again,

in each case, you won't be given the number.

Firstly, in Spanish.

Ladies dancing. Senores is ladies.

Nominate Watts. Ladies dancing.

No, it's Lords a Leaping. Senores.

10 Lords a Leaping, there were.

Secondly in German...

Dudelsackspieler. Bagpipers.

It's Pipers Playing. Pipers Piping. Pipers Piping.

Pipers Piping is correct, yes. 11 of them.

And finally, in Portuguese.

Gold rings. Dourados.

Dourados is gold. Dourados is gold. Go for it.

Go for it. Go for it. Do you want to go for rings? Yeah. Go for it.

Gold rings. It is five gold rings, yes.

APPLAUSE

Right, another starter question now.

Which group of seasonal figures connects the Roman god of desire

and attraction, a small icy astronomical object,

the profession of...

BUZZER Sheffield, Watts.

Santa's reindeers. That's correct, yes.

APPLAUSE

Now, your bonuses are on fish traditionally eaten at Christmas.

In each case, identify the fish from the description.

Firstly, a saltwater fish of the genus Gadus.

In Portugal it's eaten with potatoes and cabbage and in Nordic countries

as the traditional dish, Lutefisk.

Nominate Lord Blunkett.

Sardines. No, it's cod. Arghh!

I suppose it could be a very small cod!

And secondly, the traditional main course

in many Eastern European countries,

it's a large-scale freshwater fish of the family Cyprinidae,

with two barbels on each side of its upper jaw.

Perch? What do you think? Perch or pike.

Nominate you. Perch.

No, it's a carp.

And finally,

often eaten at the traditional Lithuanian Christmas Eve supper,

a small saltwater fish of the family Clupeidae which is often salted,

pickled or smoked.

Herring? I think it could be herring. What do you think?

Go for that. Let's go for it.

Herring. Herring is correct.

APPLAUSE 10 points for this.

First produced commercially in 1939 by Imperial Chemical Industries,

what is the most widely used plastic in the world?

BUZZER Manchester, Allwright.

Nylon. No. You lose five points.

It can be made into products ranging from food wrapping

and shopping bags to chemical drums and cable insulation.

You may not confer.

BUZZER Sheffield, Page.

Cellophane? No, its polythene, or polyethylene.

Right, we're going to take another starter question then,

10 points for this.

Which year saw the general election known as the coupon election,

named after the letters given to...?

BUZZER Sheffield, Blunkett.

1918. Correct.

APPLAUSE

So, Sheffield, you get a set of bonuses on Aethelflaed,

the eldest daughter of Alfred the Great.

Oh, bloody hell! Aethelflaed and her brother,

King Edward the Elder, led the efforts to reconquer which region?

It's name derived from the belief that its legal practices

were of Norse origin.

I mean, the only thing I can think of... Dane Geld?

Anybody buying Dane Geld? The Dane Geld.

No, it was Dane Law.

According to William of Malmesbury, which future King of the English

was fostered by Aethelflaed and her husband in Mercia?

I nominate you. Arthur?

No, it was Athelstan.

And finally, Aethelflaed had relics of the Northumbrian Saint Oswald

translated to her new Minster in which city situated

on the banks of the River Severn?

The Severn. Was it Shrewsbury or was it was Worcester? Gloucester?

Gloucester is on the Severn, isn't it?

Gloucester, Worcester, or Shrewsbury.

I would say Shrewsbury, but I'm not sure. David, I nominate you.

Worcester. No, it's Gloucester. Bad luck.

10 points for this.

The name of what foodstuff appears in the first line

of a popular song written by Mel Torme and Bob Wells as a...?

BUZZER Manchester, Allwright.

Chestnuts. Very good.

APPLAUSE

Right, your bonuses are on the names of animals used in an ironical

or insulting sense in Fawlty Towers.

In each case, give the common name from the description.

Firstly, for five points, a large,

even-toed ungulate particularly associated with the Serengeti Plain.

Basil asks the aggressive Mrs Richards if she expects

to see herds of them from her hotel window.

Wildebeest. Wildebeest, yeah.

Wildebeest is correct.

Secondly, an insect of the family Phasmatodea,

able to camouflage itself on plants.

The name follows the words "ageing" and "Brilliantined"

in an insult that Sybil applies to Basil when he attempts

to ingratiate himself with an attractive young woman.

Stick insect? Is it stick insect? It is stick insect.

And finally, a South American fish of the family Characidae...

Oh, yes!

Have you...? We think we know, but do please finish!

LAUGHTER

How kind of you. Thank you! Noted for its sharp teeth.

Basil applies this word to Sybil

when she repeatedly orders him to do the car.

We suspect it's piranha. It is piranha, yes. Well done.

APPLAUSE

Time for a music round.

For your music starter, you're going to hear a piece of popular music.

10 points if you can name the band.

# All men have...

BUZZER Sheffield, Watts.

The Smiths. It is the Smiths, yes.

APPLAUSE

So, Sheffield,

your bonus bonuses are on other Rough Trade label records.

The Smiths were of course one of the most successful signings

of that label, founded in 1978.

Your music bonuses, three more notable releases.

Again, name the band each time.

# Ah oh, ah ah ah oh...

# Oh oh, oh oh oh oh...

# Oh oh oh... Go for it.

Pass? Pass. Pass, thank you.

That was Arcade Fire.

It's a bit modern for you blokes, perhaps!

Secondly...

# I'm eternally grateful

# To my past influences

# But they will not free me

# I am not diseased

# All the people ask me... #

PIL. No, that's The Fall.

And finally...

# Last night she said

# Oh, baby, I feel so down

# Oh, it turns me off

# When I feel left out... #

Do you think it is the Arctic Monkeys? Well, I'll nominate you.

No, no.

It's not that? It's not? Go for Arctic Monkeys.

I'll say it. Go on, then.

Well, we don't think it is, but I'm going to say the Arctic Monkeys,

because they're from Sheffield.

They're from Sheffield, and that's no argument!

It's The Strokes.

Right, perhaps you'll get this one. Another starter question.

Young, Young, Johnson, Williams and Rudd,

have all been members of which influential rock band?

Its short name is said to symbolise,

"raw energy and power driven performances"...

BUZZER Manchester, Aaronovitch.

The Verve. No.

And is often stylised with the inclusion of an international

electrical symbol.

You lose five points, Manchester, for that incorrect interruption.

One of you can buzz from Sheffield.

No? It's AC/DC. 10 points for this.

Trading For The Future and Politics Between The Extremes

are among the publications of which political figure?

Born in 1967, he was elected to the European Parliament

in 1999 and to the British Parliament in 2005,

before losing his seat in 2017.

BUZZER Manchester, Aaronovitch.

In 2007?

No, 2017, I said. In 2017.

Come on! I've got to have an answer from you.

I know, I know, I know. But I got it wrong. OK, right.

I was going to say Douglas Carswell, but he didn't lose his seat. No, OK.

Well, we're going to offer it to Sheffield. One of you buzz.

You lose five points, Manchester.

BUZZER Sheffield, Blunkett.

It was Carswell. It wasn't!

LAUGHTER

It was Nick Clegg. Oh! Argh!

How could you forget Nick Clegg?!

BUZZER Is it Carswell?

LAUGHTER

Right, 10 points for this.

Born in Milan in 1906,

"the father of neo-realism"

is an epithet given to which director

for films such as Obsession and later films

in other genres include The Leopard and...

BUZZER Manchester, Aaronovitch.

Visconti. Visconti is correct, yes.

APPLAUSE

You get three questions on the journalist and author Rebecca West.

Firstly, born Cicely Isabel Fairfield in 1892,

Rebecca West took her pseudonym from the heroine of Rosmersholm,

a play of 1886 by which dramatist?

Ibsen. Correct.

What is the title of West's debut novel?

It concerns Chris Baldry,

a man whose experiences in the First World War

have left him suffering from shellshock?

Return of the Soldier.

Is it Return of the Soldier? Return of the Soldier?

Return of the Soldier? That is correct. Well done.

That takes you to 100.

And finally, first published in 1941,

West's acclaimed work Black Lamb and Grey Falcon is subtitled,

A Journey Through which former country?

Will we say Yugoslavia? I don't know. I think it is.

I think it's Yugoslavia. Yugoslavia?

It is Yugoslavia, yes.

APPLAUSE

Time for a second picture round. Your picture starter.

We've taken a well-known poem

and removed all but the last word of each line.

For 10 points, I want the poem's title.

You can now turn over your braille card or look at the screen.

BUZZER Sheffield, Watts.

Anthem For Doomed youth? Correct. By Wilfred Owen.

APPLAUSE

So we follow on from that with picture bonuses

similarly representing three more major poems of the First World War.

This time, I just need the name of the poet in each case.

Firstly...

Anybody know it? No. No. We'll just try. Edward Thomas?

Do you want to try it? Nominate... We'll try it. Edward Thomas.

No, that's part of Siegfried Sassoon's Suicide in the Trenches.

Secondly, three stanzas sometimes excerpted from a longer work.

INAUDIBLE

It's not Wilfred Owen. I'll nominate you. Wilfred Owen?

No, that's Lawrence Binion, his Ode of Remembrance from For The Fallen.

And finally...

Rupert Brooke. It is Rupert Brooke, The Soldier. Well done.

APPLAUSE

10 points for this.

A heavy overcoat for wet weather and a fearless person,

are among the meanings of what compound word better known

in the context of a turbine-powered or big gun class of battleships

that first appeared in 1906?

BUZZER Sheffield, Mason.

Dreadnought. Dreadnought is correct.

APPLAUSE

Sheffield, these bonuses are on scientific terms.

In each case, identify the term from the description.

All three begin with the same prefix.

Firstly, any chemical compound that retards the reaction by which

a substance combines with oxygen or scavenges the free radicals

that such a reaction produces.

Chemical compound that's a fire retardant.

I don't know. Pass. It's an antioxidant.

Secondly, also called immunoglobulin,

a protective protein produced by the immune system

in response to the presence of a foreign substance?

Antibody. Antibody. Antibody. Correct.

And finally, a subatomic unit of matter or energy having

the same mass but opposite electric charge and magnetic moment

as that of ordinary matter.

It's antimatter, isn't it? Antimatter? Yes. Antimatter.

Specifically the subatomic unit? Anti-atom.

No, it's an antiparticle.

10 points for this.

Born in 1852, which German bacteriologist gave his name

to a shallow transparent dish used for the...?

BUZZER Manchester, Allwright.

Petri. Petri is correct, yes.

APPLAUSE

You get a set of bonuses, Manchester, on a US corporation.

Bethany McLean, Peter Elkind's 2003 book

The Smartest Guys In The Room

concerns the corruption and bankruptcy of which US company?

This is Enron. It is Enron, yes.

With its headquarters at 1,400 Smith Street,

Enron was based in which city in Texas?

INAUDIBLE

It has to be Houston because that's the centre of the oil business.

Houston.

Houston is correct.

Enron filed for bankruptcy in December 2001 during the term

of office of which US President?

INAUDIBLE

2001, it's going to be George W Bush.

George W Bush. Correct.

10 points for this.

Based on the theory of quantum electrodynamics, QED,

The Strange Theory Of Light And Matter...

BUZZER Manchester, Brodkin.

Quod erat demonstrandum.

No. You lose five points.

..Is a work by which US physicist born in New York in 1918?

No? It's Richard Feynman. 10 points for this.

Used notably in 2015 and 2016

to denote an alleged political practice,

what eight letter term is defined by the OED...?

BUZZER Manchester, Aaronovitch.

Fake news. No. You lose five points.

What eight letter term is defined by the OED as the policy

or practice of joining an organisation with the intention

of subverting its aims and activities?

BUZZER Sheffield, Blunkett.

Infiltrate.

No, it's entryism. 10 points for this.

What present participle links a music hall song

by Charles Penrose, an arrow maker's daughter in a poem of 1855,

and a 1624 painting in the Wallace collection?

BUZZER Manchester, Edgar.

Cupid?

No. Anyone like to buzz from Sheffield?

BUZZER Sheffield, Page.

Angel? No, it's "laughing". 10 points for this.

Mandarin, English, Tamil and Malay are the four official languages...

BUZZER Manchester, Aaronovitch.

No, I'm afraid if you buzz, you must answer if you buzz. Malaysia.

No, that's wrong.

Anyone like to buzz? Four official languages of which city state?

BUZZER Sheffield, Blunkett.

Singapore. Singapore is correct, yes.

APPLAUSE

Three questions on works inspired by the Spanish Civil War

for your bonuses, Sheffield.

David Carr, an unemployed British Communist,

joins the International Brigades in Land and Freedom,

a 1995 film by which British director?

GONG And there is the gong.

APPLAUSE

You were just a little too slow answering there.

It was by Ken Loach, of course. So Sheffield, 90.

90 is a perfectly respectable score, though.

Well, it's not a particularly respectable score,

but it's all right! You old sarky!

That's a terrible sneer! There's no call for that!

So congratulations to you, Manchester.

115 isn't a high enough score

to come back as one of the highest scoring winning teams.

But thank you very much for joining us

and thank you for your sartorial contribution, too.

Thank you very much.

I hope you can join us next time

for the final first-round match of this series.

But until then, it's goodbye from Sheffield University. Goodbye.

It's goodbye from Manchester University. Farewell. Goodbye!

And it's goodbye from us. Goodbye.

For more infomation >> University Challenge - Christmas 2018 E06 Sheffield University v Manchester University - Duration: 28:40.

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

Taking Charge of Excel - Excel Skills for Business: Essentials by Macquarie University #3 - Duration: 7:08.

Sean has just started a new job where he's going to be working with Excel quite

a lot and he's feeling a bit nervous.

Let's help Sean take charge of Excel.

I have just opened Excel 2016, if you are working with an older version,

you may find some things look a bit different but

they mostly work the same, so don't worry.

In 2016, you will come to this screen where you can chose to open a file you

have been working recently or got to a blank workbook.

We're going to click Blank Workbook.

And here we are, welcome to Excel.

Let's start by getting familiar with where things are and what they're called.

To begin with, we have a large toolbar at the top of our screen.

This is called the ribbon, and it contains nearly all the tools we're going to need.

There were so many though, that they couldn't fit them all into one stretch.

So we're on the Home tab of the ribbon, but you'll notice there's also an Insert

tab that has tools for inserting things like pictures and charts.

Or there's a Data tab which gives us tools for working with data, like sorting and

filtering.

As we go through the course, you'll become more familiar with the tabs and

the tools on them.

Coming back to the Home tab though, I'd like you to notice that the tools haven't

been scattered randomly across the ribbon, they've been logically grouped.

So for example, this group is called my Font group and

it contains all the tools that I need to change my text.

At the bottom right hand corner of some of the groups,

you'll find what's called a small dialog launcher.

If you single click on that, it opens up your additional options.

We won't need these very often, but it's nice to know they're there.

I'm going to click Cancel to close.

One tab on the ribbon that is a little bit special, is the File tab.

When we click on the File tab it brings us to the Backstage View.

And this contains all the tools we need for managing our file,

like Open, Save, or Close.

To come out of the backstage view, click on the back arrow or

press the escape key on your keyboard.

Now we'd like to use our backstage view to open our first file.

So I'm going to click file and make sure you've come to Open.

If you have worked with the file recently, it will appear in your recents list.

Otherwise, you will need to click the Browse button.

If you haven't already, please make sure you've downloaded the file you need for

this practice video.

Then navigate to it.

Mine is in the Documents folder, and I've put in Excel Essentials.

The file we need is W01 V01 take charge.

And I'm going to double-click to open it.

We now have something to look at.

The ribbon does take up quite a lot of space, and so

we have the option to collapse it by double-clicking on any of the Tabs.

That does free up space, but

it can be a bit alarming when your ribbon suddenly vanishes.

If that happens by mistake, don't panic,

to get it back just double click on any of the ribbon tabs and we're back.

Now just above the ribbon, you will notice another toolbar.

This little guy is called our quick access toolbar, and

it has my two favorite commands, save and undo.

It also has the redo, but even more importantly we can change

this quick access toolbar to contain the tools that we need.

If I come to the drop down arrow and click, it gives me some favorites.

There's some really great stuff here, I'm going to click on the Sort Ascending.

Now if I need to quickly sort my data by city,

I can click into city, click A to Z, and my data's resorted.

What about all the other tools that aren't on our drop down?

Well they can be added too.

So for example, I'm going to click on my Review tab, and

come to my Spelling and my Proofing group.

Now this time I'm going to right-click, and then click,

Add to Quick Access Toolbar, and there it is.

So absolutely any tool in your ribbon can be added to the quick access by

right-clicking.

Customize this toolbar to speed up your workflow.

Just under the ribbon, you will see another bar called the Formula Bar.

This bar allows you to see what data is in a cell, and also edit the data.

Now let's come down to the main section of our worksheet.

When you open an Excel file it is typically called a workbook.

And a workbook will contain at least one worksheet.

Inside a worksheet you will notice it is divided into columns and rows.

At the intersection of each of these is a square which we call a cell.

I'm going to click on the cell and

you see it gets a solid border telling me that this is the active cel.

Each cell also has a unique identifier made up of

it's column letter and row number.

So I am clicked on D2, if I click into this cell, I'm now in C1.

Last quick thing, at the bottom of your workbook is another small bar

called your status bar, it's gray in 2016 but may appear green in other versions.

If I were to select some numeric data, you will notice my status

bar gives me the average, count and sum of those values.

So the status bar can be used to see what's happening in your workbook and

also modify some of the views.

We will look at how to use it more in the next video.

The last thing we want to do now is close our workbook.

To do this I'm going to click File and Close.

Excel will check if I want to save first,

if you want to keep your changes press save, if not don't save.

Now it's your chance.

Have a go clicking around the ribbon and trying out the different tools.

Be brave.

You can't break Excel.

For more infomation >> Taking Charge of Excel - Excel Skills for Business: Essentials by Macquarie University #3 - Duration: 7:08.

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

Biozentrum University of Basel | Wikipedia audio article - Duration: 9:20.

For more infomation >> Biozentrum University of Basel | Wikipedia audio article - Duration: 9:20.

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

Boston University College of Arts and Sciences | Wikipedia audio article - Duration: 1:58.

For more infomation >> Boston University College of Arts and Sciences | Wikipedia audio article - Duration: 1:58.

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

University of Copenhagen Faculty of Science | Wikipedia audio article - Duration: 4:07.

For more infomation >> University of Copenhagen Faculty of Science | Wikipedia audio article - Duration: 4:07.

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

Botswana International University of Science and Technology | Wikipedia audio article - Duration: 4:02.

For more infomation >> Botswana International University of Science and Technology | Wikipedia audio article - Duration: 4:02.

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

Regent University College of Science and Technology | Wikipedia audio article - Duration: 5:46.

For more infomation >> Regent University College of Science and Technology | Wikipedia audio article - Duration: 5:46.

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

Daniel Murphy | Newman University 2018 Graduate - Duration: 2:41.

Well in this new chapter of my life, getting an MBA has been a long life goal

of mine and thanks Newman University it's made it possible. I think that the

small class size and the very professional faculty and staff were just

a tremendous asset to the degree. And the business analytics program has been

phenomenal so far. I got a couple classes to take in the summer, so cross my

fingers, but there's a little asterisk by my name in the program.

But Dr. Simmering teaches the business analytics concentration, and he

brings a lot of experience inside the classroom. And we use hands-on technology

with a lot of industry software to help analyze data, big data. I went in thinking

that it was going to be simple. Not simple, but I didn't think it would be as

time consuming as it was, and it was pretty rigorous, but the instructors help

you through it. If you have a question, I've often emailed my professors and

they were quick to respond, very professional with a lot of industry

knowledge they take to the classroom . But they made a very difficult

curriculum possible because of their close interaction with their students.

I hope to just expand my opportunities beyond my pre-existing skill set. So by

expanding that knowledge to business analytics which is a hugely demanded

skill, not only does it help me in my current position, but later on down

the road. And who knows when that might be? Other doors might open

within my current organization or elsewhere. Yeah, I would definitely

recommend it. The number of MBA concentrations are really broad, from

finance to management, to now business analytics

and Healthcare Administration. So I think that those tracks are specific to

Newman in how they can deliver a better concentration than other universities

around the area I really think that the MBA program really stands out and really

makes a difference in the experience of the student.

For more infomation >> Daniel Murphy | Newman University 2018 Graduate - Duration: 2:41.

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

New York University Graduate School of Arts and Science | Wikipedia audio article - Duration: 2:43.

For more infomation >> New York University Graduate School of Arts and Science | Wikipedia audio article - Duration: 2:43.

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

David Curry: Religious Freedom in a Time of Growing Persecution [Biola University Chapel] - Duration: 21:44.

For more infomation >> David Curry: Religious Freedom in a Time of Growing Persecution [Biola University Chapel] - Duration: 21:44.

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

Excel Templates - Excel Skills for Business: Essentials by Macquarie University #10 - Duration: 2:30.

So we've now seen how we could create our own Excel workbook from scratch

using the blank workbook template.

If you wanted to create a more sophisticated Excel spreadsheet,

it can be a little tricky though to know where to even begin.

Excel helps us by giving us a large selection of templates

that we can choose from to get us started.

Let's take a quick look at how we can use Excel's online templates.

If you open one of the newer versions of Excel,

you will see a large range of templates as you open it.

If you're working with one of the older versions, you may need to select, File and

New and again, that will let you choose either a blank workbook or

a selection of templates.

If you scroll down you will see there is quite a lot to choose from just from this

brief preview.

There are project trackers, to do lists, budgets.

But if you have something quite specific in mind and

you can't see what you need here, you can do a search for it.

And there are hundreds of online templates, so

chances are there will be one that meets your needs.

We need to create an invoice for the first time.

So we're going to click into the search bar and type invoice and

then press enter or click the search icon.

You will need an Internet connection as most of the templates are located online.

You can see a large selection has been returned from my search criteria.

And when I scroll down,

I'm just going to look through until I find one that kind of meets my needs.

This one looks good.

So I'm going to click on it once to preview it.

If you're not happy with it,

you can continue to preview the others by scrolling through using the arrow keys.

When you find the one you want, then click the create button or

on older versions, the download button.

And what that will do is download the template and

create a brand new workbook from that template.

Now, all you need to do is customize this to your own needs.

So really easy to use Excel templates to get you started.

[SOUND]