Este curso forma parte de Programa Especializado - Habilidades de Excel aplicadas para los negocios

Nicky Bull +2 instructores más

ofrecido por

Programa Especializado - Habilidades de Excel aplicadas para los negociosUniversidad de Macquarie

Acerca de este Curso

1,127,551 vistas recientes

Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In the United States alone, millions of job advertisements requiring Excel skills are posted every day. Research by Burning Glass Technologies and Capital One shows that digitals skills lead to higher income and better employment opportunities at a time when digital skills job are growing much faster than non-digital jobs.
In this second course of our Excel specialization Excel Skills for Business you will build on the strong foundations of the Essentials course. Intermediate Skills I will expand your Excel knowledge to new horizons. You are going to discover a whole range of skills and techniques that will become a standard component of your everyday use of Excel. In this course, you will build a solid layer of more advanced skills so you can manage large datasets and create meaningful reports. These key techniques and tools will allow you to add a sophisticated layer of automation and efficiency to your everyday tasks in Excel.

Once again, we have brought together a great teaching team that will be with you every step of the way. Prashan and Nicky will guide you through each week (and I am even going to make a guest appearance in Week 5 to help you learn about my favourite tool in Excel - shh, no spoilers!). Work through each new challenge step-by-step and in no time you will surprise yourself by how far you have come. This time around, we are going to follow Uma's trials and tribulations as she is trying to find her feet in a new position in the fictitious company PushPin. For those of you who have done the Essentials course, you will already be familiar with the company. Working through her challenges which are all too common ones that we encounter everyday, will help you to more easily relate to the skills and techniques learned in each week and apply them to familiar and new contexts.

Resultados profesionales del estudiante

25%

comenzó una nueva carrera después de completar estos cursos

25%

consiguió un beneficio tangible en su carrera profesional gracias a este curso

Certificado para compartir

Obtén un certificado al finalizar

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Curso 2 de 4 en

Programa Especializado - Habilidades de Excel aplicadas para los negocios

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.

Nivel intermedio

Aprox. 30 horas para completar

Inglés (English)

Subtítulos: Árabe (Arabic), Francés (French), Portugués (europeo), Chino (simplificado), Italiano, Vietnamita, Coreano, Alemán (German), Ruso (Russian), Turco (Turkish), Inglés (English), Español (Spanish), Húngaro

Habilidades que obtendrás

ConcatenationMicrosoft ExcelConsolizationPivot TablePivot Chart

Resultados profesionales del estudiante

25%

comenzó una nueva carrera después de completar estos cursos

25%

consiguió un beneficio tangible en su carrera profesional gracias a este curso

Certificado para compartir

Obtén un certificado al finalizar

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Curso 2 de 4 en

Programa Especializado - Habilidades de Excel aplicadas para los negocios

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.

Nivel intermedio

Aprox. 30 horas para completar

Inglés (English)

Instructores

Calificación del instructor

4.89/5 (2,320 calificaciones)

ofrecido por

Universidad de Macquarie

Macquarie is ranked among the top one per cent of universities in the world, and with a 5-star QS rating, we are recognised for producing graduates who are among the most sought-after professionals in the world. Since our foundation 54 years ago, we have aspired to be a different type of university: one focused on fostering collaboration between students, academics, industry and society.

Programa - Qué aprenderás en este curso

Calificación del contenido97%(48,050 calificaciones)

Semana

Semana 1

6 horas para completar

Working with Multiple Worksheets & Workbooks

This module is all about working with multiple worksheets and workbooks. Learn how you can combine data, manage datasets and perform calculations across multiple sources. And don't forget the Toolbox with handy shortcuts and ninja tips.

6 horas para completar

8 videos (Total 37 minutos), 8 lecturas, 6 cuestionarios

8 videos

Week 1 Introduction2m

Week 1 Discussion4m

Practice Video: Multiple Worksheets6m

Practice Video: 3D Formulas5m

Practice Video: Linking Workbooks6m

Practice Video: Consolidating by Position5m

Practice Video: Consolidating by Category (Reference)3m

Week 1 Wrap-Up1m

8 lecturas

Welcome to Excel Skills for Business: Intermediate I10m

