Acerca de este Curso

257,236 vistas recientes
Certificado para compartir
Obtén un certificado al finalizar
100 % en línea
Comienza de inmediato y aprende a tu propio ritmo.
Fechas límite flexibles
Restablece las fechas límite en función de tus horarios.
Nivel intermedio
Aprox. 15 horas para completar
Inglés (English)

Qué aprenderás

  • Use Excel tools and functions to clean and prepare data for analysis.

  • Use Named Ranges and Tables to automate your analysis.

  • Understand the different types of data in Excel and use appropriate functions to work with them.

  • Use logical and lookup functions to transform, link and categorise data.

Habilidades que obtendrás

Data AnalysisMicrosoft ExcelData Cleansing
Certificado para compartir
Obtén un certificado al finalizar
100 % en línea
Comienza de inmediato y aprende a tu propio ritmo.
Fechas límite flexibles
Restablece las fechas límite en función de tus horarios.
Nivel intermedio
Aprox. 15 horas para completar
Inglés (English)

ofrecido por

Placeholder

Universidad de Macquarie

Programa - Qué aprenderás en este curso

Calificación del contenidoThumbs Up97%(2,478 calificaciones)Info
Semana
1

Semana 1

1 hora para completar

Welcome and critical information

1 hora para completar
1 video (Total 3 minutos), 3 lecturas
1 video
3 lecturas
Welcome to Excel Fundamentals for Data Analysis15m
Course goals and weekly learning objectives10m
Important information about versions and regions10m
3 horas para completar

Cleaning and manipulating text

3 horas para completar
6 videos (Total 30 minutos), 4 lecturas, 6 cuestionarios
6 videos
Excel functions for combining text values6m
Functions that split text data3m
Combining text functions6m
Cleaning data and changing case4m
Removing and replacing text characters4m
4 lecturas
Read me before you start: Quizzes and Navigation10m
Download the Week 1 workbooks5m
Week 1 Practice Challenge20m
Week 1 Toolbox10m
6 ejercicios de práctica
Excel functions for combining text values10m
Functions that split text data10m
Combining text functions10m
Cleaning data and changing case10m
Removing and replacing text characters10m
Cleaning and manipulating text: Test your skills30m
Semana
2

Semana 2

3 horas para completar

Working with numbers and dates

3 horas para completar
6 videos (Total 37 minutos), 3 lecturas, 6 cuestionarios
6 videos
Converting Data with VALUE and TEXT6m
Understanding dates and basic date functions7m
Generating Valid Dates using the DATE function6m
Calculations with Dates and using DAYS, NETWORKDAYS and WORKDAY8m
More sophisticated date calculations with EOMONTH and EDATE5m
3 lecturas
Download the Week 2 workbooks10m
Week 2 Practice Challenge20m
Week 2 Toolbox10m
6 ejercicios de práctica
Converting Data with VALUE and TEXT10m
Understanding dates and basic date functions10m
Generating Valid Dates using the DATE function10m
Calculations with Dates and using DAYS, NETWORKDAYS and WORKDAY10m
More sophisticated date calculations with EOMONTH and EDATE10m
Working with numbers and dates: Test your skills30m
Semana
3

Semana 3

3 horas para completar

Defined Names for working more effectively with data

3 horas para completar
6 videos (Total 36 minutos), 3 lecturas, 6 cuestionarios
6 videos
Cell Referencing and Naming6m
Defined Names and Create from Selection4m
Managing Names5m
Calculations with Named Ranges6m
Automating Data Validation with Named Ranges6m
3 lecturas
Download the Week 3 workbooks10m
Week 3 Practice Challenge20m
Week 3 Toolbox10m
6 ejercicios de práctica
Cell Referencing and Naming10m
Defined Names and Create from Selection10m
Managing Names10m
Calculations with Named Ranges10m
Automating Data Validation with Named Ranges10m
Defined Names for working more effectively with data: Test your skills30m
Semana
4

Semana 4

3 horas para completar

Tables for automating data manipulation

3 horas para completar
6 videos (Total 42 minutos), 3 lecturas, 6 cuestionarios
6 videos
Introduction to Tables6m
Customising Tables 5m
Sorting and Filtering Tables8m
Table Calculations and Structured References9m
Automation with Tables7m
3 lecturas
Download the Week 4 workbooks10m
Week 4 Practice Challenge20m
Week 4 Toolbox10m
6 ejercicios de práctica
Introduction to Tables10m
Customising Tables10m
Sorting and Filtering Tables10m
Table Calculations and Structured References10m
Automation with Tables10m
Tables for automating data manipulation: Test your skills30m

Reseñas

Principales reseñas sobre EXCEL FUNDAMENTALS FOR DATA ANALYSIS

Ver todas las reseñas

Preguntas Frecuentes

¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.