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

International Business II (Coursera) Coursera
University of New Mexico

International Business II (Coursera)

This course, Introduction to the Global Business Environment II, focuses on managing organizations in the international economy. Building on Introduction to the Global Business Environment I, this second course focuses on organizational level and management issues in international settings. The course prepares students with practical as well as research-based knowledge and skills necessary to successfully operating an organizational across borders.

Nov 16th 2026
5-12 Weeks
Leading Innovation in Arts and Culture (Coursera) Coursera
Vanderbilt University,National Arts Strategies - NAS

Leading Innovation in Arts and Culture (Coursera)

Developed by David Owens at Vanderbilt University and customized for the cultural sector with National Arts Strategies, this course will help arts and culture leaders create an environment where new ideas are constantly created, shared, evaluated and the best ones are successfully put to work. One of the toughest challenges for any leader is getting traction for new ideas. Winning support can be a struggle. As a result, powerful new ideas often get stuck. This is especially true in the cultural sector. People involved in arts and culture often have little time and even less money for experimentation and risks. This course will help those in the performing arts, museums, zoos, libraries and other cultural organizations build environments where new management and program ideas flourish.

Nov 16th 2026
5-12 Weeks
Introduction to Learning Transfer and Life Long Learning (3L) (Coursera) Coursera
University of California, Irvine

Introduction to Learning Transfer and Life Long Learning (3L) (Coursera)

Learn how to identify the enablers and barriers to learning transfer. Use your own experience to categorise the processes and activities involved in learning and transferring that learning into practice. There are many criteria against which the success of training and development activities can be judged.

Nov 16th 2026
3 Weeks
Data Processing Using Python (Coursera) Coursera
Nanjing University

Data Processing Using Python (Coursera)

This course is mainly for non-computer majors. It starts with the basic syntax of Python, to how to acquire data in Python locally and from network, to how to present data, then to how to conduct basic and advanced statistic analysis and visualization of data, and finally to how to design a simple GUI to present and process data, advancing level by level.

Nov 23rd 2026
5-12 Weeks
Combining and Analyzing Complex Data (Coursera) Coursera
University of Maryland, College Park

Combining and Analyzing Complex Data (Coursera)

In this course you will learn how to use survey weights to estimate descriptive statistics, like means and totals, and more complicated quantities like model parameters for linear and logistic regressions. Software capabilities will be covered with R® receiving particular emphasis. The course will also cover the basics of record linkage and statistical matching—both of which are becoming more important as ways of combining data from different sources. Combining of datasets raises ethical issues which the course reviews. Informed consent may have to be obtained from persons to allow their data to be linked. You will learn about differences in the legal requirements in different countries.

Nov 16th 2026
4 Weeks
Data Science Ethics (Coursera) Coursera
University of Michigan

Data Science Ethics (Coursera)

What are the ethical considerations regarding the privacy and control of consumer information and big data, especially in the aftermath of recent large-scale data breaches? This course provides a framework to analyze these concerns as you examine the ethical and privacy implications of collecting and managing big data. Explore the broader impact of the data science field on modern society and the principles of fairness, accountability and transparency as you gain a deeper understanding of the importance of a shared set of ethical values.

Nov 16th 2026
4 Weeks
L'avenir de la décision : connaître et agir en complexité (Coursera) Coursera
ESSEC Business School

L'avenir de la décision : connaître et agir en complexité (Coursera)

Ce MOOC a l’intention d’affronter et traiter des problèmes que rencontrent chaque personne, chaque groupe, chaque entreprise, chaque société, de façon de plus en plus aiguë et pressante ; dans notre temps d’évolution accélérée, de transformations ininterrompues, de mondialisation incontrôlée, d’incertitudes.

Nov 16th 2026
5-12 Weeks
Statistical Thinking for Industrial Problem Solving, presented by JMP (Coursera) Coursera
SAS

Statistical Thinking for Industrial Problem Solving, presented by JMP (Coursera)

Statistical Thinking for Industrial Problem Solving is an applied statistics course for scientists and engineers offered by JMP, a division of SAS. By completing this course, students will understand the importance of statistical thinking, and will be able to use data and basic statistical methods to solve many real-world problems.

Nov 16th 2026
5-12 Weeks
A Scientific Approach to Innovation Management (Coursera) Coursera
Università Bocconi

A Scientific Approach to Innovation Management (Coursera)

How can innovators understand if their idea is worth developing and pursuing? In this course, we lay out a systematic process to make strategic decisions about innovative product or services that will help entrepreneurs, managers and innovators to avoid common pitfalls. We teach students to assess the feasibility of an innovative idea through problem-framing techniques and rigorous data analysis labelled ‘a scientific approach’.

Nov 16th 2026
5-12 Weeks
European Business Law: Doing Business in Europe (Coursera) Coursera
Lund University

European Business Law: Doing Business in Europe (Coursera)

This six-week course titled Doing Business in Europe is the second in a series of three exploring some of the main business aspects of European Union law. Besides providing learners with a sound knowledge base of European laws and regulations relevant to establishing and managing a company within the European Union, the course also explores business considerations within a broader perspective by including inputs from leading law practitioners in the field.

Nov 16th 2026
5-12 Weeks
Managing Responsibly: Practicing Sustainability, Responsibility and Ethics (Coursera) Coursera
University of Manchester

Managing Responsibly: Practicing Sustainability, Responsibility and Ethics (Coursera)

Managers are increasingly confronted with issues of sustainability, responsibility and ethics. Managing responsibly is an integrative approach to sustainability, responsibility and ethics, which allows you as a manager to deal competently with such challenges. This course will facilitate your learning process to engage in changing practices to make them more sustainable, responsible, and ethically informed.

Nov 16th 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.

Nov 16th 2026
4 Weeks