The New Way to Work with Data, Formulas, and Functions
In this section, you will learn how to effectively work with Excel 2010 and explore the new possibilities.
Creating the Month Data Series
To quickly create a list of all months of the year, perform the following steps:
Select File/New and click Create to open an empty Excel workbook.
Enter the following text in columns A2 through E2 (see Figure 1-1):
Profit margin (D2)
Figure 1-1. Naming the table columns.
To enter the names of the months, you will use the fill feature. Start by entering January in cell A3.
Select cell A3 and point to the small square in the lower-right ...