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

Driving business towards the Sustainable Development Goals (Coursera) Coursera
Erasmus University Rotterdam

Driving business towards the Sustainable Development Goals (Coursera)

Extreme weather events, wars, famine and environmental destruction are just a few of the wicked problems faced by humanity. That’s why in 2015 the United Nations adopted the 2030 Agenda for Sustainable Development. This agenda includes 17 Sustainable Development Goals (SDGs) that target the big challenges such as how to eliminate poverty, how to protect the environment and how to bring about peace. Every member state committed to achieving these goals by 2030. What can businesses do to counter climate change and create a sustainable business culture? Why is this relevant for business anyway? Explore how business can contribute to a better future for people AND the planet without giving up profits.

Nov 16th 2026
5-12 Weeks
Corporate & Commercial Law II: Business Forms, Financing & Governmental Regulation (Coursera) Coursera
University of Illinois at Urbana-Champaign

Corporate & Commercial Law II: Business Forms, Financing & Governmental Regulation (Coursera)

This course is the second course in a two-part series on corporate and commercial law. In this part, we focus on three main topics: business organizations, business financing, and governmental regulation. In the first module, we discuss the characteristics of a number of the most common forms of business entities, such as corporations and LLCs.

Nov 16th 2026
4 Weeks
Bayesian Statistics: Mixture Models (Coursera) Coursera
University of California, Santa Cruz

Bayesian Statistics: Mixture Models (Coursera)

Bayesian Statistics: Mixture Models introduces you to an important class of statistical models. The course is organized in five modules, each of which contains lecture videos, short quizzes, background reading, discussion prompts, and one or more peer-reviewed assignments. Statistics is best learned by doing it, not just watching a video, so the course is structured to help you learn through application.

Nov 16th 2026
5-12 Weeks
An Introduction to Consumer Neuroscience & Neuromarketing (Coursera) Coursera
Copenhagen Business School

An Introduction to Consumer Neuroscience & Neuromarketing (Coursera)

How do we make decisions as consumers? What do we pay attention to, and how do our initial responses predict our final choices? To what extent are these processes unconscious and cannot be reflected in overt reports? This course will provide you with an introduction to some of the most basic methods in the emerging fields of consumer neuroscience and neuromarketing. You will learn about the methods employed and what they mean. You will learn about the basic brain mechanisms in consumer choice, and how to stay updated on these topics. The course will give an overview of the current and future uses of neuroscience in business.

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
Process Mining: Data science in Action (Coursera) Coursera
Eindhoven University of Technology

Process Mining: Data science in Action (Coursera)

Process mining is the missing link between model-based process analysis and data-oriented analysis techniques. Through concrete data sets and easy to use software the course provides data science knowledge that can be applied directly to analyze and improve processes in a variety of domains. Data science is the profession of the future, because organizations that are unable to use (big) data in a smart way will not survive. It is not sufficient to focus on data storage and data analysis. The data scientist also needs to relate data to process analysis.

Nov 16th 2026
5-12 Weeks
Data Processing with Azure (Coursera) Coursera
LearnQuest

Data Processing with Azure (Coursera)

This Azure training course is designed to equip students with the knowledge need to process, store and analyze data for making informed business decisions. Through this Azure course, the student will understand what big data is along with the importance of big data analytics, which will improve the students mathematical and programming skills. Students will learn the most effective method of using essential analytical tools such as Python, R, and Apache Spark.

Nov 16th 2026
3 Weeks
Negocios Internacionales II (Coursera) Coursera
University of New Mexico

Negocios Internacionales II (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 II, sigue a la primera materia (Entorno Global de Negocios, Parte I) e introduce al alumno a una comprensión fundamental de como administrar una organización o empresa internacional.

Nov 16th 2026
5-12 Weeks
Interest Rate Models (Coursera) Coursera
École Polytechnique Fédérale de Lausanne

Interest Rate Models (Coursera)

This course gives you an easy introduction to interest rates and related contracts. These include the LIBOR, bonds, forward rate agreements, swaps, interest rate futures, caps, floors, and swaptions. We will learn how to apply the basic tools duration and convexity for managing the interest rate risk of a bond portfolio. We will gain practice in estimating the term structure from market data. We will learn the basic facts from stochastic calculus that will enable you to engineer a large variety of stochastic interest rate models. In this context, we will also review the arbitrage pricing theorem that provides the foundation for pricing financial derivatives.

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