Excel advanced 2016

Excel advanced 2016

Goals

• The objective of this course is to learn to handle Excel 2016 at a more advanced level of the usual.
• Create, use and handle Tables in Excel.
• Import external data to a spreadsheet.
• Learn the use and management of a dynamic table.
• Use data analysis to find objectives.
• Acquire knowledge to create automatic macros and first notions with the Basic Visual Code editor.
• Learn the basic notions of programming, to be able to build more complex macros in Visual Basic.
• Learn the basic instructions to work with the different elements of a spreadsheet.
• Manage the different dialog boxes that can be generated in Excel with the BASIC visual application.
• Learn to share and protect workbooks.
• Share work books in the cloud.

Excel advanced 2016

What prepares you

To handle Excel at a higher level than the user.

Excel advanced 2016

Who is it addressed

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

Excel advanced 2016

Methodology

The course methodology is based on 100%online learning, through the Aula_Smart virtual campus, an innovative and easy -to -use platform, which will allow you to access all the contents and resources of the course from anywhere and device. The course has a highly specialized teaching team, formed by education professionals with extensive experience and training in the analysis of teaching skills. They will accompany you and guide you throughout the learning process, through personalized tutorials, chat, email and even videoconference. The teaching method is totally multidisciplinary, since it combines different pedagogical approaches and strategies, such as:

- Theoretical contents, where the fundamental concepts and principles of the analysis of the teaching skills will be presented, as well as the normative and reference frameworks that regulate them.
- Practical contents, 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 you will reflect on the teaching performance itself and on the areas of strength and improvement, as well as on the strategies to enhance them.
- Collaborative learning activities, where the exchange of experiences, opinions and proposals through forums will be promoted.

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