Microsoft

Before taking the Microsoft 365 Fundamentals exam, you should feel confident in demonstrating your knowledge to a potential employer across these 4 core areas:

• Cloud Concepts

  Describe the different types of cloud services available: laaS & PaaS offerings. Be prepared to describe where Microsoft Azure and Dynamics 365 fit into the Microsoft ecosystem. Know about cloud-based productivity. Describe the benefits of and considerations for using a cloud service instead of on-premises services.

• Microsoft 365 Services and Concepts

  Identify core Microsoft 365 capabilities, describe options for deploying and supporting Windows and Office, describe analytics capabilities in Microsoft 375, describe Microsoft 365 collaboration solutions.

• Security, Compliance, Privacy, and Trust in Microsoft 365

  Explain zero-trust security principles for Microsoft 365 such as key components that need to be protected within an organization’s cloud and on-premises infrastructure. Explain unified endpoint management concepts. Be prepared to describe identity and access management concepts. Explain threat protection in Microsoft 365. Describe the Service Trust portal, Microsoft 365 security center, and Compliance Manager. Describe information protection and governance solutions.

• Microsoft 365 Pricing and Support

  Plan, predict, and compare pricing. Identify licensing options available in Microsoft 365, describe the service lifecycle in Microsoft 365, and describe support offerings for Microsoft 365 services.

This exam is designed for candidates looking to demonstrate foundational-level knowledge on the considerations and benefits of adopting cloud services in general and the Software as a Service (SaaS) cloud model. Candidates should have knowledge of available options and benefits gained by implementing Microsoft 365 cloud service offerings.

The technical skills validated through the Microsoft 365 Fundamentals exam will help prepare you for IT career opportunities such as:

• Microsoft 365 Administrator
• Modern Desktop Administrator Associate
• Security Administrator Associate

If you have no prior IT experience, and you’re planning out your IT career path, having a well-rounded skill set on Microsoft 365 Fundamentals for both desktop platforms provides the maximum career potential. Getting your foot in the door in Microsoft 365 Fundamentals is a great way to get started, giving you access to supporting users running a variety of hardware and software technologies.

CIAT’s Career Services team provides personalized career transition support to ensure you translate your technical training and industry certifications into viable career opportunities. Our full suite of career services support includes resume building, LinkedIn profile optimization, mock interview support, career coaching, and job placement support, and specialty workshops, to help ensure you’re positioned for success.

Typically, students enrolled in our Applied Bachelor’s Degree in Computer Information Systems program feel confident taking the Microsoft 365 Fundamentals exam after 5 weeks of technical training and exam preparation.

Microsoft 365 Fundamentals is an intermediate level certification that can serve as a launchpad for numerous IT certification and career pathways. The more certs you earn, the more skills you acquire, the more career opportunities will be available. Register for our Microsoft 365 certification training!

Here is the recommended IT certification pathways that include the Microsoft 365 Fundamentals certification:

• Associate's of Applied Science in Computer Information Systems
• Applied Bachelor's Degree in Computer Information Systems - Cybersecurity Concentration
• Applied Bachelor's Degree in Computer Information Systems - Cloud Concentration

Your Microsoft Fundamental exam voucher, retake costs, and exam prep software, are included in the cost of your tuition for any CIAT Certificate or Degree programs. CIAT provides unlimited attempts at passing the Microsoft Fundamentals exam to ensure you start your exam calm and confident, without worrying about what will happen if you don’t pass.

You save hundreds of dollars in out-of-pocket expenses over a DIY studying approach.

The CIAT National City campus includes secure and authorized testing center facilities, available to local San Diego students and alumni. For our online students, we work closely with you to help locate and facilitate an authorized testing center near you.

In response to the COVID-19 pandemic, CIAT has enabled students to take the Microsoft Fundamentals exam remotely from the comfort of their own home through Microsoft’s new “Test Anywhere” process. Don’t put your goals on hold or push off until normalcy returns.

Studying for the Microsoft 365 Fundamentals on your own is doable, but often leaves you without the required technical skills in your background, or the necessary resources to translate your exam score into an IT career.

Join over 2,000 students who have enrolled in CIAT accredited Certificate and Degree programs and are on their path to launching or advancing their IT careers. Our extensive, custom designed IT curriculum provides training for up to 14 industry certifications, including Microsoft 365 Fundamentals.

• No exam fees
• Unlimited exam attempts*
• Hands-on training through on-campus and virtual online classes
• Online test preparation workshops
• Test preparation software
• One-on-one support from certified instructors
• Accredited Certificate and Degree programs to beef up your resume
• Personalized career services support including resume building and job placement support