Course Goals and Weekly Learning Objectives10m

Read me before you start: Quizzes and Navigation10m

Download the Week 1 workbooks5m

Read me before you start: Versions and regions10m

Week 1: Practice Challenge30m

Week 1: Advanced Practice Challenge30m

Keyboard Shortcuts, Excel Terminology and Ninja Tips30m

6 ejercicios de práctica

Multiple Worksheets30m

3D Formulas30m

Linking Workbooks30m

Consolidating by Position30m

Consolidating by Category (Reference)30m

Test your Skills: Working with Multiple Worksheets & Workbooks30m

Semana

Semana 2

5 horas para completar

Text and Date Functions

By the end of this module, you will be an expert in Date and Text functions. This module discusses ways you can extract information and manipulate data to fulfil specific business requirements.

5 horas para completar

8 videos (Total 31 minutos), 3 lecturas, 6 cuestionarios

8 videos

Week 2 Introduction2m

Week 2 Discussion5m

Practice Video: Combining Text (CONCAT, &)4m

Practice Video: Changing Text Case (UPPER, LOWER, PROPER)4m

Practice Video: Extracting Text (LEFT, MID, RIGHT)3m

Practice Video: Finding Text (FIND)5m

Practice Video: Date Calculations (NOW, TODAY, YEARFRAC)3m

Week 2 Wrap-Up1m

3 lecturas

Download the Week 2 workbooks5m

Week 2: Practice Challenge30m

Keyboard Shortcuts, Excel Terminology and Ninja Tips30m

6 ejercicios de práctica

Combining Text (CONCAT, &)30m

Changing Text Case (UPPER, LOWER, PROPER)30m

Extracting Text (LEFT, MID, RIGHT)30m

Finding Text (FIND)30m

Date Calculations (NOW, TODAY, YEARFRAC)30m

Test your Skills: Text and Date Functions30m

Semana

Semana 3

4 horas para completar

Named Ranges

Learn how you can create, manage and apply Named Ranges to enhance your calculations.

4 horas para completar

8 videos (Total 31 minutos), 3 lecturas, 6 cuestionarios

8 videos

Week 3 Introduction2m

Week 3 Discussion2m

Practice Video: Introducing Named Ranges5m

Practice Video: Creating Named Ranges5m

Practice Video: Managing Named Ranges4m

Practice Video: Named Ranges in Formulas5m

Practice Video: Apply Names5m

Week 3 Wrap-Up1m

3 lecturas

Download the Week 3 workbooks5m

Week 3: Practice Challenge20m

Keyboard Shortcuts, Terminology and Ninja Tips10m

6 ejercicios de práctica

Introducing Named Ranges30m

Creating Named Ranges30m

Managing Named Ranges30m

Named Ranges in Formulas30m

Apply Names30m

Test your Skills: Named Ranges30m

Semana

Semana 4

5 horas para completar

Summarising Data

Graduate to advanced formulas in this module. Learn how you can use functions like COUNTIFS to extract information from data, as well as generate graphical representations of it.

5 horas para completar

9 videos (Total 37 minutos), 3 lecturas, 7 cuestionarios

9 videos

Week 4 Introduction2m

Week 4 Discussion3m

Practice Video: COUNT functions4m

Practice Video: Counting with Criteria (COUNTIFS)5m

Practice Video: Adding with Criteria (SUMIFS)6m

Practice Video: Sparklines4m

Practice Video: Advanced Charting5m

Practice Video: Trendlines4m

Week 4 Wrap-Up1m

3 lecturas

Download the Week 4 workbooks5m

Week 4: Practice Challenge20m

Keyboard Shortcuts, Excel Terminology and Ninja Tips30m

7 ejercicios de práctica

COUNT functions30m

Counting with Criteria (COUNTIFS)30m

Adding with Criteria (SUMIFS)30m

Sparklines30m

Advanced Charting30m

Trendlines30m

Test your Skills: Summarising Data30m

Semana

Semana 5

4 horas para completar

Tables

Tables, tables, tables. Start with creating, formatting and managing tables and then move on to sorting and filtering tables to get the data you need. Finally, wrap up this module automating your tables to make your work more efficient.

