Microsoft Training in Abu Dhabi

Microsoft 365 offers a comprehensive suite of cloud-based tools designed to enhance productivity and collaboration, featuring key applications such as Teams, OneDrive, Planner, and Copilot to streamline modern workplace operations.

This instructor-led training session, available either online or onsite, is designed for intermediate-level professionals looking to leverage Microsoft 365 capabilities to boost productivity, strengthen governance, and improve cross-team collaboration.

After completing this course, participants will be able to:

• Configure and manage Teams to foster effective team collaboration and optimize meeting practices.
• Utilize OneDrive for secure file storage, seamless sharing, and robust version control.
• Plan and monitor workloads using Planner while integrating tasks directly into team workflows.
• Harness Copilot to accelerate document creation, generate meeting summaries, and extract valuable data insights.

Course Format

• Engaging interactive demonstrations paired with guided, hands-on lab exercises.
• Scenario-based activities that mirror real-world organizational workflows.
• Practical sessions focused on configuration, governance strategies, and best practices for user adoption.

Customization Options

• We can customize examples, governance checklists, and hands-on labs to align with your organization's specific policies and environment.

Microsoft 365 offers a robust ecosystem of tools designed to build enterprise-grade knowledge management systems. By integrating SharePoint, Teams, Power Automate, and Power BI, organizations can effectively organize, connect, and visualize their information. This course delves into the creation of dynamic intranet dashboards, the linking of diverse data sources, and the implementation of structured workflows to boost collaboration and facilitate seamless knowledge sharing across teams.

This instructor-led, live training is available online or onsite, targeting advanced professionals seeking to develop and oversee sophisticated knowledge management frameworks using Microsoft 365 capabilities.

Upon completion of this training, participants will be equipped to:

• Architect advanced knowledge management systems utilizing Microsoft 365 tools.
• Construct interconnected SharePoint sites and Teams channels to streamline information flow.
• Automate content workflows through Power Automate.
• Create Power BI dashboards for effective knowledge visualization and reporting.
• Enhance governance, access controls, and version management across shared repositories.

Course Format

• Engaging interactive lectures and discussions.
• Numerous exercises and practical implementation scenarios.
• Hands-on configuration within a live Microsoft 365 environment.

Customization Options

• For tailored training needs regarding this course, please contact us to arrange a customized schedule.

Microsoft Intune serves as a cloud-based endpoint management solution that empowers organizations to securely oversee users, devices, and applications. It offers extensive tools for configuration, compliance, and protection across Windows, macOS, iOS, and Android platforms.

This instructor-led, live training (available online or onsite) is designed for IT professionals with intermediate to advanced expertise who aim to deploy, configure, and manage enterprise devices using Microsoft Intune and associated Microsoft 365 technologies.

Upon completing this training, participants will be equipped to:

• Implement and manage Microsoft Intune for endpoint management.
• Configure device enrollment, compliance, and security policies.
• Deploy and safeguard enterprise applications using Intune.
• Integrate Intune with Microsoft 365, Entra ID, and Defender for Endpoint for unified management.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practical activities.
• Hands-on implementation within a live-lab environment.

Course Customization Options

• To request a tailored training for this course, please contact us to arrange.

Microsoft 365 serves as a comprehensive suite of integrated productivity tools designed to facilitate collaboration, deliver data-driven insights, and automate workflows through applications such as Excel, Word, PowerPoint, Outlook, and Copilot.

This instructor-led live training, available either online or onsite, is tailored for intermediate-level professionals eager to master Microsoft 365 tools and AI-powered features to enhance decision-making, communication, and overall organizational efficiency.

Upon completing this training, participants will be equipped to:

• Utilize advanced Excel techniques and automation tools to support business and leadership decisions.
• Craft impactful PowerPoint presentations by leveraging storytelling and data visualization techniques.
• Create, format, and collaborate on professional documents in Word with the assistance of Copilot.
• Boost productivity and time management by using Outlook and AI-driven features across the Microsoft 365 ecosystem.

