Course Modules
Modulo I: Administrar las opciones y los ajustes de los libros
- Administrar Libros
- Administrar revisiones de libros
Modulo II: Aplicar formatos de datos y diseños personalizados
- Aplicar formatos de datos y validación personalizados
- Aplicar formato y filtrado condicional avanzado
- Crear y modificar elementos personalizados del libro
- Preparar un libro para la internacionalización
Modulo II: Aplicar formatos de datos y diseños personalizados
- Aplicar funciones en las fórmulas
- Buscar datos con funciones
- Aplicar funciones avanzadas de fecha y hora
- Realizar análisis de datos y de inteligencia empresarial
- Solución de problemas en las fórmulas
- Definir rangos y objetos con nombre
Modulo IV: Crear gráficos y tablas avanzadas
- Crear gráficos avanzados
- Crear y administrar PivotTables
Current process 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).
Prerequisites
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.
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| International Certification Excel Expert 2016 | 30 hours |
| • E-learning reinforcement topics and exclusive materials and simulators | • Complementary platform with digital resources, study guides, support recordings and exam simulators. |
| • Flexible educational model (in-person or live remote) | • Possibility to choose modality without losing human interaction and teaching support. |
| • Focus on employability and professional performance and exam preparation. | • Preparation oriented to certification, job performance and professional scaling based on practice, enhanced with AI support. |
| • Integration of Artificial Intelligence in learning | • Students use AI tools to reinforce understanding, practice exams and enhance their productivity. |
| • International Certification included | • Official endorsement with global recognition. Includes certification exams and access to the partner platform. |
| • Laboratories in real learning environments. | • Unlimited practical experience with real lab accounts and access to professional cloud infrastructure. |
| • Live classes with certified expert instructors. | • Guided and personalized training with direct real-time support, not offline. Recorded classes only for review. |
| • Personalized attention, small groups. | • Individual tracking, progress evaluations and technical support during training. AI-proctored performance examiner. |
| • Post-certification support and extended access to resources | • Post-assistance, access to materials for and continuous updates. |
| • Practical methodology and real and/or simulated projects. | • Applied learning from day one: simulations, business cases, projects and real cloud environments. |
| • Certificates of Approval and/or participation. | • International Certification by Microsoft It Academy
• Infinity Training Institute USA: International Certification Diploma in English • Aula Matriz IETDH Colombia - Certificate of participation |
Why choose Infinity Training Institute?
All our courses are Internationally certified:
- Infinity Training Institute USA: International Certification Diploma in English.
- International Certification from our partners Microsoft, Oracle, Certitalents, AWS, PMI, Cisco, etc.
2. We are not an automatic platform, nor self-study through videos
We are a unique model, in-person or Remote modality (with live instructor). Technology + pedagogy + AI + expert instructors + real practice — not self-study or outdated content.
3. Training designed for today's job market
Experience applicable immediately in interviews, technical tests and real work environments.
4. Real or simulated projects with international standards
Students access real environments such as Azure, AWS, Google Cloud, Oracle Cloud, develop real or simulated projects, building a demonstrable technical portfolio depending on the type of course or certification they have chosen.
5. A unique combination in Latin America and the USA
Certification + real practice + AI + continuous support + dual diploma.
6. Proven results
More than 95% of our graduates obtain official certification and improve professionally in less than six months.
7. Competency level guarantee
If the student during the practical training process does not reach a minimum performance level of 75%, they must repeat the course if the instructor determines so, and the student has shown the commitment and minimum class attendance required by the model.
Your professional future starts here
At Infinity Training Institute we boost your growth with an innovative, flexible model focused on real learning and performance evaluation. Certified instructors, intensive practice, integrated AI and constant support: world-class training.
Learning Methodology
At Infinity Training Institute, we apply a comprehensive, ever-evolving methodology centered on practical learning, powered by Artificial Intelligence, enabling personalized instruction, performance assessment, and optimized preparation for international certifications with certified instructors, real labs, simulators, and e-learning platforms. Participants learn by doing, developing technical and professional skills in small groups, with personalized follow-up and pre and post-certification support. Infinity Training Institute: Learn. Apply. Get Certified. Transcend.
Current process 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).
Prerequisites
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.
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| International Certification Excel Expert 2016 | 30 hours |
| • E-learning reinforcement topics and exclusive materials and simulators | • Complementary platform with digital resources, study guides, support recordings and exam simulators. |
| • Flexible educational model (in-person or live remote) | • Possibility to choose modality without losing human interaction and teaching support. |
| • Focus on employability and professional performance and exam preparation. | • Preparation oriented to certification, job performance and professional scaling based on practice, enhanced with AI support. |
| • Integration of Artificial Intelligence in learning | • Students use AI tools to reinforce understanding, practice exams and enhance their productivity. |
| • International Certification included | • Official endorsement with global recognition. Includes certification exams and access to the partner platform. |
| • Laboratories in real learning environments. | • Unlimited practical experience with real lab accounts and access to professional cloud infrastructure. |
| • Live classes with certified expert instructors. | • Guided and personalized training with direct real-time support, not offline. Recorded classes only for review. |
| • Personalized attention, small groups. | • Individual tracking, progress evaluations and technical support during training. AI-proctored performance examiner. |
| • Post-certification support and extended access to resources | • Post-assistance, access to materials for and continuous updates. |
| • Practical methodology and real and/or simulated projects. | • Applied learning from day one: simulations, business cases, projects and real cloud environments. |
| • Certificates of Approval and/or participation. | • International Certification by Microsoft It Academy
• Infinity Training Institute USA: International Certification Diploma in English • Aula Matriz IETDH Colombia - Certificate of participation |
Why choose Infinity Training Institute?
1. Internationally guaranteed certificationsAll our courses are Internationally certified:
- Infinity Training Institute USA: International Certification Diploma in English.
- International Certification from our partners Microsoft, Oracle, Certitalents, AWS, PMI, Cisco, etc.
2. We are not an automatic platform, nor self-study through videos
We are a unique model, in-person or Remote modality (with live instructor). Technology + pedagogy + AI + expert instructors + real practice — not self-study or outdated content.
3. Training designed for today's job market
Experience applicable immediately in interviews, technical tests and real work environments.
4. Real or simulated projects with international standards
Students access real environments such as Azure, AWS, Google Cloud, Oracle Cloud, develop real or simulated projects, building a demonstrable technical portfolio depending on the type of course or certification they have chosen.
5. A unique combination in Latin America and the USA
Certification + real practice + AI + continuous support + dual diploma.
6. Proven results
More than 95% of our graduates obtain official certification and improve professionally in less than six months.
7. Competency level guarantee
If the student during the practical training process does not reach a minimum performance level of 75%, they must repeat the course if the instructor determines so, and the student has shown the commitment and minimum class attendance required by the model.
Your professional future starts here
At Infinity Training Institute we boost your growth with an innovative, flexible model focused on real learning and performance evaluation. Certified instructors, intensive practice, integrated AI and constant support: world-class training.
Learning Methodology
At Infinity Training Institute, we apply a comprehensive, ever-evolving methodology centered on practical learning, powered by Artificial Intelligence, enabling personalized instruction, performance assessment, and optimized preparation for international certifications with certified instructors, real labs, simulators, and e-learning platforms. Participants learn by doing, developing technical and professional skills in small groups, with personalized follow-up and pre and post-certification support. Infinity Training Institute: Learn. Apply. Get Certified. Transcend.