Excel Skills for Business: Essentials

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

4.9
estrellas
35,109 calificaciones

98 %

Nicky Bull +2 instructores más

556,514 ya inscrito

ofrecido por

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

Acerca de este Curso

2,154,465 vistas recientes

In this first course of the specialization Excel Skills for Business, you will learn the essentials of Microsoft Excel. Within six weeks, you will be able to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs.
Whether you are self-taught and want to fill in the gaps for better efficiency and productivity, or whether you have never used Excel before, this course will set you up with a solid foundation to become a confident user and develop more advanced skills in later courses. 

The best way to learn Excel is to use Excel. In this course, learners will solve a broad range of business problems as they apply the Excel skills and techniques they learn along the way. This course uses downloadable Excel workbooks and full data sets with applied examples and practical challenge exercises. This provides learners with countless opportunities to practice their Excel skills while discovering new and useful productivity features of Excel for a variety of business contexts.

Spreadsheet software is 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. At a time when digital skills jobs are growing much faster than non-digital jobs, make sure to position yourself ahead of the rest by adding Excel skills to your employment portfolio.

Resultados profesionales del estudiante

22%

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

22%

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

11%

consiguió un aumento de sueldo o ascenso

Certificado para compartir

Obtén un certificado al finalizar

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Curso 1 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 principiante

This Course is appropriate for anyone who is interested in learning about Microsoft Excel. You do not need previous experience with Excel.

Aprox. 26 horas para completar

Inglés (English)

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

Habilidades que obtendrás

GraphsSpreadsheetMicrosoft ExcelChart

Resultados profesionales del estudiante

22%

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

22%

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

11%

consiguió un aumento de sueldo o ascenso

Certificado para compartir

Obtén un certificado al finalizar

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Curso 1 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 principiante

This Course is appropriate for anyone who is interested in learning about Microsoft Excel. You do not need previous experience with Excel.

Aprox. 26 horas para completar

Inglés (English)

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

Instructores

Calificación del instructor

