Advanced Excel Syllabus

Advanced Excel Syllabus

Printing your worksheet

1. Make sure that the chart isn’t selected. If a chart is selected, the chart will print
on a page by itself. To deselect the chart, just press Esc or click any cell.
2. To make use of Excel’s handy Page Layout view, click the Page Layout button on
the right side of the status bar. Excel displays the worksheet page by page so that
you can easily see how your printed output will look. In Page Layout view, you can
tell immediately whether the chart is too wide to fi t on one page. If the chart is too
wide, click and drag a corner of the chart to resize it or just move the chart below
the table of numbers.
3. When you’re ready to print, choose File ➪ Print. At this point, you can change
some print settings. For example, you can choose to print in landscape rather than
portrait orientation. Make the change, and you see the result in the preview window.
4. When you’re satisfied, click the large Print button in the upper-left corner. The
page is printed, and you’re returned to your workbook.

Saving your workbook

Until now, everything that you’ve done has occurred in your computer’s memory. If the
power should fail, all may be lost — unless Excel’s AutoRecover feature happened to kick
in. It’s time to save your work to a fi le on your hard drive.
1. Click the Save button on the Quick Access toolbar. (This button looks like an
old-fashioned fl oppy disk, popular in the previous century.) Because the work￾book hasn’t been saved yet and still has its default name, Excel responds with
a Backstage screen that lets you choose the location for the workbook fi le. The
Backstage screen lets you save the fi le to an online location or to your local
computer.
2. Click Browse. Excel displays the Save As dialog box.
3. In the File Name field, enter a name (such as Monthly Sales Projection). If you
like, you can specify a different location.
4. Click Save or press Enter. Excel saves the workbook as a fi le. The workbook
remains open so that you can work with it some more.