Coursera

Fundamentos de Excel para Negocios (Coursera)

Offered by Universidad Austral,
Fundamentos de Excel para Negocios (Coursera)

Cuando finalices este curso habrás logrado un gran número de habilidades como introducir información, ordenarla, manipularla, realizar cálculos de diversa índole (matemáticos, trigonométricos, estadísticos, financieros, ingenieriles, probabilísticos), extraer conclusiones, trabajar con fechas y horas, construir gráficos, imprimir reportes y muchas más.

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

Asimismo, los ejemplos sobre los cuales se apoyan los contenidos dictados en este curso tienen una profunda aplicabilidad al mundo de los negocios, con lo que su inmediata utilización empresarial está al alcance de la mano.
Finalmente, los profesores que han diseñado y elaborado este curso para ti, no solamente dan una visión académica del software sino que, debido a su gran trayectoria profesional apoyada justamente en una profunda utilización de Excel, te transmitirán su propia vivencia que te permitirá tener una visión más concreta de las posibilidades que te brinda esta herramienta.

Syllabus

WEEK 1
Introducción, configuración y manejo general de Excel
¡Bienvenidos al curso! En este primera semana, veremos los siguientes temas: funcionalidad básica; menú; cinta de opciones; celdas; filas y Columnas; barra de acceso rápido; uso del mouse; preferencias del teclado.

WEEK 2
Trabajando con la planilla
Bienvenidos a la semana 2 del curso. En esta semana veremos los siguientes temas: ingreso de datos; celdas, rangos, nombres de celdas; autocompletar; formatos básicos de las celdas: numéricos, bordes, colores. Insertar y eliminar celdas, filas y columnas; estructura de las funciones; principales funciones básicas: autosuma, promedio, máximo, mínimo, condicional.

WEEK 3
Bienvenidos a la semana 3 del curso. En esta semana veremos los siguientes temas:
opciones de copiado: simple, transpuesta, funciones, valores; referencias absolutas y relativas; mover celdas; implicaciones

WEEK 4
Analizando información
Bienvenidos a la 4 semana de clases. Esta semana veremos los siguientes temas: ordenar información; múltiples criterios; filtros automáticos; uso de diferentes criterios; combinación de funciones y filtros; filtros avanzados; fijación de columnas y filas.

WEEK 5
Funciones en Excel
Bienvenidos a la semana 5 del curso. En esta semana veremos los siguientes temas: funciones matemáticas y estadísticas. funciones financieras y de fecha; funciones de texto; funciones de búsqueda; funciones matemáticas como Suma, Valor Absoluto, Raíz Cuadrada; funciones estadísticas como Promedio, Desvío Estándar; funciones financieras como Tasa de Retorno, Valor Actual Neto, Cálculo de Cuota, Tasa de interés efectiva; funciones de fecha y hora como Año, Mes, Día, Hora; funciones de texto como Izquierda, Derecha, Extrae, Mayúscula y Minúscula; funciones de búsqueda como Búsqueda Vertical, Búsqueda Horizontal.

WEEK 6
Creando gráficos
Bienvenidos a la semana 6 del curso. En esta semana veremos los siguientes temas: tipos de gráficos; selección de los datos; elementos de los gráficos; opciones de gráficos.

WEEK 7
Imprimiendo planillas
Bienvenidos a la semana 7 del curso. En esta semana veremos los siguientes temas: definición del objeto a imprimir; configuración de la impresión; opciones de impresión: bordes, títulos, cantidad de páginas.

WEEK 8
Manejo avanzado de celdas
Llegamos al final del curso. En esta semana veremos los siguientes temas: trabajar con fechas, horas y minutos; trabajar con textos; concatenar textos y números.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

The Data Scientist's Toolbox (Coursera) Coursera
Johns Hopkins University

The Data Scientist's Toolbox (Coursera)

Statistics & Data Analysis Data Science

In this course you will get an introduction to the main tools and ideas in the data scientist's toolbox. The course gives an overview of the data, questions, and tools that data analysts and data scientists work with. There are two components to this course. The first is a conceptual introduction to the ideas behind turning data into actionable knowledge. The second is a practical introduction to the tools that will be used in the program like version control, markdown, git, GitHub, R, and RStudio.

Jun 1st 2026
4 Weeks
Data Github Data Analysis
Details
Data Science Companion (Coursera) Coursera
MathWorks

Data Science Companion (Coursera)

Statistics & Data Analysis Data Science

The Data Science Companion provides an introduction to data science. You will gain a quick background in data science and core machine learning concepts, such as regression and classification. You’ll be introduced to the practical knowledge of data processing and visualization using low-code solutions, as well as an overview of the ways to integrate multiple tools effectively to solve data science problems.

