This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Community Hub.
This article is brought to you by the Nonprofit Tech Acceleration (NTA) for Black and African American Communities Program Technical Team. For information on how to take advantage of the granted offerings or free technical consultation, please visit: Supporting Black Community Nonprofits | Microsoft Nonprofits
Hello to our amazing NTA non-profit organizations. In this article we will continue our discussion on Microsoft Excel Basics. Last article we learned our way around the Excel interface and where to find key components. Now, let’s learn how to use them! We are going to create a new blank data table.
A blank data table is perfect for when you want to enter data but are unsure of how many columns and rows you need. As you type in new data, Excel will automatically extend your table to include the new 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 of 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 of 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 headers. 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 that is already entered into your spreadsheet.
Happy Exceling non-profits, and as always, thank you for allowing the NTA team to serve you and in turn help better serve our communities!