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

Mastering Excel Essentials to Enhance Business Value (Coursera) Coursera
Illinois Tech

Mastering Excel Essentials to Enhance Business Value (Coursera)

This course is designed to cater to a diverse audience, particularly those with an interest in working in dynamic environments that place a strong emphasis on data-driven, quantitative analysis. Whether you are an experienced professional seeking to enhance your skills or someone looking to pivot into a cutting-edge industry, this course provides valuable insights and knowledge to thrive in today's data-centric and rapidly evolving landscape.

Sep 14th 2026
4 Weeks
Get Started with Spreadsheet Applications: Excel (Coursera) Coursera
SkillUp EdTech

Get Started with Spreadsheet Applications: Excel (Coursera)

Spreadsheet applications are an essential part of productivity at work and school. Understanding how to use spreadsheet apps such as Microsoft Excel can make you a more efficient and valuable worker. In this mini-course, you will learn the essentials of working with spreadsheet apps. You will learn how to open, save, share, and print spreadsheet files, move around a worksheet, and enter and edit data.

Sep 7th 2026
3 Weeks
Excel/VBA for Creative Problem Solving, Part 2 (Coursera) Coursera
University of Colorado Boulder

Excel/VBA for Creative Problem Solving, Part 2 (Coursera)

Excel/VBA for Creative Problem Solving, Part 2" builds off of knowledge and skills obtained in "Excel/VBA for Creative Problem Solving, Part 1" and is aimed at learners who are seeking to augment, expand, optimize, and increase the efficiency of their Excel spreadsheet skills by tapping into the powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA).

Sep 7th 2026
4 Weeks
Prepare Data for Exploration (Coursera) Coursera
Google

Prepare Data for Exploration (Coursera)

This is the third course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. As you continue to build on your understanding of the topics from the first two courses, you’ll also be introduced to new topics that will help you gain practical data analytics skills. You’ll learn how to use tools like spreadsheets and SQL to extract and make use of the right data for your objectives and how to organize and protect your data. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources.

Sep 7th 2026
5-12 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
How to finance your venture ? (Coursera) Coursera
École Polytechnique

How to finance your venture ? (Coursera)

The course aims at providing knowledge and experience to entrepreneurs and would-be entrepreneurs. Entrepreneurs generally start with a mission, a new idea that they want to bring to the world. If the idea is original, it is probably not expected by the market, which has to be educated. This is a very costly experience. Entrepreneurs need to gather capital at the start of the journey.

Sep 21st 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
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
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.

Sep 21st 2026
5-12 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.

Sep 14th 2026
5-12 Weeks