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

Finance for Everyone: Debt (Coursera) Coursera
McMaster University

Finance for Everyone: Debt (Coursera)

In Debt, we take on one of the most challenging financial questions that remains unresolved: How much to borrow? We start by demonstrating why using debt has always been and continues to be a great temptation, particularly when borrowing costs are historically low. We identify conditions for selecting the optimal amount of debt for a corporation looking to maximize its value. You’ll become fluent in related concepts like norms and benchmarks.

Oct 12th 2026
4 Weeks
Matrix Methods (Coursera) Coursera
University of Minnesota

Matrix Methods (Coursera)

Mathematical Matrix Methods lie at the root of most methods of machine learning and data analysis of tabular data. Learn the basics of Matrix Methods, including matrix-matrix multiplication, solving linear equations, orthogonality, and best least squares approximation. Discover the Singular Value Decomposition that plays a fundamental role in dimensionality reduction, Principal Component Analysis, and noise reduction.

Oct 12th 2026
5-12 Weeks
Behavioral Finance (Coursera) Coursera
Duke University

Behavioral Finance (Coursera)

We make thousands of decisions every day. Do I cross the road now, or wait for the oncoming truck to pass? Should I eat fries or a salad for lunch? How much should I tip the cab driver? We usually make these decisions with almost no thought, using what psychologists call “heuristics” – rules of thumb that enable us to navigate our lives. Without these mental shortcuts, we would be paralyzed by the multitude of daily choices.

Oct 12th 2026
3 Weeks
Costos para los Negocios (Coursera) Coursera
Universidad de Chile

Costos para los Negocios (Coursera)

Al completar el curso, los participantes podrán: a) Analizar los elementos, las estructuras, los métodos y los sistemas de costeo propios de una empresa, utilizando diversas herramientas, para identificar los posibles tipos de cálculos a generar. b) Calcular costos, utilizando diversos procedimientos acordes a los tipos de objetos de costos, estructuras, procesos y sistemas, con el propósito de obtener información relevante para la empresa que permitan una adecuada toma de decisiones. c) Elaborar e interpretar informes de costeos de objetos del costo, basándose en la información recabada y los datos obtenidos, con la finalidad de proponer diversas recomendaciones que permitan efectivas toma de decisiones.

Oct 12th 2026
5-12 Weeks
How to Validate your Startup Idea (Coursera) Coursera
UNSW Sydney - University of New South Wales

How to Validate your Startup Idea (Coursera)

Starting a new business begins with an idea that needs to evolve through experimentation, iteration and interactions with people. This course is for existing and potential entrepreneurs who are looking for guidance and support to make their ‘great idea’ a reality. In addition to reviewing the basic principles of entrepreneurship, this course guides you through the process of actively validating your idea in the market.

Oct 12th 2026
5-12 Weeks
Mathematical Biostatistics Boot Camp 1 (Coursera) Coursera
Johns Hopkins University

Mathematical Biostatistics Boot Camp 1 (Coursera)

This class presents the fundamental probability and statistical concepts used in elementary data analysis. It will be taught at an introductory level for students with junior or senior college-level mathematical training including a working knowledge of calculus. A small amount of linear algebra and programming are useful for the class, but not required.

Oct 12th 2026
4 Weeks
Principles of fMRI 1 (Coursera) Coursera
Johns Hopkins University

Principles of fMRI 1 (Coursera)

Functional Magnetic Resonance Imaging (fMRI) is the most widely used technique for investigating the living, functioning human brain as people perform tasks and experience mental states. It is a convergence point for multidisciplinary work from many disciplines. Psychologists, statisticians, physicists, computer scientists, neuroscientists, medical researchers, behavioral scientists, engineers, public health researchers, biologists, and others are coming together to advance our understanding of the human mind and brain. This course covers the design, acquisition, and analysis of Functional Magnetic Resonance Imaging (fMRI) data, including psychological inference, MR Physics, K Space, experimental design, pre-processing of fMRI data, as well as Generalized Linear Models (GLM’s).

Oct 12th 2026
4 Weeks
Investment Management in an Evolving and Volatile World by HEC Paris and AXA Investment Managers (Coursera) Coursera
HEC Paris

Investment Management in an Evolving and Volatile World by HEC Paris and AXA Investment Managers (Coursera)

Have you ever wanted to invest in financial markets, but were always afraid that you didn’t have the proper tools or knowledge to make informed decisions? Have you ever wondered how investment management companies operate and what fund managers do? AXA Investment Managers, in partnership with HEC Paris, will introduce you to the most important ideas and concepts in investment management, to help you better understand your financial future.

Oct 12th 2026
4 Weeks
Sustainable Vikings: Sustainability & Corporate Social Responsibility in Scandinavia (Coursera) Coursera
Copenhagen Business School

Sustainable Vikings: Sustainability & Corporate Social Responsibility in Scandinavia (Coursera)

This course gives you immediate access to the world leading sustainability and corporate social responsibility (CSR) practices. Scandinavian firms dominate the major sustainability and CSR performance indicators including the Dow Jones Sustainability Index (DJSI). In this course we explore the concepts of sustainability and CSR and focus attention on how Scandinavian firms, like Novo Nordisk, have achieved superior sustainability and CSR performances.

Oct 12th 2026
5-12 Weeks
Negocios Internacionales I (Coursera) Coursera
University of New Mexico

Negocios Internacionales I (Coursera)

Vivimos en un mundo cada vez mas globalizado, en el cual el éxito en los negocios internacionales se ha convertido en el factor determinante del desarrollo económico y la prosperidad. Esta materia, Entorno Global de Negocios, Parte I, introduce al alumno a una comprensión fundamental del entorno político, cultural, lingüística y socio-económico en el cual opera una empresa internacional.

Oct 12th 2026
5-12 Weeks
Identifying Social Entrepreneurship Opportunities (Coursera) Coursera
Copenhagen Business School

Identifying Social Entrepreneurship Opportunities (Coursera)

This Course will clarify the definition and meaning of Social Entrepreneurship and will focus on the need to learn about the source and root of a social problem. You will be introduced to different perspectives about Social Entrepreneurship and you will learn about complementary and opportunistic assets which will help you to detect an opportunity and develop an idea of how to create a business for social change.

Oct 12th 2026
5-12 Weeks
International Business I (Coursera) Coursera
University of New Mexico

International Business I (Coursera)

We live in a world of intensifying global relationships, one in which international business has become the key determinant of economic development and prosperity. This course, Global Business Environment, Part I, introduces students to a fundamental understanding of the socioeconomic political, cultural, and linguistic environment in which international businesses operate.

Oct 12th 2026
5-12 Weeks