Microsoft Training in South Carolina

Microsoft 365 provides a comprehensive suite of cloud-based productivity and collaboration services, including Teams, OneDrive, Planner, and Copilot, designed to support modern operational workflows.

This instructor-led, live training program, available online or onsite, is tailored for intermediate-level professionals seeking to enhance productivity, governance, and cross-functional collaboration through Microsoft 365 capabilities for government operations.

Upon completion, participants will be equipped to:

• Configure and administer Teams to ensure effective team collaboration and standardized meeting protocols.
• Utilize OneDrive for secure file storage, controlled sharing, and rigorous version control.
• Plan and monitor operational tasks using Planner, integrating work items into broader team workflows.
• Apply Copilot to expedite document drafting, meeting summarization, and data analysis.

Training Format

• Interactive demonstrations paired with guided, hands-on laboratory exercises.
• Scenario-based activities that reflect real-world organizational processes.
• Practical instruction focused on configuration, governance, and user adoption best practices.

Customization Options

• We can adapt examples, governance checklists, and practical labs to align with your specific organizational policies and technical environment.

This instructor-led training in South Carolina is designed for advanced professionals to construct enterprise knowledge management systems using Microsoft 365. Learners will design SharePoint repositories, automate workflows using Power Automate, and visualize data through Power BI dashboards to enhance collaboration and operational transparency for government and public sector needs.

This instructor-led training in South Carolina focuses on the deployment and security of enterprise endpoints utilizing Microsoft Intune. Participants will learn to configure enrollment, compliance, and application management across Windows, macOS, iOS, and Android. This course is designed for IT professionals seeking unified security frameworks and practical skills for government environments.

Microsoft 365 constitutes an integrated suite of productivity applications designed to facilitate collaboration, derive data-driven insights, and automate workflows through Excel, Word, PowerPoint, Outlook, and Copilot.

This instructor-led, live training program (available online or onsite) is tailored for intermediate-level professionals seeking to proficiently master Microsoft 365 tools and AI-enhanced features to improve decision-making, communication, and organizational effectiveness within public sector contexts.

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

• Utilize advanced Excel techniques and automation tools to support strategic and administrative decisions.
• Develop high-impact PowerPoint presentations utilizing structured storytelling and precise data visualization.
• Draft, format, and manage professional documents in Word, leveraging Copilot for efficiency.
• Optimize productivity and time management through Outlook and AI-integrated features across Microsoft 365.

Instructional Methodology

• Interactive instructional sessions and facilitated discussions.
• Hands-on exercises and scenario-based practical application.
• Real-time application of Microsoft 365 tools in a controlled laboratory environment.

Customization Options for Government Entities

Microsoft To Do serves as a cloud-based task management solution engineered to assist individuals and teams in structuring, prioritizing, and administering tasks across multiple endpoints, featuring seamless interoperability within the Microsoft 365 ecosystem.

This instructor-led, live training program (delivered via remote or on-site modalities) is tailored for professional staff at beginner to intermediate proficiency levels who aim to utilize Microsoft To Do not merely for individual efficiency, but as a robust collaborative instrument integrated with Microsoft 365 applications for government and corporate operations.

Instructional Outcomes

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

• Establish and configure Microsoft To Do across various devices and integrate the platform with Microsoft 365 services.
• Generate, categorize, and prioritize tasks and lists for both personal and collective workstreams.
• Facilitate effective collaboration through list distribution, task delegation, and progress oversight.
• Augment operational workflows by coordinating Microsoft To Do with Outlook, Teams, and Planner.
• Apply established productivity standards and advanced methodologies to ensure sustained organizational adoption.

Curriculum Delivery Method

• Interactive instruction and facilitated dialogue.
• Practical exercises and guided laboratory sessions.
• Applied team collaboration simulations.

Program Tailoring Options

• To request a customized training curriculum aligned with specific operational requirements, please contact us to coordinate scheduling.

This instructor-led, live training in South Carolina (delivered online or in-person) is designed for public sector users and professionals from beginner to intermediate levels who aim to improve their productivity and digital collaboration using Microsoft Teams, OneDrive, and Outlook.

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