* Students are encouraged to take certification exams while actively enrolled in the degree program. Unlimited certification exam attempts expire 90 days after graduation. The following are single attempt exams and are not eligible for a retake voucher: CEH, CASP, CISSP, DevNet & CCNP. See certification exam policy for more details.

The exam code for Microsoft 365 Certified – Fundamentals is MS-900.

The minimum passing score required for the Microsoft MS-900 exam is 700.

The Microsoft Azure Fundamentals exam is designed for early stage IT professionals interested in building a career in cloud services. The Microsoft Azure Fundamentals exam validates your skills on networks, basic cloud technologies, and databases using the Azure best practices.

If you’re interested in learning more about Microsoft and its Cloud Services, then you’re ready to start preparing for your Azure certification exam. Register for our Microsoft Azure Fundamentals certification training (AZ-900).

Before taking the Microsoft Azure certification exam, you should feel confident in demonstrating your knowledge to a potential employer across these 5 core areas:

• Cloud Concepts

  Identify the benefits and considerations of using cloud services, describe the differences between categories of cloud services, and the differences between types of cloud computing.

• Core Azure Services

  Describe the core Azure architectural components, and the core resources available in Azure.

• Core Solutions and Management Tools on Azure

  Describe core solutions available on Azure, and Azure management tools.

• General Security and Network Security Features

  Learn the ins and outs of Azure security features, and Azure network security.

• Identity, Governance, Privacy, and Compliance Feature

  Explain what core Azure Identity Services is, and define the governance features, and last but not least describe the privacy and compliance resources.

How confident are you with your troubleshooting and problem-solving skills with servers run on the Azure cloud platform? Take our Azure Fundamentals knowledge quiz to validate your confidence going into the exam and/or applying for your next IT position.

There are two parts to getting ahead in the IT industry: hands-on experience and industry certifications. For many students, they are qualified for a position, but need extra support with exam strategies or exposure and practice to specific areas of Azure cloud administration that they haven’t been exposed to. This is where our certification-based curriculum comes in. Our technical classes provide the ideal blend of skills-based training and industry certification preparation so that you’re confident walking into both the exam booth and your next interview.

The technical skills validated through the Microsoft Azure Fundamentals certification exam will help prepare you for IT career opportunities and will prepare you for a more technical role.

If you have no prior IT experience, and you’re planning out your IT career path, having a well-rounded skill set on servers running both Microsoft Azure and Amazon AWS cloud platforms provide the maximum career potential. Getting your foot in the door in IT HelpDesk or IT Support is a great way to get started, giving you access to supporting users running a variety of hardware and software technologies. As you start to build your training and exposure in server management and cloud administration, you’ll increase your problem-solving and troubleshooting skills and will be ready to start studying for the Azure certification exam.

CIAT’s Career Services team provides personalized career transition support to ensure you translate your technical training and industry certifications into viable career opportunities. Our full suite of career services support includes resume building, LinkedIn profile optimization, mock interview support, career coaching, and job placement support, and specialty workshops, to help ensure you’re positioned for success.

Typically, students enrolled in our Certificate In Cloud Administration program feel confident taking the Microsoft Azure Fundamentals exam after 5 weeks of technical training and exam preparation.

Microsoft Azure is a beginner level certification that can serve as a launchpad for numerous IT certification and career pathways. The more certs you earn, the more skills you acquire, the more career opportunities will be available. Prepare for the exam by taking our Microsoft Azure Fundamentals certification training (AZ-900).

• Cloud Administration Certificate
• Associate of Applied Science in Computer Information Systems
• Applied Bachelor's Degree in Computer Information Systems - Cloud Concentration

Your Microsoft Azure exam voucher, retake costs, and exam prep software, are included in the cost of your tuition for any CIAT Certificate or Degree programs. CIAT provides unlimited attempts at passing the Microsoft Azure to ensure you start your exam calm and confident, without worrying about what will happen if you don’t pass.

You save hundreds of dollars in out-of-pocket expenses over a DIY studying approach.

CIAT’s National City campus includes secure and authorized testing center facilities, available to local San Diego students and alumni. For our online students, we work closely with you to help locate and facilitate an authorized testing center near you.

In response to the COVID-19 pandemic, CIAT has enabled students to take the Microsoft Azure certification exam remotely from the comfort of their own home through Microsoft’s new “Test Anywhere” process. Don’t put your goals on hold or push off until normalcy returns.

Studying for the Microsoft Azure Fundamentals certification on your own is doable, but often leaves you without the required technical skills in your background, or the necessary resources to translate your exam score into an IT career.