Format of the Course

• Interactive lectures and discussions.
• Hands-on exercises and scenario-based practice.
• Practical application of Microsoft 365 tools within a live-lab environment.

Course Customization Options

• To request customized training for this course, please contact us to arrange it.

Microsoft To Do is a cloud-based task management application designed to help individuals and teams organize, prioritize, and manage tasks across devices with seamless integration into Microsoft 365.

This instructor-led, live training (available online or onsite) is aimed at beginner to intermediate-level professionals who wish to leverage Microsoft To Do not only for personal productivity but also as a powerful collaborative tool integrated with Microsoft 365 applications.

Learning Objectives

By the end of this training, participants will be able to:

• Set up and configure Microsoft To Do across devices and integrate it with Microsoft 365.
• Create, organize, and prioritize tasks and lists for both personal and team use.
• Collaborate effectively by sharing lists, assigning tasks, and monitoring progress.
• Enhance workflows by using Microsoft To Do alongside Outlook, Teams, and Planner.
• Apply productivity best practices and advanced techniques for long-term adoption.

Format of the Course

• Interactive lecture and discussion.
• Hands-on exercises and guided labs.
• Practical team collaboration simulations.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Microsoft To Do is a cloud-based task management application designed to help individuals and teams organize, prioritize, and manage tasks across devices with seamless integration into Microsoft 365.

This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to use Microsoft To Do to manage tasks effectively, boost productivity, and collaborate better with teams.

By the end of this training, participants will be able to:

• Set up and configure Microsoft To Do for personal and team use.
• Create, organize, and prioritize tasks efficiently.
• Integrate To Do with Outlook, Teams, and other Microsoft 365 tools.
• Apply productivity best practices using To Do features.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Microsoft System Center Data Protection Manager (DPM) serves as Microsoft's enterprise-grade backup and recovery solution designed to safeguard critical workloads, including file servers, databases, and virtual machines.

This instructor-led live training, available online or on-site, targets intermediate-level IT professionals seeking to deploy, configure, and manage DPM to ensure data protection and maintain business continuity.

Upon completion of this training, participants will be equipped to:

• Install and configure DPM servers and agents.
• Create and manage protection groups effectively.
• Execute backup and recovery operations.
• Integrate DPM with other disaster recovery solutions.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practical practice.
• Hands-on implementation within a live-lab environment.

Customization Options

• To request customized training for this course, please contact us to arrange your needs.

This live, instructor-led training in Abu Dhabi (online or onsite) is aimed at beginner to intermediate business users who wish to improve their productivity and digital collaboration using Microsoft Teams, OneDrive, and Outlook.

Upon completion of this training, participants will be equipped to:

• Create, manage, and utilize teams and channels in Microsoft Teams effectively.
• Utilize tags, mentions, and app integrations in Teams to streamline communication.
• Store, organize, and securely share files in OneDrive by following best practices.
• Recover documents via version history and collaborate on files in real time.
• Use Outlook for advanced email management and shared calendar scheduling.

This instructor-led, live training in Abu Dhabi (online or onsite) is tailored for beginner to intermediate users who wish to boost team productivity and streamline daily workflows using Outlook, OneDrive, Teams, Planner, and Forms.

Upon completing this training, participants will be able to:

• Effectively organize and manage communications using Outlook.
• Store, share, and collaborate on files using OneDrive.
• Conduct meetings, chats, and team collaboration with Microsoft Teams.
• Plan and track tasks efficiently using Microsoft Planner.
• Create and analyze online surveys and quizzes with Microsoft Forms.

Microsoft Exchange Server serves as a robust messaging platform, delivering essential functionalities such as email, calendar management, contacts, and task organization.

This instructor-led live training, available either online or onsite, is designed for IT professionals with intermediate expertise who aim to install, configure, manage, and troubleshoot Microsoft Exchange Server environments.

