Hello to our amazing non-profit organizations. In this article, we will continue our discussion on Microsoft Excel Basics. In the last article, we learned our way around the Excel interface and where to find key components. Now, let's learn how to use them! First, we are going to create a new blank data table.
A blank data table is perfect for entering data, but unsure of how many columns and rows you need. Then, as you type in new data, Excel automatically extends your table to include the latest data. So you can build out your table as you go.
How to Create a Blank Data Table
- Open a new or existing Excel workbook and select the cell where you want to create your table.
- Go to the "Insert" tab in the top toolbar.
- Click on "Table."
4. In the "Create Table" dialog box, ensure that the "My table has headers" option is checked.
5. Click "OK" to create your empty table.
6. You can now add data to your table by typing in the cells. Remember, as you enter data in the columns and rows Excel will automatically extend your table borders.
7. Let's click inside Column 1 to rename it "Apples."
8. Next, click the cell next to column 1 and title it "Oranges. Click the cell next to it and title that "Grapes." You should now have 3 columns on your table.
9. Underneath the column titled "Apples," enter the number 6.
10. In the empty cell below, enter the number 8 and repeat again with the number 9. You should now see a table with 3 columns and 3 rows.
11. Excel will automatically format your empty table with alternating colors for each row and column header. You can modify the style of your table by selecting "Table Design" in the top toolbar.
12. Choose a new table color.
Congratulations, NTA non-profits! You've just created your first data table! Remember to play around with things and see what else you can do with your data. Don't be afraid to explore!
Click here for more information on Excel and to learn how to create a table from data already entered into your spreadsheet.
Happy Exceling non-profits, and as always, thank you for allowing us to serve you and, in turn, help better serve our communities!
Microsoft