4 horas para completar

8 videos (Total 36 minutos), 3 lecturas, 6 cuestionarios

8 videos

Week 5 Introduction2m

Week 5 Discussion4m

Practice Video: Creating and Formatting Tables5m

Practice Video: Working with Tables5m

Practice Video: Sorting and Filtering in Tables6m

Practice Video: Automation with Tables5m

Practice Video: Converting to Range and Subtotaling5m

Week 5 Wrap-Up1m

3 lecturas

Download the Week 5 workbooks5m

Week 5: Practice Challenge20m

Keyboard Shortcuts, Excel Terminology and Ninja Tips10m

6 ejercicios de práctica

Creating and Formatting Tables30m

Working with Tables30m

Sorting and Filtering in Tables30m

Automation with Tables30m

Converting to Range and Subtotaling30m

Test your Skills: Tables30m

Semana

Semana 6

5 horas para completar

Pivot Tables, Charts and Slicers

This module deep dives into the popular (and very useful) pivot tables. Learn how you can create and modify them to solve a variety of business problems. Then gain skills to create interactive dashboards with pivot charts and slicers.

5 horas para completar

9 videos (Total 42 minutos), 3 lecturas, 7 cuestionarios

9 videos

Week 6 Introduction2m

Week 6 Discussion2m

Practice Video: Creating and Modifying a Pivot Table5m

Practice Video: Value Field Settings5m

Practice Video: Sorting and Filtering a Pivot Table5m

Practice Video: Reporting Filter Pages6m

Practice Video: Pivoting Charts5m

Practice Video: Pivoting Slicers6m

Week 6 Wrap-Up1m

3 lecturas

Download the Week 6 workbooks5m

Week 6: Practice Challenge20m

Keyboard Shortcuts, Excel Terminology and Ninja Tips10m

7 ejercicios de práctica

Creating and Modifying a Pivot Table30m

Value Field Settings30m

Sorting and Filtering a Pivot Table30m

Report Filter Pages30m

Pivoting Charts30m

Pivoting Slicers30m

Test your Skills: Pivot Tables, Charts and Slicers30m

1 hora para completar

Final Assessment

1 hora para completar

1 ejercicio de práctica

Final Assessment1h

Acerca de Programa especializado: Habilidades de Excel aplicadas para los negocios

This specialization is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In the United States alone, millions of job advertisements requiring Excel skills are posted every day. Research by Burning Glass Technologies and Capital One shows that digital skills lead to higher income and better employment opportunities. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this specialization will position you way ahead of others.

In this Specialization, learners develop advanced Excel Skills for Business. Upon completing the four courses in this Specialization, learners can design sophisticated spreadsheets, including professional dashboards, and perform complex calculations using advanced Excel features and techniques. Learners have acquired the skills to manage large datasets efficiently, extract meaningful information from datasets, present data and extract information effectively. In addition, learners have mastered the skills needed to validate data and prevent errors in spreadsheets, create automation, apply advanced formulas and conditional logic to help make decisions and create spreadsheets that help forecast and model data.

Habilidades de Excel aplicadas para los negocios

Preguntas Frecuentes

