Microsoft Excel Tutorial: A Basic Introduction
Microsoft Excel Tutorial: A Basic Introduction
This video will demonstrate how to use and navigate through Microsoft Excel. Below are useful time links you may click on to skip to the exact type of Excel help you need:
Excel Tools and Ribbon: 0:11
Entering Data (for making a Table) 0:49
Resizing Columns and Rows 1:33
Adding Rows, Columns and Cells 2:09
Selecting Rows, Columns and Groups of Cells 2:53
Sorting Rows, Columns or Groups 3:15
How to Cut, Copy and Paste Cells 3:54
Making a Table 4:20
Adding, Navigating and Renaming Worksheets 4:37
Content
0 -> Microsoft Excel: A Basic Introduction Tutorial
3.833 -> This tutorial has time links located in the description
7.6 -> so you can fast-forward to the specific excel help you need.
11.467 -> Excel Tools
13.433 -> The Excel ribbon hosts all the tools that are used in Excel.
17 -> The Home Tab consists of the Basic Tools.
20.133 -> The Insert Tab consists of elements you can add to your sheet.
23.4 -> The Page Layout Tab consists of page formatting tools.
27.067 -> The Formulas tab hosts tools required for creating formulas for calculations.
32.467 -> The Data tab hosts tools that help organize data.
36.067 -> The Review Tab hosts tools for editing projects,
39.4 -> and the View Tab hosts all tools for viewing the document.
42.733 -> Let's demonstrate how to use the basic tools in Excel to create a table
46.533 -> of items in the UTM Chocolate Store.
49.5 -> Entering Data
51.5 -> To enter data, click on a cell and type in an entry.
55.167 -> Click on the 'Tab' button to move the selection to the cell
on the right, and you may start typing again.
61.9 -> Let's fill in the first row of our table.
79.133 -> You can also use the arrow buttons to move selections.
81.6 -> Pressing 'Enter' moves to the cells below.
85.6 -> Here, we are filling in the second row of the table.
93.367 -> Resizing Columns and Rows
96.3 -> You may notice that your cell entries cut off
due to the small column widths.
99.967 -> To resize them, hover your mouse on the column header between
the columns until you see the re-size icon.
106.3 -> Then, click and drag the column until the entire column entry fits.
110.467 -> Let's re-size all of the cut-off cells.
116.267 -> Now, let's fill in the remainder of the entries in the table.
130.933 -> Adding Rows, Columns and Cells.
133.567 -> Let's say we would like to add more columns and rows to our chart.
138.6 -> For example, let's say we forgot to add the row called 'Teacher's Favorite'
141.4 -> between 'Chocolate Box' and 'White Chocolate'.
144.3 -> Right click on the column header of the row
below, which is 'White Chocolate Bar',
148.033 -> and click 'Insert'.
149.767 -> Then enter in the new row's name.
157.667 -> Another way of adding cells is by right clicking
on a cell and click 'Insert'.
161.533 -> You have the option of shifting cells right or down, or shifting the
entire row or column to make room for the cell.
175.033 -> Selecting Rows, Columns and Groups
177.267 -> To select rows or columns, click on the header of the column or row.
182.067 -> Let's click on the first row's header and make the entries bold.
188.967 -> To select a group of cells, click on a cell, hold down the
mouse button and drag until your desired cells are covered.
195.033 -> Sorting Rows, Columns or Groups.
198.767 -> Let's sort our product column alphabetically.
202.567 -> First select all data entries in your table.
206.667 -> In the Home tab, select the 'Sort and Filter', 'Sort A to Z'.
210.667 -> Now, let's sort the data so that the Profit
is sorted from largest to smallest.
215.533 -> Again select all entries and click on 'Sort and Filter', 'Custom Sort'.
220.4 -> Beside Sort By, select the 'Profit' column.
223.833 -> Beside Order, select 'Largest to Smallest'.
227.267 -> And 'Ok'.
229.067 -> You will now see that the profits are sorted and
that 'Teacher's Favorite' makes the most profit.
234.833 -> How to Cut, Copy, Paste.
238.867 -> Let's say we've entered the wrong cost for 'Teacher's Favorite' chocolate,
and it's actually the same price as Chocolate Raisins.
243.367 -> Right click on the right price and click 'Copy'.
246.533 -> Right click on the destination cell, and click 'Paste'.
250.067 -> You can also do this with a group of cells
254.067 -> Now You can format the cells you have entered into a table.
258.567 -> Select all cells.
260.9 -> Click on the 'Insert' tab, 'Table', and make sure the
data range is good and click 'Ok'.
267.533 -> Note that when you click cells in the table, a
new 'Design' tab appears on the ribbon.
273.8 -> Here you can change the design and colour of the table.
278.7 -> Adding, Navigating and Renaming Worksheets.
281.6 -> This table is on the sheet 1 worksheet.
283.9 -> To rename it, double click on it and type in a new name.
288.867 -> Type in Data.
289.733 -> To add another worksheet, click on 'Sheet 2' and enter in other data.
294.5 -> For further instruction in Excel, Visit our Video Archives.
Source: https://www.youtube.com/watch?v=rJbf-2XXsuY