Explore our comprehensive catalog of professional training programs
In this Microsoft Access Introduction Training course, you'll see how to use Access to create databases to store and manage data. This course assumes little to no previous experience with Microsoft Access, so you'll start with creating a database from scratch. You'll see how to properly plan and design your database so that it runs efficiently and can be easily modified in the future. You'll learn about all of the main Microsoft Access Objects: Tables, Forms, Queries and Reports and will see how to create basic and advanced versions of each. Throughout this course you will perform hands-on exercises to create and extend a database with multiple Tables, Queries, Forms and Reports and you'll come away with an understanding of the role of each of these objects in a full-blown Microsoft Access database application. If you've inherited a database from a former co-worker or are just struggling to create a database of your own, this course is essential in understanding how Microsoft Access works and how you can use it to create applications to automate your business in just a matter of hours or days.
In this Microsoft Access Advanced Training Course, students will learn advanced Microsoft Access skills such as how to secure and manage a database, how to design advanced forms and how to split an Access database for a multi-user environment, utilizing a front-end and back-end database. Students will also see how to use Macros in Microsoft Access to automate common tasks and will get an introduction to using VBA (Visual Basic for Applications) to take their automation skills to the next level. This class also covers how to secure an Access Database and prepares Access Power Users to be able to develop full-scale applications.
In this Microsoft Access VBA Training course, students will learn how to use the VBA (Visual Basic for Applications) programming language to automate their database applications. They will learn about creating Sub Procedures and Functions and see how to call these blocks of code from an event occurring in Microsoft Access, such as a button being clicked or a user saving a record. Students will be introduced to the Microsoft Access Object Model, which will allow them to control all aspects of the application, including things like closing or opening forms, printing reports or validating user data entry. Students will also be introduced to accessing data in the database through code by using Data Access Objects (DAO,) allowing the manipulation of data behind the scenes - with no user action needed. Finally, students will see how to debug their code and add error handling to ensure that unexpected errors don't force an application shutdown. Although a programming environment, VBA is fun and easy to learn - even for students who have no programming experience!
In this Adobe Acrobat Pro DC Advanced Training course, students will use Adobe Acrobat Pro DC to convert technical documents to PDF files, enhance PDF documents, create interactive PDF forms, and prepare PDF files for commercial printing. This course is for students who want to create sophisticated, interactive PDF files utilizing the advanced features of Adobe Acrobat Pro.
In this Advanced Interpersonal Communication Training course students learn how to build positive relationships, provide positive and constructive feedback in a business setting, identify the guidelines for communicating with colleagues, respond to customer's complaints, and identify the ways in which managers can build a positive culture.
In this Crystal Reports Introduction Training course, students will learn how to build reports that incorporate sorting, grouping, filtering, subtotals, formulas and much more. Students will learn how to navigate the Crystal Reports interface, design and preview reports and prepare reports for printing or distribution. This class is for students who are new to building reports in Crystal Reports or may have used a previous version and want to update their skills.
In this Crystal Reports Intermediate Training Course, students will build on their existing knowledge of Crystal Reports to create more complex reports for specific business scenarios. Students will learn how to use Running Totals in a Crystal Report, which allow a user to summarize only specific data in a report (unlike Subtotals and Grand Totals, which don't provide as much control over which data is included in an aggregation.) As students progress through the course, they will also see how to create more advanced formulas that use loops to iterate over data and arrays to hold values for use in other places in the report. Another key takeaway for students in this course is how to use Subreports in situations where data from multiple, potentially unrelated, tables needs to be brought together in one report. The course continues with a lesson on how to use SQL statements directly in Crystal Reports as well as how to use Table Joins, Subqueries and SQL Expression fields. Students will also see the power and flexibility of Cross-Tab reports and Cross-Tab charts in Crystal and how they can be used to summarize data quickly and efficiently. Lastly, students will see some additional features to enhance reports, like adding dynamic images and creating reports that use geographic maps to display data.
The ability to deliver presentations is vital to achieving advancement for yourself and for your ideas. Few skills in life will contribute to your success as much as presentation skills. Without a dynamic and coherent presentation, even stellar ideas can fail to convince your audience. In this course, you will learn to organize your ideas to create coherent and convincing oral presentations, while also utilizing available visual aids and using public-speaking techniques to strengthen your delivery.
In this Microsoft Excel Introduction Training course, students will learn how to create worksheets in Microsoft Excel, how to use formulas and perform calculations, how to format cells and worksheets, how to setup worksheets for printing and how to export data from Excel to various other formats, including PDF. This course assumes no prior experience with Excel and is a great starting point for those who are new to the program or for those who may have some familiarity but want to take their knowledge further.
In this Microsoft Excel Intermediate Training class, students will learn how to build on their Excel skills by using named ranges in Excel, inserting Excel Functions such as IF and SUMIF, using comparison operators such as AND, OR and NOT and using Date Functions such as DATE and NOW. In addition, students will see how to manipulate text using Text Functions like UPPER, LOWER and CONCATENATE. Students will also learn about using Lists in Excel and sorting and filtering data in lists. Students will be exposed to Database functions such as DSUM and how to work with and format tables in Excel. Modifying and formatting Charts in Excel will also be explored in this course. And, finally, students will learn how to analyze date using PivotTables, PivotCharts, Timelines and Slicers.
In this Microsoft Excel Advanced training course, students will learn how to use features in Excel to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply complex formulas and functions. Students will see how to create Links and External References to Worksheets and Workbooks, use Lookup functions like VLOOKUP and HLOOKUP, and watch and evaluate formulas to find and fix logic errors. Students will also learn how to protect worksheets and workbooks from inadvertent changes being made, apply data validation to ensure correct data is entered in the worksheet and will see how to use Macros to automate common tasks in Excel. Finally, students will learn about visualizing data using Sparklines and Maps and how to forecast data trends in Excel.
In this Microsoft Excel VBA Training course, students will learn to use VBA in Excel to create interactive worksheets and automate common worksheet tasks. Students will see how to generate VBA code from existing macros, gain an understanding of the different parts of the Visual Basic Editor, learn how code is organized in Projects, Modules and Procedures and become familiar using Objects, Properties and Methods in their code. In addition, this course teaches students how to debug their VBA code to find and fix logic errors, interact with the user using dialog boxes, control formatting of the worksheet using VBA code and how to automate the addition and deletion of workbooks. Finally, students will see how to perform calculations in code and use built-in functions in Excel in VBA to quickly calculate large amounts of data.
In this Microsoft Outlook Introduction Training course, students will use Outlook to compose and manage their email communications, calendar, contacts, and tasks. Students will learn to navigate Outlook to read and respond to email. Use the Address Book and format and spell check new messages. Attach files and insert illustrations to messages. Customize read and response options. Use flags, categories, and folders to organize messages. Create and work with Contacts. Create appointments and schedule meetings in Calendar and create and work with Tasks and Notes.
In this Microsoft Outlook Advanced Training course, you will use Outlooks advanced features to customize and manage your email communications, including using advanced features to organize emails, managing calendar settings and options, managing contact information, scheduling tasks, and managing Outlook archives and data file settings. You will: Insert objects in messages, and modify properties and global options. Organize, search, and manage messages. Protect your mailbox and manage its size. Use rules and Quick Steps to automate message management. Work with advanced calendar settings. Import and forward contacts. Assign delegate permissions and share Outlook items with others. Archive and back up Outlook items using data files.
Every project has a beginning, a middle, and an end — but what happens in between determines whether it succeeds or fails. Project Management Fundamentals gives you the practical tools and vocabulary to take charge of that journey with confidence.
In one focused day, you will move from understanding what makes something a project (versus just ongoing work) all the way through closing it out and writing the final report. Along the way you will learn how to define scope before work begins, build a realistic schedule using Work Breakdown Structures and critical path analysis, identify and analyze risks before they become problems, keep stakeholders informed through a structured communication plan, and control changes so that scope creep does not quietly derail your timeline or budget.
This course is grounded in the same frameworks used by professional project managers worldwide — including concepts aligned with the PMBOK (Project Management Body of Knowledge) — presented in plain language with hands-on activities and real-world scenarios throughout.
In this Microsoft PowerPoint Introduction Training course, you will learn how to create and deliver an engaging PowerPoint presentation. You will: Identify the basic features and functions of PowerPoint. Develop a PowerPoint presentation. Perform text formatting. Add and arrange graphical elements. Modify graphical elements and prepare to deliver your presentation.
In this Microsoft PowerPoint Advanced Training course, students will take their existing PowerPoint skills, and presentations, to the next level. They'll learn how to customize design templates, add tables and charts to their presentations, work with multimedia, build advanced slide transitions and animations, collaborate with others on a presentation, and secure and distribute a presentation.
This Microsoft Project training course is designed to show students how to use Microsoft Project to effectively manage projects. The course covers the critical knowledge and skills a project manager, or other individual tasked with managing projects, needs to create a project plan with Microsoft Project and shows students how to utilize Microsoft Project to oversee the planning, execution, monitoring, and controlling phases of their projects. This course will enable students to utilize Microsoft Project to manage projects so that they are completed on time, within budget, and according to scope.
Students will learn how Microsoft Project calculates their project schedule using a project start or end date, task relationships, resource availability and project calendars. Students will also see how to use various views in Microsoft Project, including the Gantt chart view, to analyze the project progress. This course also shows students how to share the project plan with others who may not have Microsoft Project installed and how to create a Project template to speed the creation of future projects.
Power Pivot is a powerful data exploration tool based on in-memory computing technologies that provides unmatched analytical performance to process billions of rows almost instantaneously. In this Microsoft Excel Power Pivot Training course, students will learn how to use Power Pivot to import and manipulate data, create Power Pivot reports, use DAX functions, create key performance indicators (KPI) and use slicers to enhance the visualization of data.
In this SQL Querying Introduction Training course, students will learn the basics of retrieving data from a database using Structured Query Language (SQL.) Students will also learn how to sort, filter and group data in a query result. In addition this course shows students how to join tables in a SQL statement and how to use basic SQL functions.
In this SQL Querying Advanced Training course, students will learn how to use subqueries; how to insert, modify and delete data using a SQL statement; how to create, backup and delete tables and how to work with views, indexes and transactions.
This course gives SharePoint site owners the practical skills needed to confidently manage and customize modern SharePoint Online sites. Participants learn how to configure site settings, manage lists and libraries, control access, build pages, and support team collaboration using Microsoft 365 tools. Through hands‑on activities, learners practice creating and organizing content, applying modern site features, and ensuring their sites are structured, secure, and easy for users to navigate. By the end of the course, students will be able to maintain a functional, well‑organized SharePoint site that supports their team’s daily work.
Microsoft SharePoint, together with the Microsoft 365 suite, provides a robust platform for building and managing a corporate intranet. It enables organizations to centralize content, streamline collaboration, and maintain consistent information governance. This course is designed for experienced SharePoint site owners who are ready to advance into deeper site‑building and administrative capabilities. You will learn how to create custom site templates, configure managed metadata, build and apply content types, manage permissions, and strengthen site‑level and tenant‑level security. By the end of the course, you will be equipped to extend SharePoint’s capabilities, improve information structure and discoverability, and support governance and compliance across your environment.
This course introduces everyday SharePoint users to the essential skills needed to work confidently within modern SharePoint Online sites. Participants learn how to navigate sites, access and manage content, collaborate with team members, and use core features such as lists, libraries, views, sharing, and search. Through hands‑on practice, learners gain the ability to upload, organize, edit, and share information while understanding how SharePoint fits into the broader Microsoft 365 ecosystem. By the end of the course, students will be able to use SharePoint effectively as a central hub for team communication and content management.
This Time Management Training course introduces students to the concepts of time management and it's importance in increasing personal productivity. The course covers how to set goals, use technology and tools to help manage a schedule and how to prevent interruptions and other obstacles from affecting your efforts.
In this Microsoft Word Introduction Training course, you'll learn how to use Word on the desktop to create and edit simple documents, format documents, add tables and lists, add design elements and layout options, and proof documents. This course also helps prepare students interested in the Microsoft Office Specialist Program for the Word Associate (Office 365 and Office 2019): Exam MO-100 and Word Expert (Office 365 and Office 2019): Exam MO-101 certification exams.
In this Microsoft Word Intermediate Training course, students will learn how to organize content using tables and charts, customize formats using styles and themes, insert content using Quick Parts, use templates to automate document formatting, manage long documents and use mail merge to create letters, envelopes and labels. This course also helps prepare students interested in the Microsoft Office Specialist Program for the Word Associate (Office 365 and Office 2019): Exam MO-100 and Word Expert (Office 365 and Office 2019): Exam MO-101 certification exams.
In this Microsoft Word Advanced Training course, students will learn how to use images in a document, create custom graphic elements for use in their documents, collaborate with others in creating and editing documents, add reference marks and notes to documents, secure sensitive documents, create forms in Microsoft Word documents and use macros to automate common tasks. This course also helps prepare students interested in the Microsoft Office Specialist Program for the Word Associate (Office 365 and Office 2019): Exam MO-100 and Word Expert (Office 365 and Office 2019): Exam MO-101 certification exams.
Analyzing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft Excel is designed for this purpose. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. In this Excel Data Analysis and Visualization Training course, students will learn how to connect to a wide range of data sources, perform data analysis, create diverse and robust data-based visualizations to show insights and trends, and create reports.
SharePoint Online is a powerful platform used by organizations to manage content, support collaboration, and create centralized hubs for communication. Without the right training, however, it can feel overwhelming. This course gives you the practical skills needed to confidently build, organize, and manage SharePoint Online sites. Through hands‑on labs, real‑world scenarios, and guided instruction, you’ll learn how to create site structures, manage lists and libraries, build pages, automate processes, and configure permissions. By the end of the course, you’ll be able to turn SharePoint into a productive, user‑friendly workspace for your team or department.
This Microsoft 365 Messaging training course examines the key elements of Microsoft 365 messaging administration, including message transport and mail flow, messaging security, hygiene, and compliance, messaging infrastructure, and hybrid messaging. This course is designed for persons who are aspiring to be Messaging Administrators in a Microsoft 365 deployment.
In this Microsoft 365 Security Administration training course you will learn how to secure user access to your organizations resources. The course covers user password protection, multi-factor authentication, how to enable Azure Identity Protection, how to setup and use Azure AD Connect, and introduces you to conditional access in Microsoft 365. You will learn about threat protection technologies that help protect your Microsoft 365 environment. Specifically, you will learn about threat vectors and Microsofts security solutions to mitigate threats. You will learn about Secure Score, Exchange Online protection, Azure Advanced Threat Protection, Windows Defender Advanced Threat Protection, and threat management. In the course you will learn about information protection technologies that help secure your Microsoft 365 environment. The course discusses information rights managed content, message encryption, as well as labels, policies and rules that support data loss prevention and information protection. Lastly, you will learn about archiving and retention in Microsoft 365 as well as data governance and how to conduct content searches and investigations. This course covers data retention policies and tags, in-place records management for SharePoint, email retention, and how to conduct content searches that support eDiscovery investigations.
In this Customer Service Training course, students will explore the background and techniques of customer interactions. Providing quality customer care ensures that every single contact with your company is a positive experience. Customers can range from external consumers to internal employees in other departments. Knowing how to provide the same level of service to all customers will enrich your time spent at work by establishing positive business relationships. Recognizing crucial points throughout customer interactions increases your ability to solve problems and offer affirmative solutions. Applying this knowledge to trends in service and consumer desires allows you to contribute to the companys bottom line and make a customers life a little easier.
Take your Photoshop skills to the next level with this intermediate course. Building on a solid foundation of Photoshop basics, you will master advanced raster and vector image creation, sophisticated layer techniques, task automation, video editing, and professional project management practices. This course also helps prepare you for real-world design workflows and the Adobe Certified Professional in Visual Design Using Adobe Photoshop exam.
Using AI with Excel is a hands‑on, scenario‑driven course that teaches professionals how to use freely available generative AI tools—such as ChatGPT, Gemini, and Microsoft Copilot—to enhance productivity, solve spreadsheet‑related problems, and accelerate data‑driven decision‑making. Learners discover how to generate spreadsheet content, automate tasks, troubleshoot formulas, clean and structure data, and strategically apply AI to real business challenges. The course blends conceptual understanding with practical exercises using Microsoft Excel.
Note: Students in this class will create ChatGPT, Gemini and/or Copilot accounts if they don't already have one. Access to a valid email and cell phone in order to complete authentication during setup will be needed to participate in hands-on exercises.
Generative AI tools such as Copilot, Gemini, and ChatGPT make it faster and easier to plan, write, and enhance business presentations. This course shows professionals how to use AI to brainstorm topics, generate slide text, create images, and develop presenter notes and handouts. Learners practice prompting techniques, refine AI‑generated content for clarity and professionalism, and import structured outlines directly into PowerPoint. They also explore how to use AI‑assisted web search to strengthen presentations with supporting facts and examples. By the end of the course, participants will have a streamlined workflow for using free AI tools to create polished, engaging presentations with greater speed and confidence.
Note: Students in this class will create ChatGPT, Gemini and/or Copilot accounts if they don't already have one. Access to a valid email and cell phone in order to complete authentication during setup will be needed to participate in hands-on exercises.
AI agents are rapidly becoming a core driver of business automation. Harnessing the power of generative AI and large language models (LLMs) through agentic frameworks introduces powerful new ways to streamline operations, boost productivity, and free users from tedious and time-wasting tasks. By designing and deploying agents responsibly and effectively, organizations can accelerate adoption, reduce risks, and gain a competitive advantage in the impending "agentic shift."
This course is an introduction to AI agents from a strategic business perspective. It will not teach you how to build agents — instead, it will teach you how to determine whether, where, and how agents should exist in your organization.
This course is also designed to assist students in preparing for the CertNexus® AgenticAIBIZ™ (Exam AGZ-110) credential.