Excel advanced 2013

Excel advanced 2013

Goals

• The objective of this course is to learn to handle Excel 2013 at a more advanced level of the usual.
• Create data tables and dynamic tables, as well as the use of their filters, criteria and summaries.
• Create scenarios where to quickly see the change of certain values ​​that affect the spreadsheet.
• Get an unknown objective from specified criteria.
• Import data from external sources and use database functions. Creation and use of macros, as well as its modification from Visual Basic.
• Learn the basic programming concepts and the main methods to develop small
applications that interact with the workbook, and create both default and own dialogue.
• Work in a group sharing the workbook and assigning permits to users.
• Share the book on the Internet through the Skydrive cloud tool.

Excel advanced 2013

What prepares you

To handle Excel at a higher level than the user.

Excel advanced 2013

Who is it addressed

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

Excel advanced 2013

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.