Upon completion of this training, participants will be capable of:

• Installing and configuring Microsoft Exchange Server.
• Implementing disaster recovery protocols and anti-malware safeguards.
• Configuring message transport and facilitating migration to Exchange Online.
• Troubleshooting technical issues and ensuring server availability.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practical activities.
• Hands-on implementation within a live laboratory environment.

Course Customization Options

• To request customized training for this course, please reach out to us to arrange the details.

Microsoft OneNote serves as a digital notebook application designed to help users organize, share, and collaborate on information across teams and devices.

This instructor-led live training, available online or onsite, targets professionals with limited or emerging experience in OneNote who manage or coordinate digital information. The course aims to equip them with the skills to effectively use Microsoft OneNote for organizing notes, coordinating team knowledge, and enhancing collaborative workflows.

Upon completing this training, participants will be able to:

• Organize personal and team notes using notebooks, sections, and pages.
• Share and collaborate in real-time on OneNote content.
• Embed and link files, emails, and meeting notes into a unified workspace.
• Integrate OneNote with Microsoft 365 apps like Teams, Outlook, and Planner.

Format of the Course

• Interactive lecture and discussion.
• Hands-on use of Microsoft OneNote in sample collaboration scenarios.
• Guided exercises focused on note-taking, content organization, and teamwork.

Course Customization Options

• To request a customized training for this course based on your department's workflows or internal tools, please contact us to arrange.

This instructor-led, live training in Abu Dhabi (online or onsite) is designed to help participants prepare for the Microsoft Azure Data Engineer certification exam (DP-203).

The course covers the basics of Azure data services and how they can be used to process, store, and manage data in the cloud. Participants will learn how to create data processing solutions using Azure Data Factory, Azure Stream Analytics, and Azure Databricks, and how to work with NoSQL databases using Azure Cosmos DB.

This instructor-led, live training in Abu Dhabi (online or onsite) is designed for beginner-level leadership teams who want to effectively manage and coordinate tasks using Microsoft Planner and related tools, fostering enhanced productivity and collaboration across the organization.

By the end of this training, participants will be able to:

• Effectively create, manage, and track tasks and projects using Microsoft Planner, enhancing team coordination and project visibility.
• Organize and prioritize individual tasks, share task lists, and collaborate on tasks using Microsoft To Do.
• Utilize Microsoft Loop components for real-time collaboration, integrating them seamlessly into projects and meetings, and enhancing communication and information sharing among team members.
• Design and manage custom lists tailored to specific project needs, automate workflows, and integrate Lists with other Microsoft 365 tools for more efficient task tracking.

This instructor-led, live training in Abu Dhabi (online or onsite) is aimed at beginner-level business professionals who wish to gain the skills necessary to utilize Teams, Word, and Excel effectively in a management context.

By the end of this training, participants will be able to:

• Gain a comprehensive understanding of Microsoft 365
• Navigate and utilize Microsoft Teams for communication, collaboration, and project management.
• Develop proficiency in creating, formatting, and managing Word documents.
• Use Excel for data entry, manipulation, and analysis.
• Explore how to integrate Microsoft 365 applications for seamless workflows.

This instructor-led, live training in Abu Dhabi (online or in-person) is aimed at helping candidates prepare for the Microsoft Azure DevOps Engineer certification exam (AZ-400).

The program covers the core concepts of DevOps practices and their execution on the Azure platform. Learners will gain proficiency in using Azure DevOps to manage code repositories, construct and release pipelines, and deploy continuous integration and continuous delivery (CI/CD) strategies.

This instructor-led, live training in the UAE (online or onsite) is designed to help participants prepare for the Microsoft Azure Solutions Architect Expert (AZ-305) certification exam.

The course covers advanced concepts of cloud computing and Azure services. It provides a comprehensive introduction to Azure solutions architecture, including its principles, components, and services. Participants will also learn how to design and deploy Azure solutions using best practices and industry standards.

