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 Basics for Data Analysis (Coursera) Coursera
IBM

Excel Basics for Data Analysis (Coursera)

This course is designed to provide you with basic working knowledge for using Excel spreadsheets for Data Analysis. It covers some of the first steps for working with spreadsheets and their usage in the process of analyzing data. It includes plenty of videos, demos, and examples for you to learn, followed by step-by-step instructions for you to apply and practice on a live spreadsheet.

Oct 19th 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.

Nov 2nd 2026
1 Week
Intro to Finance in Healthcare (Coursera) Coursera
Northeastern University

Intro to Finance in Healthcare (Coursera)

This course is best suited for individuals currently in the healthcare sector, as a provider, payer, or administrator. Individuals pursuing a career change to the healthcare sector may also be interested in this course. In this course, you will have an opportunity to explore concepts and topics related to accounting and finance basics for healthcare organizations.

Oct 26th 2026
4 Weeks
Data Science Math Skills (Coursera) Coursera
Duke University

Data Science Math Skills (Coursera)

Data science courses contain math—no avoiding that! This course is designed to teach learners the basic math you will need in order to be successful in almost any data science math course and was created for learners who have basic math skills but may not have taken algebra or pre-calculus. Data Science Math Skills introduces the core math that data science is built upon, with no extra complexity, introducing unfamiliar ideas and math symbols one-at-a-time.

Nov 2nd 2026
4 Weeks
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.

Oct 12th 2026
4 Weeks
Business Analytics with Excel: Elementary to Advanced (Coursera) Coursera
Johns Hopkins University

Business Analytics with Excel: Elementary to Advanced (Coursera)

A leader in a data driven world requires the knowledge of both data-related (statistical) methods and of appropriate models to use that data. This Business Analytics class focuses on the latter: it introduces students to analytical frameworks used for decision making though Excel modeling. These include Linear and Integer Optimization, Decision Analysis, and Risk modeling. For each methodology students are first exposed to the basic mechanics, and then apply the methodology to real-world business problems using Excel.

Oct 19th 2026
5-12 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.

Oct 12th 2026
4 Weeks
Compétences Excel pour l’entreprise : les notions clés (Coursera) Coursera
Macquarie University

Compétences Excel pour l’entreprise : les notions clés (Coursera)

Dans ce premier cours de la spécialisation Compétences Excel pour l’entreprise, vous apprendrez les bases de Microsoft Excel. Dans un délai de six semaines, vous serez en mesure de naviguer de manière experte dans l'interface utilisateur d'Excel, d'effectuer des calculs de base avec des formules et des fonctions, de mettre en forme des feuilles de calcul de manière professionnelle et de créer des visualisations de données au moyens de graphiques et de diagrammes.

Nov 2nd 2026
5-12 Weeks
Habilidades de Excel para negócios: Fundamentos (Coursera) Coursera
Macquarie University

Habilidades de Excel para negócios: Fundamentos (Coursera)

Neste primeiro curso da especialização Habilidades de Excel para negócios, você aprenderá os fundamentos do Microsoft Excel. Dentro de seis semanas, você poderá navegar habilmente pela interface de usuário do Excel, realizar cálculos básicos com fórmulas e funções, formatar planilhas profissionalmente e criar visualizações de dados por meio de gráficos e tabelas.

Nov 2nd 2026
5-12 Weeks
Introduction to Financial Accounting (Coursera) Coursera
University of Pennsylvania

Introduction to Financial Accounting (Coursera)

Master the technical skills needed to analyze financial statements and disclosures for use in financial analysis, and learn how accounting standards and managerial incentives affect the financial reporting process. By the end of this course, you’ll be able to read the three most common financial statements: the income statement, balance sheet, and statement of cash flows. Then you can apply these skills to a real-world business challenge as part of the Wharton Business Foundations Specialization.

Oct 19th 2026
4 Weeks
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.

Oct 19th 2026
5-12 Weeks
More Introduction to Financial Accounting (Coursera) Coursera
University of Pennsylvania

More Introduction to Financial Accounting (Coursera)

The course builds on my Introduction to Financial Accounting course, which you should complete first. In this course, you will learn how to read, understand, and analyze most of the information provided by companies in their financial statements. These skills will help you make more informed decisions using financial information.

Oct 12th 2026
5-12 Weeks