Microsoft To Do Essentials - 1 Day Training Course

About This Course

This three-day, instructor-led programme is designed for individuals aiming to transition into a database professional role or whose current responsibilities are expanding to include database-related tasks. The course covers essential database concepts, such as different database types, database languages, and database design principles.

Audience Profile

The primary audience for this course consists of professionals who are moving into a database-focused role or whose job functions have expanded to encompass database technologies.

At Course Completion

Upon completing this course, learners will be able to:
• Describe core database concepts within the context of SQL Server 2016
• Explain the database languages utilised in SQL Server 2016
• Describe data modelling techniques
• Explain normalization and denormalization techniques
• Describe relationship types and their impact on database design
• Describe how database design affects performance
• Identify commonly used database objects

About This Course

This is a three-day Instructor Led Training (ILT) programme designed for information technology (IT) professionals who are involved in the administration, configuration, troubleshooting, and operation of Office 365 services. The curriculum covers essential aspects such as identities, dependencies, requirements, and supporting technologies. The course emphasises the skills needed to manage and resolve issues within an Office 365 tenant and its core services, including Exchange Online, SharePoint Online, and Teams. It also addresses the security and compliance capabilities of Office 365.

Audience Profile

This course is ideal for IT professionals and system administrators seeking to master administration and troubleshooting techniques in Office 365. Participants should possess a minimum of three years of experience in their respective domains, preferably with backgrounds in system administration, network administration, and messaging.

At Course Completion

Upon successfully completing this course, learners will be able to:

• Describe Office 365 services.
• Administer Office 365 using the Microsoft 365 admin center and Office 365 services admin centers, an
• Administer and troubleshoot directory synchronization and directory objects.
• Administer and troubleshoot Exchange Online.
• Administer and troubleshoot Teams.
• Administer and troubleshoot SharePoint Online.
• Plan and deploy Microsoft 365 Apps for enterprise.
• Administer and troubleshoot compliance and security in Office 365.

About This Course

This five-day programme equips you with the necessary knowledge and skills to plan and administer a Microsoft SharePoint 2016 environment. You will learn how to deploy, manage, and troubleshoot your SharePoint infrastructure. Additionally, the course provides guidelines, best practices, and key considerations to help you optimize your SharePoint deployment.

This is the first of a two-course sequence designed for IT professionals, aligning with the SharePoint 2016 IT Pro certification.

Audience Profile

The course is aimed at experienced IT professionals seeking to learn how to install, configure, deploy, and manage SharePoint 2016 installations in either a data centre or cloud environment.

Typical students possess more than one year of hands-on experience* in planning and maintaining SharePoint, along with two years’ experience with core technologies that SharePoint relies on, 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.
• Is broadly familiar with SharePoint workloads.
• Has experience with business continuity management, including data backup, restoration, and high availability.
• Has experience with authentication and security technologies.
• Has experience with Windows PowerShell.

* The hands-on experience or job experience should be from a solutions-based role where the candidate has worked on multiple solutions in the SharePoint space that includes 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.

Upon completion, participants will be able to efficiently execute various calculations transparently to organize and present their results. They will utilize multiple tools to facilitate and accelerate spreadsheet creation, as well as safeguard their calculations and outcomes from unauthorized access.

Participants will be empowered to excel in their work by efficiently creating, consolidating, and managing data. This course introduces powerful tools designed to streamline workflows, significantly reducing the time spent on tasks compared to previous methods. Learners will gain the skills to design applications capable of performing new and complex tasks.

Elevate your VBA proficiency to the intermediate tier through comprehensive coverage of custom interfaces, sophisticated data types, conditional logic, looping structures, and expert debugging strategies. This practical Excel VBA training equips you with robust error handling techniques, performance optimization skills, VBA UserForms development, and workflow automation capabilities via real-world exercises. Designed to bridge the gap between basic macros and advanced automation solutions, this course empowers data analysts, reporting professionals, and business users to harness enterprise-grade spreadsheet functionalities.

