Auto news on Youtube Jan 1 2019

I'm Professor Philip Nolan. I'm President of Maynooth University.

People who look at Maynooth from the outside, the thing that immediately strikes them is

just how dynamic the institution is, how innovative, this very strong sense of momentum, very strong

sense of rapid growth and very strong sense that we're making a real contribution

to our region, to our country and are having a significant impact globally.

My name is Conor Simpson and I'm Mid East Regional Manager for IDA Ireland.

When you look at the skill sets within the university

and you look at the research capability that's there,

we often say that Maynooth University is one of the best kept secrets of the region.

I'm Baroness Nuala O'Loan and I'm the Chair of the Governing Authority.

I think Maynooth University seeks to develop in the student

the capacities, the skills, the experience, the confidence, which will

equip them to go out into the world and to contribute to society, in a way that I don't think other universities do.

Many students come to university not knowing what it is they are going to do with the rest of their life.

The Maynooth experience, between the undergraduate and post graduate experience,

is designed to enable them to develop a determination

that this is where they actually want to work and this is what they actually want to do.

My name is Rachel Rolfe and I am doing a BA in Media Technology.

I choose Maynooth to be able to mix and match different subjects. When I initially came

into first year, a lot of my computer science lecturers thought I was crazy because I took computer science,

I was doing Chinese and I was doing anthropology in first year and they were like "how do they even relate?"

Students have the capacity to range across different disciplines and different subjects,

assembling their own portfolio of learning

and their own set of skills, making them unique as graduates when they emerge from the institution.

The bedrock for us is world class research and bringing together in this campuS

some of the best researchers in Ireland and in Europe to focus on really important problems.

We hope that the research carried out in this lab will have a significant impact on the

lives of patients who are suffering from chronic inflammatory disorders

in reducing their level of pain and increasing their quality of life.

My work on observations of climate change really are foundational

to everything about climate change science.

Without observing, we can't know what has happened.

Without knowing what's happened, it's impossible to predict what may happen in the future.

It's one thing to have a lot of technology advancement but we must do this in parallel

with society, with communities with the rest of the world. We can't do it in isolation.

Our research is focused on problems that face modern society, but we bring very different

perspectives and very different disciplines to bear on those research problems.

One of the key strengths of many of our projects is that they are what we call engaged research.

So, they are not just about producing data, and academic papers etc, they are also about

shaping the policy agenda, rather than pure applied research for it's own sake.

My name is Rose Ryan, I'm the Director of Access at the Maynooth University Access Programme.

The Maynooth University Access Programme reaches out into communities that have traditionally

had less of a likelihood of progressing to higher education and we work with those groups,

their families, their communities, in partnership to try to support them into higher education

but also helping them once they're here, to settle in,

connect to the university and connect to the campus.

My name is Leon Diop, I am 23 years of age,

I'm from Tallaght and I'm about to graduate in Psychology.

For people like myself, it was tougher getting into 3rd level education than most.

If I didn't have the supports provided, I definitely would have left college a long time ago.

The ideas of the future emerge in dialogue between people from different perspectives

and different cultures. And, for that reason, we enrich the campus here and we strengthen it

by being diverse in the students that we recruit, diverse in the staff that we appoint

and a really important part of that is to be international.

My name is Siddhartha Roy and I am from Kolkata in India,

and I am currently doing my post-graduate masters in International Business Law from Maynooth University.

The cultural and the global experience that I have gained by coming here to Maynooth

and mixing with people from all over the world,

I've been able to learn a lot and gain various new perspectives across different avenues in life.

It's a very active campus, with a variety of clubs and societies

and it's a wonderful opportunity to meet other people and talk to them.

My experiences overall that I achieved from the university will be something

that I will carry along with me for the rest of my life.

Our alumni, we're so proud of where they've found themselves.

We have alumni who are ambassadors, we have alumni who are social innovators,

we have alumni leading major finance houses. So, the diversity of destinations

for our alumni is their striking feature and the fundamental skills that they learnt at

university, how they are applying those in their careers is really quite striking for us

