#### Overview of this book

Data Analysis and Business Modeling with Excel 2013
Credits
www.PacktPub.com
Preface
Free Chapter
Getting Data into Excel
Connecting to Databases
How to Clean Texts, Numbers, and Dates
Using Formulas to Prepare Your Data for Analysis
Analyzing Your Data Using Descriptive Statistics and Charts
A Primer on Using the Excel Solver
Learning VBA – Excel's Scripting Language
How to Build and Style Your Charts
Creating Interactive Spreadsheets Using Tables and Slicers
Tips, Tricks, and Shortcuts
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: