Advanced Excel 2016

Advanced Excel 2016

Goals

• The objective of this course is to learn how to use Excel 2016 at a more advanced level than usual.
• Create, use and manage tables in Excel.
• Import external data into a spreadsheet.
• Learn how to use and manage a pivot table.
• Use data analysis to find objectives.
• Acquire the knowledge to create automatic macros and first notions with the Visual Basic code editor.
• Learn the basics of programming, to be able to build more complex macros in Visual Basic.
• Learn the basic instructions for working with the different elements of a spreadsheet.
• Manage the different dialog boxes that can be generated in Excel with the Visual Basic application.
• Learn how to share and protect workbooks.
• Share workbooks in the cloud.

Advanced Excel 2016

What it prepares you for

To manage Excel at a level higher than that of the user.

Advanced Excel 2016

Who is it addressed to?

For those who work with Excel and want to expand their knowledge with more advanced tools.

Advanced Excel 2016

Methodology

The course methodology is based on 100% online learning, through the Aula_SMART virtual campus, an innovative and easy-to-use platform that will allow you to access all the course content and resources from any location and device. The course has a highly specialized teaching team, made up of education professionals with extensive experience and training in the analysis of teaching skills. They will accompany and guide you throughout the learning process, through personalized tutoring by phone, chat, email and even videoconference. The teaching method is completely multidisciplinary, as it combines different pedagogical approaches and strategies, such as:

- Theoretical content, where the fundamental concepts and principles of the analysis of teaching competencies will be presented, as well as the normative and reference frameworks that regulate them.
- Practical content, where theoretical knowledge will be applied to real or simulated cases of educational practice, using tools and methodologies to evaluate and develop teaching skills.
- Self-assessment activities, where teachers will reflect on their own teaching performance and on areas of strength and improvement, as well as on strategies to enhance them.
- Collaborative learning activities, where the exchange of experiences, opinions and proposals will be encouraged through forums.

In this way, the course methodology offers you dynamic, participatory training adapted to your needs and interests, which prepares you to be a competent and effective teacher, capable of adapting to the demands and challenges of today's education.