Català
Español
English
| Modality: | On line streaming. It allows the live broadcast of the course through the virtual classroom with the CISCO WEBEX platform. It can be done from the place you want, with computer, mobile or tablet, and follow the course live with the teacher, participate in solving the exercises, ask questions in situ, listen to the queries of the other attendees and follow the teacher's notes on the board. Once the training is over, attendees will be able to consult the recordings of the course in their private area, if these have been previously authorized by the teacher of the course or managing entity. |
| Directed to: | Anyone who dedicates part of their working time to obtaining indicators from data, mainly in departments such as: Finance. Shopping. Manufacturing. Engineering. Operations. HR. Etc. |
| ? Dates: | November 16, 18 and 23 (Monday, Wednesday) |
| ⏰Schedule: | From 9 a.m. to 1 p.m. |
| Attendees: | Maximum 25 students |
| Duration: | 12 teaching hours |
| Programming: | The course will be divided into 3 days of 4 hours each, with the following content: Day 1
Day 2
Day 3
|
| Documentation: | The documentation will be available on the platform between 24 and 48 hours before the start of the training. In the event that there is additional documentation after the training, we will provide it later. |
| Certification: | Once the training action has been completed, students will obtain a certificate of attendance which can be downloaded to the platform. |
| Targets: | Until the 2013 version of Excel, they had a fundamental tool for calculations based on data that was the PivotTable. From this version, Excel offers us two much more powerful tools for data management which are: PowerQuery and PowerPivot. This course will study in depth the handling of tables and dynamic graphs in addition to the handling of the new table management tools: PowerQuery and PowerPivot. The video with the presentation of the course can be found at: https://www.youtube.com/watch?v=48WvsfscxK0&feature=youtu.be Although the video specifies a duration of 20 hours, this course, of 12 hours, will see the same points that are explained in the video. |
| Bonuses: | We manage the procedures so that you can benefit from the corresponding training bonus. |
| Instructions for bonuses: | 1. Request the forms from CETIT at formacio@enginyerstarragona.cat 2. Provide all information 10 calendar days before the start of the course. 3. IMPORTANT NOTE: bonuses are carried out through external advice. Those who want to take advantage of the bonus for any training action, the price will be increased by 20% (which can also be discounted and recovered). |
| Conditions: | Cancellation of registrations: Depending on the registrations made, the training action will be viable or not, which is why it is important that you notify the cancellations. The cancellation must be communicated 48 hours before the start of the training via email formacio@cetit.org, if 100% of the amount of the training action will not be invoiced. Images and recording of the course: we inform you that, in compliance with the provisions of the RGPD, the current legal regulations on data protection and Law 1/1982 on civil protection, the right to honor, personal and family privacy and the image itself, photographs will be taken during the course and in certain cases will be recorded and / or broadcast live. In no case will the name of the Interested Party be published. The image is used legitimized by the legitimate interest of the College to promote these courses and their possible subsequent viewing by attendees. Due to attendance, these images will be kept and while the course is posted on the platform. Once the time has elapsed to be able to view it later, it will no longer be uploaded to the platform and the images will be deleted with the appropriate security measures. You also have the right to request access, rectification, portability and deletion of your data and the limitation and opposition to its processing by sending an email to dpd@cetit.org. For more information on data protection rights, access our website: http://www.enginyerstarragona.cat/home/article/privacitat. |
