Excel Basics - Part 3: Understanding Rows, Columns, Cells, and Cell Referencing
In the prior Excel course sections, we discussed the basics around workbooks, worksheets, and cells. Now that you know the basics of the Microsoft Excel layout, we can take the next step, and learn the basics of how the Excel application organizes spreadsheets and how cells and groups of cells are identified. This is called cell referencing, and it is the core of nearly all activities you will perform in Excel. As you create calculations, work with data, create charts, or perform a data summary, you will use cell references in all those activities. In this section you will learn about rows, columns, and addresses along with cell ranges. Cell References Basics: Think about hundreds or thousands of values on a spreadsheet, how would you perform a calculation? Instead of typing or selecting each value, you can refer to the cells that contain those numbers. Instead of having to type: 10 + 20 + 30 You would just write: A1 + A2 + A3 Referencing cells in a s...