This course covers various methods and best practices aligned with business and technical requirements for modeling, visualizing, and analyzing data using Power BI. It demonstrates how to access and process data from diverse sources, including both relational and non-relational databases. The curriculum also explores implementing robust security standards and policies across the Power BI ecosystem, covering datasets and groups. Additionally, it addresses the management and deployment of reports and dashboards for effective sharing and content distribution.

Excel serves as a powerful spreadsheet application designed for data input, analysis, reporting, and process automation.

This instructor-led live training, available both online and onsite, targets users ranging from beginners to advanced professionals who aim to build confidence and mastery over Excel's essential, intermediate, and advanced functionalities.

Upon completing this training, participants will be equipped to:

• Navigate spreadsheets, formulas, and formatting with confidence.
• Utilize intermediate tools including tables, charts, and conditional logic.
• Implement advanced functions, data analysis features, and automation strategies.
• Develop professional worksheets that facilitate informed business decision-making.

Course Format

• Instructor-led demonstrations paired with guided explanations.
• Comprehensive workbook exercises and hands-on practice sessions.
• Practical lab activities grounded in real-world spreadsheet scenarios.

Customization Options

• For tailored content aligned with your department’s specific workflows, please reach out to us to arrange a customized version of this course.

This live, instructor-led training session held in Abu Dhabi (online or on-site) is designed to aid participants in their preparation for the Microsoft Azure Security Engineer Associate (AZ-500) certification exam.

The course explores various Azure security subjects, including identity and access management, platform protection, data and application security, and operational management.

Microsoft System Center Operations Manager (SCOM) serves as a robust monitoring solution engineered to guarantee the availability, performance, and reliability of IT services across datacenters and applications.

This instructor-led, live training (available online or onsite) is designed for intermediate-level IT professionals aiming to deploy, configure, and manage SCOM for enterprise-level monitoring and alerting.

Upon completing this training, participants will gain the ability to:

• Install and configure System Center Operations Manager.
• Establish monitoring rules, alerts, and reports.
• Integrate SCOM with other System Center components.
• Troubleshoot and optimize performance within monitored environments.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practical applications.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• For a customized training version of this course, please contact us to make arrangements.

Excel is a widely utilized spreadsheet application designed for organizing data, performing analysis, and automating tasks.

This instructor-led live training, available both online and onsite, is tailored for intermediate Excel users who want to leverage Excel for inventory control, budgeting, reporting, and automation using real-world datasets.

Upon completing this training, participants will be able to:

• Utilize formulas such as SUMIF, IF, VLOOKUP, and SUMIFS for inventory and procurement scenarios.
• Efficiently manage and analyze large datasets containing 5,000 or more rows.
• Construct and interpret pivot tables for monthly and cumulative tracking.
• Automate repetitive reporting tasks using macros.
• Monitor material purchases versus consumption using structured templates.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practical practice.
• Hands-on implementation in a live laboratory environment.

Course Customization Options

• To request customized training for this course, please contact us to arrange the details.

This instructor-led, live training in Abu Dhabi (online or onsite) is designed for intermediate-level IT professionals seeking to manage and secure their organization's IT environment using Microsoft 365.

By the end of this training, participants will be able to:

• Deploy and manage Microsoft 365 services such as Intune, MDM, and Autopilot.
• Configure and enforce security policies using Windows Defender and other Microsoft 365 security tools.
• Monitor and troubleshoot devices and applications within a Microsoft 365 environment.
• Understand and implement compliance and data protection measures in Microsoft 365.
• Manage Microsoft 365 security services such as Microsoft Secure Score, Exchange Online Protection, Safe Attachments, and Safe Links.
• Implement compliance solutions using Microsoft Purview, data loss prevention, and sensitivity labels.

This instructor-led, live training in Abu Dhabi (online or onsite) is designed to help participants prepare for the Microsoft Azure Developer Associate (AZ-204) certification exam.

