Excel advanced 2013

Excel advanced 2013

Goals

• The objective of this course is to learn how to use Excel 2013 at a more advanced level than usual.
• Create data tables and pivot tables, as well as use filters, criteria and summaries of them.
• Create scenarios in which you can quickly see the change of certain values ​​that affect the spreadsheet.
• Achieve an unknown objective based on specified criteria.
• Import data from external sources and use database functions. Create and use macros, as well as modify them from Visual Basic.
• Learn the basic concepts of programming and the main methods for developing small applications
applications that interact with the workbook, and create both default and custom dialog boxes.
• Work in a group by sharing the workbook and assigning permissions to users.
• Share the book on the Internet using the SkyDrive cloud tool.

Excel advanced 2013

What it prepares you for

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

Excel advanced 2013

Who is it addressed to?

For 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 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.