Join over 2,000 students who have enrolled in CIAT accredited Certificate and Degree programs and are on their path to launching or advancing their IT careers. Our extensive, custom designed IT curriculum provides training for up to 14 industry certifications, including Microsoft Azure.

• No exam fees
• Unlimited exam attempts*
• Hands-on training through on-campus and virtual online classes
• Online test preparation workshops
• Test preparation software
• One-on-one support from certified instructors
• Accredited Certificate and Degree programs to beef up your resume
• Personalized career services support including resume building and job placement support

* Students are encouraged to take certification exams while actively enrolled in the degree program. Unlimited certification exam attempts expire 90 days after graduation. The following are single attempt exams and are not eligible for a retake voucher: CEH, CASP, CISSP, DevNet & CCNP. See certification exam policy for more details.

The minimum passing score required for the Microsoft AZ-900 (Fundamental) exam is 700.

The Microsoft Azure Administrator Associate exam is designed for early stage IT professionals interested in building a career in cloud administration. The Microsoft Azure Administrator exam validates your skills and experience implementing, managing, and monitoring an organization’s Microsoft Azure environment.

If you have a minimum of 6 months of hands-on industry experience in an IT administration role with a concentration in cloud management and exposure to working on the Microsoft Azure platform, you’re ready to start preparing for your Azure certification exam. Register for our Microsoft Azure certification training today!

Before taking the Microsoft Azure Administrator certification exam, you should feel confident in demonstrating your knowledge to a potential employer across these 4 core areas:

• Identities and Governance

  Understand how to manage Azure Active Directory objects, role-based access control (RBAC) subscriptions, and governance in Azure.

• Implementing and Managing Storage

  Understand how to manage storage accounts, data in Azure storage, and Azure File and Blob storage.

• Deploying and Managing Azure Compute Resources

  Understand how to deploy and configure virtual machines, containers, and Web Apps in Azure.

• Configuring and Managing Virtual Networks

  How to configure and manage Azure network capabilities like connectivity services, application protection, application delivery, and network monitoring services.

How confident are you with your troubleshooting and problem-solving skills with servers run on the Azure cloud platform? Take our Azure Fundamentals knowledge quiz to validate your confidence going into the exam and/or applying for your next IT position.

There are two parts to getting ahead in the IT industry: hands-on experience and industry certifications. For many students, they are qualified for a position, but need extra support with exam strategies or exposure and practice to specific areas of Azure cloud administration that they haven’t been exposed to. This is where our certification-based curriculum comes in. Our technical classes provide the ideal blend of skills-based training and industry certification preparation so that you’re confident walking into both the exam booth and your next interview.

The technical skills validated through the Microsoft Azure Administrator Associate certification exam will help prepare you for IT career opportunities such as:

• Azure Cloud Administrator
• IT Systems Administrator
• Technical Support Specialist

If you have no prior IT experience, and you’re planning out your IT career path, having a well-rounded skill set on servers running both Microsoft Azure and Amazon AWS cloud platforms provide the maximum career potential. Getting your foot in the door in IT HelpDesk or IT Support is a great way to get started, giving you access to supporting users running a variety of hardware and software technologies. As you start to build your training and exposure in server management and cloud administration, you’ll increase your problem-solving and troubleshooting skills and will be ready to start studying for the Azure certification exam.

CIAT’s Career Services team provides personalized career transition support to ensure you translate your technical training and industry certifications into viable career opportunities. Our full suite of career services support includes resume building, LinkedIn profile optimization, mock interview support, career coaching, and job placement support, and specialty workshops, to help ensure you’re positioned for success.

Typically, students enrolled in our Certificate In Cloud Administration program feel confident taking the Microsoft Azure Administrator exam after 5 weeks of technical training and exam preparation.

Microsoft Azure Administrator is an intermediate level certification that can serve as a launchpad for numerous IT certification and career pathways. The more certs you earn, the more skills you acquire, the more career opportunities will be available.

Here are three recommended IT certification pathways that include the Microsoft Azure Administrator Certification:

• Cloud Administration Certificate
• Associate of Applied Science in Computer Information Systems
• Applied Bachelor's Degree in Computer Information Systems - Cloud Concentration

Your Microsoft Azure Administrator exam voucher, retake costs, and exam prep software, are included in the cost of your tuition for any CIAT Certificate or Degree programs. CIAT provides unlimited attempts at passing the Microsoft Azure Administrator certification to ensure you start your exam calm and confident, without worrying about what will happen if you don’t pass. Prepare for the exam by taking our AZ-104 training course.

