Microsoft Office Training in Pennsylvania

This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level business professionals, educators, and marketers who wish to integrate DeepSeek with PowerPoint to automate and optimize their presentations for government use.

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

• Automate the creation of text-based content in PowerPoint slides using DeepSeek.
• Generate data-driven visuals and infographics powered by DeepSeek models.
• Utilize AI to summarize lengthy reports and convert them into presentation-ready slides.
• Integrate DeepSeek with PowerPoint for streamlined, dynamic presentations that enhance public sector workflows.

This instructor-led, live training in Pennsylvania (online or onsite) is aimed at beginner to intermediate level professionals who wish to master Microsoft Word, Excel, and PowerPoint for enhanced document creation, data analysis, and presentations for government use.

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

• Effectively create, format, and manage documents in Microsoft Word.
• Utilize Excel for data entry, analysis, and visualization.
• Design engaging and professional presentations in PowerPoint.
• Leverage collaboration features across Microsoft Office applications to enhance productivity and efficiency in government workflows.

This instructor-led, live training in Pennsylvania (online or onsite) is aimed at individuals who wish to learn and utilize the software and services available in the Microsoft Office suite to enhance their work productivity for government.

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

• Master and apply the various applications within the Microsoft Office suite.
• Improve work efficiency and foster effective collaboration using Microsoft Office tools and services for government.

This instructor-led, live training in Pennsylvania (online or onsite) is designed for MS Office users who wish to become proficient in the various tools and techniques provided by MS Office software and services.

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

• Learn and master shortcut techniques within MS Office.
• Master macros and other Excel functions for efficient worksheet manipulation.
• Utilize PowerPoint controls and advanced features for creating impactful presentations.
• Navigate and search through Outlook quickly and effectively.

This training is tailored to enhance productivity and efficiency, aligning with the needs of users in a government setting.

Microsoft Word is a robust word-processing application designed for creating, formatting, and managing professional documents.

This instructor-led, live training (online or onsite) is aimed at users ranging from beginner to advanced levels who wish to develop comprehensive skills in creating, editing, formatting, and automating documents in Microsoft Word.

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

• Create professional documents with consistent formatting.
• Utilize intermediate features such as styles, templates, and collaboration tools.
• Apply advanced tools including mail merge, references, and automation.
• Enhance productivity by leveraging Word’s advanced layout and document management capabilities for government use.

Format of the Course

• Engaging demonstrations and guided instruction.
• Extensive practical exercises and skill-building tasks.
• Real-time document creation and refinement in a live environment.

Course Customization Options

• If you require a tailored version of this training, please contact Govtra to discuss customization options for government needs.

This instructor-led, live training in Pennsylvania (online or onsite) is aimed at individuals who wish to master the essential functions and features of Microsoft Word to enhance their productivity for government tasks.

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

• Understand the foundational elements of Microsoft Word to effectively support daily responsibilities, such as creating meeting notes and memos for government.
• Utilize various formatting tools to enhance document clarity and professionalism.
• Effectively manage document collaboration to ensure seamless teamwork and compliance with public sector workflows.

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.

This course is designed for individuals with a basic working knowledge of PowerPoint 2019 who seek to enhance their skills in utilizing the application’s advanced features for government. These features include improved usability, enhanced security measures, robust collaboration tools, and efficient distribution capabilities.

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

This instructor-led, live training in Pennsylvania (online or onsite) is aimed at data analysts who wish to use advanced VBA in Excel for automating tasks for government.

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

• Write an advanced object-oriented application
• Convert text files
• Utilize external data sources
• Incorporate external libraries

This instructor-led, live training in Pennsylvania (online or onsite) is aimed at data analysts who wish to use VBA in Excel for automating tasks for government.

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

• Record and edit macros as required.
• Write procedures using data from the sheet.
• Create your own functions.
• Handle events (such as opening a worksheet or cell updates) by means of event handlers.
• Create forms for enhanced user interaction.

