Microsoft Training in Pittsburgh

Microsoft 365 is a comprehensive suite of cloud-based productivity and collaboration tools designed for government agencies. It includes Teams, OneDrive, Planner, and Copilot, all of which are tailored to support modern workplace workflows.

This instructor-led, live training (available online or on-site) is aimed at intermediate-level professionals who wish to integrate Microsoft 365 capabilities to enhance productivity, governance, and cross-team collaboration within their organizations.

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

• Configure and manage Teams for effective team collaboration and meeting practices.
• Use OneDrive for secure file storage, sharing, and version control.
• Plan and track work using Planner and integrate tasks into team workflows.
• Leverage Copilot to accelerate document drafting, meeting summaries, and data insights.

Format of the Course

• Interactive demonstrations combined with guided, hands-on labs.
• Scenario-driven exercises reflecting real organizational workflows.
• Practical sessions on configuration, governance, and user adoption best practices.

Course Customization Options

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

Microsoft 365 offers a robust suite of tools designed for creating enterprise-level knowledge management systems. By integrating SharePoint, Teams, Power Automate, and Power BI, organizations can effectively organize, integrate, and visualize information. This course focuses on the design of dynamic intranet dashboards, interlinking data sources, and implementing structured workflows to enhance collaboration and knowledge sharing across teams. This instructor-led, live training (available online or onsite) is tailored for advanced-level professionals aiming to develop and manage sophisticated knowledge management frameworks using Microsoft 365 tools for government. By the end of this training, participants will be able to: - Design advanced knowledge management systems using Microsoft 365 tools. - Build interconnected SharePoint sites and Teams channels to facilitate information flow. - Automate content workflows with Power Automate. - Develop Power BI dashboards for effective knowledge visualization and reporting. - Optimize governance, access, and version control across shared repositories. **Format of the Course** - Interactive lectures and discussions. - Extensive exercises and practical implementation. - Hands-on configuration in a live Microsoft 365 environment. **Course Customization Options** - To request a customized training for this course, please contact us to arrange.

Microsoft Intune is a cloud-based endpoint management solution designed to enable organizations to securely manage users, devices, and applications. It provides comprehensive tools for configuration, compliance, and protection across Windows, macOS, iOS, and Android environments. This instructor-led, live training (online or onsite) is aimed at intermediate to advanced IT professionals who wish to deploy, configure, and manage enterprise devices using Microsoft Intune and related Microsoft 365 technologies. By the end of this training, participants will be able to: - Implement and manage Microsoft Intune for endpoint management. - Configure device enrollment, compliance, and security policies. - Deploy and protect enterprise applications using Intune. - Integrate Intune with Microsoft 365, Entra ID, and Defender for Endpoint for unified management. **Format of the Course** - Interactive lecture and discussion. - Extensive exercises and practice sessions. - Hands-on implementation in a live-lab environment. **Course Customization Options** - To request a customized training for government or other organizations, please contact us to arrange.

Microsoft 365 is a comprehensive suite of integrated productivity tools designed to enhance collaboration, provide data-driven insights, and automate workflows through applications such as Excel, Word, PowerPoint, Outlook, and Copilot. This instructor-led, live training (available online or onsite) is tailored for intermediate-level professionals who aim to master Microsoft 365 tools and AI-powered features to improve decision-making, communication, and organizational efficiency for government operations. By the end of this training, participants will be able to: - Apply advanced Excel techniques and automation tools to support business and leadership decisions. - Design impactful PowerPoint presentations using storytelling and data visualization techniques. - Create, format, and collaborate on professional documents in Word with the assistance of Copilot. - Enhance productivity and time management using Outlook and AI-driven features across Microsoft 365. **Format of the Course:** - Interactive lecture and discussion. - Hands-on exercises and scenario-based practice. - Practical application using Microsoft 365 tools in a live-lab environment. **Course Customization Options:** - To request a customized training for government, please contact us to arrange.

Microsoft To Do is a cloud-based task management application designed to assist individuals and teams in organizing, prioritizing, and managing tasks across devices with seamless integration into Microsoft 365.

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

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

• Set up and configure Microsoft To Do across devices and integrate it with Microsoft 365 for government use.
• Create, organize, and prioritize tasks and lists for both personal and team workflows.
• Collaborate effectively by sharing lists, assigning tasks, and monitoring progress within their teams.
• Utilize Microsoft To Do alongside Outlook, Teams, and Planner to enhance organizational efficiency.
• Implement productivity best practices and advanced techniques for sustained adoption in a government setting.