You save hundreds of dollars in out-of-pocket expenses over a DIY studying approach.

CIAT’s National City campus includes secure and authorized testing center facilities, available to local San Diego students and alumni. For our online students, we work closely with you to help locate and facilitate an authorized testing center near you.

In response to the COVID-19 pandemic, CIAT has enabled students to take the Microsoft Azure certification exam remotely from the comfort of their own home through Microsoft’s new “Test Anywhere” process. Don’t put your goals on hold or push off until normalcy returns.

Studying for the Microsoft Azure Administrator certification on your own is doable, but often leaves you without the required technical skills in your background, or the necessary resources to translate your exam score into an IT career.

Join over 2,000 students who have enrolled in CIAT accredited Certificate and Degree programs and are on their path to launching or advancing their IT careers. Our extensive, custom designed IT curriculum provides training for up to 14 industry certifications, including Microsoft Azure Administrator.

• No exam fees
• Unlimited exam attempts*
• Hands-on training through on-campus and virtual online classes
• Online test preparation workshops
• Test preparation software
• One-on-one support from certified instructors
• Accredited Certificate and Degree programs to beef up your resume
• Personalized career services support including resume building and job placement support

* Students are encouraged to take certification exams while actively enrolled in the degree program. Unlimited certification exam attempts expire 90 days after graduation. The following are single attempt exams and are not eligible for a retake voucher: CEH, CASP, CISSP, DevNet & CCNP. See certification exam policy for more details.

The minimum passing score required for the Microsoft AZ-104 (MCP) exam is 700.

The Microsoft Azure Security Engineer exam is designed for IT professionals interested in building a career in Security Engineering. The Microsoft Azure Security Engineer exam validates your skills to secure data, applications, manage security operations, implement platform protection, and manage identity and its access.

If you’re interested in learning more about Microsoft, then you’re ready to start preparing for your Azure certification exam. Register for our Microsoft Azure Security Engineer Certification training course (AZ-500).

Before taking the Microsoft Azure Security Engineer certification exam, you should feel confident in demonstrating your knowledge to a potential employer across these 4 core areas:

• Manage Identity and Access

  Manage Azure active directory identities, application access and access control, configure and secure access by using Azure AD

• Implement Platform Protection

  Implement advanced network security, and configure advanced security for computers.

• Manage Security Operations

  Monitor security by using Azure Monitor, Azure security Center, and Azure Sentinel, and configure security policies.

• Secure Data and Applications

  Configure security for storage, databases, and Key Vault.

How confident are you with your knowledge in scripting, automation, virtualization, networking, and cloud architecture? Take the Azure Security Engineer practice quiz to validate your confidence going into the exam and/or applying for your next IT position.

There are two parts to getting ahead in the IT industry: hands-on experience and industry certifications. For many students, they are qualified for a position, but need extra support with exam strategies or exposure and practice to specific areas of Microsoft Azure that they haven’t been exposed to. This is where our certification-based curriculum comes in. Our technical classes provide the ideal blend of skills-based training and industry certification preparation so that you’re confident walking into both the exam booth and your next interview. Take our Azure Security course (AZ-500) to prepare for the exam.

The technical skills validated through the Microsoft Azure Security Engineer certification exam will help prepare you for IT career opportunities and will prepare you for a more technical role as a Security Engineer.

If you have no prior IT experience, and you’re planning out your IT career path, having a well-rounded skill set on servers running both Microsoft Azure and Amazon AWS cloud platforms provide the maximum career potential. Getting your foot in the door in IT HelpDesk or IT Support is a great way to get started, giving you access to supporting users running a variety of hardware and software technologies. As you start to build your training and exposure in server management and cloud administration, you’ll increase your problem-solving and troubleshooting skills and will be ready to start studying for the Azure certification exam.

CIAT’s Career Services team provides personalized career transition support to ensure you translate your technical training and industry certifications into viable career opportunities. Our full suite of career services support includes resume building, LinkedIn profile optimization, mock interview support, career coaching, and job placement support, and specialty workshops, to help ensure you’re positioned for success.

Typically, students enrolled in our Bachelor’s of Applied Science — Cloud program feel confident taking the Microsoft Azure Security Engineer exam after ? weeks of technical training and exam preparation.

Microsoft Azure Security Engineer is an intermediate level certification that can serve as a launchpad for opening up numerous IT certification and career pathways. The more certs you earn, the more skills you acquire, the more career opportunities will be available. Register for our Microsoft Azure Security Engineer certification training (AZ-500).

Here are two recommended IT certification pathways that include the Microsoft Azure Security Engineer Certification:

