In this Excel tutorial video, we are going to learn the 7 main Excel functions that can help you in a job interview, on your daily basis etc.

In this free Excel tutorial, let's find it out how to save time with Excel and automate repetitive tasks and processes through formulas and dynamic functions here in Excel.

The first formula we will use is the multiplication formula in Excel.

The 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 for each of the items and another column with the unit cost of each item.

However, I would like to know the total amount in reais of each item that I have in stock, that is, the total cost.

So that I can calculate the total cost, I will need to multiply the two previous columns and, for that, I can use the multiplication formula using the special asterisk or little star symbol.

Another alternative is to use the multiplication function in Excel, product.

There are different ways to do a multiplication in Excel either through a formula in the worksheet or through a function in the Excel worksheet.

Another function and formula that we will use in the Excel worksheet is the sum.

We can sum 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 more or by semicolons or we can still select, in the sum function, the entire range at once, that is, select several cells at once. time to be able to add a value from those cells.

CountA is the third function that we will use in this practical example of how to use Excel.

The count values function, as the name suggests, counts the amount of values contained in the selected range of cells.

That is, 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 manually count line by line.

The Excel CountA function is an excellent alternative to automate processes and automate repetitive tasks in Excel.

Another function that we will learn to use is the average function.

The average function helps us to take the average of the selected values.

We can also, instead of using the average function in Excel, use an average formula, that is, add up all the values that we want to average and then divide all these selected values by the number of values.

A practical example of how to use the average function is to find out the average ticket price of your products in stock.

Last but not least, let's say we want to know what is the highest value item that we have in stock, what is the product with the highest value in stock.

So that we can automate this task and not have to manually look product by product, line by line in Excel, we can use the MAX function to help us automate this task.

Whenever the largest function is used, it will return the highest value of the selected range or, in this case, in this example, it will return the item with the highest stock value.

After that, we will learn how to use the procv function in Excel. The Vlookup function is an excellent search function that, from a criteria or a condition, the Vlookup formula returns you the value corresponding to that previously found value.

#JopaExcel #Dashboard #Excel