This instructor-led, live training in Pennsylvania (online or onsite) is aimed at data analysts for government who wish to use VBA in Excel for automating tasks.

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

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

Audience

Analysts, researchers, scientists, graduates and students, and anyone interested in enhancing their ability to conduct statistical analysis using Microsoft Excel for government.

Course Objectives

This course is designed to enhance your proficiency with Excel and statistical methods, thereby increasing the effectiveness and efficiency of your work or research. It will provide practical skills that are directly applicable to public sector workflows and governance.

The course covers the use of the Analysis ToolPack in Microsoft Excel, statistical functions, and basic statistical procedures. It will also address Excel's limitations and offer strategies for overcoming them to ensure accurate and reliable data analysis for government.

Data analytics is a critical tool in the public sector today. This course will focus on developing practical, hands-on skills for government data analysis. The aim is to equip participants with the ability to provide evidence-based answers to key questions:

What has happened?

• processing and analyzing data
• creating informative data visualizations

What will happen?

• forecasting future performance for government operations
• evaluating the accuracy of forecasts

What should happen?

• transforming data into evidence-based decisions for government
• optimizing processes and workflows

During the training, we will address the issues of financial analysis using the advanced features of Excel for government.

This course is intended for financial analysts, accountants, and all those who wish to enhance their spreadsheet skills with a focus on financial analysis for government.

This live, instructor-led training (onsite or remote) is designed to guide participants through the most essential tools of MS Excel. By combining thoroughly prepared training materials with the expertise of the instructor, attendees will gain a comprehensive understanding of the extensive capabilities of Excel spreadsheets.
In contrast to other typical Excel courses, this training will reveal many unique functionalities that can significantly enhance and expedite your work for government.

Audience

Financial or market analysts, managers, and accountants for government

Course Objectives

Facilitate and automate a variety of financial analyses using Microsoft Excel for government applications.

This live instructor-led training (onsite or remote) will guide participants through the essential elements of Excel VBA. The course combines thoroughly prepared training materials with the instructor's expertise to showcase the capabilities of task automation using VBA for government applications.

Format of the Course

• Interactive lecture and discussion.
• Hands-on implementation in a live-lab environment.

Course Customization Options

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

Course participants will learn how to create professional-looking documents using Microsoft Word for government. They will also gain the ability to efficiently perform a variety of calculations in a transparent manner to organize and present their results. Additionally, participants will use multiple mechanisms to facilitate and accelerate the creation of spreadsheets in Excel, enhancing productivity and accuracy for government workflows.

This one-day course is designed for information workers who are currently using or will soon begin using Office 365. The course aims to equip participants with the essential knowledge and skills needed to efficiently utilize Office 365 in their daily work. With a focus on real-world scenarios, students will learn how to effectively use Outlook Online, Skype for Business, OneDrive for Business, SharePoint Online, and OneNote. By the end of the course, participants will be proficient in navigating Office 365 and leveraging all its features to enhance productivity for government operations.

Welcome to Microsoft® Project® 2019/2021: Part 1. This course is designed to familiarize you with the essential features and functions of Microsoft Project, enabling you to use it effectively and efficiently in real-world scenarios. The course covers the critical knowledge and skills required for a project manager to create a project plan using Project during the planning phase. In other words, if your supervisor assigns you to lead a project, this course will equip you to draft a project plan with Microsoft Project and share it with your supervisor (and others) for review and approval.

Learning Objectives

In this course, you will learn to construct basic project plans using Microsoft Project.

• You will:
• Identify key project management concepts and navigate Microsoft Project Professional.
• Create a new project plan.
• Add tasks to a project.
• Manage task relationships within a project.
• Manage project resources.
• Finalize a project plan.

This course is tailored specifically for government professionals, ensuring alignment with public sector workflows, governance, and accountability. It aims to enhance your ability to manage projects efficiently and effectively, leveraging the robust features of Microsoft Project for government applications.

Learning Objectives

