some image

What is Microsoft Excel?

Microsoft Excel ; it is a spreadsheet program. Excel is an application program that offers the opportunity to keep all kinds of data, especially numerical data in the form of tables or lists, and to easily perform all the necessary calculations and analyzes related to these data. The Excel definition is generally like this. Where is Excel used ? Excel is especially used for making lists, complex analysis, complex calculations using formulas, and all operations related to keeping inventory. With Excel, you can draw graphs of data, quickly and easily prepare reports and summaries, access all desired data, sort and query data. The data in Excel is stored in opened files and the file extension is 'xls'.Microsoft Excel usage areas ; payrolls, payroll, tax calculations, budgets, foreign currency transactions, product lists, bills of materials, coding and various operations on this information. It can be used in areas such as expense/income, cash accounts, stock, inventory. The right address for Microsoft Exsel tainin and advanced training in Microsoft Excel is the Informatics Training Center .

 

What is Microsoft Excel and How Is It Used?

what is excel

Excel may seem like a very complex program at first. But as you learn Excel , you will understand that it is actually based on a very simple system. You can customize the Quick toolbar by clicking the arrow from the top ribbon and work easily by editing it to suit your needs.

To start Microsoft Excel , go to the 'Programs' command from the Start menu and click Microsoft Excel from the submenu that opens on the right. Click the 'Exit' command in the 'File' menu to exit Microsoft Excel.

Excel automates all your work, lists, and calculations in an organized fashion. The more you research and try to learn Microsoft Excel , the better you will understand it. Because Microsoft Excel allows you to perform countless operations and keep data as automatic entries. For this, you need to know various formulas.

All projects you make in Excel are expressed in workbooks. Each workbook contains many formulas and functions. While preparing a workbook, you can choose one of the ready-made templates in Excel and continue your work on this template. To open and work on a file that you have worked on before, go to the 'File' menu, select the workbook from the file view and click the open button.

Microsoft Excel Formulas

excel formulas

We would like to share with you the most frequently used Excel formulas . Arithmetic formulas in Excel provide great convenience. The vertical formula is one of them. For example, suppose you have two separate columns in a workbook. You want to synchronize the data in Column 1 and row A with the data in Column 2. It is possible to transfer from different workbooks with separate columns with the Vertical() or, in English versions, Vlookup() formula.

 

The formula =SUM(B2:B10) adds the values ​​of cells B2 through B10.

=100+350+451 Adds 3 fixed numbers.

=A5+650 Adds the number in cell A5 and a constant number, like in the example, 650.

=A5+B3+F4 Adds the contents of three cells.

=35*670000 Multiplies two constant numbers.

=A2*670000 Multiplies cell A2 by a constant.

=A2*B3 Multiplies Cell A2 by Cell B3.

=155-85 Takes the difference of two fixed numbers.

=155-A9 Takes the difference of cell A9 with a constant number.

=A2-C2 takes the difference of 2 cells.

=32500000/325000 Divides one constant by another constant.

=A5/325000 Divides the contents of cell A5 by a constant.

=A1/C4 splits cell A1 into cell C4.

=AVERAGE(B2:B10) Averages the cells from B2 to B10.

=A1*0.18 takes 18% of cell A1.

=A1*1.18 Finds 118% (18% more) of Cell A1.

=MAK(C2:C10) Writes the value of the largest cell from C2 to C10.

=MIN(C2:C10) Writes the value of the smallest of the cells C2 to C10.

=COUNTIF(B2:B10;”HIGH SCHOOL”) Finds how many of the cells from B2 to B10 contain HIGH SCHOOL.

=COUNT BLANK(B2:B10) Finds how many of the cells from B2 to B10 are empty.

=BAG_DEG_DOLU_SAY(B2:B10) Finds how many cells B2 to B10 are filled.

=CONCATENATE(D9,F9) Combines the text in cell D9 with the text in cell F9.

=LEN(D8) Finds how many characters the text in cell D8 consists of.

=IF(A3>2;”GOOD”;”BAD”) If the number in cell A3 is greater than 2, it is GOOD or BAD.

=IF(A3>=2;”GOOD”;”BAD”) If the number in cell A3 is greater than 2, including 2, it is GOOD or BAD.

=IF(B2>0;”PROF”;”LOSS”) If the value of cell B2 is greater than 0, then LOSS is written if not PROFIT.

=IF(B2>2;”PASS”;”FAIL”) If the value of cell B2 is greater than 2, PASSED or FAILED.

=ROMEN(A1) Converts the number in cell A1 to Roman numerals.

=UPPER(A1) Capitalizes the text in cell A1.

=LOWER(A1) Writes the text in cell A1 in lowercase.

= MATCH(“MEHMET”;D15:D19) Writes in which cell “MEHMET” is located between cell D15 and D19.

=IBLANK(A2) returns TRUE if cell A2 is empty, FALSE if it is full.

=COUNTS(D5:D13) Writes how many lines there are from D5 to D13.

=COLUMNS(D12:H12) Writes how many columns there are from D12 to H12.

=NOW() Shows the current date and time.

=TODAY() Returns today's date.

=LIRA(A1) converts the number in cell A1 to Turkish currency.