Book Image

Data Analysis and Business Modeling with Excel 2013

Book Image

Data Analysis and Business Modeling with Excel 2013

Overview of this book

Table of Contents (18 chapters)
Data Analysis and Business Modeling with Excel 2013
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
10
Creating Interactive Spreadsheets Using Tables and Slicers
Index

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:

  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.

  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:

  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:

  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:

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: