Advanced Excel Syllabus
Making your worksheet look a bit fancier
At this point, you have a functional worksheet, but it could use some help in the appearancedepartment. Converting this range to an “official” (and attractive) Excel table is a snap:
1. Activate any cell within the range A1:B13.
2. Choose Insert ➪ Tables ➪ Table. Excel displays the Create Table dialog box to
make sure that it guessed the range properly.
3. Click OK to close the Create Table dialog box. Excel applies its default table formatting and displays its Table Tools ➪ Design contextual tab.
If you don’t like the default table style, just select another one from the Table Tools ➪
Design ➪ Table Styles group. Notice that you can get a preview of different table styles by
moving your mouse over the Ribbon. When you fi nd one you like, click it, and the style will
be applied to your table.
Summing the values
1. Activate any cell in the table.
2. Choose Table Tools ➪ Design ➪ Table Style Options ➪ Total Row. Excel automatically adds a new row to the bottom of your table, including a formula that calculates the total of the Projected Sales column.
3. If you’d prefer to see a different summary formula (for example, average), click
cell B14 and choose a different summary formula from the drop-down list.
Creating a chart
1. Activate any cell in the table.
2. Choose Insert ➪ Charts ➪ Recommended Charts. Excel displays some suggested
chart type options.
3. In the Insert Chart dialog box, click the second recommended chart (a column
chart), and click OK. Excel inserts the chart in the center of the window. To move
the chart to another location, click its border and drag it.
4. Click the chart and choose a style using the Chart Tools ➪ Design ➪ Chart
Styles options.
No comments:
Post a Comment