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

Decision-Making and Scenarios (Coursera) Coursera
University of Pennsylvania

Decision-Making and Scenarios (Coursera)

This course is designed to show you how use quantitative models to transform data into better business decisions. You’ll learn both how to use models to facilitate decision-making and also how to structure decision-making for optimum results. Two of Wharton’s most acclaimed professors will show you the step-by-step processes of modeling common business and financial scenarios, so you can significantly improve your ability to structure complex problems and derive useful insights about alternatives. Once you’ve created models of existing realities, possible risks, and alternative scenarios, you can determine the best solution for your business or enterprise, using the decision-making tools and techniques you’ve learned in this course.

Jun 22nd 2026
4 Weeks
Productivity and Systems Development (Coursera) Coursera
University of California, Irvine

Productivity and Systems Development (Coursera)

This course provides hands-on experience with technology-based productivity tools, as well as foundational knowledge and understanding of system design and development. The course is designed to integrate concepts of hardware, software, and the Internet. This course also provides an overview of data security, data privacy, and ways to increase productivity and efficiency. Students will also investigate technology career paths and some of the various certifications available in the industry.

Jun 22nd 2026
3 Weeks
Data Analysis with Spreadsheets and SQL (Coursera) Coursera
Meta

Data Analysis with Spreadsheets and SQL (Coursera)

This course introduces you to how to use spreadsheets and SQL queries to analyze and extract data. You will learn how to practically apply the OSEMN data analysis framework and spreadsheet functions to clean data, calculate summary statistics, evaluate correlations, and more. You’ll also dive into common data visualization techniques and learn how to use dashboards to tell a story with your data.

Jun 22nd 2026
5-12 Weeks
Pre-MBA Quantitative Skills: Accounting (Coursera) Coursera
Rice University

Pre-MBA Quantitative Skills: Accounting (Coursera)

Financial statements are a key source of information about the economic activities of a firm. This course is a primer on the construction and basic interpretation of financial statements that should provide learners with a rudimentary understanding of the types of information included in the four primary financial statements: balance sheet, income statement, cash flow statement, and statement of stockholders equity.

Jun 22nd 2026
4 Weeks
Understanding Financial Statements: Company Performance (Coursera) Coursera
University of Illinois at Urbana-Champaign

Understanding Financial Statements: Company Performance (Coursera)

This course is designed to provide a basic understanding of financial statements with an emphasis on the income statement. Building on the foundation formed in the first course, you will learn about the third of our three measurement questions and how the income statement helps to answer this final measurement question. Returning to the real business people introduced in the first course, this second course describes the basic content of income statement in a simple yet relevant context.

Jun 22nd 2026
4 Weeks
Introduction to Data Analysis Using Excel (Coursera) Coursera
Rice University

Introduction to Data Analysis Using Excel (Coursera)

The use of Excel is widespread in the industry. It is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning. This course is designed to give you a working knowledge of Excel with the aim of getting to use it for more advance topics in Business Statistics. The course is designed keeping in mind two kinds of learners - those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and wish to enhance their skills.

Jun 22nd 2026
4 Weeks
Optimization for Decision Making (Coursera) Coursera
University of Minnesota

Optimization for Decision Making (Coursera)

In this data-driven world, companies are often interested in knowing what is the "best" course of action, given the data. For example, manufacturers need to decide how many units of a product to produce given the estimated demand and raw material availability? Should they make all the products in-house or buy some from a third-party to meet the demand? Prescriptive Analytics is the branch of analytics that can provide answers to these questions. It is used for prescribing data-based decisions.

Jun 22nd 2026
4 Weeks
Accounting for Decision Making (Coursera) Coursera
University of Michigan

Accounting for Decision Making (Coursera)

Through this course, you will start by addressing the two “big questions” of accounting: “What do I have?” and “How did I do over time?” You will see how the two key financial statements – the balance sheet and the income statement - are designed to answer these questions and then move on to consider how individual transactions aggregate to make up these financial statements.

Jun 22nd 2026
5-12 Weeks
Data Structures and Design Patterns for Game Developers (Coursera) Coursera
University of Colorado System

Data Structures and Design Patterns for Game Developers (Coursera)

This course is the fourth course in the specialization about learning how to develop video games using the C# programming language and the Unity game engine on Windows or Mac. Why use C# and Unity instead of some other language and game engine? Well, C# is a really good language for learning how to program and then programming professionally. Also, the Unity game engine is very popular with indie game developers; Unity games were downloaded 16,000,000,000 times in 2016! Finally, C# is one of the programming languages you can use in the Unity environment.

Jun 22nd 2026
4 Weeks
Introduction to Spreadsheets and Models (Coursera) Coursera
University of Pennsylvania

Introduction to Spreadsheets and Models (Coursera)

The simple spreadsheet is one of the most powerful data analysis tools that exists, and it’s available to almost anyone. Major corporations and small businesses alike use spreadsheet models to determine where key measures of their success are now, and where they are likely to be in the future. But in order to get the most out of a spreadsheet, you have know how to use it. This course is designed to give you an introduction to basic spreadsheet tools and formulas so that you can begin harness the power of spreadsheets to map the data you have now and to predict the data you may have in the future.

Jun 22nd 2026
4 Weeks
Advanced Data Structures in Java (Coursera) Coursera
University of California, San Diego

Advanced Data Structures in Java (Coursera)

How does Google Maps plan the best route for getting around town given current traffic conditions? How does an internet router forward packets of network traffic to minimize delay? How does an aid group allocate resources to its affiliated local partners? To solve such problems, we first represent the key pieces of data in a complex data structure. In this course, you’ll learn about data structures, like graphs, that are fundamental for working with structured real world data.

Jun 22nd 2026
5-12 Weeks