• Create, manage, and utilize teams and channels in Microsoft Teams for government operations.
• Leverage tags, mentions, and app integrations in Teams to enhance communication efficiency.
• Store, organize, and securely share files in OneDrive in accordance with best practices.
• Retrieve documents using version history and collaborate on files in real time.
• Utilize Outlook for advanced email management and shared calendar scheduling.

This instructor-led, live training program in South Carolina (available online or on-site) is designed for users at beginner to intermediate levels who aim to enhance team productivity and streamline daily workflows through the utilization of Outlook, OneDrive, Teams, Planner, and Forms.

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

• Effectively organizing and managing communication channels using Outlook.
• Storing, sharing, and collaborating on digital documents via OneDrive.
• Facilitating meetings, discussions, and team coordination through Microsoft Teams.
• Planning and monitoring task progress efficiently using Microsoft Planner.
• Constructing and analyzing online surveys and assessments with Microsoft Forms.

Microsoft Exchange Server is an enterprise messaging platform that facilitates email, calendar, contact, and task management capabilities.

This live, instructor-led training (delivered online or onsite) is designed for intermediate-level IT professionals seeking to install, configure, manage, and troubleshoot Microsoft Exchange Server environments within government or corporate settings.

Upon completion of this program, participants will possess the skills to:

• Install and configure Microsoft Exchange Server instances.
• Implement robust disaster recovery and anti-malware controls.
• Configure message transport pathways and migrate workloads to Exchange Online.
• Diagnose operational issues and ensure continuous server availability.

Course Format and Delivery

• Interactive instructional sessions and professional discussions.
• Comprehensive exercises and practical application activities.
• Hands-on implementation tasks within a live-lab environment.

Customization and Tailored Training

• Organizations may request customized training curricula by contacting the provider for specific arrangements.

This instructor-led, live training session, conducted in South Carolina (either online or on-site), is designed to facilitate readiness for the Microsoft Certified: Azure Data Engineer Associate (DP-203) examination. This program supports the technical workforce requirements for government data operations.

The syllabus encompasses core Azure data services and methodologies for processing, storing, and managing cloud data resources. Participants will acquire proficiency in constructing data processing architectures using Azure Data Factory, Azure Stream Analytics, and Azure Databricks, as well as managing NoSQL data stores via Azure Cosmos DB. These skills are essential for compliant and efficient data governance in public sector contexts.

This instructor-led, live training in South Carolina (conducted online or on-site) is designed for entry-level leadership teams seeking to effectively manage and coordinate tasks using Microsoft Planner and associated tools, thereby enhancing productivity and collaboration for government operations.

Upon completion of this training, participants will possess the capability to:

• Create, manage, and track tasks and projects using Microsoft Planner to improve team coordination and project visibility.
• Organize and prioritize individual tasks, share task inventories, and collaborate on duties using Microsoft To Do.
• Deploy Microsoft Loop components for real-time collaboration, integrating them into projects and meetings to enhance communication and information dissemination among team members.
• Design and manage customized lists for specific project requirements, automate workflows, and integrate Lists with other Microsoft 365 tools for efficient task tracking.

This instructor-led, live training delivered in South Carolina (online or onsite) is directed at entry-level professionals who seek to develop the skills necessary to effectively utilize Teams, Word, and Excel in a managerial context for government.

By the conclusion of this training, participants will be capable of:

• Attaining a comprehensive understanding of the Microsoft 365 platform
• Navigating and employing Microsoft Teams for communication, collaboration, and project administration.
• Developing proficiency in the creation, formatting, and management of Word documents.
• Utilizing Excel for data entry, manipulation, and analytical processing.
• Investigating strategies to integrate Microsoft 365 applications for cohesive workflows.

This instructor-led, live training session, conducted in South Carolina (via online or on-site delivery), is designed to assist participants in preparing for the Microsoft Azure DevOps Engineer certification exam (AZ-400). 