In this course, you will learn fundamental Word skills for government use.

• You will:
• Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application settings.
• Format text and paragraphs to enhance document clarity and professionalism.
• Perform repetitive operations more efficiently using tools like Find and Replace, Format Painter, and Styles.
• Enhance lists by sorting, renumbering, and customizing list styles for better organization.
• Create and format tables to present data clearly and effectively.
• Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art, to enrich content.
• Format the overall appearance of a page through the use of page borders and colors, watermarks, headers and footers, and page layout options.
• Utilize Word features to help identify and correct issues with spelling, grammar, readability, and accessibility, ensuring compliance with government standards.

TARGET AUDIENCE

This course is intended for students who want to learn basic Word 2019 skills for government use, such as creating, editing, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content.

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.

Course participants will learn how to create clear, professional-looking documents, including all types of official correspondence. They will also gain a comprehensive understanding of the fundamental mechanisms that ensure the transparent flow of information in both short and long documents for government use.

Course participants will learn how to automate the process of creating complex documents, retrieving data from databases, and preparing forms for government use.

This instructor-led, live training in Pennsylvania (online or onsite) is aimed at beginner to intermediate level professionals who wish to enhance their skills in extracting, analyzing, and manipulating data within Microsoft Access using queries and SQL.

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

• Understand different types of queries in Microsoft Access for government use.
• Use query design tools to extract and analyze data effectively for government workflows.
• Write SQL queries to retrieve and manipulate data efficiently for government applications.
• Perform data aggregation, filtering, and sorting using queries to support public sector governance.
• Apply advanced query techniques for troubleshooting and optimization in a government context.

This course is designed for individuals who are already familiar with the basics of VBA and wish to enhance their skills and utilize the full capabilities of the language for government applications.

Training for government employees working with Microsoft Excel spreadsheets who wish to enhance their proficiency and efficiency in their work.

The course is designed for government users of Excel to create analyses and reports for government.

Please answer the following questions:

• Is your daily work in Excel a never-ending series of copy-paste commands?
• Are you wasting time repeating similar operations to prepare data for analysis?
• Do you know all the keyboard shortcuts in Excel, yet still find the results unsatisfactory?
• Instead of focusing on data analysis, are you spending excessive time preparing data?
• Do you have to manually verify the correctness of data obtained from different systems?
• Are you staying late at work or taking Excel files home because you cannot complete tasks during regular hours?
• Is your job to prepare reports based on large data sets?
• Do you feel that working in Excel, you are taking a roundabout way to achieve results?

If you can answer YES to any of these questions, then it is time to end this inefficiency. This training is for government professionals like you.

Discover how you can streamline your daily operations and maximize the capabilities of MS Excel.

WARNING

After completing this training, your workflow will be transformed significantly. Tasks that once took an entire day will now take just a few moments. Are you ready for this change?

This course is designed to enhance the PowerPoint skills of participants through practical exercises complemented by relevant theoretical instruction. It is tailored for a broad audience, including presentation designers, conference speakers, and team meeting presenters, with a focus on improving capabilities for government presentations.

This course is designed for government professionals seeking to enhance their efficiency in creating PowerPoint slides and mastering the fundamentals of effective presentations for government use.

This course is designed for government sales teams. It emphasizes the effective use of PowerPoint’s functionalities to enhance the sales process. Key topics include strategies for presenting data clearly, avoiding overly cluttered slides, and identifying essential elements to highlight in a sales presentation for government audiences.

This Advanced PowerPoint Training course is designed for government professionals seeking to enhance their presentation capabilities and develop visually engaging presentations. Over the two-day program, participants will receive hands-on instruction in advanced PowerPoint features, such as business presentation techniques, infographic design, animation, thematic consistency, and the integration of digital media into slides. The course also includes training on data analysis and presentation skills using the PwC approach, ensuring that participants can effectively communicate complex information to their audiences for government use.

Objective:

Enhancing the capability to create compelling presentations using PowerPoint and other tools.