Format of the Course

• Interactive lectures and discussions.
• Hands-on exercises and guided laboratory sessions.
• 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 assist individuals and teams in organizing, prioritizing, and managing tasks across devices with seamless integration into Microsoft 365.

This instructor-led, live training (available online or onsite) is tailored for government professionals at beginner to intermediate levels who seek to leverage Microsoft To Do to manage tasks effectively, enhance productivity, and improve collaboration within teams.

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

• Set up and configure Microsoft To Do for personal and team use in a government setting.
• Create, organize, and prioritize tasks efficiently to meet agency goals.
• Integrate Microsoft To Do with Outlook, Teams, and other Microsoft 365 tools for streamlined workflows.
• Apply productivity best practices using the features of Microsoft To Do for government operations.

Format of the Course

• Interactive lecture and discussion focused on public sector applications.
• Extensive exercises and practice tailored to government tasks and scenarios.
• Hands-on implementation in a live-lab environment designed for government users.

Course Customization Options

• To request a customized training for government, please contact us to arrange specific agency needs.

Microsoft System Center Data Protection Manager (DPM) is Microsoft’s enterprise backup and recovery solution designed to protect critical workloads such as file servers, databases, and virtual machines. This instructor-led, live training (available online or onsite) is tailored for intermediate-level IT professionals who are responsible for deploying, configuring, and managing DPM to safeguard data and ensure business continuity for government agencies. By the end of this training, participants will be able to: - Install and configure DPM servers and agents. - Create and manage protection groups. - Perform backup and recovery operations. - Integrate DPM with other disaster recovery solutions for enhanced resilience. **Format of the Course** - Interactive lectures and discussions. - Extensive exercises and hands-on practice. - Practical implementation in a live-lab environment. **Course Customization Options** - To request a customized training program for government, please contact us to arrange.

This instructor-led, live training (online or onsite) is designed for government employees at the beginner to intermediate level who wish to enhance their productivity and digital collaboration using Microsoft Teams, OneDrive, and Outlook. By the end of this training, participants will be able to: - Effectively create, manage, and utilize teams and channels in Microsoft Teams. - Utilize tags, mentions, and app integrations in Teams to improve communication efficiency. - Store, organize, and securely share files in OneDrive following best practices. - Recover documents using 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 [location] (online or onsite) is designed for government employees at beginner to intermediate levels who wish to enhance team productivity and streamline daily workflows using Outlook, OneDrive, Teams, Planner, and Forms. By the end of this training, participants will be able to: - Organize and manage communication effectively with Outlook. - Store, share, and collaborate on files using OneDrive for government. - 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 is a messaging platform that provides email, calendar, contacts, and tasks functionality for government agencies and other organizations.

This instructor-led, live training (online or onsite) is aimed at intermediate-level IT professionals who wish to install, configure, manage, and troubleshoot Microsoft Exchange Server environments for government use.

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

• Install and configure Microsoft Exchange Server for government systems.
• Implement disaster recovery and anti-malware measures in a government context.
• Configure message transport and migration to Exchange Online for government networks.
• Troubleshoot issues and ensure server availability for government operations.

Format of the Course

• Interactive lecture and discussion focused on government IT practices.
• Lots of exercises and practice relevant to government workflows.
• Hands-on implementation in a live-lab environment tailored to government scenarios.

Course Customization Options

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

Microsoft OneNote is a digital notebook application designed for organizing, sharing, and collaborating on information across teams and devices. This instructor-led, live training (online or onsite) is aimed at professionals with limited or emerging experience in OneNote who manage or coordinate digital information and wish to use Microsoft OneNote effectively to organize notes, coordinate team knowledge, and enhance collaborative workflows for government. By the end of 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 [location] (online or onsite) is designed to assist participants in preparing for the Microsoft Azure Data Engineer certification exam (DP-203). The course provides an overview of Azure data services and their application in processing, storing, and managing data in the cloud. Participants will gain hands-on experience in creating data processing solutions using Azure Data Factory, Azure Stream Analytics, and Azure Databricks. Additionally, they will learn how to work with NoSQL databases through Azure Cosmos DB, ensuring alignment with best practices for government data management and governance.

