At first, I want to explain how you can create a table in excel. How to Create a Table in Excel; For creating a table in Excel you should follow these steps; 1- Select the cells which you want to create a table on them. 2- Click on the Home tab In the Style part Click on the “Format as Table”. 3- Select your desired format. 4- Specify the range of the table.
Sometimes you have different columns and you want to combine their data of the cells together. For that, we want to explain two methods How to Concatenate in Excel First method; You can use “Concatenate” formula to bring the data of those columns together. For that you can follow these steps; 1- Write this formula =Concatenate(B3,C3,D3) If you want to have space between the data of each column, you can add space between data by this formula;
Sometimes when you enter a time value in the cell of your table in excel, you face some problems. here we are going to explain some of them and how to solve these problems. Before start to explain this subject, it is better to understand how excel store time values. In the following picture we shows that; the value of 12:00 AM is zero, and then for every 6 hours, excel adds -0.
we have different methods for rounding the numbers down in excel here we are going to explain some of them. How to Round Down Digits in Excel with Int Command; If you want to round down a number to the nearest integer you can use this formula. you should pay attention, this command round down negative digits away from zero. For that, you can use this formula =INT(D5) In this formula, “D5” is the address of the cell which you want to round it down.
you can use “MROUND” command to round your digits to specific numbers and also round the time to specific time. Here we are going to explain them with some example; How to Round to Specific Digit in Excel; How to round number to first digit. If you have decimal digit and you want to round them to the digit without any decimals you can use this formula. =MROUND(C5,1) In this formula
If we have numbers in our table and we have to limit the decimals, we can use these commands. How to Round Number in Excel. In this command, if your integrated or decimal part is less than 5, you will be rounded to a smaller value, and if it is equal to or greater than 5, it will be rounded to a larger amount. Here we want to explain this command with an example.
Sometimes you want to freeze a cell in your worksheet, for that you can follow these steps. How to Freeze Panes in Excel There are different methods for freezing panes in Excel, here we are going to explain some of them. You can use split command for splitting the sheet. After you use this command, the sheet will be split into four or two parts and then you can freeze each part which you need.
Sometimes you have a big table but you need to see the first column or some columns in your table when you are searching in that table. For that you can follow these steps; How to Freeze First Column in Excel; If you need to freeze the first column you should follow these steps; 1- Click on the View tab. 2- Click on the Freeze Panes. 3- Click on the Freeze First Column.
How to Compare Two Column in one Row; If we want to compare the content of the cells of two columns in the same row, we have different ways, Here we are going to explain two of them. write this formula in the cell and specify it to other cells of the column. Here we want to compare column B and C with each other and these columns start from row number three so we should write this formula and specify it to other cells of the column.
If statement has three parameters; Condition; condition is the value which you want to test. Value_If_True; It is the value that is returned if condition evalutes to True. Value_If_False; It is the value that is returned if condition evalutes to False and this parameter is optional. you should pay attention if you do not write anything in the formula the program will place the word “False”, if the result of condition be false.