Jun 5th 2026
4 Weeks
MATLAB Machine Learning Regression
Details
Fundamentals of Project Planning and Management (Coursera) Coursera
University of Virginia

Fundamentals of Project Planning and Management (Coursera)

Management & Leadership Business

Projects are all around us. Virtually every organization runs projects, either formally or informally. We are engaged in projects at home and at work. Across settings, planning principles and execution methodologies can offer ways in which projects can be run more effectively and efficiently. Project management provides organizations (and individuals) with the language and the frameworks for scoping projects, sequencing activities, utilizing resources, and minimizing risks.

Jun 1st 2026
4 Weeks
Business Management Risk Analysis
Details
On Strategy : What Managers Can Learn from Philosophy - PART 1 (Coursera) Coursera
CentraleSupélec

On Strategy : What Managers Can Learn from Philosophy - PART 1 (Coursera)

Management & Leadership

In the expression “creative thinking”, the keyword is not creativity; the keyword is thinking. With the help of great philosophers, you will rediscover the art of thinking. To help leaders to be rigorous even without figures, great philosophers have lots of ideas. Managers are invited to rediscover the art of thinking. They should understand the role of mental models, realize the importance of cognitive bias, agree on clear definitions and efficient criteria etc. Creativity demands the ability to unshackle ourselves from conventional ways of thinking, to "think outside the box".

Jun 1st 2026
5-12 Weeks
Business Philosophy Innovation
Details
Statistical Inference (Coursera) Coursera
Johns Hopkins University

Statistical Inference (Coursera)

Statistics & Data Analysis Data Science

Statistical inference is the process of drawing conclusions about populations or scientific truths from data. There are many modes of performing inference including statistical modeling, data oriented strategies and explicit use of designs and randomization in analyses. Furthermore, there are broad theories (frequentists, Bayesian, likelihood, design based, …) and numerous complexities (missing data, observed and unobserved confounding, biases) for performing inference.

Jun 1st 2026
4 Weeks
Statistics Probability Data Analysis
Details
Regression Modeling in Practice (Coursera) Coursera
Wesleyan University

Regression Modeling in Practice (Coursera)

Statistics & Data Analysis

This course focuses on one of the most important tools in your data analysis arsenal: regression analysis. Using either SAS or Python, you will begin with linear regression and then learn how to adapt when two variables do not present a clear linear relationship. You will examine multiple predictors of your outcome and be able to identify confounding variables, which can tell a more compelling story about your results. You will learn the assumptions underlying regression analysis, how to interpret regression coefficients, and how to use regression diagnostic plots and other tools to evaluate the quality of your regression model. Throughout the course, you will share with others the regression models you have developed and the stories they tell you.

Jun 5th 2026
4 Weeks
Python Data Analysis Linear Regression
Details
Alternative Approaches to Valuation and Investment (Coursera) Coursera
University of Melbourne

Alternative Approaches to Valuation and Investment (Coursera)

Management & Leadership Economics & Finance

In this course, participants will develop an understanding of the intuitive foundations of asset and investment valuation, and how alternative valuation techniques may be used in practice. This is part of a Specialization in corporate finance created in partnership between the University of Melbourne and Bank of New York Mellon (BNY Mellon).

Jun 1st 2026
4 Weeks
Finance Business Risk
Details
Operations Management: Analysis and Improvement Methods (Coursera) Coursera
University of Illinois at Urbana-Champaign

Operations Management: Analysis and Improvement Methods (Coursera)

Business

In this course, you will learn about the role of operations and how they are connected to other business functions in manufacturing- and service-focused organizations. You will learn and practice the use of decision-making frameworks and techniques applicable at all levels, from management-level strategic decisions such as connecting process to the needs of various customer segments, to front-line tactical decisions such as choosing between ordering larger quantities vs. ordering more frequently.

Jun 1st 2026
4 Weeks
Business Business Strategy Quality Management
Details
Introduction to Financial Accounting (Coursera) Coursera
University of Pennsylvania

Introduction to Financial Accounting (Coursera)

Management & Leadership Business

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.

Jun 1st 2026
4 Weeks
Finance Business Accounting
Details
Model Thinking (Coursera) Coursera
University of Michigan

Model Thinking (Coursera)

Economics & Finance Humanities

We live in a complex world with diverse people, firms, and governments whose behaviors aggregate to produce novel, unexpected phenomena. We see political uprisings, market crashes, and a never ending array of social trends. How do we make sense of it? Models. Evidence shows that people who think with models consistently outperform those who don't. And, moreover people who think with lots of models outperform people who use only one. Why do models make us better thinkers? Models help us to better organize information - to make sense of that fire hose or hairball of data (choose your metaphor) available on the Internet.

Jun 1st 2026
5-12 Weeks
Business Economics Models
Details