This instructor-led, live training in [location] (online or onsite) is aimed at beginner-level leadership teams who wish to effectively manage and coordinate tasks using Microsoft Planner and its related tools, leading to 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, improving 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 to enhance 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 training is specifically designed to support the unique requirements of leadership teams in the public sector, ensuring alignment with government workflows, governance, and accountability.

This instructor-led, live training in Pittsburgh (online or onsite) is designed for beginner-level business professionals who wish to acquire the skills necessary to effectively utilize Teams, Word, and Excel in a management context.

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

• Achieve a thorough understanding of Microsoft 365 for government.
• 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 methods to integrate Microsoft 365 applications for seamless workflows.

This instructor-led, live training in Pittsburgh (online or onsite) is designed to assist participants in preparing for the Microsoft Azure DevOps Engineer certification exam (AZ-400). The course provides an overview of DevOps practices and their implementation on the Azure platform. Participants will gain hands-on experience using Azure DevOps to manage code repositories, configure build and release pipelines, and implement continuous integration and continuous delivery (CI/CD) practices for government projects.

This instructor-led, live training (available online or onsite) is designed to assist participants in preparing for the Microsoft Azure Solutions Architect Expert (AZ-305) certification exam. The course delves into advanced cloud computing concepts and Azure services, providing a thorough introduction to Azure solutions architecture. It covers key principles, components, and services essential for government and private sector professionals. Participants will gain the skills necessary to design and deploy Azure solutions in accordance with best practices and industry standards, ensuring alignment with public sector workflows, governance, and accountability requirements for government projects.

This course will cover a range of methods and best practices aligned with business and technical requirements for modeling, visualizing, and analyzing data using Power BI. It will also demonstrate how to access and process data from various sources, including both relational and non-relational databases. Additionally, the course will delve into the implementation of appropriate security standards and policies across the Power BI platform, ensuring compliance for government datasets and groups. The curriculum will further address the management and deployment of reports and dashboards, facilitating effective sharing and content distribution within public sector workflows.

This instructor-led, live training in Pittsburgh (online or onsite) is designed to assist participants in preparing for the Microsoft Azure Security Engineer Associate (AZ-500) certification exam. The course covers a range of security topics relevant to Azure, including identity and access management, platform protection, data and application protection, and operations management. This training is tailored to support professionals in enhancing their cybersecurity skills for government and private sector environments, ensuring alignment with best practices and industry standards.

Microsoft System Center Operations Manager (SCOM) is a monitoring tool designed to ensure the availability, performance, and reliability of IT services across data centers and applications.

This instructor-led, live training (online or onsite) is aimed at intermediate-level IT professionals who wish to deploy, configure, and manage SCOM for government enterprise monitoring and alerting.

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

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

Format of the Course

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

Course Customization Options

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

This instructor-led, live training (online or onsite) is designed for intermediate-level IT professionals who wish to manage and secure an organization's IT environment using Microsoft 365 for government. 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 for government. - 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 Pittsburgh (online or onsite) is designed to assist participants in preparing for the Microsoft Azure Developer Associate (AZ-204) certification exam. The course covers essential concepts of developing Azure solutions, including Azure compute, storage, and security features. It offers a thorough introduction to Azure development, encompassing tools and services necessary for building, testing, and deploying applications for government use.

This instructor-led, live training in Pittsburgh (online or onsite) is designed for intermediate-level IT professionals who are tasked with managing and securing an organization's IT environment using Microsoft 365.

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

• Deploy and manage Microsoft 365 services, including 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 for government.
• Apply best practices for Microsoft 365 administration and security to enhance organizational governance and accountability.

This instructor-led, live training in Pittsburgh (online or onsite) is designed to assist participants in preparing for the Microsoft Azure Administrator Associate (AZ-104) certification exam. The course covers the essential skills required to manage Azure resources, including virtual machines, storage solutions, and network management, ensuring alignment with best practices for government operations.

This instructor-led, live training in Pittsburgh (online or onsite) is designed to assist participants in preparing for the Microsoft Azure Fundamentals (AZ-900) certification exam. The course offers a thorough introduction to cloud computing and Azure services, tailored for government professionals. It covers essential concepts of Azure, including its architecture, pricing models, support options, and an overview of the most frequently utilized Azure services. This training is specifically structured to align with public sector workflows, governance, and accountability requirements for government.

