Microsoft Training in Lexington

Microsoft 365 provides a comprehensive suite of cloud-based productivity and collaboration applications, including Microsoft Teams, OneDrive, Planner, and Copilot, designed to facilitate contemporary workplace operations.

This instructor-led training program, delivered either virtually or at a designated location, targets intermediate-level personnel seeking to implement Microsoft 365 capabilities to enhance operational efficiency, strengthen governance frameworks, and improve cross-functional collaboration. This curriculum is specifically developed for government entities and agencies aiming to modernize their digital infrastructure.

Upon successful completion of this course, participants will demonstrate the ability to:

• Configure and administer Microsoft Teams to support effective team coordination and standardized meeting protocols.
• Utilize OneDrive for secure file archiving, controlled sharing, and robust version management.
• Organize and monitor project milestones using Planner, ensuring seamless integration into departmental workflows.

Leverage Copilot functionalities to expedite the creation of official documentation, generate meeting minutes, and derive actionable data insights.

Instructional Methodology

• Interactive technical demonstrations paired with guided, hands-on laboratory exercises.
• Scenario-based training modules that mirror authentic federal organizational workflows.
• Practical instruction focused on system configuration, compliance governance, and strategies for user adoption.

Program Customization

• Customizable course materials, including tailored examples, governance checklists, and lab exercises, can be aligned with specific agency policies and technical environments.

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 Lexington (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 Lexington (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.

Excel is a spreadsheet application utilized for data entry, analysis, reporting, and automation. This instructor-led, live training (online or onsite) is designed for government employees ranging from beginner to advanced levels who wish to build confidence and proficiency across Excel’s essential, intermediate, and advanced capabilities. Upon completion of this training, participants will be prepared to: - Work confidently with spreadsheets, formulas, and formatting. - Use intermediate tools such as tables, charts, and conditional logic. - Apply advanced functions, data analysis features, and automation techniques. - Create professional worksheets that support business decision-making for government operations. Format of the Course - Instructor-led demonstrations and guided explanations. - Extensive workbook exercises and hands-on practice. - Practical lab activities using real-world spreadsheet scenarios relevant to government workflows. Course Customization Options - For tailored coverage based on your department’s specific workflows, please contact us to arrange a customized version of this course for government.

This instructor-led, live training in Lexington (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 Lexington (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 Lexington (online or onsite) is aimed at beginner-level to advanced-level data analysts who wish to use Excel for government 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. - Utilize tools like Power Query and Power Pivot for enhanced data analysis. - Automate tasks using macros and VBA to streamline workflows and improve efficiency.

This instructor-led, live training in Lexington (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 Lexington (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 Lexington (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.

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.

Microsoft Excel is a robust spreadsheet application designed for organizing, analyzing, and visualizing data. This instructor-led, live training (available online or on-site) is tailored for beginner-level data analysts who wish to utilize Excel for data analysis and reporting. By the end of this training, participants will be able to: - Create and manage spreadsheets in Excel. - Format and organize data to enhance clarity and efficiency. - Use formulas and functions to automate calculations. - Visualize data through charts, tables, and conditional formatting. - Collaborate and securely share workbooks within Microsoft 365. **Format of the Course** - Interactive lecture and discussion - Extensive exercises and practice sessions - Hands-on implementation in a live-lab environment **Course Customization Options for Government** To request a customized training program for government use, please contact us to arrange.

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.

This training program for government professionals delivers advanced methodologies for financial data analysis within Microsoft Excel. The curriculum emphasizes the automation of complex calculations and reporting processes, covering essential topics such as financial functions, INDEX-MATCH operations, database queries, PivotTables, PivotCharts, and external data integration. Participants will learn to utilize Goal Seek, Solver, the Analysis ToolPak, and VBA macros to streamline recurring administrative workflows. The instruction aims to enable federal employees to convert raw financial data into actionable insights and precise forecasts that support strategic planning objectives for government entities.

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 Lexington (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.

This instructor-led educational program, available in Lexington via virtual or physical attendance, is designed for entry-level information technology personnel seeking foundational knowledge of Microsoft Azure and cloud computing principles. Upon successful completion of this curriculum, participants will be equipped to: * Demonstrate comprehension of fundamental cloud computing concepts. * Recognize primary Azure services. * Articulate core solutions and management utilities within the Azure environment. * Explain general security protocols and network protection features. * Understand identity management, governance frameworks, privacy safeguards, and compliance requirements. * Evaluate Azure cost optimization strategies and Service Level Agreements (SLAs). This structured learning path is developed specifically for government agencies and public sector organizations aiming to enhance workforce competency in cloud infrastructure.

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 curriculum is intended for professionals with prior experience in Microsoft Excel who seek to streamline their operational processes through established best practices. The program addresses foundational data management principles, including the implementation of Tables, Cell Styles, and Custom Number Formats. Additionally, it covers techniques for Conditional Formatting and Data Validation, alongside methods for identifying and resolving formula errors utilizing artificial intelligence capabilities. Participants will also acquire essential skills in worksheet protection to ensure the integrity and reliability of documentation. This training is designed specifically for government entities aiming to enhance data governance and operational efficiency for government use cases.

This instructor-led, live training in [location] (online or onsite) is aimed at beginner to intermediate-level business analysts and data analysts who wish to use Excel for government to perform data analysis and reporting for their projects and tasks. By the end of this training, participants will be able to: - Use Excel formulas and functions to perform calculations and data manipulation. - Utilize Excel data analysis tools such as PivotTables, What-If Analysis, and Forecasting to summarize and visualize data. - Create and customize data visualizations using Excel charts and graphs. - Ensure data quality and highlight data insights through Excel data validation and conditional formatting. - Connect to external data sources and share data with others using Excel's import and export features.

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.

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.