Use the clickable sections below to skip through

different parts of this tutorial.

First, launch the program.

A window will appear with various templates.

These are ready-made workbooks you can choose

so you won't need to create one from scratch.

To use a template, double-click on the icon.

Total a List is a popular template for shopping lists.

You can choose other useful templates,

like this one from the homepage, for other common uses,

such as the mortgage loan calculator

and the time-sheet template.

All of the individual rectangles on the page

are called cells.

You can double-click on a cell,

type some information,

and press enter.

That information will then be stored in the cell.

At the top of the sheet,

you'll see letters from A to Z.

These are the columns.

If you click on letter D,

it'll highlight all the cells in column D.

The numbers down the left-hand side indicate the rows.

Click on a number to highlight the cells in a row.

When using Excel, you'll want to know which cell

your information is in when using formulas.

Each cell is named by the column letter

followed by the row number.

Let's click on this cell.

The column G is highlighted at the top;

the row nine is highlighted on the left.

On the top left of your screen,

you'll also see names of the cell here. G9.

You can select multiple cells,

which is useful when you need to create formulas

or want to move cells around.

Click on a cell and drag your cursor

across other cells to select a group.

Let's select all of our cost prices.

We'll click on C5 and then drag down to C13.

Once selected, you can hover over the edge of the selection

until you see the grab icon.

Click and drag to move your cells around.

When using formulas in Excel, you may need to refer

to a group of cells you're selecting.

This is called the range.

This is done by typing the name of the cell

in the top left corner, followed by a colon,

followed by the cell in the bottom far-right corner.

This range would be called C5 to H13.

Open up Excel and double-click on "Blank Workbook"

to start creating your spreadsheet.

We'll start by giving our spreadsheet a title.

We're making a buying report for our startup clothes line.

Then we'll give each column we need a heading.

Here we'll type "Item," and then we'll list

all our clothing items in stock below.

The next column we want to add

is the cost of the products.

First, let's let Excel know that we're entering prices.

To do this, type the cost into the cell,

double-click the cell,

and then click on the drop-down here

and select "Currency."

Let's now highlight the rest of the cells

we want to be in this currency

and do the same thing.

Continue to populate your spreadsheet

with the rest of the information you need.

Formulas calculate the value of cells.

To create a formula, first select the cell

where you want to see your answer.

At the top of your screen,

click on the white bar next to the "fx" sign.

This is where the formulas are stored for each cell.

You'll be able to write formulas here,

as well as edit them.

Let's use a formula to add up the cost of our stock.

First, double-click where you want the total,

and then type the equation in the "fx" bar.

Always start a formula with an equals sign

followed by the formula instruction.

Type "="

followed by "SUM" in capital letters

followed by "("

followed by the range.

Our range is from D5 to D13,

as these are the numbers we want to total.

So we'll type "D5:D13"

followed by a closed-bracket sign

to complete the equation.

Press enter.

If the formula has been entered correctly,

the total will immediately be shown in the cell.

If you've made a mistake,

perhaps you've misspelled something,

an error symbol will appear, like this.

Then you should go back to your "fx" bar,

and you can edit it until it's correct.

Another common action used in formulas is multiply.

To do this, select where you'd like to see your answer,

and in the "fx" bar, type "="

followed by the cell number you want to multiply

followed by the star symbol

and then the other cell you want to multiply.

Press enter.

Your cell should now have the formula installed.

As the formula is now installed,

you can change the data in cell C5,

and the answer will be corrected in E5 automatically.

If you want to apply this formula

to the rest of the cells in the "Total Cost" column,

click on the cell where the formula is entered.

Hover your cursor over the bottom right corner of the cell

until you see a small black cross.

Click and drag across the rest of the cells

where you want the formula applied.

The formula will now be copied to the remaining cells.

Click on a cell and look in the "fx" bar

to check the formula used to create the cell value.

You'll see that E10 has been calculated

by multiplying C10 and D10,

just like in the first cell.

Remember, you can edit formulas in the "fx" bar

if you want to change any of them at any time.

You can learn how to create other formulas

by learning the Excel language.

For example, multiply is indicated by the asterisk symbol.

Divide is indicated by the forward slash symbol.

You can customize your worksheet by formatting cells.

Let's start by changing the look of the title.

You probably want to make it bigger

or change the font and color to make it stand out.

Select the title cell,

go to the home menu at the top of the screen,

and select the font size from the drop-down menu.

24 looks just about right.

Now you can also select your font and color.

To change the color of your cells, highlight the cells

and click on the paint icon from the home menu.

A drop-down menu will appear.

Now you can select your color of choice.

You can also add borders to your table.

Highlight your cells and go to the home menu

and click on the border tool.

A drop-down menu will appear.

Select an option you want.

We'll choose "All Borders."

Highlight your cells

and explore the icons on the home page

to try different formatting options

to customize your workbook.

A table is a specific set of rows and columns

that you can apply functions to,

such as adding filters,

formatting, or creating graphs.

Let's turn our buying report for our fashion startup

into a table.

First, highlight the cells you want to add to your table.

Click on "Insert," then click on "Table."

If your cells include headings,

check the "My Table has headers" box,

then click "OK."

Your cells will now be turned into a table.

On the top right corner of the screen

under the table section,

you'll see a series of colored designs.

Choose the one you like,

and you'll see your table change.

You can expand the size of your table

by amending the number of columns or rows in it.

To do this, hover your cursor

over the bottom right corner of the table

and click and drag the black arrowed square

across the columns or rows

you want to be added to your table.

The sort and filter features on tables

help to organize your data.

Click on the drop-down arrow next to one of the headings.

A pop-up will appear.

Next to "Sort," click on "Ascending."

The table will now be arranged

in ascending order of retail prices.

Now use the filter function by unchecking

one of these boxes.

This will hide all the items on the table

that are $182.50.

A bar graph is a visual way to present your data.

Let's say you want to see

how profitable your denim stock is in a bar chart.

We want to show the profit-margin values

against the different denim clothing items.

Select all the denim clothing items in the column,

then press and hold down the command or CTRL button

on your keyboard and select the sales-profit values.

Once you have selected all the data,

click on the insert tool on the top menu,

then select the bar graph.

A pop-up window will appear

with bar-graph design options.

Select the one you want by clicking on it,

and your graph will appear.

You can double-click on the chart title

and type in the heading you want to give your chart.

Under the "Chart Design" section,

you can customize your bar graph.

Click on the drop-down arrow

by the quick-layout icon

and select a design to add X-axis and Y-axis titles.

To change your graph to a different kind of chart,

you can click on the drop-down arrow

beside the "Change Chart Type" icon

and select a different type of graph.