Excel is a commonly used office software, which can greatly improve our work efficiency; Now let’s introduce to you: introduction to excel table making tutorial and common formulas!

The current operating environment is computer side, using notebook: Dell Lingyue 5000, corresponding operating system: windows10, corresponding software version: WPS office 11.1.0.11045

01 excel table: add border lines

First, select the a1:e9 cell area with the mouse, click the toolbar border button drop-down triangle, and then select all borders to add borders to the excel table;

02 excel table: center alignment

Select the cell area from column a to column e, and click the toolbar: [vertical center] and [horizontal center] buttons respectively to align the center, and the excel table will no longer be messy;

03 excel table: table beautification

We first select the a1:e9 cell area, then click [table style] on the toolbar, and select the appropriate style to pop up the [table style] dialog box. At this time, we click [OK] to end our confirmation, and then we can add a table style to the excel table;

04 excel table: merge cells

Double click A10 cell and enter: introduction to excel table making tutorial; Then select a10:e10 cell area, and click [merge and center] on the toolbar to merge and center a row of cells;

05 excel table: fill color

Select A10 cell, click the [fill color] button on the toolbar, and select the appropriate color; Then click the [font color] button on the toolbar, select white, and finally press the excel shortcut [ctrl+b] to bold the font; You can fill the excel table with colors;

06 excel table: automatic filtering

Select the cell in column C with the mouse, click the button [auto filter] on the toolbar, click the drop-down triangle of the cell [gender], and then check [female], then we can filter out the sales data of women in Excel table;

07 excel table: table sorting

First select the cell area in column e, and then click auto filter on the toolbar to pop up the sorting warning dialog box. Finally, check expand selected area, and press OK to end the confirmation. You can sort the excel table by sales volume;

08 excel table: highlight duplicates

We use the mouse to select the cell area in column D, and click the toolbar [duplicate item button]; Then select [set highlighted repetition] to pop up [highlight repetition value]; Finally, press [OK] to end the confirmation; You can highlight the excel table and duplicate data;

09 excel table: delete duplicates

First, select the cell area in column B, click the [duplicate] button on the toolbar, and select [delete duplicate]; Pop up the [delete duplicates warning] dialog box, and click the [delete duplicates] button to pop up the [delete duplicates] dialog box; Next, select [name] by radio and press enter to end the confirmation; You can delete the duplicate items in the excel table;

10 excel table: common formulas

Sum function formula:

Double click cell G2 and enter the function formula in the edit bar: =sum(); Then enter the function parameters: select the e2:e9 cell area with the mouse; Finally, press enter to end the confirmation, and you can calculate the total sales volume of all personnel in the excel table;

SUMIF function formula:

Double click cell G2 and enter the function formula in the edit bar: =sumif(); Then enter the first parameter of the function: select the cell area in column d with the mouse; Second parameter: click cell D2; The third parameter: select the cell area of column e with the mouse; Finally, press the Enter key to end the confirmation, and you can calculate the total sales volume of all personnel in the state of Wei in the excel table;

Sumifs function formula:

Double click cell G2 and enter the function formula in the edit bar: =sumifs(); Then enter the first parameter: select the cell area of column e with the mouse; Group 2 parameters: d:d, D2; Group 3 parameters: c:c, C2; Finally, press the Enter key to end the confirmation, and you can calculate the total sales volume of all men in the state of Wei in the excel table;

Introduction to excel table making tutorial, have you learned it? Try it quickly!

recommend:

fouad whatsapp new version 2022

Leave a Reply

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