and something we are very proud of.

I'm Marie O'Donoghue and I work in PwC

in the people and consulting advisory practice.

It's not necessarily a traditional path to move from a BA in English and Geography into management consulting,

but I felt that the range and breath of subjects which I had access to and exposure to

is definitely something that has led me into this as a career.

(Europe's Rosetta cometary probe is today)

(travelling into deep space in its quest to discover the origins of life.)

My name is Laurence O'Rourke, I work in the European Space Agency

as a Rosetta science operations manager.

Maynooth built on the interest I had in science and made me who I am today.

In reality, it's created a foundation which was extraordinary in nature

and which I continue to rely on in my day to day life.

Out of the city, a place dedicated to learning, it's impossible to come to this place

and not be inspired. Whatever you are doing on the campus, it's simply an inspirational place to work

because of the interest and the enthusiasm of the people

and the environment in which we're lucky enough to work.

For more infomation >> Maynooth University: Know No Bounds - Duration: 7:36.

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

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

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.

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

Eng CC) VLOG : 대학생 일상 브이로그. 안녕 2018, 안녕 2019. University Student Daily. Bye 2018, Hi 2019 - Duration: 15:15.

I bought pajamas, this is

super soft

Really soft~~

(How to make Tteokguk)

(Put mom made stock in another pot)

(Of course, it already has to be done seasoning)

(Put rice cake in the pot as much as you want)

(If you already feel hungry, eat a dried persimmon)