This instructor-led, live training (available online or on-site) is designed for government employees who wish to learn how to use Microsoft OneNote to manage notes effectively and enhance productivity. By the end of this training, participants will be able to: - Understand the fundamental features and functionalities of OneNote. - Create, organize, and edit notes using OneNote. - Integrate notes with other applications for seamless workflow management for government operations.

The course participants will be able to efficiently utilize primary data analysis tools such as scenarios and pivot tables, leverage features for performing calculations on dates and text-processing functions, and develop and customize macros to automate spreadsheet tasks for government use.

Excel is a popular spreadsheet program created by Microsoft. Jest used to store, organize and analyze data in tabular form. Here are some key features and functions of Excel: 1. Spreadsheets: It consists of sheets, where each sheet is an array consisting of cells arranged in rows and columns. It allows you to create multiple sheets in one file, which allows you to organize different data sets. 2. Calculations and Formulas: Allows you to perform a variety of mathematical, statistical and logical calculations using formulas. It has a wide set of built-in functions such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, etc. 3. Data Formatting and Appearance: Provides tools for formatting data, including changing font, color, style, and creating charts, pivot tables and diagrams. 4. Sorting, Filtering and Grouping: Allows you to sort data according to specific criteria. Allows you to filter data to display only selected information. Possibility to group data depending on needs. 5. Data analysis: Tools for performing advanced analyzes such as scenario analysis, trends, forecasting, and creating macros. 6. Data Sharing: Enables real-time data sharing and collaboration, allowing multiple users to work on the same data simultaneously. 7. Task automation: Ability to create macros and automate tasks using the programming language VBA (Visual Basic for Applications). Excel is widely used in various fields, from business to science and education. Its comprehensive features enable data analysis, creation of reports, budgets, schedules, data management and many other applications.

This live instructor-led training, available both onsite and remotely, is designed to guide participants through the essential tools of Microsoft Excel for government use. The combination of meticulously prepared training materials and the instructor's expertise will showcase the extensive capabilities of Excel spreadsheets. Unlike typical Excel courses, this training will reveal numerous unique functionalities that can significantly enhance and accelerate your work processes for government operations.

About This Course

This three-day instructor-led course is designed for individuals transitioning into a database professional role or whose responsibilities are expanding to include database elements. The course covers essential database concepts, including database types, languages, and design methodologies.

Audience Profile

The primary audience for this course includes professionals who are moving into a database role or whose job duties now encompass database technologies.

At Course Completion

Upon completing this course, students will be able to:
• Describe key database concepts within the context of SQL Server 2016
• Identify and explain the database languages used in SQL Server 2016
• Apply data modeling techniques effectively
• Understand and implement normalization and denormalization techniques
• Recognize different relationship types and their impacts on database design
• Analyze how database design influences performance
• Utilize commonly employed database objects

This course is tailored to provide comprehensive training for government professionals seeking to enhance their database management skills.

About This Course

This is a three-day Instructor-Led Training (ILT) course designed to meet the needs of information technology (IT) professionals responsible for administering, configuring, troubleshooting, and operating Office 365 services. The course covers identities, dependencies, requirements, and supporting technologies essential for effective management. It focuses on the skills required to administer and troubleshoot Office 365 tenant and key services such as Exchange Online, SharePoint Online, and Teams, as well as security and compliance features.

Audience Profile

This course is intended for IT professionals and system administrators who are interested in learning administration and troubleshooting techniques for Office 365. Participants should have at least three years of experience in their respective fields, ideally in system administration, network administration, and messaging.

At Course Completion

Upon completing this course, students will be able to:

• Describe Office 365 services for government use.
• Administer Office 365 using the Microsoft 365 admin center and Office 365 services admin centers.
• 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 environments.
• Administer and troubleshoot compliance and security in Office 365.

About This Course

This five-day course is designed to equip you with the knowledge and skills necessary to plan and administer a Microsoft SharePoint 2016 environment. The curriculum covers the deployment, administration, and troubleshooting of your SharePoint environment. Additionally, it provides guidelines, best practices, and considerations that will help optimize your SharePoint deployment for government use.

This course is the first in a series of two courses tailored for IT professionals and aligns with the SharePoint 2016 IT Pro certification.

Audience Profile

