Basic Excel Functions and Operations

Functions

Types of Functions

• Arithmetic Functions:
  • SUM: calculates the sum of a range of cells
  • AVERAGE: calculates the average of a range of cells
  • PRODUCT: calculates the product of a range of cells
  • MIN/MAX: returns the minimum/maximum value in a range of cells
• Text Functions:
  • LEN: returns the length of a text string
  • LOWER/UPPER: converts a text string to lowercase/uppercase
  • PROPER: converts a text string to proper case (first letter capitalized)
  • CONCATENATE: combines multiple text strings into one
• Logical Functions:
  • IF: tests a condition and returns one value if true and another value if false
  • IFERROR: returns a value if an error occurs
  • IFBLANK: returns a value if a cell is blank
• Date and Time Functions:
  • TODAY: returns the current date
  • NOW: returns the current date and time
  • EOMONTH: returns the last day of the month
  • HOUR/MINUTE/SECOND: returns the hour, minute, or second of a time value

Nivel Básico (Basic Level)

Basic Operations

• Basic Arithmetic Operations:
  • Addition: =A1+B1
  • Subtraction: =A1-B1
  • Multiplication: =A1*B1
  • Division: =A1/B1
• Basic Formatting:
  • Number formatting: #,##0 or #,##0.00
  • Date formatting: dd/mm/yyyy or mm/dd/yyyy
  • Time formatting: hh:mm or hh:mm:ss

Basic Data Management

• Selecting and Editing Cells:
  • Selecting cells: clicking on a cell or using keyboard shortcuts (e.g. Ctrl+A to select all)
  • Editing cells: typing in a cell or using the formula bar
• Copying and Pasting Data:
  • Copying: Ctrl+C or right-clicking and selecting "Copy"
  • Pasting: Ctrl+V or right-clicking and selecting "Paste"
• Basic Data Analysis:
  • Sorting data: using the "Sort" button in the "Data" tab
  • Filtering data: using the "Filter" button in the "Data" tab