International Certification Excel Mos 2016

This course is designed to provide complete training in Microsoft Excel 2016, addressing from the creation and administration of spreadsheets to the application of advanced functions, database management and the generation of graphic reports. The course prepares participants to obtain internatio…

20 hours
Official Certificate
Expert Instructors
Online Learning
Certificación internacional Excel MOS 2016
Microsoft It Academy logo

Course Modules

Module I: Create and Manage Spreadsheets and Workbooks

  • Create spreadsheets and workbooks 
  • Navigate through spreadsheets and workbooks
  • Format spreadsheets and workbooks
  • Customize options and views in spreadsheets and workbooks 
  • Set up spreadsheets and workbooks for distribution

  • Insert data into cells and ranges
  • Format cells and ranges  
  • Summarize and organize the data

  • Creation and management of tables
  • Managing table styles and options
  • Filtering and sorting a table

  • Summarizing data with functions
  • Performing conditional operations with functions 
  • Formatting and modifying text with functions

  • Create charts
  • Format graphic elements
  • Insert and format objects

  • Software Development Life Cycle
  • Agile Software Development
  • Waterfall Model
  • V Model

  • Benefits of Continuous Integration

  • Continuous Learning
  • CALMS Model
  • DevOps, Other Recommended Practices and Frameworks
  • DevOps and Agile
  • DevOps and Scrum
  • DevOps and ITSM (ITIL)

  • DevOps Culture
  • DevOps-Oriented Culture

  • Organization-Legacy
  • Traditional Operators and Developers
  • Dedicated DevOps Teams are Created
  • Total DevOps
  • Team Roles
  • Service Management Office SMO

  • System Thinking
  • Experimentation and Learning

Current process description

This course is designed to provide complete training in Microsoft Excel 2016, addressing from the creation and administration of spreadsheets to the application of advanced functions, database management and the generation of graphic reports.

The course prepares participants to obtain international certification:

Microsoft Office Specialist: Excel 2016 Core (77-427).

Objectives

At the end of the course, participants will be able to:

  • Create and manage spreadsheets and Excel books.
  • Apply formats and customize spreadsheet options.
  • Manage data cells and intervals for advanced analysis.
  • Create and manage dynamic tables in Excel.
  • Develop applications with advanced formulas and functions.
  • Generate graphics and visual objects for dynamic reports.

Prepare for MOS certification: Excel 2016 (77-427).

Prerequisites

To participate in this training, attendees must meet the following requirements:

  • Basic knowledge of computer science.

This requirement guarantees that participants can focus on the professional use of Excel without initial technical difficulties.

What Does This Course Include?

Our Value Proposition Benefit for Participant or Company
International Certification Excel Mos 2016 20 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 certifications
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.

Payment Options

Make your payment quickly, safely and reliably

  • For bank transfer payments, request the details by email customerservice@infinityti.org

Log In

Para continuar con tu inscripción, debes iniciar sesión o crear una cuenta.

Current process description

This course is designed to provide complete training in Microsoft Excel 2016, addressing from the creation and administration of spreadsheets to the application of advanced functions, database management and the generation of graphic reports.

The course prepares participants to obtain international certification:

Microsoft Office Specialist: Excel 2016 Core (77-427).

Objectives

At the end of the course, participants will be able to:

  • Create and manage spreadsheets and Excel books.
  • Apply formats and customize spreadsheet options.
  • Manage data cells and intervals for advanced analysis.
  • Create and manage dynamic tables in Excel.
  • Develop applications with advanced formulas and functions.
  • Generate graphics and visual objects for dynamic reports.

Prepare for MOS certification: Excel 2016 (77-427).

Prerequisites

To participate in this training, attendees must meet the following requirements:

  • Basic knowledge of computer science.

This requirement guarantees that participants can focus on the professional use of Excel without initial technical difficulties.

What Does This Course Include?

Our Value Proposition Benefit for Participant or Company
International Certification Excel Mos 2016 20 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 certifications
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.

Payment Options

Make your payment quickly, safely and reliably

  • For bank transfer payments, request the details by email customerservice@infinityti.org

Log In

Para continuar con tu inscripción, debes iniciar sesión o crear una cuenta.

Download Syllabus