官术网_书友最值得收藏!

Manually creating data

Let's create our first dataset by using the following steps:

  1. First, fire up Excel 2013 and create a new spreadsheet. We will begin with creating some data manually as an introduction to gathering data. We will begin with typing in cell A1, as shown in the following screenshot:
    Manually creating data
  2. Type Revenue in cell A1 and Name in cell B1, as shown in the following screenshot. These are going to be our column headings of our dataset.
    Manually creating data
  3. We are now going to apply styles to the column headings so that they stand out. Highlight columns A1 and B1 and press Ctrl + B. This action will make the two strings that we selected bold. Another option is to highlight the cells and click on the Bold button in the toolbar, as shown in the following screenshot:
    Manually creating data
  4. Now, type 321, 45, 7, and 23 in the Revenue column. Then, type David, Bob, Bill, and Mike in the Name column. Your spreadsheet should look like the example in the following screenshot:
    Manually creating data
  5. For our finishing touches, we can apply styles to our data by adding borders around the cells. We can accomplish this by highlighting the cells A1 through B5 and clicking on the Borders button. This will bring up a new menu. Select All Borders. Remember that you need to first highlight the cells you want to add the borders to. Refer to the following screenshot:
    Manually creating data

Congratulations! You have just learned how to enter numbers, strings, and column headers in an Excel spreadsheet. You have also learned how to apply styles to the text and cells using various built-in Excel functions. You can think of this as your first Hello World program in Excel 2013. Your final output should look like this:

Manually creating data
主站蜘蛛池模板: 杭锦后旗| 垣曲县| 彭泽县| 讷河市| 郧西县| 通海县| 前郭尔| 沛县| 济南市| 余干县| 济南市| 宁波市| 文安县| 普安县| 揭东县| 保康县| 益阳市| 乌审旗| 布尔津县| 三穗县| 肇庆市| 辽宁省| 永宁县| 英山县| 佳木斯市| 晋州市| 台前县| 维西| 兴化市| 马关县| 中阳县| 贵定县| 囊谦县| 巨鹿县| 博白县| 衡水市| 山东省| 宁明县| 区。| 宝应县| 济南市|