The course covers the concepts of developing Azure solutions, including Azure compute, storage, and security features. It provides a comprehensive introduction to Azure development, including tools and services for building, testing, and deploying applications.

This instructor-led, live training in Abu Dhabi (online or onsite) is designed for data analysts at beginner to advanced levels who wish to use Excel to perform a variety of tasks such as data entry, formula creation, data analysis, and advanced automation.

By the end of this training, participants will be able to:

• Navigate Excel’s interface and perform basic data entry, formatting, and calculations.
• Apply advanced formulas, functions, and conditional formatting for data analysis.
• Create and manage pivot tables and charts for data visualization.
• Use tools like Power Query, Power Pivot, and perform data analysis.
• Automate tasks using macros and VBA to streamline workflows.

This instructor-led, live training in Abu Dhabi (online or onsite) targets beginner to intermediate professionals who wish to improve their productivity and efficiency by leveraging the advanced features of Excel and Google Sheets for data organization, analysis, and collaboration.

By the end of this training, participants will be able to:

• Navigate and utilize the core features of Excel and Google Sheets.
• Perform data analysis and create actionable insights using advanced spreadsheet techniques.
• Collaborate in real-time using Google Sheets for seamless teamwork.
• Create reusable templates for reporting, tracking, and project management.

This instructor-led, live training in Abu Dhabi (online or onsite) is designed for intermediate-level IT professionals who aim to manage and safeguard their organization's IT infrastructure using Microsoft 365.

Upon completing this training, participants will be equipped to:

• Deploy and manage Microsoft 365 services, including Intune, MDM, and Autopilot.
• Configure and enforce security policies utilizing Windows Defender and other Microsoft 365 security tools.
• Monitor and troubleshoot devices and applications within a Microsoft 365 ecosystem.
• Understand and implement compliance and data protection protocols in Microsoft 365.
• Apply best practices for Microsoft 365 administration and security.

This instructor-led, live training in Abu Dhabi (online or onsite) is specifically structured to assist participants in preparing for the Microsoft Azure Administrator Associate (AZ-104) certification examination.

The curriculum addresses the essential competencies needed to administer Azure resources, encompassing Azure virtual machines, storage solutions, and Azure network management.

This instructor-led, live training in Abu Dhabi (online or onsite) is designed for data analysts and anyone eager to learn how to use Excel for creating data models for data analysis.

Upon completion of this training, participants will be able to:

• Analyze and resolve business challenges using structured problem-solving techniques.
• Navigate Excel tools confidently and efficiently.
• Effectively set up, format, and present data.
• Grasp the logical framework of Excel models and apply appropriate functions.

This instructor-led, live training in Abu Dhabi (delivered online or onsite) is designed to help participants prepare for the Microsoft Azure Fundamentals (AZ-900) certification exam.

The course covers the basic concepts of cloud computing and Azure services. It provides a comprehensive introduction to Azure, including its architecture, pricing and support, and the most commonly used Azure services.

Participants will gain the ability to efficiently leverage core data analysis tools like scenarios and pivot tables, utilize functions for date calculations and text processing, and develop and customize macros to automate spreadsheet workflows.

Excel is a widely used spreadsheet program developed by Microsoft. It is utilized for storing, organizing, and analyzing data in a tabular format. Below are some key features and functions of Excel: 1. Spreadsheets: It consists of sheets, where each sheet is an array composed of cells arranged in rows and columns. It allows the creation of multiple sheets within a single file, enabling the organization of various data sets. 2. Calculations and Formulas: It enables performing diverse mathematical, statistical, and logical calculations using formulas. It includes a wide range of built-in functions, such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, etc. 3. Data Formatting and Appearance: It provides tools for formatting data, including changing fonts, colors, styles, and creating charts, pivot tables, and diagrams. 4. Sorting, Filtering, and Grouping: It allows sorting data based on specific criteria. It enables filtering data to display only selected information. It offers the ability to group data according to specific needs. 5. Data Analysis: It includes tools for conducting advanced analyses, such as scenario analysis, trend analysis, forecasting, and creating macros. 6. Data Sharing: It facilitates sharing and collaborating on data in real time, allowing multiple users to work on the same data simultaneously. 7. Task Automation: It allows creating macros and automating tasks using the VBA (Visual Basic for Applications) programming language. Excel is extensively used in various fields, from business to science and education. Its versatile features enable data analysis, report generation, budgeting, scheduling, data management, and many other applications.

