Practice Video: Data Entry, Data Types, Editing and Deleting

Loading...

Do curso por Macquarie University

Excel Skills for Business: Essentials

1451 classificações

Macquarie University

Excel Skills for Business: Essentials

1451 classificações

Curso 1 de 4 em Specialization Excel Skills for Business

In this first course of the specialization Excel Skills for Business you will learn the Essentials of Microsoft Excel. Within six weeks, you will learn to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs. Whether you are self-taught and want to fill in the gaps for better efficiency and productivity, or whether you have never used Excel before, this course will set you up with a solid foundation to become a confident user and develop more advanced skills in later courses. We have brought together a great teaching team that will be with you every step of the way. A broad range of practice quizzes and challenges will provide great opportunities to build up your skillset. Work through each new challenge with our team and in no time you will surprise yourself with how far you have come. Spreadsheet software is one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. At a time when digital skills jobs are growing much faster than non-digital jobs, make sure to position yourself ahead of the rest by adding Excel skills to your employment portfolio.

Na lição

Critical Core of Excel

In this module, you will learn about key foundational features of Excel: The Excel user interface, basic Excel terminology, how to operate essential navigational controls in Excel and how to perform basic data entry with Excel spreadsheets.

Practice Video: Taking Charge of Excel7:07

Practice Video: Navigating and Selecting5:36

Practice Video: View Options5:29

Practice Video: Data Entry, Data Types, Editing and Deleting6:46

Practice Video: Fill Handle5:30

Week 1 Wrap-up1:41

Conheça os instrutores

Dr Yvonne Breyer
Director, Learning and Teaching
Faculty of Business and Economics

We're now ready to start creating our workbooks.

As a practice exercise,

let's help Sean, create his expenses for the day.

To begin with we're going to need a new workbook.

To do this we're going to come up to the File tab on our ribbon and click.

Come down on the green panel until you find New

and click and then select blank workbook and again it's a single click.

We now have our blank workbook.

Let's quickly zoom in so we can see what we're doing.

I'm coming down to the zoom slider and just clicking the plus a few times.

You will notice that the first cell A1 has a green box around it.

It is by default the active cell and that

means we can just start typing directly into it.

So I'm going to type expenses and now I could click away but in Excel,

it's better practice to press Tab to jump to the cell to

the right or press enter to jump to the cell below.

This commits the change and moves you down one cell.

We're going to press Enter again to get one more down.

Right. Next thing we're going to type is item,

but now I want to go right,

so press tab and it's gone one cell to the right where I'm going to type cost.

And press Enter.

You'll notice it actually jumps down and back to the first empty cell in the next row.

This makes your data entry very quick and easy.

Right. Sean's first expense was his train, right?

So we're going to type train and press Tab and that costs $6.30.

So I'm just going to put 6.3.

We don't need to worry about putting extra decimal places or the dollar sign,

as we'll look at how we can use formatting tools to do that easily in a later video.

Now click Enter. All right.

Sean also bought a coffee,

so let's put a coffee in and press Tab and that cost $3.50 and then lastly,

he bought some lunch and that cost $12 and enter.

He also bought a juice,

but then he realizes actually he didn't buy that juice today.

That was yesterday.

So now he wants to delete that value from that cell.

Deleting is easy.

Select the cell or cells

where you want to remove the data and press the delete key on your keyboard.

This will not remove the cell,

just the contents of that cell.

Please note, pressing Delete on your keyboard and

using the delete on your ribbon are quite different.

The delete on the ribbon actually removes the cell

and that may cause other data in your spreadsheet to move.

So don't use that unless you actually want to remove the cell itself.

Sean now realizes he actually has made a bit of a mistake.

The train journey didn't cost him $6.30,

but he's going to have to catch the train home again so he wants to double this value.

If you wish to replace the value in a cell,

single click and over type by putting in the new value.

So we're going to put in $12.60 and press enter.

In a situation where you want to modify the contents of the cell you have a few options.

So I'd like train to actually say train ride.

Start by clicking on the cell you want to change,

then you can either come up to the formula bar,

click in the formula bar and type your change.

Now I actually don't want to keep that,

so here's a nice little trick.

If you've started modifying a cell and you don't want to

keep your changes, just press Escape.

You don't need to press Undo,

because you haven't really committed the change until you press Enter.

Now another way you can edit a cell,

is to double-click on it.

You see my cursor is now blinking in the cell and I can type

in my change and again, click Enter.

The keyboard shortcut for double-clicking is to press

F2 and then again if you don't want to make the change press Escape.

Next thing we need to do is type in a date.

So I'm going to come up to cell B1 and I'm going to type in

the current date which is the 12th of the fourth 2017.

Now it's really important when you type dates into Excel that

you use the correct format for your regional settings.

So, in Australia for example,

we type day, followed by month, followed by year.

If I was in the US, I would need to put month and day and year.

Once you finish typing, click Enter.

And you will notice that Excel has actually made

my column wide enough to fit the date which is really handy,

but it doesn't do that for all your data.

So if you decide you want to adjust your column widths,

come up to the top where you have your column letters,

find the little separating line but to the right of the column you

want to make wider and then click and drag.

It is a very bad idea to leave blank columns in the middle of your dataset,

so if you need to,

rather just make your columns a little wider.

Now one last little thing to finish off our expenses,

we need to total them up.

So I'm going to click into B7 and here's a great trick.

We're going to come up to our Home tab on our ribbon and on the far right,

you will see a tool called AutoSum.

We'll look at working with calculations and a lot more detail next week,

but if you just quickly need to add up some numbers you can click on the AutoSum.

You'll see it's added up all the numeric values above

the cell where I originally clicked and then just press Enter.

So that's Sean's expenses complete.

Why don't you now practice at creating your own expenses.

Explore nosso catálogo

Registre-se gratuitamente e obtenha recomendações, atualizações e ofertas personalizadas.

O Coursera proporciona acesso universal à melhor educação do mundo fazendo parcerias com as melhores universidades e organizações para oferecer cursos on-line.

© 2018 Coursera Inc. Todos os direitos reservados.

Baixar na App Store

Baixar no Google Play