Excel Tutorial: Building Blocks of Excel
Learn the building blocks of Excel in this Excel tutorial. Expert: Shir Moscovitz
Up next in How to Use Microsoft Excel (29 videos)
Get a handle on Microsoft Excel -- the industry standard for spreadsheets -- with the help of computer whiz Shir Moscovitz in these Howcast videos.
Comments
Transcript
Hi, my name is Shir and I'm the founder and CEO of shirconsulting.com where we focus on converting the existing data from your business into massive savings and extraordinary profits. Today we're going to learn the basics of Excel. Let's get started. So before we can start building really amazing spreadsheets, we need to know what we're working with. We need to know the different building blocks of Excel. And they include CELLS, ROWS, COLUMNS, WORKBOOKS and WORKSHEETS. Let's go over each one one at a time. A CELL is an exact location in the spreadsheet for a single unit of data. An example of a CELL is "E3." It's the COLUMN letter and the ROW number. It is shown here in the main box. So whatever CELL is active is shown right over here. We also always are going to have it highlighted to give us a quick preview of where we're, where we're currently selected. A COLUMN is simply a collection of vertical CELLS. Now there are quite a few. If we were to scroll all the way to the bottom, we'd see that there's over a million different CELLS here in a single COLUMN. We can do the same thing in a ROW which is just horizontal CELLS collected together. There's also quite a few of these. It's goes to "XFD." It's about 16,000 or more different CELLS stacked horizontally. All these things together combine to make one spreadsheet or what's called one WORKSHEET. As you can see down here, this little tab here is the entire WORKSHEET. Among this WORKSHEET, there are other WORKSHEETS and these all together comprise of what's called a WORKBOOK. If I were to "Restore Down," you'll see that here's one WORKBOOK together on one topic and here's a completely different WORKBOOK with its own number of WORKSHEETS. I can maximize this and go between them like so. So once again, EXCEL is comprised of CELLS, of ROWS, COLUMNS, WORKSHEETS and entire WORKBOOKS like so.