Master Microsoft Excel through this professional training course designed to boost your spreadsheet efficiency and productivity. Gain essential skills in editing worksheets, managing workbooks, building complex formulas using powerful functions, formatting cells, creating professional charts and graphs, working with PivotTables and data lists, and handling graphic objects. This course is ideal for business analysts, accountants, data handlers, and office professionals looking to advance their Excel proficiency from an intermediate to an expert level. Enhance your data analysis capabilities, streamline reporting workflows, and unlock the full power of Microsoft Excel to drive better decision-making and workplace productivity.

In this whiteboard design session, you will learn how to design a solution with a combination of Azure Resource Manager templates and Azure DevOps to enable continuous delivery with several Azure PaaS services.

At the end of this workshop, you will be better able to build templates to automate cloud infrastructure and reduce error-prone manual processes. In addition, you'll create an Azure Resource Manager (ARM) template to provision Azure resources, configure continuous delivery with Azure DevOps, configure Application Insights into an application, and create an Azure DevOps project and Git repository.

This programme equips IT Professionals with the skills to manage Azure subscriptions, secure identities, administer infrastructure, configure virtual networking, connect Azure with on-premises environments, manage network traffic, implement storage solutions, create and scale virtual machines, deploy web apps and containers, back up and share data, and monitor solutions.

Designed for Azure Administrators, this course covers the implementation, management, and monitoring of identity, governance, storage, compute, and virtual networks within a cloud environment. Azure Administrators will learn to provision, size, monitor, and adjust resources as necessary.

About This Course

The Dynamics 365 Finance and Operations applications encompass, among others, Dynamics 365 Finance, Dynamics 365 Supply Chain Management, and Dynamics 365 Supply Chain Management, Manufacturing. Dynamics 365 Finance empowers you to: Automate and modernize global financial operations. Monitor performance in real time, predict future outcomes, and make data-driven decisions to drive business growth. Drive strategic financial decisions with artificial intelligence (AI), unify and automate your financial processes, reduce operational expenses, and decrease global financial complexity and risk. Dynamics 365 Supply Chain Management helps you to: Transform your manufacturing and supply chain operations. Use predictive insights and intelligence from AI and the Internet of Things (IoT) across planning, production, inventory, warehouse, and transportation management. Maximize operational efficiency, product quality, and profitability. Innovate with intelligent manufacturing operations, modernize warehouse management, optimize production performance, maximize the life of your assets, and automate and streamline your supply chain. Note: For more information, please refer to https://docs.microsoft.com/learn/paths/get-started-finance-operations/ In this module, we will focus on the core features and functionality for Dynamics 365 Dynamics 365 Finance apps that are most used by end users and consultants.

Audience Profile

A Dynamics 365 for Finance and Operations Functional Consultant is responsible for performing discovery, capturing requirements, engaging subject matter experts and stakeholders, translating requirements, and configuring the solution and applications. The Functional Consultant implements a solution using out of the box capabilities, codeless extensibility, application and service integrations.

At Course Completion

After completing this course, students will be able to:

• How to navigate and efficiently use search, filtering and queries
• How to use operational workspaces
• Work with Business Document Management
• Work with record templates
• Integrate Power BI with Dynamics 365 Finance and Operations apps
• How to personalize workspaces
• Identify when to use Power Platform in Dynamics 365 Finance and Operations app.
• How to apply security roles to users
• Run and analyze security reports
• Create and use workflow for approval
• Work with Organization Hierarchy and its purposes.
• How to use personalization feature
• Use Data Management workspace
• Create and use and entity templates
• Copy configuration data between legal entities
• Import and Export data and manage data by using Office Integration
• Use Regression Suite Automation Tool (RSAT)
• Create User acceptance Tests (UAT) and test plans
• Create and work with Business Process Modeler (BPM)
• Understand how to use Issue search

About This Course

