TEACHING EXCEL FOR DATA ANALYSIS: HANDS ON 18 Creating and modifying a table

 

Creating and modifying a table

You have decided that because the Weekly Sales & Bonus Payout worksheet will become larger on a weekly basis, it is a good idea to convert the range into a table to facilitate data analysis. You would also like to apply a new table style to it.

1. Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.

https://github.com/alcadelina/Excel-

2. First, use your cursor to select the A4:G14 cell range:

3. Next, click Insert → Table:

4. In the Create Table dialog box, you will see that the range you previously selected is listed inside the “Where is the data for your table?” text box:

5. Ensure that the “My table has headers” checkbox is checked and click OK:

6. You will see that the previously selected range has now been converted into a table:

7. Now, you need to apply a new table style. With any of the cells inside the table selected, open the Table Design contextual tab. Within the Table Styles group, click the More arrow:

8. A variety of different quick styles to choose from is now displayed. For this example, click Table Style Medium 8:

9. The new style is now applied to the current table:

10. Save the current workbook as Activity 3-1 Complete and then close Microsoft 365 Excel to complete this exercise.

11. Now, you can check out an example of a completed document in the link below:

https://github.com/alcadelina/Excel-