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.

analyze tab in excel 2013

TIPs: 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

  1. 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.
  2. Click File> New.
  3. Under New, click Blank Book.
  4. New blank book
  5. Top of page
  6. Enter the data
  7. Click on an empty cell. For example, cell A1 of a new sheet.
  8. 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.
  9. Type text or a number in the cell.
  10. Press ENTER or TAB to move to the next cell.
  11. Learn more about ways to enter data manually in worksheet cells.
  12. Top of page
  13. Use Autosuma to add data
  14. Once you write the numbers on the sheet, you may want to add them together. One quick way to do this is through Autosuma.
  15. Select the cell to the right or below the numbers you want to add.
  16. Click Start> AutoSum or press Alt + =.
  17. Autosuma in the Home tab
  18. The Autosuma adds the numbers and displays the result in the cell you select.
  19. Top of page
  20. Create a simple formula
  21. 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.
  22. Select a cell and type an equal sign (=). This tells Excel that the cell will contain a formula.
  23. 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.
  24. For example, type = 2 + 4, = 4-2, = 2 * 4, or = 4/2.
  25. Press Enter. This calculates the calculation.
  26. You can also press Ctrl + Enter if you want the cursor to remain in the active cell.
  27. Learn more about creating a simple formula.
  28. Top of page
  29. Apply a number format
  30. To distinguish between different types of numbers, add a format, such as currency, percentages, or dates.
  31. Select the cells that contain numbers to which you want to change the format.
  32. Click Start> the arrow next to General.
  33. Table Format of the Home tab
  34. Select a number format.
  35. Gallery of number formats
  36. If you do not see the number format you are looking for, click More Number Formats.
  37. Learn more about ways to format numbers.
  38. Top of page
  39. Write the data in a table
  40. 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.
  41. Select the data by clicking the first cell and dragging it to the last cell of the data.
  42. To use the keyboard, hold down the Shift key while pressing the arrow keys to select the data.
  43. Click the Quick Scan button Quick Scan button in the lower right corner of the selection.
  44. Data selected with the visible fast analysis lens button
  45. Click Tables, move the cursor to the Table button to see what the data will look like. If you like, click the button.
  46. Quick Analysis Tables Gallery
  47. 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.
  48. 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.
  49. Select All from Gallery Sort and Filter
  50. To sort all the data, click Sort from A to Z or Sort from Z to A.
  51. Order management commands

How To Create a Spreadsheet in Excel 2013