This course is designed to provide advanced training in Microsoft Excel 2016, addressing book management and administration, the application of advanced functions, automation with complex formulas, structured data management and the generation of dynamic graphics and data analysis.
The course prepares participants to obtain international certification:
Microsoft Office Specialist: Excel 2016 Expert (77-428).
At the end of the course, participants will be able to:
- Manage and share Excel books professionally.
- Apply advanced designs, formats and validations.
- Create and manage advanced formulas.
- Automate calculations and processes with advanced functions.
- Develop data analysis and business intelligence with Excel.
- Optimize data models and information structuring.
- Create advanced graphics and dynamic reports.
Prepare for MOS certification: Excel 2016 Expert (77-428).
To participate in this training, attendees must meet the following requirements:
- Basic Excel knowledge.
This requirement guarantees that participants can focus on the advanced use of Excel without initial technical difficulties.
| Certificación internacional Excel expert 2016 | Applies |
|---|---|
| Certificación internacional Excel expert 2016 | 30 hours |
Learning Methodology
The learning methodology, regardless of the modality (in-person or remote), is based on the development of workshops or labs that lead to the construction of a project, emulating real activities in a company.
The instructor (live), a professional with extensive experience in work environments related to the topics covered, acts as a workshop leader, guiding students' practice through knowledge transfer processes, applying the concepts of the proposed syllabus to the project.
The methodology seeks that the student does not memorize, but rather understands the concepts and how they are applied in a work environment.
As a result of this work, at the end of the training the student will have gained real experience, will be prepared for work and to pass an interview, a technical test, and/or achieve higher scores on international certification exams.
Conditions to guarantee successful results:
- a. An institution that requires the application of the model through organization, logistics, and strict control over the activities to be carried out by the participants in each training session.
- b. An instructor located anywhere in the world, who has the required in-depth knowledge, expertise, experience, and outstanding values, ensuring a very high-level knowledge transfer.
- c. A committed student, with the space, time, and attention required by the training process, and the willingness to focus on understanding how concepts are applied in a work environment, and not memorizing concepts just to take an exam.
Pre-enrollment
You do not need to pay to pre-enroll. By pre-enrolling, you reserve a spot in the group for this course or program. Our team will contact you to complete your enrollment.
Pre-enroll nowInfinity Payments
Make your payment quickly, safely and reliably
- For bank transfer payments, request the details by email
capacita@aulamatriz.edu.co.
- If you wish to finance your payment through our credit options
(Sufi, Cooperativa Unimos or Fincomercio), click on the following link:
Ver opciones de crédito.
Description
This course is designed to provide advanced training in Microsoft Excel 2016, addressing book management and administration, the application of advanced functions, automation with complex formulas, structured data management and the generation of dynamic graphics and data analysis.
The course prepares participants to obtain international certification:
Microsoft Office Specialist: Excel 2016 Expert (77-428).
Objectives
At the end of the course, participants will be able to:
- Manage and share Excel books professionally.
- Apply advanced designs, formats and validations.
- Create and manage advanced formulas.
- Automate calculations and processes with advanced functions.
- Develop data analysis and business intelligence with Excel.
- Optimize data models and information structuring.
- Create advanced graphics and dynamic reports.
Prepare for MOS certification: Excel 2016 Expert (77-428).
To participate in this training, attendees must meet the following requirements:
- Basic Excel knowledge.
This requirement guarantees that participants can focus on the advanced use of Excel without initial technical difficulties.
offers
| Certificación internacional Excel expert 2016 | Applies |
|---|---|
| Certificación internacional Excel expert 2016 | 30 hours |
Learning Methodology
The learning methodology, regardless of the modality (in-person or remote), is based on the development of workshops or labs that lead to the construction of a project, emulating real activities in a company.
The instructor(live), a professional with extensive experience in work environments related to the topics covered, acts as a workshop leader, guiding students' practice through knowledge transfer processes, applying the concepts of the proposed syllabus to the project.
La metodología persigue que el estudiante "does not memorize", but rather "understands" the concepts and how they are applied in a work environment."
As a result of this work, at the end of the training the student will have gained real experience, will be prepared for work and to pass an interview, a technical test, and/or achieve higher scores on international certification exams.
Conditions to guarantee successful results:
- a. An institution that requires the application of the model through organization, logistics, and strict control over the activities to be carried out by the participants in each training session.
- b. An instructor located anywhere in the world, who has the required in-depth knowledge, expertise, experience, and outstanding values, ensuring a very high-level knowledge transfer.
- c. A committed student, with the space, time, and attention required by the training process, and the willingness to focus on understanding how concepts are applied in a work environment, and not memorizing concepts just to take an exam.
Infinity Payments
Make your payment quickly, safely and reliably
- For bank transfer payments, request the details by email
capacita@aulamatriz.edu.co.
- If you wish to finance your payment through our credit options
(Sufi, Cooperativa Unimos or Fincomercio), click on the following link:
Ver opciones de crédito.
Course Modules
Module I: Manage the Options and Settings of Workbooks
- Manage Workbooks
- Manage Workbook Revisions
Module II: Apply Data Formats and Custom Designs
- Apply custom data formats and validation
- Apply advanced conditional formatting and filtering
- Create and modify custom workbook elements
- Prepare a workbook for internationalization
Module II: Apply Data Formats and Custom Designs
- Apply functions in formulas
- Search for data using functions
- Apply advanced date and time functions
- Perform data analysis and business intelligence
- Troubleshoot formulas
- Define named ranges and objects
Module IV: Creating Advanced Charts and Tables
- Create advanced charts
- Create and manage PivotTables