Tools, meaning and uses.

Tools, meaning and uses.

1. CONDTIONAL FORMAT

   • El formato condicional facilita el proceso de resaltar celdas o rangos de celdas interesantes, destacar valores inusuales y ver datos empleando barras de datos, escalas de colores y conjuntos de iconos que se corresponden con las variaciones específicas de los datos.

2. CELLS FORMATS

   • The cell format is the appearance that the cells have, referring to the aspects includes the use of colors, fonts, alignment, and all the various elements that contribute an adequate presentation of the content of the cells.

3. GRAPHS

   • Selecting an Excel chart displays the Format contextual tab, which contains a large number of commands that allow you to apply a format to any part of the chart. In order to apply the format, you must first select the part of the graph that you want to modify.

4. TEXT FORMAT

   • If you want Excel to treat certain types of numbers as text, you can use text format instead of number format. For example, if you use credit card numbers or other number codes that contain 16 digits or more, you must use a text format.

5. FILTERS

   • Filters in Excel allow us to search for a subset of data that meets certain criteria. Generally everything starts when we have a range of cells with information and we want to see only those rows that meet certain conditions.