While working with spreadsheets can be a daunting task for some, and people uncomfortable with math tend to shy away from them altogether, they can serve a purpose in the home as well as the office, for tracking expenses, planning budgets, and they allow you to create a visual representation of your information.
In my Basic Microsoft Excel pages I will cover:
- The Autosum operation
- Using the Function key to create an average
- Cell formating
- Adding a comment to a cell
- Creating a chart of your information
- The basic concept of creating you own formula
I've broken this down to four pages, each with a video demonstration.
Here, in my Basic Excel 1, I cover using autosum as well as the function key to create an average.
As you can see in the graphic, you enter information into a cell. The cell is mapped by it's coordinates on the sheet. In this case 100 is in cell A2.
The formula SUM, the addition, is of cells A2 through A4. Cells A2 through A4 represent what is refered to as the range. Here, the answer to A2+A3+A4 will be shown in A5. This can be performed horizontally or vertically.
The numbers on the left create the rows, and the letters across the top create the columns.
As you can see in the graphic, you enter information into a cell. The cell is mapped by it's coordinates on the sheet. In this case 100 is in cell A2.
