MICRSOFT EXCEL

MICRSOFT EXCEL

1. Software that allows you to perform accounting and financial tasks thanks to its functions to help you create and work with spreadsheets.

2. USES

   • Create models to analyze data
   • Write formulas.
   • Create varieties of graphs.

3. FUNCTION

   • A formula already written that takes a value or values, performs an operation and returns a value and values.
   • BUSCARV
     • Is used to locate a value within a specific data range.
   • SUM
     • In this case, it is used to sum the cell interval
   • IF
     • This function is used to answer questions. If the result corresponds to a specific value, you will get the answer you have set.
   • INDEX
     • Helps us to obtain the value of the cell that is exactly at the intersection of the row and the column we have specified.
   • DATE
     • With this function we will obtain a date from three different values. Specifically, year, month and day, in that order.
   • COUNT.IF
     • It gives us the opportunity to count the number of cells in a range that meet a set criterion. Only when the value of those cells meets the condition is it considered within the count.

4. It increases the speed in the work of tabulating and organizing information. It is ideal for the need to insert data in order to manage, interpret and store it.