(If you don't have this in your home, you can replace a sweet potato mallet)

M - Hey, you are wasting the heat

M - You had to use other small burner

M - Why you always don't match the size of burner?

I just wanted to eat more hurry

M - You can't eat more hurry even you use there

No, it can be more hurry (Soom is sad)

(Eventually I moved it to small burner)

(If the rice cake is soft, then put in to a bowl)

(And also put spring onion that mom prepared,)

(seaweed that you have,)

(plus, my mom's made meat)

Oh I will put all meat

M - No, your brother will eat later

(We have to leave very very little meat for brother)

Finish! (Wow, it was really hard)

(I felt heavy when I lift coffee cup)

(I have to exercise next year for sure!)

Hi

(Today also shying)

Today is Friday, 28th, December

I thought I won't buy diary for next year

Because I always..

didn't write diary from every March

I did like that 2018

and also 2017

But yeah, I bought it again

(I believed me again)

I had some event that I didn't expected

So I think

I will need memo note

And I will write it for sure

for sure!!

So I got this

Did you plan your next year goal?

I didn't do it yet

But I have some things I already thought

So, now

So I will make a note now

First, I will write it on my phone

and I will write again in my diary later

when I organize all

Next year...

2019

My Goal

and...

and To Do list

My first goal of 2019 is..

Something that I couldn't achieve in 2018.. (Too many)

What should I do?

Actually I..

I planned getting drive license

on this winter vacation

But I have to delay it because I have no time for it

Oh! I will write the goals that I really really can fulfill

So... put body wash..

No! Put body lotion,

hand..

hand cream,

and lip balm

everyday

and also when I feel

my skin dry

I usually really didn't put these things

So when winter is coming

I can see blood on my skin

because my skin is super dry

and my lips also

My legs and hands also

But I couldn't apply it because I'm lazy

So this is my first goal

Second is..

eat more healthy food

This is very important part

I really like instant foods

So I eat it a lot

Yeah, I also eat home made food

But when I stay home alone,

I become more lazy, so I eat instant ramen

I frequently eat hamburger because I like it

and also french fries that I love

So I want to reduce eating these food

And I will try to eat more healthier Korean foods

If I still eat many instant food when I live alone,

maybe..

you can see

my hospital VLOG

So, it is my second goal

Write every,,

Write dairy everyday

No no, not everyday

Every week

Write every week

I think I will never keep that goal

If I want to write dairy everyday

I know me

I never have the writing habit

So I will write it 'every week' next year

And next.. Think one more time

before when I buy something

Think more before buy something

This is not 'don't buy something' and it just think more

'Is it really I need?'

'If I don't buy it, will I die?'

'Is it daily necessity thing?' or 'Is it really important to me?'

I will think like that again

But I don't tell I will not buy

It is too tough and hard

that tell me 'do not buy anymore!'

I think I have to buy something

(Just my inner mind told it)

Yep, I can buy, but think one more

(I just want to move next goal)

Do not use swear words

I think when we get older more and more, we have to use good words

And it also seems more cool

Um.. it is not specially cool thing

Yeah everyone has to not use swear words

I had many angry events this 2018.. so.. I used..

bad words..

But I will not use it next year

I will try to use good words

and also positive things.. ah!

Think more positively

I will think positive

and not use bad words

Also, I will try be happy

I think this two things is super important to me

My friend told me

If I use bad words, not only other people can heard it

and also I can heard it even I used it

So it is not good for me

I didn't know well what mean is

Now, I can understand it

I thought about that more

So, let's don't use it together!

Yeah, this is all thing now I thinking

I think the goal can change everyday and can add something whenever I want

So, this is all now

It is just 6 things, and I really can keep these if I try little

So I will keep this and try to live in happy this 2019!

(I felt, these day I put on only this shoes)

Wow, too many people in here

Y - Yeah too many

Y - Today, here is like an ant tunnel

What will you buy today?

Y - Scheduler

I thought you will buy a book

Y - Oh I don't study

Yeah, you never read a book

Y - What??

Y - I read many books

Y - Recently I read Goethe's Faust

Oh don't lie to me

Y - It is real!

Y - But yeah, I read just little pages because it has too many pages

I knew it, you just read 2 pages

Y - No, no

Y - Isn't it too cute?

Would you like to choose hurry?

Y - We have lots of time

Y - Did I make you tired?

Of course, even from we just met (To make fun of my friend is my biggest happiness)

Y - Wow, you felt tired from that time

Y - Oh you take this moment in your video?

Y - Isn't it too show-style?

Congratulation to get a job!

Y - What is this?

Take out it please

Y - Oh, so many bath bomb here

There are three of bath bomb

Looks so tasty~~

Um! Delicious!

She is really nervous

(She doesn't have to nervous)

(Oh go through well~~)

I think my friend is coming now

Is she?

Or not?

Is she right?

Right, right!

Run! Run!!

Um.. 2019 is coming, so do you have goal?

S - You just telling about another topic, aren't you?

Um.. No

S - Is it already done?

Yes

S - I didn't heard all

S - New year goal?

S - Yes I have

What is it?

S - I will born again

Y - as diligent person

Oh I thought you will be gone in real

(I went to theater to watch Aquaman)

Master's skill

Cute!!

Looks like human!!

S - The foots are chubby

J - It is pig

S - Cute

S - and really quiet

Happy new year

Bye bye~~

10

9

8

7

6

5

4

3

2

1

This is first music I listened, 2019

For more infomation >> Eng CC) VLOG : 대학생 일상 브이로그. 안녕 2018, 안녕 2019. University Student Daily. Bye 2018, Hi 2019 - Duration: 15:15.

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

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 University of Sheffield v University of Manchester - 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 University of Sheffield v University of Manchester - 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.

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

Navigating and Selecting in Excel - Excel Skills for Business: Essentials by Macquarie University #4 - Duration: 5:37.

To navigate in Excel,

the easiest way is to use the scroll bars.

We have a horizontal scroll bar,

which will allow us to go right and left,

and a vertical scroll bar,

which will allow us to scroll down and up.

At either end of the scroll bars,

you will also see small arrows that allow us to make smaller movements.

So, for example, I can click here to move up one row at a time.

Using the scroll bars, however,

is not always the most efficient method.

Sometimes it is quicker to use our keyboard.

For example, we have four arrow keys,

which will allow us to easily move left, down,

right, and up one cell at a time.

If you need to make bigger movements,

two really useful keys are the Page Up and Page Down.

What they do is take us down one screen's worth at a time.

So, you can see at the moment I'm on row 562 at the bottom here.

If I press my Page Down,

you can now see 563 at the top and if I press Page Up,

I'm back to where I was before.

One super useful shortcut is the Control Home button.

Press it, see what happens.

Control Home takes you back to the beginning

of your spreadsheet and in a very large spreadsheet,

that can save you a lot of time.

You may also wish to navigate to different sheets within a spreadsheet.

If you have a look at the bottom here,

you'll see I actually have three worksheet tabs and each of these is a different sheet.

To move between these,

simply click on the appropriate worksheet tab,

and I'm going to move to Sales 2016 now to look at selecting data.

To select a single cell,

simply click on that cell,

and this a single click not a double-click.

This cell then becomes the active cell and you can

recognize it because it's got a solid border around the edge.

If you wish to select more than one cell,

click on the first cell in your selection,

hold your mouse down and drag to the last cell.

You'll notice that they all become highlighted

except for the first one that you started on.

Don't worry that is still part of the selection.

Be very careful however when selecting that you make sure you have the big white cross.

There are three icons you need to look out for.

The big white cross is your Select icon.

But if you come to the edge of the cell,

you will notice you get a skinny cross with black arrows on the edge.

This icon is actually your Move icon.

So, if I click and drag now,

what it has actually done is move the data.

Oops! I didn't mean to do that. Don't panic.

Nearly every mistake in Excel can be undone just

by clicking on the Undo button on our Quick Access Toolbar.

So, I'm going to do that now.

The third icon you need to look out for is a little skinny cross with no arrows.

You get this when you hover over the corner of the active cell.

This time, when I click and drag,

it looks like it's selecting but,

actually, it has copied the data.

Again, that's not what I meant to do,

so I'm going to undo that.

So, remember when selecting,

you want the big white cross.

To select an entire column of data,

you can simply click on the appropriate letters.

So, to select column C, I click on the C. You can also select multiple columns.

So, let's say I want to go A to E, I click on the A,

and hold down and drag till I get to the E,

and of course you can do the same with the rows.

So, to select row five,

I'm just gonna click on the number five.

Between the row numbers and the column letters is a funny little corner,

and if you click on that,

you select your whole spreadsheet. Nice and easy.

Sometimes you want to select larger sets

of data and clicking and dragging can be quite slow.

So, another option is to click on the first cell in your data set,

then hold the Shift key down and click on the last cell,

and that will select everything between your two clicks.

But wait there's more.

An even quicker way of doing this is to click somewhere in

the data set and then use the shortcut Control A.

Control A for all. Very nice and quick.

One last thing, sometimes you need to select

two sections of data that are not next to each other.

We call this non-contiguous data.

So, let's say I want my account managers and they Q4 results.

I start by clicking,

selecting my account managers but if I now try and select my Q4 results,

oh dear I've un-selected my account managers.

So, let's try that again.

I'm going to select my account managers,

but this time I'm going to hold down the Control key and select my Q4.

Excellent. Now it's your chance to give it a go.

For more infomation >> Navigating and Selecting in Excel - Excel Skills for Business: Essentials by Macquarie University #4 - Duration: 5:37.

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

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.

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

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.

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

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]

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

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

Week 1 Wrap-Up - Excel Skills for Business: Essentials by Macquarie University #8 - Duration: 1:42.

Congratulations! You've taken your first all important steps to take charge of Excel.

With the skills and tools you have learned this week,

you're now ready to perform a whole range of

activities with this complex but amazing bit of software.

It's one thing of course to work alongside Nicki in the practice videos,

and another to venture out on your own.

But this is where it gets interesting.

Trust yourself and start experimenting.

Open the practice challenge for this week,

and get ready to be amazed at how far you have come already.

To reinforce what we covered this week,

test yourself with the quizzes and study the results in the two books.

Here you will find the shortcuts, terms,

and concepts that we work through each week,

and keep an eye out for our ninja tips.

To get the most out of this course,

make sure that you set your goals and make a plan on how to achieve them.

Try to schedule a bit of time once a day to study and practice.

Remember, practice makes permanent.

Before we call it a day,

I wanted to say how excited we are to have you

with us on this journey. You are not alone.

If you have a question,

get stuck, or need some inspiration,

jump onto the discussion forum and connect with

us and the other learners from around the world.

Now, get into the practice challenge,

work hard, and have some fun.

See you next week.

For more infomation >> Week 1 Wrap-Up - Excel Skills for Business: Essentials by Macquarie University #8 - Duration: 1:42.

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

Excel Discussion - Excel Skills for Business: Essentials by Macquarie University #2 - Duration: 3:40.

Welcome to week one. Welcome, Nikki.

Thank you.

Sean's tasks for this week is that he has to get used to

Excel and understand its user interface.

So, Nikki, do we really need to learn this stuff?

I know we're just saying, Prashan, it's the basics.

But the reality is that whether you've been using

Excel for a little bit or even for quite a long time,

most of us are self-taught.

Exactly.

The problem with that is there are lots of gaps,

and we don't even know where those gaps are.

So, the point of this course is to help fill those gaps.

In that way, we can start building a really solid foundation,

unpacking how Excel actually works,

and so that we can move forward with confidence.

So, the point of this week is to take control of Excel,

to stop feeling like we're at the mercy of Excel.

We want to be in the driver's seat,

in control, and feeling confident about how we're using it.

To take charge of Excel,

how do you think the best way to break it down into different steps for our first week?

Good question. So, I think,

first of all, we need to get familiar with the user interface.

What I'd like to start with a bit of a name and shame.

So basically, we can use something for 10 years but not know what it's called,

and then we have the problem in that we don't know how to ask for help on it,

and when we're asked questions about it,

often we don't even understand the question.

So, we're going to find what everything's called, find where it is,

and just start getting more comfortable with clicking

around and not being scared because there's nothing to be scared off.

Once we're comfortable with Excel and we know what everything is called,

what do you think we should do next?

Okay. Next up, it's important that we can navigate

confidently but also efficiently around the user interface.

So, you may be kind of getting around,

but let's look at some of the quicker ways of doing that and also selecting data.

It sounds obvious, but we have to do with quite a lot and there

are a few tips and pitfalls,

and I'm just going to make sure that our learners can navigate those successfully.

Once we get to understand how to go through a huge Excel spreadsheet,

what do we do next?

Okay. So, next up,

what we need to do is look at actually entering data.

This is something that just about everybody's going to have to do at some point.

It's reasonably straightforward. But again,

some different data types behave slightly differently,

and we want to make sure that people can work efficiently,

confidently enter, and confidently delete and edit data as well.

Coming back to the point of data entry and efficiency,

as well as what you said about the naming and

shaming and understanding what things are called,

I've always use the fill handle for years and I didn't know it was called.

So, it's hard for me to ask for help about it or have discussions with my colleagues.

So, it's great that you'll be embedding this

and giving us the actual names of all these tools.

Absolutely, and the fill handles actually the full thing we'll be

looking at this week. Excellent, Prashan.

Now that we've broken it up into different parts for this week,

you can take charge of Excel.

We'll be showing you videos to practice alongside with us,

which you need to also practice after we have completed

the videos because practice makes permanent when it comes to Excel.

You can't break Excel.

You might as well do what we're doing and practice it so that you master Excel,

so that you can become productive in your workplace.

Thank you, Nikki. Now, it's over to you.

For more infomation >> Excel Discussion - Excel Skills for Business: Essentials by Macquarie University #2 - Duration: 3:40.

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

University of Maryland College of Computer, Mathematical, and Natural Sciences | Wikipedia audio ... - Duration: 1:33.

For more infomation >> University of Maryland College of Computer, Mathematical, and Natural Sciences | Wikipedia audio ... - Duration: 1:33.

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

Thatu Awith | තටු ඇවිත් - University of Kelaniya Theater Production - Duration: 6:51.

"ජිවිතයද වේදිකාවකි" අප චැනලය Subscribe කරන්න