Crear un Informe Financiero con Google Sheets (Coursera)

Crear un Informe Financiero con Google Sheets (Coursera)

En este curso basado en un proyecto y de 2 horas de duración, aprenderá a completar una plantilla de informe financiero con Google Sheets. Aprenderá a ingresar las transacciones de su empresa y a definir los elementos del Balance Financiero. Con la información ingresada, aprenderá a interpretar los datos presentados acerca de las pérdidas y ganancias. Con ello, comprenderá cómo utilizar esta herramienta para realizar un seguimiento y presentar la información financiera de su empresa con el uso de gráficos.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

In this Free Guided Project, you will:

  • Configurar las transacciones y categorías de una plantilla de informe financiero de Google Sheets
  • Entender los elementos de un balance general y los resultados de ganancias y pérdidas
  • Presentar resultados financieros en forma de gráficos
  • Showcase this hands-on experience in an interview

Learn step-by-step
In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Abrir la plantilla de Informe Financiero en Google Sheets
  2. Ingresar transacciones de la empresa en la pestaña de Transacciones
  3. Definir los elementos de la pestaña de Balance Financiero
  4. Entender los datos presentados en la pestaña de Pérdidas y Ganancias y la pestaña de Panel
  5. Formatear los gráficos y hacerlos presentables
Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Excel Skills for Business: Intermediate I (Coursera) Coursera
Macquarie University

Excel Skills for Business: Intermediate I (Coursera)

In this second course of our Excel specialization Excel Skills for Business you will build on the strong foundations of the Essentials course. Intermediate Skills I will expand your Excel knowledge to new horizons. You are going to discover a whole range of skills and techniques that will become a standard component of your everyday use of Excel.

Sep 7th 2026
5-12 Weeks
Data Visualization and Dashboards with Excel and Cognos (Coursera) Coursera
IBM

Data Visualization and Dashboards with Excel and Cognos (Coursera)

This course covers some of the first steps in the development of data visualizations using spreadsheets and dashboards. Begin the process of telling a story with your data by creating the many types of charts that are available in spreadsheets like Excel. Explore the different tools of a spreadsheet, such as the important pivot function and the ability to create dashboards and learn how each one has its own unique property to transform your data.

Sep 7th 2026
4 Weeks
Financial Acumen for Non-Financial Managers (Coursera) Coursera
University of Pennsylvania

Financial Acumen for Non-Financial Managers (Coursera)

In this course, you’ll explore how financial statement data and non-financial metrics can be linked to financial performance. Professors Rick Lambert and Chris Ittner of the Wharton School have designed this course to help you gain a practical understanding of how data is used to assess what drives financial performance and forecast future financial scenarios. You’ll learn more about the frameworks of financial reporting, income statements, and cash reporting, and apply different approaches to analyzing financial performance using real-life examples to see the concepts in action.

Sep 7th 2026
4 Weeks
Two Speed IT: How Companies Can Surf the Digital Wave, a BCG Perspective (Coursera) Coursera
CentraleSupélec

Two Speed IT: How Companies Can Surf the Digital Wave, a BCG Perspective (Coursera)

Transform or disappear, the Darwinism of IT: In order to adapt to a digital world, a two-speed IT is needed. Despite the importance of IT in today’s digital world, Chief Information Officers (CIOs) often struggle to get their voices heard by executive committees. Faced with this challenge, IT departments are being forced to reinvent themselves to adapt their companies to the fast paced evolution of technology. The Boston Consulting Group has developed a business approach that allows IT to shed off its appearance of a heavy cost center and to adopt a new, more realistic persona as a quality service provider, partnering with users and the management.

Sep 21st 2026
5-12 Weeks
Google Sheets - Advanced Topics (Coursera) Coursera
Google Cloud

Google Sheets - Advanced Topics (Coursera)

This course builds on some of the concepts covered in the earlier Google Sheets course. In this course, you will learn how to apply and customize themes In Google Sheets, and explore conditional formatting options. You will learn about some of Google Sheets’ advanced formulas and functions. You will explore how to create formulas using functions, and you will also learn how to reference and validate your data in a Google Sheet.

Sep 21st 2026
1 Week
Algorithms, Part II (Coursera) Coursera
Princeton University

Algorithms, Part II (Coursera)

This course covers the essential information that every serious programmer needs to know about algorithms and data structures, with emphasis on applications and scientific performance analysis of Java implementations. Part I covers elementary data structures, sorting, and searching algorithms. Part II focuses on graph- and string-processing algorithms.

Sep 14th 2026
5-12 Weeks
Excel Skills for Business: Essentials (Coursera) Coursera
Macquarie University

Excel Skills for Business: Essentials (Coursera)

In this first course of the specialization Excel Skills for Business you will learn the Essentials of Microsoft Excel. Within six weeks, you will learn to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs.

Sep 7th 2026
5-12 Weeks
MySQL for Data Analytics and Business Intelligence (Coursera) Coursera
Edureka

MySQL for Data Analytics and Business Intelligence (Coursera)

Embark on a thorough educational expedition through the "Fundamentals of Database Management with MySQL" module. This foundational program aims to impart a robust comprehension of MySQL, a prominent Relational Database Management System (RDBMS). Participants will delve into crucial concepts, ranging from the fundamentals of SQL to more advanced topics like data retrieval, relationships, business intelligence, and data visualization.

Sep 7th 2026
1 Week
Fundamentos de los Aspectos Financieros del Negocio con Goldman Sachs 10,000 Women (Coursera) Coursera
Goldman Sachs

Fundamentos de los Aspectos Financieros del Negocio con Goldman Sachs 10,000 Women (Coursera)

Este curso gratuito es uno de los 10 cursos disponibles en la colección Goldman Sachs 10,000 Women, diseñado para emprendedoras listas para llevar su negocio al siguiente nivel. Este curso te presentará la terminología financiera y te mostrará cómo utilizar los estados financieros para comprender y controlar la posición financiera de tu empresa para poder tomar decisiones comerciales clave.

Sep 7th 2026
1 Week
Excel Skills for Business: Advanced (Coursera) Coursera
Macquarie University

Excel Skills for Business: Advanced (Coursera)

Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces around the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. Across the globe, millions of job advertisements requiring Excel skills are posted every day. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this course will position you ahead of others, so keep reading.

Sep 7th 2026
5-12 Weeks