The curriculum covers foundational DevOps methodologies and their implementation within the Azure platform. Participants will gain the skills necessary to utilize Azure DevOps for code management, pipeline orchestration, and the adoption of continuous integration and continuous delivery (CI/CD) practices.

This instructor-led, live training in South Carolina (online or onsite) is structured to assist participants in preparing for the Microsoft Azure Solutions Architect Expert (AZ-305) certification examination.

The curriculum addresses advanced cloud computing concepts and Azure service capabilities. It offers a thorough overview of Azure solution architecture, encompassing its underlying principles, constituent components, and associated services. Participants will also acquire the skills necessary to design and deploy Azure solutions in accordance with best practices and industry standards.

This course outlines methodologies and best practices for modeling, visualizing, and analyzing data with Power BI, aligned with operational and technical standards. It covers data access and processing from both relational and non-relational sources. Furthermore, the course addresses the implementation of security standards and policies across the Power BI environment, including datasets and user groups. It also discusses the management and deployment of reports and dashboards for effective content distribution.

Excel is a spreadsheet application utilized for data entry, analysis, reporting, and automation for government operations.

This instructor-led, live training (delivered online or onsite) is designed for users ranging from beginner to advanced levels who seek to develop proficiency in Excel's fundamental, intermediate, and advanced capabilities.

Upon completing this training, participants will be equipped to:

• Utilize spreadsheets, formulas, and formatting with confidence.
• Employ intermediate tools such as tables, charts, and conditional logic.
• Apply advanced functions, data analysis features, and automation techniques.
• Develop professional worksheets that support informed decision-making.

Course Delivery Format

• Instructor-led demonstrations with guided instruction.
• Comprehensive workbook exercises and practical application.
• Lab activities utilizing real-world spreadsheet scenarios.

Customization Options

• For tailored content aligned with specific departmental workflows, please contact us to arrange a customized curriculum for government use.

This instructor-led, live training, available online or in person, is structured to assist participants in preparing for the Microsoft Azure Security Engineer Associate (AZ-500) certification examination.

The curriculum addresses comprehensive security domains within Azure, including identity and access governance, platform hardening, data and application safeguards, and operational management protocols.

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

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

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

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

Course Format

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

Customization Options for Government

• To request customized training for this course, please contact us to make arrangements.

This instructor-led, live training program, conducted in South Carolina (online or onsite), is intended for intermediate-level IT professionals responsible for managing and securing organizational IT environments using Microsoft 365 for government purposes.

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

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

This instructor-led live training in South Carolina (online or on-site) is structured to assist participants in preparing for the Microsoft Azure Developer Associate (AZ-204) certification assessment.

The curriculum addresses the principles of engineering Azure solutions, encompassing compute, storage, and security capabilities. It delivers a thorough orientation to Azure development for government contexts, covering the essential tools and services required for application construction, validation, and deployment.

This instructor-led, live training in South Carolina (available online or onsite) is designed for data analysts ranging from beginner to advanced levels who seek to leverage Excel for a diverse array of tasks, including data entry, formula construction, data analysis, and advanced automation.

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

• Navigate the Excel interface and execute basic data entry, formatting, and computational tasks.
• Implement advanced formulas, functions, and conditional formatting for comprehensive data analysis.
• Construct and manage pivot tables and charts for effective data visualization.
• Utilize tools such as Power Query and Power Pivot to perform complex data analysis.
• Automate routine tasks using macros and VBA to optimize workflows.

This instructor-led, live training in South Carolina (delivered online or onsite) is targeted at mid-level IT professionals seeking to oversee and secure an organization’s IT environment using Microsoft 365 for government operations.

Upon completion of this training, participants will possess the skills to:

• Deploy and administer Microsoft 365 services, including Intune, MDM, and Autopilot.
• Configure and enforce security policies utilizing Windows Defender and other Microsoft 365 security instruments.
• Monitor and resolve issues regarding devices and applications within a Microsoft 365 ecosystem.
• Interpret and implement compliance and data protection protocols within Microsoft 365.
• Apply established best practices for Microsoft 365 administration and security governance.

