Competencias digitales de ofimática: Microsoft Excel from Coursera

Los continuos cambios tecnológicos, sobre todo en aquellos aspectos vinculados a las tecnologías de la información y la comunicación (TIC) hacen que las personas tengan la necesidad de actualizarse de forma continua para que sus conocimientos no queden obsoletos. En este contexto, para las empresas se convierte en algo imprescindible disponer de profesionales que tengan las competencias necesarias para ejercer con éxito las actividades que requieren en su lugar de trabajo.

El curso, basado en las experiencias previas y el syllabus de ECDL (European Computer Driving Licence), nace con la voluntad de facilitar:

- el desarrollo continuado de las personas en aquellas competencias vinculadas a las tecnologías de la información y la comunicación,

- la inserción laboral y la renovación de las competencias tecnológicas de los estudiantes y de los profesionales.

Los cursos que ofrecemos bajo el título general “Competencias digitales” están destinados a personas sin conocimientos de ofimática o a personas con unas competencias digitales básicas y que deseen mejorar sus conocimientos de ofimática para ser más eficientes en sus estudios o en su trabajo, o bien quieran aumentar sus perspectivas laborales.

En este curso, trabajaremos la aplicación Microsoft Excel (hoja de cálculo).

Si piensas inscribirte también en los cursos de Word y PowerPoint, puedes hacer la inscripción en el curso "Competencias Digitales 2: Herramientas de Ofimática (Microsoft Word, Excel y PowerPoint)" donde tendrás los contenidos de los tres cursos en uno solo y te ahorrarás tener que pagar el certificado de cada uno).

What's inside

Syllabus

PRESENTACIÓN Y DOCUMENTACIÓN

Los cursos de Competencias digitales están destinados a personas sin conocimientos de ofimática o a personas con unas competencias digitales básicas y que deseen mejorar sus conocimientos de ofimática para ser más eficientes en su trabajo.

En este curso, trabajaremos la aplicación ofimática Microsoft Excel (hoja de cálculo).

Antes de empezar a visualizar vídeos u otros contenidos, te recomendamos que hagas una parada en la siguiente sección (Información básica sobre el curso), en la que se te ofrece información importante sobre el curso y su funcionamiento.

¡Bienvenido/a!

IMPORTANTE: Si piensas inscribirte también en los cursos de Word y PowerPoint, puedes hacer la inscripción en el curso "Competencias digitales: Herramientas de Ofimática (Microsoft Word, Excel y PowerPoint)" donde tendrás los contenidos de los tres cursos en uno solo y te ahorrarás tener que pagar el certificado de cada uno).

MICROSOFT EXCEL (Uso de la aplicación y operaciones básicas)

Esta semana trabajaremos las nociones más básicas: uso de la aplicación, introducción de datos, selección, búsquedas, ordenación, ...

MICROSOFT EXCEL (Dar formato)

Esta semana trabajaremos los formatos: diferentes tipos de formatos numéricos, alineación, bordes, ...

MICROSOFT EXCEL (Cálculos)

Esta semana trabajaremos los cálculos: operaciones básicas y uso de funciones.

MICROSOFT EXCEL (Gráficos e Impresión)

Esta semana trabajaremos los gráficos y la impresión.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Diseñado para personas sin conocimientos en ofimática o profesionales con competencias básicas que desean mejorar sus habilidades para optimizar su rendimiento laboral o académico

Cuenta con un instructor reconocido, Miquel Mazuque Periz, con experiencia en el campo de las tecnologías de la información

Basado en el programa ECDL (European Computer Driving Licence), reconocido por su rigor en la formación digital

Incorpora Microsoft Excel, una herramienta ampliamente utilizada en entornos laborales y académicos

Estructura organizada en módulos semanales, abarcando aspectos fundamentales e intermedios de Microsoft Excel

Requiere acceso a una computadora e Internet, recursos que pueden ser limitados para algunos estudiantes

Career center

Learners who complete Competencias digitales de ofimática: Microsoft Excel will develop knowledge and skills that may be useful to these careers:

Data Scientist

Data Scientists use scientific methods and algorithms to extract insights from data. The Microsoft Excel course will provide you with a strong foundation in data management, analysis, and visualization. This knowledge will be crucial for building predictive models, discovering hidden patterns, and communicating your findings to drive informed decision-making.

See salaries and explore the career path for Data Scientist

Quantitative Analyst

Quantitative Analysts use mathematical and statistical models to analyze financial data and make investment recommendations. The Microsoft Excel course will provide you with a strong foundation in data analysis, modeling, and visualization, enabling you to excel in this role. By understanding and applying these techniques, you can contribute to making informed investment decisions and maximizing returns.