The course targets 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. Participants typically have more than one year of hands-on experience with planning and maintaining SharePoint environments and at least two years of experience with core technologies that SharePoint depends on, such as 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.
• Possesses practical knowledge and experience with SharePoint Online.
• Has broad familiarity with SharePoint workloads.
• Has expertise in business continuity management, including data backup, restoration, and high availability.
• Is familiar with authentication and security technologies.
• Has hands-on experience with Windows PowerShell.

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

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.

The course participants will be able to efficiently perform a variety of calculations in a transparent manner to organize and present their results. They will also use multiple mechanisms to facilitate and accelerate the creation of spreadsheets, ensuring that the calculations and their results are protected from unauthorized access for government use.

Participants will enhance their capabilities to create, consolidate, and manage data in the most efficient manner. A variety of tools designed to streamline workflows for government often significantly reduce the time required for these activities and can assist in designing applications that perform new tasks effectively.

This intermediate-level Excel VBA curriculum equips professionals with essential competencies in custom interfaces, complex data structures, conditional logic, iterative processing, and systematic debugging methodologies. Through practical application, the program demonstrates robust error handling, performance optimization, UserForm development, and workflow automation. Designed to facilitate the transition from foundational macros to advanced automation strategies, this training supports data analysts, reporting specialists, and business users in enhancing enterprise spreadsheet capabilities for government operations.

This professional training program is designed to advance participants' proficiency in Microsoft Excel, with a specific focus on enhancing operational efficiency and data management capabilities. The curriculum covers essential technical competencies, including workbook and worksheet management, the development of complex formulaic structures, cell formatting, and the creation of analytical visualizations. Participants will also engage in hands-on exercises involving PivotTables, data manipulation, and the integration of graphical elements. This instruction is particularly relevant for government professionals, including business analysts, financial specialists, and administrative staff, who seek to elevate their technical skills from an intermediate to an expert level. By mastering these tools, personnel can streamline reporting processes, improve data analysis accuracy, and support informed decision-making to drive public sector productivity.

This instructor-led, live training in Pittsburgh (online or onsite) is designed for beginner-level analysts who seek to leverage Excel VBA to automate repetitive tasks, cleanse and transform data, and enhance reporting processes for government.

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

This 5-day Advanced Excel for Government Sales Professionals course is designed to equip sales teams with the skills necessary to manage, analyze, and automate sales data efficiently. Participants will learn advanced Excel functions, data analysis techniques, and automation tools to enhance reporting accuracy, create dynamic dashboards, and forecast sales performance. Through hands-on exercises, sales professionals will gain practical insights into building interactive sales reports, automating repetitive tasks, and utilizing advanced tools like Power Query, Power Pivot, and Macros. This course is ideal for those looking to leverage Excel to drive data-driven sales strategies for government operations.

This course equips IT professionals with the skills needed to manage their Azure subscriptions effectively, secure identities, administer infrastructure, configure virtual networking, connect Azure and on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, deploy web apps and containers, back up and share data, and monitor their solutions. Designed specifically for government Azure Administrators, this course covers the essential tasks of implementing, managing, and monitoring identity, governance, storage, compute, and virtual networks in a cloud environment. Azure Administrators will learn to provision, size, monitor, and adjust resources as needed to ensure optimal performance and compliance with public sector workflows, governance, and accountability standards.

About This Course

This course will cover the various methods and best practices aligned with business and technical requirements for modeling, visualizing, and analyzing data using Power BI. It will also demonstrate how to access and process data from a wide range of sources, including both relational and non-relational databases. Additionally, the course will delve into implementing appropriate security standards and policies across the Power BI environment, encompassing datasets and groups. Furthermore, it will explore the management and deployment of reports and dashboards for sharing and content distribution, ensuring alignment with public sector workflows and governance.

Audience Profile

The target audience for this course includes data professionals and business intelligence specialists who wish to master accurate data analysis using Power BI. This course is also designed for individuals responsible for developing reports that effectively visualize data from both cloud-based and on-premises platforms, enhancing decision-making processes for government.

Skills Gained

• Ingest, clean, and transform data
• Model data to optimize performance and scalability
• Design and create reports for comprehensive data analysis
• Apply advanced report analytics techniques
• Manage and share report assets effectively

