How to make a table in Excel

The Excel formulas, the Excel functions, the diagram, the pivot table, the macros, the layout… The Excel office suite program is famous above all for  its ease of creating tables .

For daily or professional use, it is very often used to order and design data in rows and columns, such as income statements, invoices … It also facilitates calculations and the creation of graphs.

Before  creating a table in Excel , make sure you have the software on your computer. Sometimes it is built into the computer when you buy it, because it was installed directly by the seller.

If you don’t have Excel, then you have to subscribe on the Microsoft Office office suite website (Office for home, Office for business, etc.). Downloading Excel is simple and you can take advantage of various programs such as Word, PowerPoint and Microsoft Excel.

But this simplified free or paid version of this office software is not the only solution. You can also find  similar programs with Libre Office . However, the operations will not always be the same.

If you have a trial version, a full version, an older version or another, then you simply  have to double click on the program icon and choose a new document . The spreadsheet will appear on your screen. The rows have numbers, and the columns are indicated by letters.

To make a simple table or a pivot table, you must  start by adding all your data in the cells of the spreadsheet  (cells is the name that the cells have). If you have two types of data, first write some data in one column (the expenses of the month, for example) and then in each row, write the second type of data (each month of the year).

You can include automatic calculations and macros. To do this, click on the box where you want the result to appear and write the equal sign in it. Then select the first box of the operation, write in it the sign of the operation you want to perform and then select the second box of the operation.

• For example: = Cell B2 + Cell B3. The program will perform the operation.

Once you have added all the data to the spreadsheet, select all the cells you want to appear in the table and click on the  “Insert” tab on the toolbar . All you have to do is click on “Table” (or “Pivot Table”), and you’re done! To add the headings to the table, just check the box before clicking OK.

Once the table is made, you can also  modify the design , that is, change the colors of the columns or rows, highlight information, etc. To do this, select the table and go to the ” Design” tab , and then to ” Table styles” . Then, you can choose the type of table that suits you best or style it as you see fit with the boxes next to it.

Once the table is finished, you can  copy and paste it on another page or save it in PDF, Excel or other format . How to make a table in Excel