Delivered by an instructor via live online or onsite sessions in Abu Dhabi, this training targets data analysts seeking to use VBA in Excel for automation purposes.

By the end of this training, participants will be able to:

• Record and edit macros as required.
• Write procedures using data from the sheet.
• Create your own functions.
• Handle an event (opening worksheet cell update etc.) by means of the handler.
• Create a form.

This instructor-led live training in Abu Dhabi (online or onsite) is designed for data analysts who wish to acquire skills in preparing data using Excel and visualizing it through Power BI.

By the conclusion of this training, participants will be able to:

• Understand the principles, objectives, and approaches of data analysis.
• Apply DAX formulas in Power BI for complex calculations.
• Create and utilize visualizations and charts for specific analysis cases.
• Import data using Power View to transition from Excel-based Power BI to standalone Power BI.

Streamline workflows and develop robust desktop applications using VBA across Microsoft Excel and Access. This comprehensive training program covers programming fundamentals, object-oriented coding, SQL database design, user interface development, debugging techniques, error handling, and advanced Excel analysis routines through practical exercises — empowering analysts, financial professionals, and developers to eliminate manual tasks and unlock advanced data management and reporting capabilities.

Microsoft Excel is a robust spreadsheet application designed for organizing, analyzing, and visualizing data.

This instructor-led live training, available online or onsite, targets beginner-level data analysts looking to leverage Excel for data analysis and reporting.

Upon completing this course, participants will be equipped to:

• Create and manage spreadsheets effectively in Excel.
• Format and organize data to enhance clarity and operational efficiency.
• Utilize formulas and functions to automate complex calculations.
• Visualize data through charts, tables, and conditional formatting.
• Collaborate and securely share workbooks within the Microsoft 365 ecosystem.

Course Delivery Format

• Interactive lectures coupled with group discussions.
• Extensive hands-on exercises and practice sessions.
• Practical implementation within a live laboratory environment.

Customization Options

• For inquiries regarding customized training arrangements for this course, please reach out to us directly.

This Excel training program for financial analysis equips finance professionals with advanced spreadsheet techniques. The curriculum includes lookup functions, search formulas, PivotCharts, conditional formatting, external data workflows, and securities analysis. It delves into practical methods for evaluating time value of money concepts, identifying market trends, building financial forecasting models, and utilizing Excel's comprehensive analytical toolkit for complex financial computations and reporting.

This course on Analyzing Financial Data in Excel empowers financial analysts and accountants with sophisticated techniques to automate intricate calculations and reporting processes. It covers essential principles of financial functions, INDEX-MATCH lookups, database queries, PivotTables, PivotCharts, and integrating external data. Participants will explore tools such as Goal Seek, Solver, Analysis ToolPak, and VBA macros to streamline repetitive tasks. This training enables professionals to convert raw data into actionable financial insights and precise forecasts, supporting strategic decision-making.

This course expands on the foundational concepts covered in the Microsoft® Office Excel® 2019: Part 1 curriculum, guiding you toward the creation of sophisticated workbooks and worksheets. These tools are essential for deepening your grasp of organizational intelligence. The capacity to analyze vast amounts of data, extract actionable insights, and effectively present them to decision-makers forms the backbone of a successful organization capable of high-level competition.

Learning Objectives

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

You will:

• Work with functions.
• Work with lists.
• Analyze data.
• Visualize data with charts.
• Use PivotTables and PivotCharts.

