Home » Spreadsheet Software » How To Create a Spreadsheet in Excel 2013

How To Create a Spreadsheet in Excel 2013

How To Create a Spreadsheet in Excel 2013 – IMPORTANT: This article has been translated with automatic translation; See declining responsibilities. For your reference, you can find the English version of this article here.

Excel is a very effective tool for obtaining meaningful information from large amounts of data. It also works great with simple calculations and to track almost any type of information. The key to unlocking all this potential is the cell grid. Cells can contain numbers, text, or formulas. The data is written to cells and grouped into rows and columns. This allows aggregating data, sorting and filtering them, putting them in tables and creating very visual graphs. Let’s look at the basic steps to get you started.

TIP: For a learning course to help you create your first book, see Create your first book in Excel 2013. For information about new features, see What’s New in Excel 2013.

Create a new book

Excel documents are called books. Each book has sheets, which are usually called worksheets. You can add as many sheets as you want to a book or you can create new books to separate the data.

Click File> New.

Under New, click Blank Book.

New blank book

Top of page

Enter the data

Click on an empty cell. For example, cell A1 of a new sheet.

The cells are referenced by their location in the row and column of the sheet, so that cell A1 is the first row in column A.

Type text or a number in the cell.

Press ENTER or TAB to move to the next cell.

Learn more about ways to enter data manually in worksheet cells.

Top of page

Use Autosuma to add data

Once you write the numbers on the sheet, you may want to add them together. One quick way to do this is through Autosuma.

Select the cell to the right or below the numbers you want to add.

Click Start> AutoSum or press Alt + =.

Autosuma in the Home tab

The Autosuma adds the numbers and displays the result in the cell you select.

Top of page

Create a simple formula

Adding numbers alone is one of the things you can do, but Excel can also do other calculations. Try some simple formulas to add, subtract, multiply, or divide numbers.

Select a cell and type an equal sign (=). This tells Excel that the cell will contain a formula.

Enter a combination of numbers and calculation operators, such as the plus sign (+) for addition, minus sign (-) for subtraction, asterisk (*) for multiplication, or backslash (/) for division.

For example, type = 2 + 4, = 4-2, = 2 * 4, or = 4/2.

Press Enter. This calculates the calculation.

You can also press Ctrl + Enter if you want the cursor to remain in the active cell.

Learn more about creating a simple formula.

Top of page

Apply a number format

To distinguish between different types of numbers, add a format, such as currency, percentages, or dates.

Select the cells that contain numbers to which you want to change the format.

Click Start> the arrow next to General.

Table Format of the Home tab

Select a number format.

Gallery of number formats

If you do not see the number format you are looking for, click More Number Formats.

Learn more about ways to format numbers.

Top of page

Write the data in a table

An easy way to access much of Excel’s potential is to put the data in a table. This allows you to quickly filter or sort the data to get started.

Select the data by clicking the first cell and dragging it to the last cell of the data.

To use the keyboard, hold down the Shift key while pressing the arrow keys to select the data.

Click the Quick Scan button Quick Scan button in the lower right corner of the selection.

Data selected with the visible fast analysis lens button

Click Tables, move the cursor to the Table button to see what the data will look like. If you like, click the button.

Quick Analysis Tables Gallery

Now you can play with the data: just drag them to see just the data you want or order them to go, for example, from highest to lowest. Click the drop-down arrow from the one-column table header filter.

To filter the data, clear the Select All box to clear all check marks and check the boxes of the data you want to display in the table.

Select All from Gallery Sort and Filter

To sort all the data, click Sort from A to Z or Sort from Z to A.

Order management commands

How To Create a Spreadsheet in Excel 2013