4.88/5 (11,389 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 contenido98%(186,894 calificaciones)

Semana

Semana 1

6 horas para completar

Critical Core of Excel

In this module, you will learn about key foundational features of Excel: The Excel user interface, basic Excel terminology, how to operate essential navigational controls in Excel and how to perform basic data entry with Excel spreadsheets.

6 horas para completar

10 videos (Total 46 minutos), 8 lecturas, 8 cuestionarios

10 videos

Week 1 Introduction2m

Week 1 Discussion3m

Practice Video: Taking Charge of Excel7m

Practice Video: Navigating and Selecting5m

Practice Video: View Options5m

Practice Video: Data Entry, Data Types, Editing and Deleting6m

Practice Video: Fill Handle5m

Week 1 Wrap-up1m

Copy and Paste5m

Templates2m

8 lecturas

Welcome to Excel Skills for Business: Essentials20m

Course goals and weekly learning objectives10m

Important information about versions and regions10m

Read me before you start: Quizzes and Navigation10m

Download the Week 1 workbooks5m

Week 1: Practice Challenge20m

Week 1: Keyboard Shortcuts, Terminology, and Ninja Tips25m

Week 1: Excellent Tips and Resources25m

8 ejercicios de práctica

Are essential skills too basic for me?10m

Taking Charge of Excel10m

Navigating and Selecting10m

View Options10m

Data Entry10m

Fill handle30m

Taking Charge of Excel: Test your skills, Part 130m

Taking Charge of Excel: Test your skills, Part 230m

Semana

Semana 2

4 horas para completar

Performing calculations

The syntax of formulas is very important in Excel. In this module, you will get introduced to formulas and functions - learn how to write them, use them to perform calculations and understand the different cell references.

4 horas para completar

11 videos (Total 44 minutos), 5 lecturas, 7 cuestionarios

11 videos

Week 2 Introduction2m

Week 2 Discussion4m

Practice Video: Formulas3m

Practice Video: Formulas in Context4m

Practice Video: Functions I: SUM and AUTOSUM4m

Practice Video: Functions II: AVERAGE, MIN and MAX4m

Discussion: Absolute Cell References4m

Practice Video: Absolute Cell References3m

Practice Video: Calculations across sheets4m

Week 2 Wrap-up1m

Excel Options6m

5 lecturas

Download the Week 2 workbooks5m

Week 2: Practice Challenges1h

Word Search Puzzle: Master ranges15m

Week 2: Keyboard Shortcuts, Terminology, and Ninja Tips25m

Week 2: Excellent Tips and Resources20m

7 ejercicios de práctica

Formulas6m

Formulas in Context30m

Functions I6m

Functions II6m

Absolute Cell References6m

Calculations across Sheets6m

Performing Calculations: Test your skills30m

Semana

Semana 3

3 horas para completar

Formatting

Formatting helps to highlight key messages and make the data presentable. This module covers several formatting tools like font formatting, borders, alignment, number formatting, as well as the Excel styles and themes.

3 horas para completar

10 videos (Total 40 minutos), 4 lecturas, 7 cuestionarios

10 videos

Week 3 Introduction2m

Week 3 Discussion3m

Practice Video: Formatting3m

Practice Video: Borders3m

Practice Video: Alignment Tools4m

Practice Video: Format Painter3m

Practice Video: Number Formats5m

Practice Video: Styles and Themes5m

Week 3 Wrap-up1m

Graphics6m

4 lecturas

Download the Week 3 workbooks5m

Week 3: Practice Challenge30m

Week 3: Keyboard Shortcuts and Ninja Tips10m

Week 3: Excellent Tips and Resources15m

7 ejercicios de práctica

Formatting8m

Borders8m

Alignment Tools8m

Format Painter12m

Number Formats8m

Styles and Themes5m

Formatting: Test your skills30m

Semana

Semana 4

3 horas para completar

Working with Data

This module is all about working with data – and making it easy to work with. This week you will learn how you can manage your spreadsheets – find data with Filter and Sort, retrieve and change data using Find and Replace, and use Conditional Formatting to highlight specific data.

3 horas para completar

9 videos (Total 35 minutos), 3 lecturas, 6 cuestionarios

9 videos

Week 4 Introduction1m

Week 4 Discussion3m

Practice Video: Managing Rows and Columns4m

Practice Video: Find and Replace3m

Practice Video: Filtering6m

Practice Video: Sorting3m

Practice Video: Conditional Formatting5m

Week 4 Wrap-up1m

Accessibility5m

3 lecturas

Download the Week 4 workbooks5m

Week 4: Practice Challenge30m

Week 4: Keyboard Shortcuts, Terminology, and Ninja Tips25m

6 ejercicios de práctica

Managing Rows and Columns10m

Find and Replace8m

Filtering30m

Sorting10m

Conditional Formatting15m

Working with Data: Test your skills30m

Reseñas

4.9

9558 reseña

5 stars
88.70%
4 stars
10.30%
3 stars
0.69%
2 stars
0.12%
1 star
0.18%

Principales reseñas sobre EXCEL SKILLS FOR BUSINESS: ESSENTIALS

por RB28 de ago. de 2019

The course was defiantly more than I expected. It not only strengthened what I did know about Excel but it showed me several options that I was not using or haven't found. I would highly recommend it.

por DT8 de feb. de 2021

Really well done! You kept me interested and motivated, and that's not easy to do! I enjoyed the balance of instructional videos and hands-on exercises, and I'm excited to try the Intermediate now.

por VJ10 de nov. de 2020

With this course you learn how to use Excel in your daily life. I recommend it to everyone that starts using excel and the ones that want to become better in understanding how it works and be quicker.

por KS29 de jun. de 2020

This is an amazing course for learners. I am having a lot of fun completing this course from the starting point. It is very much enjoyable and the way the course teachers deliver every lecture superb.

Ver todas las reseñas

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.

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

Excel Skills for Business: Essentials

Acerca de este Curso

Resultados profesionales del estudiante

22%

22%

11%

Habilidades que obtendrás

Resultados profesionales del estudiante

22%

22%

11%

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

Critical Core of Excel

Semana 2

Performing calculations

Semana 3

Formatting

Semana 4

Working with Data

Semana 5

Printing

Semana 6

Charts

Final Assessment

Reseñas

Principales reseñas sobre EXCEL SKILLS FOR BUSINESS: ESSENTIALS

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