Formulas y Gráficos en Hojas de Cálculo

Formulas

• Types of formulas:
  • Arithmetic: =A1+B1
  • Comparison: =A1+B1>10
  • Text: ="Hello "&A1
  • Logical: =IF(A1>10, "Greater than 10", "Less than or equal to 10")
• Operators:
  • Arithmetic: +, -, *, /, %, ^
  • Comparison: =, <>, >, <, >= , <=
• Functions:
  • SUM: =SUM(A1:A10)
  • AVERAGE: =AVERAGE(A1:A10)
  • COUNT: =COUNT(A1:A10)
  • IFERROR: =IFERROR(A1/B1, "Error!")

Charts

• Types of charts:
  • Column
  • Bar
  • Line
  • Pie
  • Scatter
• Chart components:
  • Title
  • X-axis
  • Y-axis
  • Legend
  • Data labels
• Customizing charts:
  • Changing colors and fonts
  • Adding axis labels and titles
  • Rotating axis labels
  • Adding data labels and annotations

Pivot Tables

• Creating a pivot table:
  • Selecting a data range
  • Going to the "Insert" tab and clicking "PivotTable"
  • Choosing a cell to place the pivot table
• Configuring a pivot table:
  • Dragging fields to the "Rows", "Columns", and "Values" areas
  • Using the "Field Settings" button to customize field settings
  • Using the "PivotTable Tools" tab to format and analyze the pivot table
• Pivot table functions:
  • SUM
  • AVERAGE
  • COUNT
  • PERCENTAGE

Conditional Formatting

• Types of conditional formatting:
  • Highlighting cells based on values
  • Highlighting cells based on formulas
  • Highlighting duplicate values
• Formatting options:
  • Fill color
  • Font color
  • Font style
  • Borders
• Creating a conditional formatting rule:
  • Selecting a range of cells
  • Going to the "Home" tab and clicking "Conditional Formatting"
  • Choosing a formatting rule type and setting the rule criteria

Fórmulas

• Tipos de fórmulas:
  • Aritmética: se utiliza para realizar operaciones numéricas básicas, como suma, resta, multiplicación y división. Ejemplo: =A1+B1
  • Comparación: se utiliza para comparar valores y devuelve un valor booleano (verdadero o falso). Ejemplo: =A1+B1>10
  • Texto: se utiliza para concatenar textos y valores. Ejemplo: ="Hello "&A1
  • Lógica: se utiliza para evaluar condiciones y devolver un valor según sea verdadera o falsa. Ejemplo: =IF(A1>10, "Greater than 10", "Less than or equal to 10")

Operadores

• Operadores aritméticos:
  • Suma: +
  • Resta: -
  • Multiplicación: *
  • División: /
  • Modulo: %
  • Potencia: ^
• Operadores de comparación:
  • Igual: =
  • No igual: <>
  • Mayor que: >
  • Menor que: <
  • Mayor o igual que: >=
  • Menor o igual que: <=