See salaries and explore the career path for Quantitative Analyst

Financial Analyst

Financial Analysts evaluate the financial performance of companies and make recommendations to clients. The Microsoft Excel course will equip you with the proficiency in financial modeling, budgeting, and data analysis essential for this role. By mastering these skills, you can build robust financial models, analyze financial data, and provide valuable insights to help businesses make informed decisions.

See salaries and explore the career path for Financial Analyst

Business Intelligence Analyst

Business Intelligence Analysts transform raw data into actionable insights. The Microsoft Excel course will empower you with the skills to collect, clean, analyze, and visualize data. By leveraging this knowledge, you can uncover trends, identify patterns, and communicate insights that drive decision-making, improve business performance, and stay ahead in the competitive market.

See salaries and explore the career path for Business Intelligence Analyst

Data Engineer

Data Engineers design, build, and maintain data pipelines. The Microsoft Excel course will provide you with a foundation in data management, data integration, and data quality. By mastering these skills, you can effectively manage large datasets, ensure data integrity, and support data-driven decision-making across various industries.

See salaries and explore the career path for Data Engineer

Market Research Analyst

Market Research Analysts conduct studies to understand market trends and consumer behavior. The Microsoft Excel course will provide you with the data analysis and visualization skills necessary to collect, analyze, and interpret data from various sources. By effectively communicating your findings, you can help businesses make informed decisions, develop effective marketing strategies, and stay ahead in the competitive market.

See salaries and explore the career path for Market Research Analyst

Statistician

Statisticians collect, analyze, interpret, and present data. The Microsoft Excel course will provide you with a comprehensive understanding of data analysis techniques and the ability to effectively manage and present statistical data. By mastering these skills, you will be able to support decision-making and draw meaningful conclusions from complex datasets.

See salaries and explore the career path for Statistician

Financial Planner

Financial Planners assist clients in managing their financial affairs. By completing the Microsoft Excel course, you will gain proficiency in financial analysis, budgeting, and data management—core skills for developing personalized financial plans, managing investments, and guiding clients toward achieving their financial goals.

See salaries and explore the career path for Financial Planner

Business Analyst

Business Analysts study the needs of their clients to improve their business processes. The Microsoft Excel course will enhance your ability to gather, analyze, and interpret data, identify areas for improvement, and create detailed reports. These skills are crucial for success as a Business Analyst, providing you with the necessary foundation to optimize business operations and drive positive change.

See salaries and explore the career path for Business Analyst

Operations Research Analyst

Operations Research Analysts use mathematical and analytical techniques to improve the efficiency and effectiveness of business operations. The Microsoft Excel course will provide you with the skills to analyze data, build models, and develop solutions to complex problems. This knowledge will be invaluable in optimizing processes, reducing costs, and enhancing the overall performance of businesses.

See salaries and explore the career path for Operations Research Analyst

Actuary

Actuaries assess the financial implications of future events. The Microsoft Excel course will provide you with a solid understanding of data analysis, probability, and statistical modeling. This knowledge will enable you to calculate risks, develop insurance policies, and make informed decisions under uncertainty, contributing to the stability and security of financial systems.

See salaries and explore the career path for Actuary

Risk Analyst

Risk Analysts identify, assess, and mitigate risks within organizations. The Microsoft Excel course will provide you with the skills to analyze data, identify patterns, and develop risk management strategies. These skills are vital for managing risks effectively, ensuring compliance, and protecting businesses from potential threats.

See salaries and explore the career path for Risk Analyst

Auditor

Auditors examine financial records to ensure accuracy and compliance. The Microsoft Excel course will provide you with the skills to organize and analyze data, facilitating your ability to detect anomalies, identify risks, and ensure financial integrity. By leveraging these skills, you can ensure the reliability of financial statements and contribute to the overall success of businesses.

See salaries and explore the career path for Auditor

Management Consultant

Management Consultants provide expertise and guidance to businesses to improve their performance. With the knowledge gained from the Microsoft Excel course, you can effectively analyze data, develop solutions, and communicate your findings to help businesses make better decisions. This course will provide you with the necessary skills to succeed in this dynamic and challenging role.

See salaries and explore the career path for Management Consultant

Data Analyst

Data Analysts sift through vast quantities of data to find trends and patterns, helping businesses understand their customers and make better decisions. With the skills in data management and analysis learned in this Microsoft Excel course, you will be able to effectively clean, organize, and analyze data, uncover hidden insights, and communicate your findings. This course is a valuable foundation for a career as a Data Analyst.

See salaries and explore the career path for Data Analyst