• Applied Bachelor's Degree in Computer Information Systems — Cybersecurity Concentration
• Applied Bachelor's Degree in Computer Information Systems — Cloud Concentration

Your Microsoft Azure exam voucher, retake costs, and exam prep software, are included in the cost of your tuition for any CIAT Certificate or Degree programs. CIAT provides unlimited attempts at passing the Microsoft Azure to ensure you start your exam calm and confident, without worrying about what will happen if you don’t pass.

You save hundreds of dollars in out-of-pocket expenses over a DIY studying approach.

CIAT’s National City campus includes secure and authorized testing center facilities, available to local San Diego students and alumni. For our online students, we work closely with you to help locate and facilitate an authorized testing center near you.

In response to the COVID-19 pandemic, CIAT has enabled students to take the Microsoft Azure certification exam remotely from the comfort of their own home through Microsoft’s new “Test Anywhere” process. Don’t put your goals on hold or push off until normalcy returns.

Studying for the Microsoft Azure Security Engineer certification on your own is doable, but often leaves you without the required technical skills in your background, or the necessary resources to translate your exam score into an IT career.

Join over 2,000 students who have enrolled in CIAT accredited Certificate and Degree programs and are on their path to launching or advancing their IT careers. Our extensive, custom designed IT curriculum provides training for up to 14 industry certifications, including Microsoft Azure.

• No exam fees
• Unlimited exam attempts*
• Hands-on training through on-campus and virtual online classes
• Online test preparation workshops
• Test preparation software
• One-on-one support from certified instructors
• Accredited Certificate and Degree programs to beef up your resume
• Personalized career services support including resume building and job placement support

* Students are encouraged to take certification exams while actively enrolled in the degree program. Unlimited certification exam attempts expire 90 days after graduation. The following are single attempt exams and are not eligible for a retake voucher: CEH, CASP, CISSP, DevNet & CCNP. See certification exam policy for more details.

The exam code for Azure Security Engineer is AZ-500

The minimum passing score required for the Microsoft AZ-500 exam is 700.

In order to earn a Microsoft Office Specialist Expert certification, you must complete the Microsoft Office Specialist Associate certification by passing three of the following Associate exams:

• MO-100: Microsoft Word (Office 2019)

• MO-200: Microsoft Excel (Office 2019)

• MO-300: Microsoft Powerpoint (Office 2019)

• MO-400: Microsoft Outlook (Office 2019)

Once you earn your Microsoft Office Specialist Associate certification, you can earn your Microsoft Office Specialist Expert certification by passing any two of the following three Expert exams:

• MO-101: Microsoft Word Expert (Office 2019)

• MO-201: Microsoft Excel Expert (Office 2019)

• MO-500: Microsoft Access Expert (Office 2019)

The MOS certification tests core Microsoft Office product knowledge including:

Microsoft Word

• Managing document options and settings

• Managing document collaboration

• Creating and managing references

• Use advanced editing and formatting features

• Creating custom document elements

• Use advanced Microsoft Word features

Microsoft Excel

• Manage workbook options and settings

• Managing worksheets and workbooks

• Managing and formatting data

• Performing operations using formulas and functions

• Creating advanced formulas and macros

• Managing advanced charts and tables

Microsoft PowerPoint

• Creating and managing PowerPoint presentations

• Creating and animating PowerPoint slide content

• Managing multiple PowerPoint presentations

Microsoft Office

• Manage Outlook settings and processes

• Manage messages

• Manage schedules

• Manage contacts and tasks

Microsoft Access

• Managing databases

• Creating and modifying tables

• Creating and modifying queries

• Modifying forms in layout view

• Modifying reports in layout view

The Microsoft Office Specialist certification exam tests your knowledge of Microsoft Office products including Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft Outlook, and Microsoft Access.

Success on the MOS certification exam requires advanced knowledge and experience with Microsoft Office software applications. Enrolling in CIAT’s Associate of Applied Science in Business Administration degree program can help you gain the hands-on experience and specialized skills you need to pass your MOS certification exam with flying colors. Apply Today and take your first step into getting MOS certified!

The MOS exam covers a wide range of topics related to Microsoft Office software applications, including:

Microsoft Word Knowledge

• Managing document options and settings

• Managing document collaboration

• Creating and managing references

• Use advanced editing and formatting features

• Creating custom document elements

• Use advanced Microsoft Word features

Microsoft Excel Skills

• Manage workbook options and settings

• Managing worksheets and workbooks

• Managing and formatting data

• Performing operations using formulas and functions

• Creating advanced formulas and macros