This course is designed to equip you with the essential foundational knowledge and skills in Excel, serving as a springboard for your journey toward data manipulation expertise. Excel empowers you to organize, calculate, analyze, revise, update, and present your data in ways that enable organizational decision-makers to guide your strategy effectively. Furthermore, it significantly enhances your efficiency, allowing you to complete these tasks much faster and with greater ease than traditional pen-and-paper methods or generic software would permit.

Learning Objectives

Upon successful completion of this course, you will be capable of creating and developing Excel worksheets and workbooks to effectively work with and analyze the critical data driving your organization's success.

• You will:
• Begin working with Microsoft Office Excel 2019.
• Execute calculations.
• Modify worksheets.
• Format worksheets.
• Print workbooks.
• Manage workbooks.

This course expands on the foundational and intermediate concepts covered in the Microsoft® Office Excel® Basic and Microsoft® Office Excel® Intermediate courses, designed to help you maximize your Excel capabilities. By mastering the ability to collaborate with colleagues, automate complex or repetitive tasks, and apply conditional logic to build sophisticated formulas and functions, you will have the full power of Excel at your fingertips. As you gain proficiency in leveraging Excel to handle heavy lifting, you can shift your focus to deriving critical insights from the extensive data generated by your organization.

Learning Objectives

Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

• You will:
• Work with multiple worksheets and workbooks.
• Share and protect workbooks.
• Automate workbook functionality.
• Use Lookup functions and formula auditing.
• Forecast data.
• Create sparklines and map data.

About This Course

Over the course of five days, this program equips you with the essential knowledge and skills required to plan and manage a Microsoft SharePoint 2016 environment. You will learn how to deploy, administer, and troubleshoot your SharePoint setup. Additionally, the course provides guidelines, best practices, and strategic considerations to help you optimize your SharePoint deployment.

This course is the first in a two-part sequence designed for IT professionals and aligns with the SharePoint 2016 IT Pro certification.

Audience Profile

The training is designed for experienced IT professionals interested in learning how to install, configure, deploy, and manage SharePoint 2016 installations, whether in a data center or in the cloud.

Typical participants possess over one year of hands-on experience* in planning and maintaining SharePoint, along with two years of experience with core underlying technologies, including Windows Server 2012 R2 or later, Internet Information Services (IIS), Microsoft SQL Server 2014 or later, Active Directory Domain Services (AD DS), and networking infrastructure services.

The minimally qualified candidate typically:

• Is an IT professional responsible for planning, implementing, and maintaining a multi-server deployment of SharePoint 2016.
• Has a working knowledge of, and preferably hands-on experience with, SharePoint Online.
• Demonstrates broad familiarity with SharePoint workloads.
• Has experience in business continuity management, including data backup, restoration, and high availability.
• Is experienced with authentication and security technologies.
• Has experience with Windows PowerShell.

* The hands-on or job experience should be from a solutions-based role where the candidate has worked on multiple solutions in the SharePoint space, including document management, content management, and search.

At Course Completion

• Describe the key features of SharePoint 2016.
• Design an information architecture for a SharePoint 2016 deployment.
• Design a logical architecture for a SharePoint 2016 deployment.
• Design the physical architecture for a SharePoint 2016 deployment.
• Install and configure SharePoint 2016.
• Create and configure web applications and site collections.
• Plan and configure service applications for a SharePoint 2016 deployment.
• Manage users and permissions, and secure content in a SharePoint 2016 deployment.
• Configure authentication in a SharePoint 2016 deployment.
• Configure platform and farm-level security in a SharePoint 2016 deployment.
• Manage information taxonomy in SharePoint web applications and site collections.
• Configure and manage user profiles and audiences.
• Configure and manage the search experience in SharePoint 2016.
• Monitor, maintain, and troubleshoot a SharePoint 2016 deployment.

Participants will gain the ability to efficiently execute a wide range of calculations with full transparency to organize and present their findings. The course covers various mechanisms designed to streamline and accelerate spreadsheet creation, while also teaching how to safeguard calculations and their results from unauthorized access.