This instructor-led, live training program, delivered either online or on-site, is structured to equip public sector professionals with the competencies necessary to pass the Microsoft Azure Administrator Associate (AZ-104) certification examination in South Carolina.

The curriculum addresses the technical requirements for overseeing Azure infrastructure, with specific focus on virtual machines, storage architectures, and network governance.

This instructor-led, live training program, conducted in South Carolina (online or onsite), is structured to assist participants in preparing for the Microsoft Azure Fundamentals (AZ-900) certification examination.

The curriculum addresses fundamental cloud computing concepts and Azure service offerings. It delivers a thorough introduction to Azure, encompassing its architectural framework, pricing models, support structures, and the most frequently utilized Azure services.

Microsoft Excel is a standardized spreadsheet application widely adopted for administrative, analytical, and operational purposes. It serves as a robust platform for storing, structuring, and analyzing data in tabular formats. Key capabilities relevant to professional and public sector use include: 1. Structured Data Organization: The application utilizes workbooks composed of multiple worksheets, each consisting of a grid of cells arranged by rows and columns. This architecture facilitates the segregation and management of distinct datasets within a single file. 2. Computational and Formulaic Precision: Excel supports complex mathematical, statistical, and logical calculations. It includes an extensive library of built-in functions, such as SUM, AVERAGE, MAX, MIN, IF, and VLOOKUP, enabling accurate data processing. 3. Presentation and Formatting Standards: Comprehensive tools are available for standardizing data appearance, including font, color, and style adjustments. These features also support the generation of visual representations such as charts, pivot tables, and diagrams. 4. Data Refinement and Segmentation: Users can sort records based on defined criteria, filter content to isolate specific information subsets, and group data elements to align with reporting needs. 5. Advanced Analytical Capabilities: The software provides tools for deep-dive analysis, including scenario modeling, trend identification, forecasting, and macro development for repetitive tasks. 6. Collaborative Data Management: Features support real-time data exchange and simultaneous user collaboration, ensuring consistency and efficiency in shared work environments. 7. Process Automation: Through Visual Basic for Applications (VBA), users can create macros to automate routine operational tasks, enhancing workflow efficiency. Excel is extensively utilized across business, scientific, and educational sectors to support data analysis, report generation, budgeting, scheduling, and comprehensive data management functions.

Acquire essential Microsoft Excel skills in this beginner-focused training in South Carolina. The course addresses data entry, formatting, formulas, functions, tables, and data visualization, enabling participants to establish a strong foundation for data analysis and reporting for government agencies and public sector operations.

This Excel training for financial analysis addresses the advanced spreadsheet techniques required for government financial operations. The curriculum covers essential topics including lookup functions, search formulas, and Pivot Charts, as well as conditional formatting, external data workflows, and securities analysis. It provides practical methodologies for evaluating the time value of money, identifying market trends, constructing financial forecasting models, and utilizing Excel’s comprehensive analytical toolkit to support complex financial computations and reporting standards for government agencies.

This live instructor-led training, available in both onsite and remote formats, provides comprehensive guidance on the critical tools within MS Excel. By integrating meticulously prepared instructional materials with expert instructor facilitation, this program demonstrates the extensive operational capabilities of Excel spreadsheets for government applications.
In contrast to standard Excel instruction, this course highlights specialized functionalities designed to optimize workflow efficiency and enhance analytical precision for government operations.

This course provides financial analysts and accountants with the advanced skills necessary to automate complex calculations and reporting processes for government applications. It addresses core principles of financial functions, INDEX-MATCH lookup methods, database queries, PivotTables, PivotCharts, and external data integration. The curriculum explores Goal Seek, Solver, Analysis ToolPak, and VBA macros to streamline recurring workflows. It enables professionals to convert raw data into actionable financial insights and accurate forecasts that support strategic planning in the public sector.

Course Description

This three-day instructor-led training is designed for professionals seeking to transition into database administration roles or those whose current responsibilities are expanding to include database management for government systems. The curriculum covers foundational database concepts, including classification, programming languages, and architectural design.

Target Audience

The primary target for this course is individuals entering database-focused positions or those whose professional scope now incorporates database technologies.

Learning Outcomes

Upon successful completion of this course, participants will be able to:
• Identify core database concepts within the SQL Server 2016 framework
• Specify the database languages utilized in SQL Server 2016
• Outline data modeling methodologies
• Explain normalization and denormalization procedures
• Define relationship types and their implications for database design
• Evaluate the impact of database design on system performance
• Identify common database objects for government use

About This Course

This three-day Instructor-Led Training (ILT) course is designed to meet the operational requirements of information technology (IT) professionals responsible for administering, configuring, and maintaining Office 365 services. The curriculum addresses identities, dependencies, system requirements, and supporting technologies. Primary focus is placed on the skills necessary for the administration and troubleshooting of the Office 365 tenant and core services, including Exchange Online, SharePoint Online, and Microsoft Teams. Additionally, the course covers security frameworks and compliance mandates relevant to government operations.

Audience Profile

This course is intended for IT professionals and system administrators seeking to master administration and troubleshooting techniques within the Office 365 ecosystem. Participants should possess at least three years of professional experience in relevant fields, with preferred backgrounds in system administration, network administration, and messaging infrastructure.

Course Outcomes

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

• Describe the capabilities of Office 365 services.
• Administer Office 365 using the Microsoft 365 admin center and Office 365 service-specific admin centers, for government compliance and efficiency
• Administer and troubleshoot directory synchronization and directory objects.
• Administer and troubleshoot Exchange Online.
• Administer and troubleshoot Microsoft Teams.
• Administer and troubleshoot SharePoint Online.
• Plan and deploy Microsoft 365 Apps for enterprise.
• Administer and troubleshoot compliance and security settings in Office 365.

Course Description

This five-day instructional course equips participants with the expertise necessary to plan, administer, and maintain a Microsoft SharePoint 2016 environment. The curriculum covers the deployment, administration, and troubleshooting of SharePoint systems. Additionally, it provides regulatory guidelines, industry best practices, and strategic considerations to optimize SharePoint deployments for government operations.

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

Target Audience

This course is intended for experienced IT professionals who seek to master the installation, configuration, deployment, and management of SharePoint 2016 in both data center and cloud-based contexts.

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

A minimally qualified candidate typically meets the following criteria:

• Is an IT professional responsible for planning, implementing, and maintaining multi-server SharePoint 2016 deployments for government and public sector use.
• Has practical knowledge and, preferably, hands-on experience with SharePoint Online.
• Has a comprehensive understanding of SharePoint workloads.
• Has experience with business continuity management, including data backup, recovery, and high availability strategies.
• Has experience with authentication and security technologies.
• Has experience with Windows PowerShell.

* The hands-on or job experience should derive from a solutions-focused role where the candidate has managed multiple SharePoint initiatives, including document management, content management, and search services for government entities.

Learning Objectives

• Describe the primary features and capabilities 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.

This curriculum enables participants to optimize the creation, consolidation, and administration of data assets. The deployment of specialized tools significantly reduces operational processing times and supports the development of custom applications for executing novel governmental tasks for government efficiency.

Develop intermediate-level VBA proficiency with comprehensive instruction on custom interfaces, complex data structures, conditional logic, and iterative processing. This practical Excel VBA curriculum emphasizes robust exception management, performance enhancement, and UserForm implementation. It provides essential skills for government data analysts, reporting professionals, and business users requiring advanced automation capabilities to improve operational efficiency and data integrity in enterprise spreadsheet environments.

This instructor-led live training conducted in South Carolina (available online or onsite) targets entry-level analysts aiming to employ Excel VBA for the automation of routine duties, data refinement and transformation, and the optimization of reporting protocols for government use.

Upon completion, participants will be proficient in: recording and editing macros, composing elementary VBA procedures, utilizing Excel object models for reporting tasks, and diagnosing fundamental automation solutions.

This five-day Advanced Excel for Sales Professionals curriculum is designed to equip sales teams with the skills needed 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 using 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 applications.

This curriculum is designed to equip IT professionals with the capabilities required to administer Azure subscriptions, enforce identity security, oversee infrastructure operations, configure virtual networking, establish connectivity between Azure and on-premises environments, regulate network traffic, deploy storage architectures, provision and scale virtual machines, implement web applications and containers, execute data backup and sharing protocols, and monitor solution performance for government operations.

Targeted at Azure Administrators, this training addresses the responsibilities of implementing, managing, and monitoring identity, governance, storage, compute, and virtual network resources within cloud environments. Azure Administrators are responsible for provisioning, sizing, observing, and adjusting resources to ensure compliance and operational efficiency.

This instructor-led, live training in South Carolina (delivered online or on-site) is designed for entry-level IT professionals seeking to acquire knowledge of Microsoft Azure and cloud computing principles.

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

• Comprehend fundamental cloud computing concepts.
• Recognize core Azure service offerings.
• Explain core solutions and administrative tools available in Azure.
• Understand general security and network security protocols.
• Understand identity management, governance, privacy, and compliance frameworks.
• Understand Azure cost management practices and Service Level Agreements (SLAs).

Course Overview

This course outlines the various methods and best practices aligned with business and technical requirements for modeling, visualizing, and analyzing data using Power BI. It demonstrates how to access and process data from a range of sources, including both relational and non-relational databases. Additionally, the course explores the implementation of appropriate security standards and policies across the Power BI environment, including datasets and user groups. It further addresses the management and deployment of reports and dashboards for secure sharing and content distribution.

Target Audience

This course is designed for data professionals and business intelligence specialists seeking to master accurate data analysis using Power BI. It is also tailored for individuals who develop reports that visualize data from platform technologies hosted in the cloud or on-premises.

Acquired Skills

• Ingest, clean, and transform data
• Model data for performance and scalability
• Design and create reports for data analysis
• Apply and perform advanced report analytics
• Manage and share report assets

This course is intended for personnel with prior experience in Microsoft Excel who seek to align their workflows with established best practices. The curriculum addresses core data management principles, the utilization of Tables, Cell Styles, and Custom Number Formats, as well as advanced techniques for Conditional Formatting and Data Validation. Participants will acquire methodologies for analyzing and resolving formula errors, supported by AI tools, and learn the fundamentals of worksheet protection to develop clear, reliable, and error-resistant workbooks suitable for official government use.

This instructor-led, live training in South Carolina (delivered online or onsite) is designed for beginner-to-intermediate level business analysts and data analysts seeking to leverage Excel for data analysis and reporting within their professional assignments and projects.

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

• Employ Excel formulas and functions to execute calculations and manage data manipulation.
• Utilize Excel analytical tools, including PivotTables, What-If Analysis, and Forecasting, to summarize and visualize data.
• Generate and customize data visualizations using Excel charts and graphs.
• Apply Excel data validation and conditional formatting to maintain data integrity and emphasize critical insights.
• Utilize Excel data import and export capabilities to interface with external data sources and facilitate data sharing.

About This Course

Dynamics 365 Finance and Operations applications include, but are not limited to, Dynamics 365 Finance, Dynamics 365 Supply Chain Management, and Dynamics 365 Supply Chain Management, Manufacturing. Dynamics 365 Finance assists in the following: Automating and modernizing global financial operations. Monitoring performance in real time, predicting future outcomes, and making data-driven decisions to drive business growth. Driving strategic financial decisions with artificial intelligence (AI), unifying and automating financial processes, reducing operational expenses, and decreasing global financial complexity and risk for government entities. Dynamics 365 Supply Chain Management assists in the following: Transforming manufacturing and supply chain operations. Using predictive insights and intelligence from AI and the Internet of Things (IoT) across planning, production, inventory, warehouse, and transportation management. Maximizing operational efficiency, product quality, and profitability. Innovating with intelligent manufacturing operations, modernizing warehouse management, optimizing production performance, maximizing the life of assets, and automating and streamlining the supply chain for government operations. Note: For more information, please refer to https://learn.microsoft.com/en-us/training/paths/get-started-finance-operations/ In this module, the focus is on the core features and functionality of Dynamics 365 Finance applications that are most frequently utilized by end users and consultants in the public sector.

Audience Profile

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

At Course Completion

Upon completing this course, participants will be able to:

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

This five-day instructor-led training (ILT) program is designed to address the operational requirements of IT professionals involved in the evaluation, strategic planning, deployment, and ongoing operation of Microsoft Office 365 services for government. The curriculum covers critical aspects of identity management, dependency mapping, requirement analysis, and supporting technologies. The course emphasizes the skills necessary to establish an Office 365 tenant, including identity federation with existing user directories, and the competencies required to maintain tenant integrity and user support.

This course is targeted at IT professionals accountable for the planning, configuration, and management of Office 365 environments for government. Participants are expected to possess a comprehensive understanding of key on-premises technologies, including Domain Name System (DNS) and Active Directory Domain Services (AD DS). Additionally, candidates should demonstrate general proficiency with Microsoft Exchange Server, Microsoft Lync Server or Skype for Business Server, and Microsoft SharePoint Server.

Upon successful completion of this course, participants will be capable of:

• Strategic planning of Office 365 deployments, configuration of the Office 365 tenant, and design of pilot initiatives.
• Management of Office 365 users, groups, and licenses, as well as configuration of delegated administrative roles.
• Planning and implementation of client connectivity to Office 365.
• Planning and configuration of directory synchronization between Microsoft Azure AD and on-premises AD DS.
• Strategic planning and execution of Office 365 ProPlus deployments.
• Management of Microsoft Exchange Online recipients and associated permissions.
• Configuration of Exchange Online service parameters.
• Planning and implementation of Microsoft Teams.
• Configuration of Microsoft SharePoint Online services.
• Development of Office 365 collaboration solutions.
• Integration of Office 365 with Microsoft Azure Information Protection.
• Monitoring of Office 365 services and resolution of operational issues.
• Implementation of identity federation between on-premises AD DS and Azure AD.

This curriculum is intended for professionals preparing for the Microsoft 365 Administrator role who have successfully completed at least one of the Microsoft 365 role-based administrator certification tracks.

Course Description

This course establishes a foundational understanding of the strategic implications and operational benefits associated with adopting cloud services, specifically within the Software as a Service (SaaS) model. The curriculum focuses on Microsoft 365 cloud service offerings, providing essential knowledge for public sector operations. Participants will first explore cloud computing fundamentals, including an examination of Microsoft’s specific cloud infrastructure. The course introduces Microsoft Azure and distinguishes the functional differences between Microsoft 365 and Office 365. A comprehensive review of Microsoft 365 follows, covering comparisons between on-premises and cloud-based services, enterprise mobility standards, and collaborative capabilities. The curriculum concludes with an analysis of security, compliance, privacy, and trust frameworks, as well as an examination of subscription structures, licensing, billing, and support models.

Target Audience

This course is tailored for business leaders and IT specialists in government and the public sector who are responsible for implementing cloud services or seeking to develop a robust understanding of cloud fundamentals. It addresses the strategic considerations and operational advantages of cloud adoption, with a primary focus on the SaaS model and the specific service portfolio of Microsoft 365.

Learning Objectives

Upon successful completion of this course, participants will be able to:

• Distinguish between distinct cloud service models.
• Recognize the key variations among Microsoft 365 subscription tiers.
• Develop strategies for migrating to Microsoft 365 services.
• Identify the operational distinctions between on-premises infrastructure and Microsoft 365 cloud services.
• Explain how Microsoft 365 services facilitate collaborative workflows.
• Define identity management concepts, including cloud-based, on-premises, and hybrid architectures.
• Describe cloud-based device management and protection strategies, including the application of Intune.
• Outline data protection measures, specifically the implementation of Azure Information Protection.
• Explain general compliance principles and specific compliance features within Microsoft 365.
• Describe the structures for Microsoft 365 subscriptions, licensing, billing, and support