This developer training programme focuses on equipping Microsoft Dynamics 365 Finance and Operations Apps Developers to implement and extend applications in alignment with business requirements. Candidates will learn to deliver comprehensive solutions by leveraging standardized application coding patterns, extensible features, and external integrations.

Audience Profile

Microsoft Dynamics 365 Finance and Operations Apps Developers

This is a 5-day instructor-led training (ILT) course designed for IT professionals involved in evaluating, planning, deploying, and managing Microsoft Office 365 services, including their identities, dependencies, requirements, and supporting technologies. The course focuses on the skills needed to set up an Office 365 tenant, such as federating with existing user identities, as well as maintaining the tenant and its users.

This course is intended for IT professionals responsible for planning, configuring, and managing an Office 365 environment. Students attending this course are expected to have a broad understanding of several on-premises technologies such as Domain Name System (DNS) and Active Directory Domain Services (AD DS). Additionally, they should have a general understanding of Microsoft Exchange Server, Microsoft Lync Server or Skype for Business Server, and Microsoft SharePoint Server.

After completing this course, students will be able to:

• Plan an Office 365 deployment, configure the Office 365 tenant, and plan a pilot deployment.
• Manage Office 365 users, groups, and licenses, and configure delegated administration.
• Plan and configure client connectivity to Office 365.
• Plan and configure directory synchronization between Microsoft Azure AD and on-premises AD DS.
• Plan and implement the Office 365 ProPlus deployment.
• Plan and manage Microsoft Exchange Online recipients and permissions.
• Plan and configure Exchange Online services.
• Plan and configure Microsoft Teams
• Plan and configure Microsoft SharePoint Online.
• Plan and configure an Office 365 collaboration solution.
• Plan and configure the integration between Office 365 and Microsoft Azure Information Protection.
• Monitor and review Office 365 services, and troubleshoot Office 365 issues.
• Plan and implement identity federation between on-premises AD DS and Azure AD.

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

About This Course

This course offers a solid grounding in the key considerations and advantages of adopting cloud services and the Software as a Service (SaaS) cloud model, with a specific emphasis on Microsoft 365 cloud offerings. You will start by exploring cloud fundamentals, covering an overview of cloud computing and Microsoft's specific cloud services. You will be introduced to Microsoft Azure and examine the distinctions between Microsoft 365 and Office 365. The course then delves into a detailed review of Microsoft 365, comparing Microsoft on-premises services with Microsoft 365 cloud services, reviewing enterprise mobility within Microsoft 365, and analysing how these services facilitate collaboration. Additionally, the course explores how security, compliance, privacy, and trust are managed in Microsoft 365, concluding with an overview of Microsoft 365 subscriptions, licensing, billing, and support.

Audience Profile

This course is tailored for Business Decision Makers and IT Professionals who aim to deploy cloud services within their organisations or those seeking foundational knowledge of cloud concepts. It covers the considerations and benefits of adopting cloud services generally, with a particular focus on the Software as a Service (SaaS) cloud model and Microsoft 365 cloud offerings.

At Course Completion

Upon completing this course, students will be able to:

• Distinguish between various cloud service models.
• Identify the key differences between Microsoft 365 subscription plans.
• Plan for migration to Microsoft 365 services.
• Differentiate between Microsoft on-premises services and Microsoft 365 cloud services.
• Explain how Microsoft 365 services support teamwork.
• Describe identities, including cloud, on-premises, and hybrid identity.
• Describe cloud device management and protection, including the use of Intune.
• Describe data protection, including the use of Azure Information Protection.
• Outline compliance in general and the compliance features available in Microsoft 365.
• Describe Microsoft 365 subscriptions, licenses, billing, and support.

This five-day, instructor-led course is tailored for IT professionals with prior exposure to Windows Server. It targets individuals responsible for managing identity, networking, storage, and compute infrastructure using Windows Server 2019, providing a comprehensive understanding of the scenarios, requirements, and available options specific to this platform. The curriculum equips IT professionals with the fundamental administration skills necessary to deploy and support Windows Server 2019 across most organizational environments.