Microsoft Excel Tutorial: A Basic Introduction

Uploaded by UTMLibrary on 13.03.2012

Microsoft Excel: A Basic Introduction Tutorial
This tutorial has time links located in the description
so you can fast-forward to the specific excel help you need.
Excel Tools
The Excel ribbon hosts all the tools that are used in Excel.
The Home Tab consists of the Basic Tools.
The Insert Tab consists of elements you can add to your sheet.
The Page Layout Tab consists of page formatting tools.
The Formulas tab hosts tools required for creating formulas for calculations.
The Data tab hosts tools that help organize data.
The Review Tab hosts tools for editing projects,
and the View Tab hosts all tools for viewing the document.
Let's demonstrate how to use the basic tools in Excel to create a table
of items in the UTM Chocolate Store.
Entering Data
To enter data, click on a cell and type in an entry.
Click on the 'Tab' button to move the selection to the cell on the right, and you may start typing again.
Let's fill in the first row of our table.
You can also use the arrow buttons to move selections.
Pressing 'Enter' moves to the cells below.
Here, we are filling in the second row of the table.
Resizing Columns and Rows
You may notice that your cell entries cut off due to the small column widths.
To resize them, hover your mouse on the column header between the columns until you see the re-size icon.
Then, click and drag the column until the entire column entry fits.
Let's re-size all of the cut-off cells.
Now, let's fill in the remainder of the entries in the table.
Adding Rows, Columns and Cells.
Let's say we would like to add more columns and rows to our chart.
For example, let's say we forgot to add the row called 'Teacher's Favorite'
between 'Chocolate Box' and 'White Chocolate'.
Right click on the column header of the row below, which is 'White Chocolate Bar',
and click 'Insert'.
Then enter in the new row's name.
Another way of adding cells is by right clicking on a cell and click 'Insert'.
You have the option of shifting cells right or down, or shifting the entire row or column to make room for the cell.
Selecting Rows, Columns and Groups
To select rows or columns, click on the header of the column or row.
Let's click on the first row's header and make the entries bold.
To select a group of cells, click on a cell, hold down the mouse button and drag until your desired cells are covered.
Sorting Rows, Columns or Groups.
Let's sort our product column alphabetically.
First select all data entries in your table.
In the Home tab, select the 'Sort and Filter', 'Sort A to Z'.
Now, let's sort the data so that the Profit is sorted from largest to smallest.
Again select all entries and click on 'Sort and Filter', 'Custom Sort'.
Beside Sort By, select the 'Profit' column.
Beside Order, select 'Largest to Smallest'.
And 'Ok'.
You will now see that the profits are sorted and that 'Teacher's Favorite' makes the most profit.
How to Cut, Copy, Paste.
Let's say we've entered the wrong cost for 'Teacher's Favorite' chocolate, and it's actually the same price as Chocolate Raisins.
Right click on the right price and click 'Copy'.
Right click on the destination cell, and click 'Paste'.
You can also do this with a group of cells
Now You can format the cells you have entered into a table.
Select all cells.
Click on the 'Insert' tab, 'Table', and make sure the data range is good and click 'Ok'.
Note that when you click cells in the table, a new 'Design' tab appears on the ribbon.
Here you can change the design and colour of the table.
Adding, Navigating and Renaming Worksheets.
This table is on the sheet 1 worksheet.
To rename it, double click on it and type in a new name.
Type in Data.
To add another worksheet, click on 'Sheet 2' and enter in other data.
For further instruction in Excel, Visit our Video Archives.