Excel for Beginners - The Complete Course
Technology for Teachers and Students
This is Excel for beginners. The complete course doesn't matter
how little experience you have in Excel. I promise you that as you
watch this video and follow along, you will learn everything you
need to know to get started using Excel effectively. We'll learn
the basics of what I call the anatomy of a spreadsheet and also
the layout in Microsoft Excel. An Excel workbook can contain over
17 billion cells when you click on a cell that becomes the active
cell. The anatomy of a spreadsheet includes columns, rows, cells,
and cell ranges. You can add more worksheets by clicking this
plus sign. In addition to the anatomy of the spreadsheet, it's also
important to understand the layout in Microsoft Excel. The
anatomy of a spreadsheet and the layout in Microsoft Excel is
shown below. We also have a horizontal scroll bar underneath
that we have a zoom slider if I slide this to the right I zoom in on
the spreadsheet if I slide it to the left I zoom out on the
spreadsheet. Doing this does not change the data at all; it just
zooms in or out.
In Microsoft Excel, the fill handle is a feature that helps you
identify patterns and then extend those patterns. If I click and
drag to select that range A1 through A4, the pattern should be
clear. I'm going to zoom in a little bit. We need to learn about
entering cell values in Excel. Is how to clear and copy cell
contents. We've already looked at how to edit them by double
clicking but what if you just need to copy the contents of one cell
to another cell? You can click on a cell or even a range if you
prefer, and then hold the Ctrl key and tap C to copy. If I click on
the autofill handle and pull down the spreadsheet all the way
down to the bottom, it's going to extend that pattern of just the
number 15 and it basically copies that same number all down the
page. Sometimes you need to completely clear everything that's
in that cell, not just the data but maybe also the formatting and
other information.
Excel is a powerful spreadsheet program developed by Microsoft. It
is widely used for various purposes, including data analysis,
Technology for Teachers and Students
This is Excel for beginners. The complete course doesn't matter
how little experience you have in Excel. I promise you that as you
watch this video and follow along, you will learn everything you
need to know to get started using Excel effectively. We'll learn
the basics of what I call the anatomy of a spreadsheet and also
the layout in Microsoft Excel. An Excel workbook can contain over
17 billion cells when you click on a cell that becomes the active
cell. The anatomy of a spreadsheet includes columns, rows, cells,
and cell ranges. You can add more worksheets by clicking this
plus sign. In addition to the anatomy of the spreadsheet, it's also
important to understand the layout in Microsoft Excel. The
anatomy of a spreadsheet and the layout in Microsoft Excel is
shown below. We also have a horizontal scroll bar underneath
that we have a zoom slider if I slide this to the right I zoom in on
the spreadsheet if I slide it to the left I zoom out on the
spreadsheet. Doing this does not change the data at all; it just
zooms in or out.
In Microsoft Excel, the fill handle is a feature that helps you
identify patterns and then extend those patterns. If I click and
drag to select that range A1 through A4, the pattern should be
clear. I'm going to zoom in a little bit. We need to learn about
entering cell values in Excel. Is how to clear and copy cell
contents. We've already looked at how to edit them by double
clicking but what if you just need to copy the contents of one cell
to another cell? You can click on a cell or even a range if you
prefer, and then hold the Ctrl key and tap C to copy. If I click on
the autofill handle and pull down the spreadsheet all the way
down to the bottom, it's going to extend that pattern of just the
number 15 and it basically copies that same number all down the
page. Sometimes you need to completely clear everything that's
in that cell, not just the data but maybe also the formatting and
other information.
Excel is a powerful spreadsheet program developed by Microsoft. It
is widely used for various purposes, including data analysis,
