Aula_smart course

Excel 2013

Name: Excel 2013
Brand: Aula_SMART
Availability: InStock

Discover ours Excel 2013 course! In just 60 hours, it dominates Excel's essential functions and tools to improve your productivity and efficiency. Learn from basics to the advanced and transform your data management. Sign up now and enhance your skills!

€0,00

Free registration for the teacher and 100% bonus through Fundae for private and concerted centers, as long as you are in the General Social Security regime, RD 694/2017, of July 3. (Sign up through your center)

Course included in the AUGE_TIC AUGES PROGRAM. Every 100 hours of training, the Aula_Smart Foundation donates a laptop, iPad, Chromebook or other ICT equipment. (Valid for all teachers of private, concerted and public centers)

Date start courses

Sign up now! Limited places

Degree: Aula_smart
Duration: 60 hours
Modality: Online
Place: Cabeula_interactive Campus
Cost: No cost to the center or the teacher. RD 694/2017, of July 3
Fundae: 100% bonus

FA_S donation: laptop, iPad, Chromebook or ICT equipment every 100 hours of training

Sign up through your center (*)

Sign up (**)

(*) No cost to the center or the teacher according to RD 694/2017, of July 3.
(**) For students who are not going to take the course through their center

Excel 2013

Goals

• Acquire knowledge and skills from a basic level, on the use and management of spreadsheets.
• Know how to perform extremely simple mathematical operations to statistical and financial operations with some complexity.
• Have the capacity to provide statistical graphic documents, in addition to other types of graphics.

Excel 2013

What prepares you

To know in depth the spreadsheets and work books. Will know thoroughly the main formulas that are
They use day by day.

Excel 2013

Who is it addressed

To people who want to learn and deepen the domain and management of spreadsheets and want to expedite the mathematical operations of their work.

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

Excel 2013

Syllabus

Download the agenda in .pdf format

Topic 1

Introduction to Excel 2013
Introduction.
Enter and leave the program.
The Microsoft Excel window.
The concept of spreadsheet.
Data introduction.
Summary.

Title

Write content to help your customers to better understand your products or policies.

Topic 2

Basic operations
Introduction.
Close and create new work books.
Various ways to save books.
Open a workbook.
Displacement by the workbook.
Excel data.
Prior print view and print.
Summary.

Topic 3

Work with cells
Introduction.
Cell selection.
Copy and move blocks.
Data modification.
Undo and remake commands.
Data search and replacement.
Insert and remove cells.
Character repetition.
The sum command.
Summary.

Topic 4

Text format and spreadsheets
Introduction.
Fonts.
Data alignment.
Application of plots, edges and color.
Bleeding
Configure page.
Headers and feet of page.
Page jumps.
Styles
Data validation.
Summary.

Topic 5

Use of external names and references
Introduction.
Selection of spreadsheets.
Move and copy spreadsheets.
Insert and eliminate spreadsheets.
Generalities of the spreadsheets.
Use of names.
Summary.

Topic 6

Office's help
Introduction.
Office's help.
Contextual help.
Summary.

Topic 7

Visualization of workbooks
Introduction.
Ways of seeing a spreadsheet.
Name and formula box.
Zoom.
Visualization of the book and leaves.
WINDOW MANAGEMENT.
Summary.

Topic 8

Leaf formats
Introduction.
Automatic cell filling.
Absolute, relative and mixed reference cells.
Numerical data formats.
Conditional formats.
Data protection.
Shared books
Comments.
Creation of schemes.
Summary.

Topic 9

Most useful tools in Excel
Introduction.
Autocorrection.
Ordinations.
Automatic calculations in the status bar.
Other Excel features.
Summary.

Topic 10

Formulas and Functions I
Introduction.
Create formulas.
Location of errors in the formulas.
Calculate subtotals.
Rank of functions.
Statistical and mathematical functions.
Financial functions.
The Euroconvert function.
Information functions.
Summary.

Topic 11

Formulas and Functions II
Introduction.
Date and time functions.
Text functions.
Logical functions
Search and reference functions.
Summary.

Excel 2013

Do you have any questions about this course?

You can send us your consultation by filling out this form or in the following ways:

- Through the phone (+34) 951 411 800
- Through email

comunicacion@fundacionaulasmart.org

Related courses

¡Potencia el talento y las competencias emocionales de tus alumnos! Este curso de 100 horas te enseñará técnicas de coaching educativo para desarrollar habilidades y mejorar el rendimiento académico. Aprende a inspirar y guiar a tus estudiantes hacia el éxito.

Educational Coaching: Development of skills, talent and emotional competences in students

€0,00

¡Descubre nuestro curso Habilidades Docentes: El Perfil del Profesor en el Siglo XXI! En solo 110 horas, adquiere las competencias necesarias para ser un docente innovador y eficaz en el aula. Mejora tus habilidades pedagógicas y tecnológicas. ¡Inscríbete ahora y transforma tu enseñanza!

Teaching skills: the teacher's profile in the 21st century

€0,00

¡Desarrolla una escuela emocionalmente inteligente con nuestro curso de Inteligencia Emocional! Aprende a implementar programas y herramientas para mejorar el bienestar emocional en tu centro educativo. Curso online, 100% bonificable y con titulación universitaria. ¡Inscríbete ahora y recibe un equipo TIC gratuito!

Emotional intelligence and development of an emotionally intelligent school

€0,00

¡Transforma tu enseñanza con el curso “Medio Ambiente Educativo: Innovación y Buenas Prácticas”! Aprende a integrar la educación ambiental en tus estrategias docentes. Curso online, 100% bonificable y con titulación universitaria. ¡Inscríbete ahora y recibe un equipo TIC gratuito!

Educational Environment: Innovation and Good Practices

€0,00

Aula_SMart® Foundation

Referents in the education sector

From the Aula_Smart® Foundation we work to develop and incorporate
New technologies to the education sector.

Contact us

Do you have any questions?

You can also send us your consultation in the following ways:

- Through the phone (+34) 951 411 800
- Through email

comunicacion@fundacionaulasmart.org

AULA_SMART ® Foundation

C/ Palma del Río, 19 - Melior Building, 29004, Málaga
Telephone: +34 951 411 800
E-mail: comunicacion@fundacionaulasmart.org
Website: www.fundacionaulasMart.org