Participants will enhance their capabilities to create, consolidate, and manage data in the most efficient manner. A range of specialized tools is introduced to streamline workflows, significantly reducing the time spent on routine activities and enabling you to design applications capable of performing new tasks.

Elevate your VBA proficiency to an intermediate level by exploring custom interfaces, complex data types, conditional logic, looping structures, and professional debugging strategies. This practical Excel VBA training focuses on robust error handling, performance optimization, VBA UserForms, and workflow automation through real-world exercises, bridging the gap between basic macros and advanced automation solutions for data analysts, reporting specialists, and business users aiming to leverage enterprise-grade spreadsheet capabilities.

Achieve mastery in Microsoft Excel through this specialized professional training program aimed at boosting your spreadsheet efficiency and productivity. Gain essential skills such as editing worksheets, managing workbooks, constructing complex formulas using powerful functions, formatting cells, designing professional charts and graphs, working with PivotTables and data lists, and handling graphic objects. Suitable for business analysts, accountants, data handlers, and office professionals looking to advance their Excel proficiency from intermediate to expert level. Enhance your data analysis capabilities, streamline reporting workflows, and harness the full power of Microsoft Excel for improved decision-making and workplace productivity.

This instructor-led, live training in Abu Dhabi (online or onsite) is aimed at beginner-level analysts who wish to use Excel VBA to automate repetitive work, clean and transform data, and improve reporting processes.

By the end of this training, participants will be able to: record and edit macros, write simple VBA procedures, work with Excel objects for reporting tasks, and debug basic automation solutions.

This five-day Advanced Excel for Sales Professionals course is crafted to empower sales teams with the essential skills to manage, analyze, and automate sales data efficiently. Participants will master advanced Excel functions, data analysis methodologies, and automation tools to improve reporting accuracy, develop dynamic dashboards, and forecast sales performance. Through practical, hands-on exercises, sales professionals will acquire actionable insights into constructing interactive sales reports, automating routine tasks, and utilizing advanced tools such as Power Query, Power Pivot, and Macros. This course is particularly suited for those aiming to leverage Excel to drive data-centric sales strategies.

This training program equips IT professionals with the skills to manage Azure subscriptions, secure identities, administer infrastructure, configure virtual networking, link Azure with on-premises environments, manage network traffic, implement storage solutions, deploy and scale virtual machines, establish web applications and containers, back up and share data, and monitor overall solution performance.

Designed specifically for Azure Administrators, this course covers the implementation, management, and monitoring of identity, governance, storage, compute, and virtual networks within cloud environments. Azure Administrators will learn how to provision, size, monitor, and optimize resources effectively.

This instructor-led, live training in Abu Dhabi (online or onsite) is designed for beginner to intermediate business analysts and data analysts who aim to leverage Excel for performing data analysis and reporting in their projects and tasks.

Upon completion of this training, participants will be able to:

• Utilize Excel formulas and functions to execute calculations and manipulate data.
• Employ Excel data analysis tools, including PivotTables, What-If Analysis, and Forecasting, to summarize and visualize data effectively.
• Create and customize data visualizations using Excel charts and graphs.
• Apply Excel data validation and conditional formatting to ensure data quality and highlight key insights.
• Use Excel's data import and export capabilities to connect with external data sources and share information with others.

This course is intended for individuals aiming for the Microsoft 365 Administrator role who have completed at least one of the Microsoft 365 role-based administrator certification paths.

This five-day, instructor-led course is tailored primarily for IT professionals who possess prior experience with Windows Server. It is designed for individuals tasked with managing identity, networking, storage, and compute resources using Windows Server 2019, requiring a thorough understanding of the available scenarios, requirements, and options applicable to this platform. The course equips IT professionals with the fundamental administration skills necessary to deploy and support Windows Server 2019 in most organizational environments.