📊 Curso Google Sheets ✅ Funciones de Google, GOOGLETRANSLATE, GOOGLEFINANCE, SPARKLINE

Google Sheets Functions Overview

Introduction to Google Sheets Functions

• The video continues the course on Google Sheets, focusing on functions provided by Google for spreadsheet work.

• A new sheet titled "Funciones de Google" is created to demonstrate various functions.

Using Google Translate Function

• The first function discussed is Google Translate, which translates content based on language codes listed in the spreadsheet.

• To use this function effectively, one must know the abbreviation for each language. A reference page from Google provides these codes.

• The formula requires inputting the text to translate (from cell C2), along with source and target languages specified by their abbreviations.

• After setting up the formula with absolute references for consistent cells, translations are generated across multiple languages as you drag down the formula.

Applying Absolute References

• Absolute references are used for both source text and source language to ensure they remain constant while dragging formulas down through rows.

• The final reference for destination languages remains relative so that it adjusts automatically as you drag down.

Using Google Finance Function

Currency Conversion Example

• The next function introduced is Google Finance, which retrieves financial data; a simple example of currency conversion is demonstrated.

• Users need to specify currency symbols in a specific format (e.g., "CURRENCY:USD/EUR") to get exchange rates between currencies.

Inverse Currency Conversion

• By reversing the order of currencies in the formula, users can obtain inverse conversion rates (EUR to USD).

Creating Graphical Representations with Sparkline

Visualizing Currency Trends

• The video explains how to combine Sparkline with Google Finance data to create visual graphs within a single cell showing currency trends over time.

How to Use Google Finance Functions in Spreadsheets

Introduction to Google Finance Function

• The speaker explains how to set the end date for data retrieval, which will collect data from the last 30 days.

• The function being discussed is SPARKLINE, which takes parameters including currency exchange rates and cell references.

Parameters of the Google Finance Function

• The first parameter is the currency symbol, specifically for currency conversion (e.g., Euro).

• Additional parameters include start date (30 days ago using TODAY()-30) and end date (today's date using TODAY()).

Closing Functions Properly

• Emphasis on closing parentheses correctly: three parentheses must be closed sequentially for TODAY(), GOOGLEFINANCE, and SPARKLINE.

• After entering the formula, a graph displaying the trend of Euro to Dollar exchange over the past 30 days is generated.

Adjusting Graph Visibility