Microsoft Office Tutorials and References
In Depth Information
Creating Your First Excel Workbook
Creating Your First Excel Workbook
This section presents an introductory hands-on session with Excel. If you haven’t used
Excel, you may want to follow along on your computer to get a feel for how this
software works.
In this example, you create a simple monthly sales projection table along with a chart.
Getting started on your worksheet
Start Excel and make sure that you have an empty workbook displayed by selecting Blank
workbook from the Start screen. To create a new, blank workbook when Excel is already
open, press Ctrl+N (the shortcut key for File
Blank Workbook).
The sales projection will consist of two columns of information. Column A will contain the
month names, and column B will store the projected sales numbers. You start by entering
some descriptive titles into the worksheet. Here’s how to begin:
1. Move the cell pointer to cell A1 (the upper-left cell in the worksheet) if needed
by using the navigation (arrow) keys. The Name box displays the cell’s address.
2. Type Month into cell A1 and press Enter. Depending on your setup, either Excel
moves the cell pointer to a different cell or the pointer remains in cell A1.
3. Move the cell pointer to B1, type Projected Sales, and press Enter. The text
extends beyond the cell width, but don’t worry about that for now.
Filling in the month names
In this step, you enter the month names in column A.
1. Move the cell pointer to A2 and type Jan (an abbreviation for January). At this
point, you can enter the other month name abbreviations manually or you can let
Excel do some of the work by taking advantage of the AutoFill feature.
2. Make sure that cell A2 is selected. Notice that the active cell is displayed with a
heavy outline. At the bottom-right corner of the outline, you’fill see a small square
known as the fi fill handle. Move your mouse pointer over the fi fill handle, click, and
drag down until you’ve highlighted from cell A2 down to cell A13.
3. Release the mouse button, and Excel automatically fi fills in the month names.
Your worksheet should resemble the one shown in Figure 12.5.
Search JabSto ::

Custom Search