This course is designed for participants who have prior experience with Microsoft Excel and are looking to enhance their workflow in accordance with best practices. The curriculum covers essential principles for effective data management, including the utilization of Tables, Cell Styles, and Custom Number Formats. Additionally, it delves into techniques for Conditional Formatting and Data Validation. Participants will also learn how to analyze and address formula errors using AI support, as well as fundamental methods for worksheet protection to ensure clear, reliable, and error-resistant workbooks. This training is tailored to improve efficiency and accuracy in data handling processes for government professionals.

This five-day course is designed to provide comprehensive training on using Configuration Manager and its associated site systems to efficiently manage network resources. Participants will learn essential day-to-day management tasks, such as managing applications, ensuring client health, conducting hardware and software inventory, deploying operating systems, and distributing software updates using Configuration Manager. The course also covers optimizing System Center Endpoint Protection, managing compliance, and creating management queries and reports. By completing this course along with Microsoft Official Course 20703-2A, participants will be well-prepared to take Exam 70-703: Administering System Center Configuration Manager and Cloud Services Integration, which is crucial for certification in IT management for government and enterprise environments.

This five-day, instructor-led course equips participants with the knowledge and skills necessary to install and configure System Center 2012 Operations Manager. Additionally, this training will prepare students to effectively manage their 2012 Operations Manager infrastructure for government use.

About This Course

The Dynamics 365 Finance and Operations applications, which include but are not limited to Dynamics 365 Finance, Dynamics 365 Supply Chain Management, and Dynamics 365 Supply Chain Management for Manufacturing, are designed to enhance various aspects of financial and operational management. Dynamics 365 Finance enables the automation and modernization of global financial operations, allowing real-time performance monitoring, predictive analytics, and data-driven decision-making to drive business growth. It supports strategic financial decisions through artificial intelligence (AI), unifies and automates financial processes, reduces operational expenses, and mitigates global financial complexity and risk. Dynamics 365 Supply Chain Management is aimed at transforming manufacturing and supply chain operations by leveraging AI and the Internet of Things (IoT) for planning, production, inventory, warehouse, and transportation management. It maximizes operational efficiency, product quality, and profitability through intelligent manufacturing operations, modernized warehouse management, optimized production performance, extended asset life, and streamlined supply chains. 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 of Dynamics 365 Finance applications that are most commonly used by end users and consultants for government.

Audience Profile

The target audience for this course is a Dynamics 365 for Finance and Operations Functional Consultant. This role involves performing discovery, capturing requirements, engaging subject matter experts and stakeholders, translating requirements, and configuring the solution and applications. The Functional Consultant implements solutions using out-of-the-box capabilities, codeless extensibility, and application and service integrations.

At Course Completion

Upon completion of this course, students will be able to:

• Navigate and efficiently use search, filtering, and queries
• Utilize operational workspaces effectively
• Manage business documents
• Work with record templates
• Integrate Power BI with Dynamics 365 Finance and Operations applications
• Personalize workspaces to meet individual needs
• Determine when to use the Power Platform in Dynamics 365 Finance and Operations applications
• Apply security roles to users
• Run and analyze security reports
• Create and manage workflows for approval processes
• Understand and work with organizational hierarchies
• Utilize personalization features effectively
• Use the Data Management workspace for data management tasks
• Create and use entity templates
• Copy configuration data between legal entities
• Import, export, and manage data using Office Integration
• Utilize the Regression Suite Automation Tool (RSAT)
• Create User Acceptance Tests (UAT) and test plans
• Create and work with Business Process Modeler (BPM)
• Use issue search to identify and resolve issues

About This Course

This training program is designed to equip developers with the skills necessary to implement and extend Microsoft Dynamics 365 Finance and Operations applications in support of organizational business requirements. Participants will learn to deliver comprehensive solutions by leveraging standardized coding practices, extensible system features, and external integration capabilities.

Audience Profile

The content is tailored for developers working with Microsoft Dynamics 365 Finance and Operations Apps who require specialized instruction to enhance their technical proficiency within government environments.

This is a five-day instructor-led training (ILT) course designed for IT professionals who are involved in evaluating, planning, deploying, and managing Microsoft Office 365 services. The course covers the essential skills needed to set up an Office 365 tenant, including integration with existing user identities, and to maintain an Office 365 tenant and its users. This course is intended for IT professionals responsible for planning, configuring, and managing an Office 365 environment. Participants should have a comprehensive understanding of on-premises technologies such as Domain Name System (DNS) and Active Directory Domain Services (AD DS). Additionally, they should possess a general knowledge of Microsoft Exchange Server, Microsoft Lync Server or Skype for Business Server, and Microsoft SharePoint Server. Upon 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 training is specifically tailored to meet the needs of IT professionals in the public sector, ensuring that they are well-equipped to support and manage Office 365 environments for government operations.