• Managing advanced charts and tables

Microsoft PowerPoint Skills

• Creating and managing PowerPoint presentations

• Creating and animating PowerPoint slide content

• Managing multiple PowerPoint presentations

Microsoft Office Skills

• Manage Outlook settings and processes

• Manage messages

• Manage schedules

• Manage contacts and tasks

Microsoft Access Skills

• Managing databases

• Creating and modifying tables

• Creating and modifying queries

• Modifying forms in layout view

• Modifying reports in layout view

Before taking the MOS exam, you should feel confident in your understanding of core Microsoft Office software applications, including: Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft Office, and Microsoft Access.

Microsoft Office is one of the most widely used software application suites in the world, with businesses across industries relying on its applications for daily operations and growth. Employers looking to hire for positions that involve working with software prefer or sometimes even require that candidates are proficient in Microsoft Office.

Passing the MOS exam and obtaining your certification can help you get a leg up on the competition: stacking your resume with Microsoft Office certifications can increase your marketability as a business professional and your earning potential. The software application skills validated through the MOS certification exam will help prepare you for promising opportunities in the business world such as:

• Office Manager

• Assistant Manager

• Administrative Assistant

• Business Office Specialist

• Desktop Publishers

Passing your MOS certification exam is a pivot first step to building a thriving career in the business world. But the journey doesn’t end once you earn your certification. The next crucial step? Arming yourself for the job hunt process and learning how to strategically showcase your skills, certifications, and expertise to potential employers.

CIAT's Career Services team provides personalized career services support to help you translate your specialized training and industry certifications into viable career opportunities. Our full suite of career services support includes resume building, LinkedIn profile optimization, mock interview support, career coaching, and job search support, and specialty workshops, to help ensure you can use what you’ve learned to compete for top positions in today’s job market.

Typically, students should prepare to allocate at least 10 weeks of studying to adequately prepare for the Microsoft Office Specialist certification exam.

The CIAT National City campus includes secure and authorized testing center facilities, available to local San Diego students and alumni. For our online students, we work closely with you to help locate and facilitate an authorized testing center near you.

In response to the COVID-19 pandemic, CIAT has enabled students to take the MOS exam remotely from the comfort of their own home.

With our one-of-a-kind Unlimited Certification Exam Policy, your MOS exam voucher, retake costs, and exam prep software are included in the cost of your tuition for all Certificate and Degree programs. CIAT provides unlimited attempts at passing the MOS exam so you can take your exam without the added stress and worries about potential outcomes.

With our Unlimited Certification Exam Policy, you can save hundreds of dollars in out-of-pocket expenses over a DIY studying approach.

CIAT’s National City campus includes secure and authorized testing center facilities, available to local San Diego students and alumni. For our online students, we work closely with you to help locate and facilitate an authorized testing center near you.

In response to the COVID-19 pandemic, CIAT has enabled students to take the MOS certification exam(s) remotely from the comfort of their own home.

The best way to get MOS certified is to build your knowledge, skills, and confidence around Microsoft Office software applications. Enrolling in CIAT’s Associate of Applied Science in Business Administration program can give you the resources and hands-on experience you need to translate your knowledge into a passing exam score, and that passing exam score into a flourishing career.

Join over 2,000 students who have enrolled in CIAT accredited Certificate and Degree programs and are on their path to launching or advancing their careers. Our extensive, custom designed curriculum provides training for up to 14 industry certifications, including MOS.

• No exam fees
• Unlimited exam attempts*
• Hands-on training through on-campus and virtual online classes
• Online test preparation workshops
• Test preparation software
• One-on-one support from certified instructors
• Accredited Certificate and Degree programs to beef up your resume
• Personalized career services support including resume building and job placement support

* Students are encouraged to take certification exams while actively enrolled in the degree program. Unlimited certification exam attempts expire 90 days after graduation. The following are single attempt exams and are not eligible for a retake voucher: CEH, CASP, CISSP, DevNet & CCNP. See certification exam policy for more details.

All Microsoft technical certification exams are reported on a scale of 1 to 1,000. To pass your exam, you must earn a score of 700 or greater. As these exams are scaled, it may not be equivalent to 70% of the points. All Microsoft Office exam scores are reported on a scale of 1 to 1,000. The actual score you need to pass depends on the specific exam you are taking.

Students will learn the necessary skills in professional presentation design, multimedia integration, and visual communication strategies.

If you regularly create presentations for work, education, or personal projects, this certification is ideal for you. It’s particularly valuable if you need to deliver impactful presentations, create training materials, or develop visual content for business communications. This certification validates your ability to use PowerPoint’s core features effectively.

