Create an Excel table

In this tutorial, we will talk about Excel tables. By “Excel spreadsheet”, we do not mean a simple range of Excel cells that contain data, but as you will see, an Excel table is a particular and organized structure that facilitates the calculation of formulas, filtering and sorting. your data in question, etc. In this Excel tutorial, we will not only see how to make an Excel spreadsheet, but also how to format it and how to take advantage of its strengths to calculate formulas and easily sort and filter your data. A / Create an Excel table If you already have data entered, click in your cell range → “Insert” tab in Excel 2013 and 2016, or “Insert” in Excel 2007 and 2010 → Table. Microsoft Excel opens the “Create Table” dialog box in which it proposes the range of cells concerned. If your data contains headers / titles, check the “My table has headers” box → Excel creates your table and opens the “Table Tools – Creation” contextual tab. Note that the filter buttons are already positioned on the headers of the table and a formatting style has been assigned to easily distinguish the different lines. B / Formatting an Excel table 1- Applying a style to an Excel spreadsheet automatically applies a predefined style to your table as soon as it is created, but you can of course apply other styles that suit you by assigning it different combinations automatic borders and backgrounds offered by the Excel software: To do this, click in the table → Table Tools – Creation → In the “Table Style” command group, choose the visual style that suits you. 2- Formatting an Excel spreadsheet Of course, you can manually format an Excel spreadsheet as you do for any range of cells; but here we are talking about the automatic formatting of your proposed Excel spreadsheet through the “Table Tools – Creation” contextual tab. After clicking in your Excel table, you will find the following 4 options in the “Table Tools – Creation” tab at the “Table Style Options” command group: – Tape Lines: When checked, even lines and oddly in the table are formatted differently to better visualize the data. Tape Lines in an Excel Table – Tape Columns: When checked, the odd and even columns in the table are formatted differently to better visualize the data. Columns in an Excel Table – First Column: When checked, the data in the first column of the table is highlighted in bold. First Column Bolded – Excel Table – Last Column: When checked, the data in the last column of the table is highlighted in bold. Last Column Bolded – Excel Table C / Calculation in an Excel Table 1- Calculation Formulas in an Excel Table An Excel spreadsheet makes it easy to calculate by letting you enter the calculation formula only once, and the rest is filled automatically! We will see how right now … Let’s take the following example: In the “Total Price” column, we want to calculate the product of the quantity by the unit price (P.U). Therefore, we normally enter in the cell G2 our formula = Quantity * P.U and / or with the help of the mouse to click on cells E2 and F2. Note: If you are not yet familiar with the calculation formulas in Excel, I will give you these two tutorials: Excel – Calculation functions and Sum of non-adjacent cells in Excel and other calculation formulas. Consult them first and come back here. So let’s continue with our example: In cell G2, Excel uses a particular notation for our formula by prefixing column names with the symbol @. This is the difference in notation of calculation formulas between a normal range of cells and an Excel table. But, have no fear; the principle is the same, it’s just the presentation that differs. So you do not have to enter the @ symbol yourself in the formulas; Excel will take it. You have finished entering your calculation formula in cell G2, type “Enter” and Excel automatically fills the other cells in the column …


Leave a Reply

Your email address will not be published. Required fields are marked *