This course is tailored for individuals aiming to assume the Microsoft 365 Administrator role, who have successfully completed at least one of the Microsoft 365 role-based administrator certification paths. The curriculum is designed to align with the technical requirements and best practices for government agencies, ensuring that participants are well-prepared to manage and optimize Microsoft 365 environments in a public sector context.

About This Course

This course provides foundational knowledge on the considerations and benefits of adopting cloud services, with a specific focus on the Software as a Service (SaaS) model, particularly Microsoft 365 cloud service offerings. The curriculum begins with an overview of cloud computing fundamentals and introduces participants to Microsoft Azure. It then delves into the differences between Microsoft 365 and Office 365, followed by an in-depth review of Microsoft 365. This includes a comparison of on-premises services versus Microsoft 365 cloud services, an examination of enterprise mobility within Microsoft 365, and an analysis of collaboration capabilities. The course also covers security, compliance, privacy, and trust in Microsoft 365, concluding with a review of subscriptions, licenses, billing, and support options for government and other organizations.

Audience Profile

This course is designed for Business Decision Makers and IT Professionals who are interested in deploying cloud services within their organization or seeking foundational knowledge on cloud fundamentals. It covers the considerations and benefits of adopting cloud services, particularly the SaaS model, with a focus on Microsoft 365 cloud service offerings.

At Course Completion

Upon completing this course, students will be able to:

• Differentiate between various cloud service models.
• Identify the key differences between Microsoft 365 subscriptions.
• Plan for the migration to Microsoft 365 services.
• Recognize the distinctions between on-premises and Microsoft 365 cloud services.
• Understand how Microsoft 365 supports teamwork and collaboration.
• Describe identities, including cloud, on-premises, and hybrid identity solutions.
• Explain cloud device management and protection using Intune.
• Discuss data protection measures, including the use of Azure Information Protection.
• Outline general compliance requirements and the compliance features in Microsoft 365.
• Describe Microsoft 365 subscriptions, licensing, billing, and support options for government and other organizations.

About the Training

This workshop is designed for new users of the Office 365 platform, as well as those who wish to refresh their understanding of its capabilities. It provides an introduction to the functionality and services available, enabling participants to begin working effectively in the new environment.

Purpose of the Training

The training aims to enhance efficiency in collaboration with other users and provide greater control over documents used within the organization.

What Will Microsoft 365 Improve in Your Work?

Upon completion of the training, participants will be able to utilize lists and libraries, manage shared calendars and contacts, and create and customize document and meeting workspaces. They will also learn how to publish documents and information with change history control, contributing to the development of a robust knowledge base.

Where Will You Use the Acquired Knowledge?

The Office 365 platform will significantly enhance the operations of the entire organization. Participants will improve their reporting and collaboration processes within the organization, as well as experience increased ease in accessing data.

What Will You Learn?

This training will equip participants with the skills to work in an environment that optimally supports group work. They will learn effective methods for managing documents and streamlining their workflow, ensuring alignment with public sector workflows, governance, and accountability for government operations.

The Microsoft Power Platform is designed to help organizations enhance their operational efficiency by streamlining, automating, and transforming business tasks and processes. This course will provide students with the skills needed to develop Power Apps, automate workflows, and extend the platform to meet specific business requirements and address complex challenges, all tailored for government use.

This five-day instructor-led course is designed primarily for information technology (IT) professionals with some experience using Windows Server. It is tailored for those who will be responsible for managing identity, networking, storage, and compute resources using Windows Server 2019. The course covers the essential scenarios, requirements, and options relevant to Windows Server 2019, ensuring that IT professionals are equipped with the fundamental administration skills needed to deploy and support this operating system effectively in various organizational settings, including those for government.

This course will provide instruction on the fundamentals of Microsoft's version of the standard SQL language, known as Transact-SQL. It covers both querying and modifying data within relational databases hosted in Microsoft SQL Server-based systems, including Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics. The curriculum is designed to align with public sector workflows, ensuring that participants gain skills that are directly applicable for government use.