The exam covers five main skill areas:

Presentation Management (25-30%)

• Create and manage presentations
• Modify slide masters and layouts
• Customize presentation options

Slide Content (25-30%)

• Insert and format text
• Insert and modify shapes and text boxes
• Manage multiple objects

Graphics and Multimedia (20-25%)

• Insert and modify images
• Add tables, charts, and SmartArt
• Work with media elements

Animations and Transitions (15-20%)

• Apply and modify transitions
• Create and modify animations
• Set timing for effects

Presentation Delivery (10-15%)

• Configure presentation settings
• Set up slideshow options
• Prepare presentations for delivery

You should be comfortable with:

• Basic PowerPoint navigation and interface
• Creating and editing slides
• Adding and formatting text and objects
• Working with basic animations
• Managing basic presentation settings
• Basic design principles

Yes! The PowerPoint Associate certification can enhance your job prospects for roles such as:

• Marketing Coordinator
• Training Specialist
• Sales Representative
• Communications Specialist
• Executive Assistant
• Presentation Designer
• Corporate Trainer

Many employers value PowerPoint certification when hiring for positions that involve creating and delivering presentations.

Most candidates spend 15-25 hours preparing for the exam. If you’re already using PowerPoint regularly, you might need less time. However, if you’re new to PowerPoint, you might want to plan for 30-40 hours of study and practice. The key is to get hands-on experience with all the features covered in the exam.

Your Microsoft Office Specialist: PowerPoint Associate exam voucher, retake costs, and exam prep software, are included in the cost of your tuition. CIAT provides unlimited attempts at passing the Microsoft Office Specialist: PowerPoint Associate certification to ensure you start your exam calm and confident, without worrying about what will happen if you don’t pass.

You save hundreds of dollars in out-of-pocket expenses over a DIY studying approach.

If you use Excel regularly for work or study, or want to validate your intermediate-level Excel skills, this certification is ideal for you. It’s particularly valuable if you work with data, create reports, or need to analyze information in a business context. This certification demonstrates your ability to use Excel’s core features effectively.

The exam covers five main skill areas:

Workbook Management (30-35%)

• Create and manage worksheets and workbooks
• Format worksheet and workbook elements
• Customize options and views

Data Management (15-20%)

• Import and organize data
• Navigate within worksheets and workbooks
• Format cells and ranges

Tables and Objects (15-20%)

• Create and format tables
• Manage tables and table data
• Create and modify charts

Formulas and Functions (30-35%)

• Insert and modify formulas
• Calculate and analyze data
• Use basic to intermediate functions

Data Visualization (10-15%)

• Create charts and graphs
• Apply conditional formatting
• Insert and modify visual elements

You should be comfortable with:

• Basic Excel navigation and interface
• Creating and editing basic worksheets
• Understanding simple formulas and functions
• Working with basic charts and tables
• Data entry and basic formatting

Yes! The Excel Associate certification can enhance your job prospects for roles such as:

• Administrative Assistant
• Data Entry Specialist
• Business Analyst
• Financial Coordinator
• Project Coordinator
• Office Manager

Many employers specifically look for Excel certification when hiring for positions that involve data analysis and reporting.

Most candidates spend 20-30 hours preparing for the exam. If you’re already using Excel regularly, you might need less time. However, if you’re new to Excel, you might want to plan for 40-50 hours of study and practice. The key is to get hands-on practice with all the features covered in the exam.

Your Microsoft Office Specialist: Excel Associate exam voucher, retake costs, and exam prep software, are included in the cost of your tuition. CIAT provides unlimited attempts at passing the Microsoft Office Specialist: Excel Associate certification to ensure you start your exam calm and confident, without worrying about what will happen if you don’t pass.

You save hundreds of dollars in out-of-pocket expenses over a DIY studying approach.

This certification is ideal if you:

• Are new to AI and want a non-technical introduction
• Work in business or technical roles and need to understand AI capabilities
• Want to learn about Microsoft’s AI services without needing coding skills
• Are planning a career transition into AI
• Need to understand AI concepts for project management or decision-making

The exam covers:

• AI workloads and considerations
• Fundamental AI concepts
• Machine Learning basics
• Computer Vision workloads
• Natural Language Processing
• Responsible AI principles

The beauty of AI-900 is that it requires minimal technical prerequisites:

• Basic internet browsing and computer skills
• General understanding of cloud concepts (helpful but not required)
• No coding experience needed
• No mathematics background required
• Basic English comprehension

This certification can help with roles such as:

