Calculations in Excel Tables

There are various valuable features of Excel tables even though it has generic and confusing names. Excel tables have numerous functionalities such as expanding data, including new data, updating formulas in automatic manners, and keeping the record up to date, etc. This article has information regarding the calculations in Excel tables and its attributed facts and information.

1. Creation of Table

The creation of tables in Excel is possible within 10 seconds. First of all, blank rows should be removed, furthermore, columns must have distinct names. Putting the cursor of the mouse anywhere on the column and using the shortcut of the keyboard “Ctrl + T), clicking yes would result in the creation of the table.

2. Navigation through Tables

The tables are appearing in the dropdown menu with name boxes. Clicking on the box would result in options for the selection of tables. The Excel has the capability of navigating through the table even if some content is in different tabs within the Excel workbook.

3. Dedicated Shortcuts

When data is converted into a table in an Excel sheet, shortcuts are working efficiently. For instance, rows can be easily chosen through “shift + space” keys, whereas columns can be chosen through “ctrl + space” keys. Such shortcuts are working even over the edges of the table where the edges are not visible.

4. Drag and Drop Option

Tables are making it very easy to make arrangements of data through drag and drop options. After the selection of the entire table, any row or column, it can be dragged and dropped anywhere on the sheet. Data can be relocated to new locations without any changes or overwriting.

5. Visibility of Headers

When working with large sets of data, one often faces troubles with the disappearance of headers while scrolling through the sheet, especially when there is a table. There is a way to deal with it in Excel, the columns will have fixed headers.

6. Expansion of Tables

The table is expanding automatically through the addition of rows and columns. Similarly, when the deletion of rows and columns happens, the table shrinks.

7. Display of Totals

The tables have an optional row for the display of totals. The row for the total can be utilized for the performance of different tasks e.g. count and sum etc. without using any formula. When the filter option is applied to the table, the total is automatically applied for the calculation of values on only visible rows. The total row can also be toggled ON and OFF through the use of a shortcut (ctrl + shift +T).

8. Renaming Table

The tables are assigned with a number automatically e.g. table1, table 9, etc. however, such names can also be edited and changed at any instant when required.

9. Automatic Formulas

The tables have a built-in feature known as the calculated columns which are for the maintenance and making of formulas in an easy way. This method is considered more accurate as well. When a standard formula is entered in the column, it is copied throughout the column and is not requiring a copy/paste function.

10. Changing Formulas Automatically

The table handles changing the formulas in an automatic way. In case, if any change is needed in the formula anywhere within the table, it can be updated within the entire column.

Other useful articles: