Good morning for today I want to teach 5 tips in excel clear for people who are entered in this world of information and have no idea of tools ofimatics, tips that have helped me a lot in the office and that I want to teach them since If I had had someone to show them to me, I would have been very dependent on my workload
Tip Number 1:
Concatenate function: used to nest the contents of several columns, for me this function has been very important at the time of reporting
Tip Number 2:
Function sumar.si: function that perimite sumar a range of cells according to the criteria that you establish, this function is really important for those people who work with statistics
Tip Number 3:
Function count.si: function that allows you to count a range of cells according to the established criterion
Tip Number 4:
Average function.si: function that allows you to average a range of cells according to a set average
Tip Number 5:
If you want to find a duplicate number in a column, there is a way to make it very simple that I will tell you in the following steps:
Step number 1 go to the start menu as shown in the image
Step number 2 select the column where you want to find the duplicate value for my example is column D which is the column of the work area
Step number 3: go to the menu conditional format, rules to highlight cells and duplicate values
Step number 4 result :) will be shaded in color which by default is red only duplicate items
Well it's all for today if you want to learn something more than just let me know, I hope it's useful
Until next time, this is my English version :)