Addressees:

Sales representatives, consultants, research and teaching staff, managers, educators, corporate employees, small and medium-sized enterprises (SMEs), and public institutions. This training is designed for government and private sector professionals who need to engage and captivate their audience.

In today's rapidly evolving industry, effective communication and the efficient use of technology are essential for government professionals. This training provides a practical approach to leveraging AI for enhanced communication and mastering impactful presentation techniques.

This instructor-led, live training (online or onsite) is designed for intermediate-level government professionals who wish to upgrade their skills.

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

• Effectively use ChatGPT for enhancing communication and streamlining administrative tasks for government operations.
• Develop intermediate-level PowerPoint skills for creating engaging presentations that align with public sector workflows.

This instructor-led, live training in Pennsylvania (online or onsite) is aimed at beginner-level to intermediate-level business analysts and data analysts who wish to use Excel to perform data analysis and reporting for their projects and tasks for government.

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

• Use Excel formulas and functions to perform calculations and data manipulation.
• Use Excel data analysis tools such as PivotTables, What-If Analysis, and Forecasting to summarize and visualize data for government.
• Use Excel charts and graphs to create and customize data visualizations for government.
• Use Excel data validation and conditional formatting to ensure data quality and highlight data insights for government.
• Use Excel data import and export features to connect to external data sources and share data with others for government.

This course covers the following key elements of Microsoft 365 administration for government: Microsoft 365 tenant management, Microsoft 365 identity synchronization, and Microsoft 365 security and compliance.

In Microsoft 365 tenant management, participants will learn how to configure their Microsoft 365 tenant, including organizational profiles, subscription options, component services, user accounts and licenses, security groups, and administrative roles. The course then transitions to configuring Microsoft 365 with a primary focus on Office client connectivity, followed by managing user-driven client installations of Microsoft 365 Apps for enterprise deployments.

The course next delves into an in-depth examination of Microsoft 365 identity synchronization, focusing on Azure Active Directory Connect and Connect Cloud Sync. Participants will learn how to plan for and implement these directory synchronization options, manage synchronized identities, and implement password management using multifactor authentication and self-service password reset.

In the section on Microsoft 365 security management, participants will explore common types of threat vectors and data breaches facing organizations today. The course covers how Microsoft 365’s security solutions address these threats, introduces the Microsoft Secure Score, and Azure Active Directory Identity Protection. Participants will also learn to manage Microsoft 365 security services, including Exchange Online Protection, Safe Attachments, and Safe Links, as well as various reports that monitor an organization's security health. The course then transitions to threat intelligence, specifically using Microsoft 365 Defender, Microsoft Defender for Cloud Apps, and Microsoft Defender for Endpoint.

After gaining a comprehensive understanding of Microsoft 365’s security suite, the course examines key components of Microsoft 365 compliance management. This includes an overview of data governance aspects such as data archiving and retention, Microsoft Purview message encryption, and data loss prevention (DLP). Participants will delve deeper into archiving and retention, with a focus on Microsoft Purview insider risk management, information barriers, and DLP policies. The course concludes by examining how to implement these compliance features using data classification and sensitivity labels.

Gain insights into the management of Office 365, including its key components, the process of transitioning an organization to Office 365, configuration procedures, and the management of Office 365 ProPlus deployments.

Audience Profile

This course is designed for individuals aiming for the Microsoft 365 Enterprise Admin role who have already completed one of the Microsoft 365 role-based administrator certification paths. It is tailored to enhance skills and knowledge for government professionals seeking to optimize their use of Office 365.

Skills Gained

• Overview of Office 365
• Transitioning an organization to Office 365
• Configuring Office 365
• Managing Office 365 ProPlus deployments

In this course, participants will learn to plan and execute an endpoint deployment strategy using current deployment techniques and implementing update strategies. The curriculum introduces essential elements of modern management, co-management approaches, and integration with Microsoft Intune. It covers app deployment, the management of browser-based applications, and key security concepts such as authentication, identities, access, and compliance policies. Technologies like Azure Active Directory, Azure Information Protection, and Microsoft Defender for Endpoint are explored to safeguard devices and data, ensuring robust security practices for government.

Audience

This course is designed for individuals who possess a foundational understanding of Microsoft® Office Outlook® and are seeking to leverage its advanced functionalities to effectively manage their email communications, calendar events, contact information, search capabilities, and other communication tasks for government.

In this course, participants will utilize PowerPoint 2019 to develop compelling and dynamic multimedia presentations for government. The training will focus on enhancing presentation skills that are essential in public sector workflows, ensuring clear communication and effective information delivery.

This one-day training session is designed for individuals who use SharePoint as power users, fulfilling roles such as SharePoint site owners and/or Site Collection administrators.

Course objectives:

• Configure site navigation for enhanced user experience.
• Review site activity reports to monitor usage and engagement.
• Customize lists and libraries to meet specific organizational needs.
• Work with Site Columns and Site Content Types to ensure consistent data management.
• Set up Check out/in, Content Approval, and Versioning for better document control.
• Create and modify pages and web part pages to support dynamic content delivery.

This training is tailored to enhance SharePoint capabilities for government users, ensuring alignment with public sector workflows, governance, and accountability.

This one-day training session is designed for individuals who use SharePoint as end-users and wish to gain a deeper understanding of the tool’s advanced features. Participants should attend this course if they need to comprehend functions such as team collaboration, document management, and social capabilities in Microsoft SharePoint 2013.

This course is tailored for:

• SharePoint Site Owners and users

Course objectives:

• Manage sites and site collections effectively
• Add and manage users and groups, and control security settings for sites, lists, folders, and items
• Install and configure web parts to enhance functionality
• Customize site options, including themes, titles, descriptions, and icons

The training is specifically designed to align with the needs of federal agencies and departments, ensuring that users are equipped with the necessary skills for government operations.

This instructor-led, live training in Pennsylvania (online or onsite) is designed for IT administrators who wish to manage Office 365 as part of their responsibilities.

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

• Address the most common end-user support requests efficiently.
• Resolve startup and version compatibility issues effectively.
• Backup and restore damaged files to ensure data integrity for government operations.

This instructor-led, live training in Pennsylvania (online or onsite) is aimed at financial analysts and staff who wish to utilize Adaptive OfficeConnect for creating financial reports using Microsoft Office Excel, Word, and PowerPoint for government.

By the end of this training, participants will be able to build, create, and update financial reports within the Microsoft Office Suite, enhancing their capabilities for government reporting and analysis.

TARGET AUDIENCE

This course is designed for individuals with a foundational knowledge of Microsoft® Windows® who require the skills to effectively utilize Outlook as an email client for managing their email communications, scheduling calendar events, organizing contact information, and handling other communication tasks for government.

This instructor-led, live training in Pennsylvania (online or onsite) is designed for government marketeers who wish to create video content and presentations using Camtasia and PowerPoint.

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

• Develop video content and share it on a video hosting platform.
• Utilize assets within Camtasia, such as music and icons, to create interactive content.
• Reduce costs by producing high-quality videos with Camtasia and PowerPoint for government use.

This course is designed to provide participants with comprehensive knowledge on presenting financial information effectively using PowerPoint, extending beyond basic presentation skills. Participants will gain the ability to communicate financial data in a more professional and impactful manner, tailored specifically for government audiences.

This instructor-led, live training (available online or onsite) is designed for government developers at the beginner to intermediate level who wish to utilize VSTO to create customized solutions for Microsoft Office applications.

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

• Develop add-ins and document-level customizations for Office applications.
• Access and manipulate the Office object model and its events.
• Create custom ribbons, task panes, and dialogs for Office applications.
• Incorporate Windows Forms controls and .NET components into Office documents.
• Integrate Office applications with web services and databases.
• Deploy and secure Office solutions for government use.