Universidad Austral
Excel aplicado a los negocios (Nivel Avanzado)
Universidad Austral

Excel aplicado a los negocios (Nivel Avanzado)

Jorge Lardizabal
Paola Serafini

Instructors: Jorge Lardizabal

204,134 already enrolled

Included with Coursera Plus

Gain insight into a topic and learn the fundamentals.
4.8

(2,871 reviews)

Intermediate level
Some related experience required
Flexible schedule
Approx. 24 hours
Learn at your own pace
97%
Most learners liked this course
Gain insight into a topic and learn the fundamentals.
4.8

(2,871 reviews)

Intermediate level
Some related experience required
Flexible schedule
Approx. 24 hours
Learn at your own pace
97%
Most learners liked this course

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

24 assignments

Taught in Spanish

See how employees at top companies are mastering in-demand skills

Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 9 modules in this course

Bienvenido al Módulo 1, en éste módulo conocerás los siguientes contenidos: 1. Ventanas. División de la pantalla. Opciones de recálculo 2. Validación de datos 3. Formatos condicionales 4. Protección de celdas. Proteger y desproteger hojas y libros

What's included

8 videos2 readings4 assignments

Bienvenido al Módulo 2, en éste módulo conocerás los siguientes contenidos: 1. Fórmulas de búsquedas avanzadas (BUSCARV, INDICE, COINCIDIR, DESREF) 2. Cálculos con matrices y vectores (MMULT y TRANSPONER) 3. Funciones lógicas y de error4. Funciones condicionales

What's included

6 videos1 reading4 assignments

Bienvenido al Módulo 3, en éste módulo conocerás los siguientes contenidos: 1. Creación. Selección de datos de entrada 2. Agregar campos calculados 3. Formatos de los datos y de tablas

What's included

5 videos1 reading3 assignments

Bienvenido al módulo 4, en este módulo conocerás los siguientes contenidos: 1. Importación de archivos de texto. 2. Vinculación con bases de datos (Access, SQL)

What's included

4 videos1 reading2 assignments

Bienvenido al módulo 5, en éste módulo conocerás los siguientes contenidos: 1. Buscar objetivo 2. Administración de escenarios 3. Tablas de simple y doble entrada

What's included

5 videos2 readings3 assignments

Bienvenido al módulo 6, en éste módulo conocerás los siguientes contenidos: 1. Preparación de los datos 2. Generación de archivos de texto

What's included

4 videos1 reading2 assignments

Bienvenido al módulo 7, en éste módulo conocerás los siguientes contenidos: 1. Uso de Solver: aplicaciones empresariales 2. Función objetivo, celdas a variar, restricciones 3. Definición de restricciones. Resultados

What's included

5 videos1 reading3 assignments

Bienvenidos al módulo 8, en éste módulo conocerás los siguientes contenidos: 1. ¿Qué es una macro? Configuración para el uso de macros. 2. Uso de la grabadora de macros 3. Ejemplos prácticos de aplicación

What's included

6 videos1 reading3 assignments

What's included

1 reading1 peer review1 discussion prompt

Instructors

Instructor ratings
4.7 (650 ratings)
Jorge Lardizabal
Universidad Austral
1 Course204,134 learners
Paola Serafini
Universidad Austral
1 Course204,134 learners

Offered by

Recommended if you're interested in Data Analysis

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

4.8

2,871 reviews

  • 5 stars

    80.88%

  • 4 stars

    16.46%

  • 3 stars

    2.05%

  • 2 stars

    0.34%

  • 1 star

    0.24%

Showing 3 of 2871

PO
5

Reviewed on Sep 21, 2020

LA
4

Reviewed on Jul 9, 2020

LA
4

Reviewed on Sep 13, 2020

New to Data Analysis? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions