We may earn an affiliate commission when you visit our partners.

Usar Funciones de Fecha y Hora en Excel

Al final de este proyecto, podrás usar 15 funciones prácticas de fecha y hora en Excel y tendrás una mejor comprensión de su uso. Aprenderás tres cosas: el uso básico de la función, la fórmula básica de la función y la fórmula con combinaciones para usos alternativos. En este proyecto, te guiaré paso a paso, explicándote cada parte de la fórmula y cómo se logra el cálculo deseado.

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

What's inside

Syllabus

Visión general del proyecto

Al final de este proyecto serás capaz de utilizar 15 funciones de fecha y hora en Excel para aumentar tus habilidades. Utilizarás la versión gratuita de Microsoft Excel para la web.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Desarrolla 15 funciones prácticas de fecha y hora en Excel, mejorando tus habilidades de manejo de datos

Está diseñado para principiantes que buscan aprender los conceptos básicos de las funciones de fecha y hora en Excel

Proporciona una comprensión práctica de cómo usar estas funciones para cálculos y manipulaciones de datos relacionados con el tiempo

El curso es gratuito y accesible a través de Microsoft Excel para la web, lo que lo hace conveniente para los estudiantes

La guía paso a paso y las explicaciones claras hacen que el contenido sea fácil de entender

Save this course

Save Usar Funciones de Fecha y Hora en Excel to your list so you can find it easily later:

Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Usar Funciones de Fecha y Hora en Excel with these activities:

Revisar conceitos básicos de data e hora

Show steps

Refrescar seus conceitos básicos de data e hora fortalecerá sua compreensão das funções do Excel relacionadas a data e hora.

Show steps

Revise os conceitos de data e hora, como formatos, unidades e zonas horárias.
Pratique converter datas e horas entre diferentes formatos.

Explorar tutoriales sobre funciones de fecha y hora en Excel

Show steps

Seguir tutoriais guiados ajudará você a reforçar sua compreensão sobre as funções de data e hora do Excel e fornecerá exemplos práticos de seu uso.

Browse courses on Excel

Show steps

Pesquise tutoriais online sobre funções de data e hora do Excel.
Siga os tutoriais passo a passo e pratique usar as funções fornecidas.

Resolver exercícios de prática sobre funções de data e hora

Show steps

Resolver exercícios de prática permitirá que você aplique seu conhecimento sobre funções de data e hora e identifique quaisquer áreas que precise de melhorias.

Browse courses on Excel

Show steps

Encontre exercícios de prática online ou em livros didáticos.
Resolva os exercícios cuidadosamente e verifique suas respostas.
Revise as funções usadas e identifique os padrões nas soluções.

One other activity

Expand to see all activities and additional details

Show all four activities

Criar uma planilha de exemplo com funções de data e hora

Show steps

Criar uma planilha de exemplo o ajudará a consolidar seu conhecimento sobre as funções de data e hora, fornecendo uma referência prática que você pode revisitar no futuro.

Browse courses on Excel

Show steps

Abra uma nova pasta de trabalho do Excel.
Insira dados de data e hora em diferentes células.
Aplique várias funções de data e hora aos dados.
Formate as células para exibir os resultados corretamente.

Career center

Learners who complete Usar Funciones de Fecha y Hora en Excel will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts use skills in Excel to process large datasets, including extracting, cleaning, and analyzing data. By using the functions from this course, Data Analysts can streamline their workflow and complete projects more efficiently. This course would be especially helpful for Data Analysts who work with time-series data, as it can help them quickly generate reports and insights.

See salaries and explore the career path for Data Analyst

Financial Analyst

Financial Analysts use Excel for various tasks, including financial modeling, budgeting, and forecasting. The functions covered in this course can help Financial Analysts work more efficiently and improve the accuracy of their analyses. For example, they can use the DATE function to calculate future dates, the TIMEVALUE function to convert times into numbers, and the NETWORKDAYS function to calculate the number of business days between two dates.

See salaries and explore the career path for Financial Analyst

Business Analyst

Business Analysts use Excel to help businesses improve their operations and performance. They use functions in Excel to analyze data, identify trends, and forecast future results. This course can help Business Analysts develop the skills they need to be successful in their roles. For example, they can learn how to use the IF function to create conditional statements and the VLOOKUP function to look up data in a table.

See salaries and explore the career path for Business Analyst

Project Manager

Project Managers use Excel to plan and track projects. They use functions in Excel to create timelines, calculate budgets, and track progress. This course can help Project Managers develop the skills they need to be successful in their roles. For example, they can learn how to use the TODAY function to get the current date and the NETWORKDAYS function to calculate the number of business days between two dates.

See salaries and explore the career path for Project Manager

Operations Manager

Operations Managers use Excel to improve the efficiency and effectiveness of their operations. They use functions in Excel to analyze data, identify trends, and forecast future results. This course can help Operations Managers develop the skills they need to be successful in their roles. For example, they can learn how to use the COUNTIFS function to count the number of times a specific condition is met and the SUMIF function to sum the values in a range that meet a specific condition.

See salaries and explore the career path for Operations Manager

Marketing Manager

Marketing Managers use Excel to track campaign performance, analyze data, and forecast future results. This course can help Marketing Managers develop the skills they need to be successful in their roles. For example, they can learn how to use the AVERAGEIF function to calculate the average of a range of values that meet a specific condition and the MAXIF function to find the maximum value in a range that meets a specific condition.

See salaries and explore the career path for Marketing Manager

Sales Manager

Sales Managers use Excel to track sales performance, analyze data, and forecast future results. This course can help Sales Managers develop the skills they need to be successful in their roles. For example, they can learn how to use the SUMIFS function to sum the values in a range that meet multiple conditions and the RANK function to rank the values in a range.

See salaries and explore the career path for Sales Manager

Customer Service Manager

Customer Service Managers use Excel to track customer interactions, analyze data, and identify trends. This course can help Customer Service Managers develop the skills they need to be successful in their roles. For example, they can learn how to use the COUNTIF function to count the number of times a specific condition is met and the AVERAGEIFS function to calculate the average of a range of values that meet multiple conditions.

See salaries and explore the career path for Customer Service Manager

Human Resources Manager

Human Resources Managers use Excel to track employee data, analyze data, and identify trends. This course can help Human Resources Managers develop the skills they need to be successful in their roles. For example, they can learn how to use the VLOOKUP function to look up data in a table and the COUNTIFS function to count the number of times a specific condition is met.

See salaries and explore the career path for Human Resources Manager

Office Manager

Office Managers use Excel to manage budgets, track expenses, and order supplies. This course can help Office Managers develop the skills they need to be successful in their roles. For example, they can learn how to use the SUMIF function to sum the values in a range that meet a specific condition and the AVERAGEIF function to calculate the average of a range of values that meet a specific condition.

See salaries and explore the career path for Office Manager

Executive Assistant

Executive Assistants use Excel to manage calendars, schedule appointments, and prepare reports. This course can help Executive Assistants develop the skills they need to be successful in their roles. For example, they can learn how to use the DATE function to calculate future dates and the TIMEVALUE function to convert times into numbers.

See salaries and explore the career path for Executive Assistant

Data Entry Clerk

Data Entry Clerks use Excel to enter data into databases. This course can help Data Entry Clerks develop the skills they need to be successful in their roles. For example, they can learn how to use the VLOOKUP function to look up data in a table and the COUNTIF function to count the number of times a specific condition is met.

See salaries and explore the career path for Data Entry Clerk

Administrative Assistant

Administrative Assistants use Excel to perform a variety of tasks, such as preparing presentations, creating spreadsheets, and managing email. This course can help Administrative Assistants develop the skills they need to be successful in their roles. For example, they can learn how to use the SUMIF function to sum the values in a range that meet a specific condition and the AVERAGEIF function to calculate the average of a range of values that meet a specific condition.

See salaries and explore the career path for Administrative Assistant

Accountant

Accountants use Excel to track financial data, prepare financial statements, and perform audits. This course can help Accountants develop the skills they need to be successful in their roles. For example, they can learn how to use the SUMIF function to sum the values in a range that meet a specific condition and the AVERAGEIF function to calculate the average of a range of values that meet a specific condition.

See salaries and explore the career path for Accountant

Teacher

Teachers use Excel to create lesson plans, track student progress, and communicate with parents. This course may be useful for Teachers who want to learn how to use Excel more effectively in their classrooms. For example, they can learn how to use the COUNTIF function to count the number of times a specific condition is met and the AVERAGEIF function to calculate the average of a range of values that meet a specific condition.

See salaries and explore the career path for Teacher

Reading list

We've selected 11 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Usar Funciones de Fecha y Hora en Excel.

Excel 2019 Bible

Save

Comprehensive guide to using Excel 2019. It covers a wide range of topics, including formulas and functions, data analysis, and macros.

Usar Funciones de Fecha y Hora en Excel

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses