In this Excel video tutorial, we will see 10 functions in 10 minutes in Excel. The most important formulas in Excel for everyday life and for the job market and job interviews. VLOOKUP, COUNTA, COUNTIF, PRODUCT, IF, SUM, SUMIF, LARGE, SMALL, AVERAGEIF.

Each of these formulas in Excel can help us in practice and in real life to automate tasks and automate processes, so we can do automation with these formulas and functions in the Excel spreadsheet.

If you need to learn how to use Excel or are still looking for a free basic Excel course or free intermediate Excel advanced Excel course, this tutorial can help you a lot because here we will see several practical examples and applications of formulas and functions that Excel has.

VLOOKUP, The VLOOKUP function in Excel, or VLOOKUP excel formula, is one of the most important functions in Excel that can help us a lot in everyday life, in the job market and even with Excel for a job interview.

COUNTA, The count values function, as the name suggests, counts the number of values contained in the selected range of cells. In other words, if you, for example, need to know the number of items registered in a spreadsheet, you can use the count values function in Excel to help you with this automatically and without having to count line by line manually.

COUNTIF, The COUNTIF function can help me, as it can count values that appear more than once in a list, it can count repetitions, it counts how many times a certain value has already appeared in the spreadsheet. It is one of the most important formulas in Excel, one of the most important functions, which can help us a lot in everyday life, in the job market, in an Excel job interview or even when carrying out analyses.

PRODUCT, multiplication formula helps us to multiply values like, in the practical and step-by-step example that I show in the Excel tutorial, I have a stock spreadsheet where I have a column with the number of units in stock of each one of the items and another column with the unit cost of each item.

IF, The IF Excel function is one of the most important functions in Excel, as it can greatly help us in automating tasks and automating processes.

SUM, Another function and formula that we will use in the Excel spreadsheet is the sum. We can add items, values, cells, ranges in Excel in different ways. We can use the plus sign or the sum function for this. We can also select items individually, select values, numbers, individually and separate them by plus or semicolon or we can select, in the sum function, the entire range at once, that is, select several cells from one time to add a value from these cells.

SUMIF, The somase formula in Excel helps us to add up not everything but only what meets a criterion, this way we can carry out analyzes in Excel through one of the most important functions of all, which is the sumase function in Excel.

LARGE, Returns the largest value from a data set. You can use any position you want, so here we can make a top 10 in Excel, top 5 excel, top 20 excel etc.

SMALL, Returns the smallest value with the same logical reasoning as the largest formula.

AVERAGEIF, the averageif function in Excel, returns the arithmetic mean of all cells in a range that satisfy a given criteria.

#JopaExcel #Dashboard #Excel