• AI Solutions Consultant
• Business Analyst for AI projects
• Project Manager for AI initiatives
• Technical Sales Specialist

AI Product Manager Note: As an entry-level certification, it’s often combined with other qualifications or experience

Typical study times:

• Part-time study:

  2-4 weeks

• Full-time study:

  1-2 weeks

• Total study hours:

  15-30 hours

• Hands-on practice:

  5-10 hours recommended

Your Azure AI Fundamentals exam voucher, retake costs, and exam prep software, are included in the cost of your tuition. CIAT provides unlimited attempts at passing the Azure AI Fundamentals certification to ensure you start your exam calm and confident, without worrying about what will happen if you don’t pass.

You save hundreds of dollars in out-of-pocket expenses over a DIY studying approach.

The Microsoft Power BI exam focuses on analyzing data and using Power BI to discover and unlock data insights. If you enjoy using those insights to provide easy-to-understand data visualizations that can help drive the success of your team and organization, then this could be the ideal certification for you.

The Microsoft Power BI certification validates certified professionals have the skills required to facilitate data-driven business decisions, including these four core topics:

• Prepare the data

• Model the data

• Visualize and analyze the data

• Deploy and maintain assets

Before diving into Power BI, it's helpful to have a foundational understanding of some technical skills:

• Basic Data Analysis

  Understand basic data concepts like types, structures, and common analysis techniques.

• Excel Skills

  Know your way around Excel, including functions and formulas.

• Data Visualization Basics

  Learn how to create effective visualizations.

• ETL Processes

  Get familiar with extracting, transforming, and loading data.

• Data Source Understanding

  Know where your data comes from and how to access it.

• Some Programming Understanding

  Basic programming knowledge helps, especially with advanced tasks.

While you don't need to be an expert in all of these areas before learning Power BI, having a basic understanding will make it easier to grasp the concepts and techniques as you progress in your learning journey.

Individuals with an up-to-date Microsoft Power BI certification on their resume are in high demand. The technical skills validated through the certification exam will help prepare you for beginner-level to advanced-level IT career opportunities such as:

• Data Analyst

• Power BI Project Manager

• Power BI Developer

• Power BI Administrator

If you’re looking to launch or advance your career in analyzing data, Power BI is one of the most in-demand certifications for beginner to advanced-level analyst jobs.

CIAT’s Career Services team2 provides personalized career support to ensure you translate your technical training and industry certifications into viable career opportunities. Our full suite of career services support includes resume building, LinkedIn profile optimization, mock interview support, career coaching, and job placement support, and specialty workshops, to help ensure you’re positioned for success.

Students enrolled in our Business Data Analytics program feel confident taking the Microsoft Power BI exam after 18 months of technical training and exam preparation.

Applicants must have a basic understanding of data repositories and data processing both on-premises and in the cloud.

Here are two recommended certification pathways that includes the Microsoft Power BI certification:

• Associate of Applied Science in Business Data Analytics
• Applied Bachelor’s Degree in Software Development – Data Analytics Concentration

Your Power BI exam voucher, exam prep software, and certified instructor tutoring resources are included in the cost of your tuition in our Business Management Program. Save hundreds of dollars in out-of-pocket expenses over a DIY studying approach.

The CIAT Team will work closely with you to help locate and facilitate an authorized testing center near you.

In response to the COVID-19 pandemic, CIAT has enabled students to take the Microsoft Power BI certification exam remotely from the comfort of their own home through Microsoft’s new “Test Anywhere” process. Don’t put your goals on hold!

Studying for the Power BI certification on your own is doable, but often leaves you without the required technical skills in your background, or the necessary resources to translate your exam score into an IT career.

Join over 2,000 students who have enrolled in CIAT accredited Certificate and Degree programs and are on their path to launching or advancing their IT careers. Our extensive, custom designed IT curriculum provides training for up to 14 industry certifications, including Microsoft Power BI Certification.

• No exam fees
• Unlimited exam attempts*
• Hands-on training through virtual online classes
• Online test preparation workshops
• Test preparation software
• One-on-one support from certified instructors
• Accredited Certificate and Degree programs to beef up your resume
• Personalized career services support including resume building and job placement support

* Students are encouraged to take certification exams while actively enrolled in the degree program. Unlimited certification exam attempts expire 90 days after graduation. The following are single attempt exams and are not eligible for a retake voucher: CEH, CASP, CISSP, DevNet & CCNP. See certification exam policy for more details.

The Microsoft Certified: Power BI Data Analyst Associate exam code is PL-300.

The minimum passing score required for the Microsoft PL-300 exam is 700.