¿Cuándo podré acceder a las lecciones y tareas?
El acceso a las clases y las asignaciones depende del tipo de inscripción que tengas. Si tomas un curso en modo de oyente, verás la mayoría de los materiales del curso en forma gratuita. Para acceder a asignaciones calificadas y obtener un certificado, deberás comprar la experiencia de Certificado, ya sea durante o después de participar como oyente. Si no ves la opción de oyente:
es posible que el curso no ofrezca la opción de participar como oyente. En cambio, puedes intentar con una Prueba gratis o postularte para recibir ayuda económica.
Es posible que el curso ofrezca la opción 'Curso completo, sin certificado'. Esta opción te permite ver todos los materiales del curso, enviar las evaluaciones requeridas y obtener una calificación final. También significa que no podrás comprar una experiencia de Certificado.
¿Qué recibiré si me suscribo a este Programa especializado?
Cuando te inscribes en un curso, obtienes acceso a todos los cursos que forman parte del Programa especializado y te darán un Certificado cuando completes el trabajo. Se añadirá tu Certificado electrónico a la página Logros. Desde allí, puedes imprimir tu Certificado o añadirlo a tu perfil de LinkedIn. Si solo quieres leer y visualizar el contenido del curso, puedes auditar el curso sin costo.
Is financial aid available?
Sí, Coursera ofrece ayuda económica a los estudiantes que no pueden pagar la tarifa. Solicítala haciendo clic en el enlace de Ayuda económica que está debajo del botón “Inscribirse” a la izquierda. Se te pedirá que completes una solicitud. Recibirás una notificación en caso de que se apruebe. Deberás completar este paso para cada uno de los cursos que forman parte del Programa especializado, incluido el proyecto final. Obtén más información.
What version of Excel do you teach?
In this course, we are using Microsoft Excel 2016 (Office 365) on a Windows PC with all options set to default. The Office 365 version of Excel is the latest version at the time of writing and developing this course. If you have a different version of Excel or you are using a Mac, some tools and buttons will look different, they may be located in a different spot, or some might be missing altogether. If there are any major differences, we usually point them out during the practice videos. If you cannot find a tool that we mention, you can always ask in the forums or search the Internet. Most of the functionality we demonstrate is also available in other spreadsheet programs, although the interface will look different. Most other spreadsheet software can import and export files in the Microsoft Excel format. If you are not sure which version of Excel you are using, check the Microsoft support pages for help.
If you cannot use Excel 2016 on a PC, you will be able to follow along with the videos, however, please note that some of the assessment tasks will require Excel. Where possible, we have designed assessment tasks so that users of older versions of Excel (such as 2013) can still solve them.
¿Recibiré crédito universitario por completar el Curso?
Este Curso no otorga crédito universitario, pero algunas universidades pueden aceptar los Certificados del curso para obtener crédito. Consulta con tu institución para obtener más información. Los Títulos en línea y los Certificados Mastertrack™ de Coursera brindan la oportunidad de obtener créditos universitarios.

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

Excel Skills for Business: Intermediate I

Acerca de este Curso

Resultados profesionales del estudiante

25%

25%

Habilidades que obtendrás

Resultados profesionales del estudiante

25%

25%

Instructores

Nicky Bull

Dr Prashan S. M. Karunaratne

A/Professor Yvonne Breyer

ofrecido por

Universidad de Macquarie

Programa - Qué aprenderás en este curso

Semana 1

Working with Multiple Worksheets & Workbooks

Semana 2

Text and Date Functions

Semana 3

Named Ranges

Semana 4

Summarising Data

Semana 5

Tables

Semana 6

Pivot Tables, Charts and Slicers

Final Assessment

Reseñas

Principales reseñas sobre EXCEL SKILLS FOR BUSINESS: INTERMEDIATE I

Acerca de Programa especializado: Habilidades de Excel aplicadas para los negocios

Preguntas Frecuentes

Principales cursos en línea

Principales especializaciones en línea

Certificados en linea

Programas de titulación en línea

Coursera

Comunidad

Más

Excel Skills for Business: Intermediate I

Acerca de este Curso

Resultados profesionales del estudiante

25%

25%

Habilidades que obtendrás

Resultados profesionales del estudiante

25%

25%

Instructores

Nicky Bull

Dr Prashan S. M. Karunaratne

A/Professor Yvonne Breyer

ofrecido por

Universidad de Macquarie

Programa - Qué aprenderás en este curso

Semana 1

Working with Multiple Worksheets & Workbooks

Semana 2

Text and Date Functions

Semana 3

Named Ranges

Semana 4

Summarising Data

Semana 5

Tables

Semana 6

Pivot Tables, Charts and Slicers

Final Assessment

Reseñas

Principales reseñas sobre EXCEL SKILLS FOR BUSINESS: INTERMEDIATE I

Acerca de Programa especializado: Habilidades de Excel aplicadas para los negocios

Preguntas Frecuentes

Coursera Footer

Principales cursos en línea

Principales especializaciones en línea

Certificados en linea

Programas de titulación en línea

Coursera

Comunidad

Más