TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Publisher for Office 365/2021

Microsoft® Publisher for Office 365/2021 is a desktop publishing software application capable of producing greeting cards, certificates, newsletters, and other printed publications. Publisher includes a large collection of templates that provide a great way to start a new publication. Publisher offers a large selection of “building blocks” that can be dragged into your documents, helping you to create page elements such as calendars, newsletter sidebars, and borders. Publisher integrates online sharing and mail merge features, which are handy when you need to send publications to a list of customers, and it’s possible to export publications as HTML web pages or PDF documents. With a user-friendly interface, Publisher makes it easy to create and edit publications.

This course presents information and skills that are appropriate for users of the Office 2019 or Office 365 desktop applications. However, the instructional environment for the delivery of this course utilizes Office 365.

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft SharePoint Modern Experience: Advanced Site Owner

Microsoft® SharePoint®, in conjunction with the Microsoft 365™ productivity and office automation suite, provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location.

Users who already have experience as SharePoint site members and owners may be ready to move on to more advanced site-building tasks such as using custom site templates, custom themes, applying advanced permissions settings, improving security, and preparing sites to support governance and compliance.

Advanced site builders may be ready to undertake more advanced site management tasks, working in conjunction with their SharePoint Administrator to create and use custom site templates, term sets and metadata, manage information governance and compliance, and get deeper into SharePoint security configuration.

This course focuses on these advanced site-building and administration tasks.

This course is the third part of a three-course series that covers the skills needed to gain a foundational understanding of SharePoint.
– SharePoint Modern Experience: Site Basics
– SharePoint Modern Experience: Site Owner with Power Platform
– SharePoint Modern Experience: Advanced Site Owner (this course)

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft SharePoint Modern Experience: Site Basics

In many professional environments, people work collaboratively in teams. Information technology and applications facilitate this by enabling people to easily share, access, edit, and save information. Microsoft® SharePoint® is a platform specifically designed to facilitate communication and collaboration, enabling people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. In this course, you will use SharePoint to access, store, share, and collaborate with information and documents.

This course is the first part of a three-course series that covers the skills needed to gain a foundational understanding of SharePoint.
– SharePoint Modern Experience: Site Basics (this course)
– SharePoint Modern Experience: Site Owner with Power Platform
– SharePoint Modern Experience: Advanced Site Owner

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Visio 2016: Part 1

From the earliest eras of human existence, visual images have been used to represent knowledge, data, and information. Beginning with the Paleolithic cave paintings and continuing to today’s most complex computer networks, these images leverage the ability of the human brain to rapidly perceive patterns and trends from visual representations.

In today’s workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts. Microsoft® Visio® provides you with an intuitive, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes. By following the exercises in this course, you will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.

This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of Visio.
Microsoft Visio 2016: Part 1 (this course)
Microsoft Visio 2016: Part 2

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Visio 2019/2021: Part 1

From the earliest eras of human existence, visual images have been used to represent knowledge, data, and information. Beginning with the Paleolithic cave paintings and continuing to today’s most complex computer networks, these images leverage the ability of the human brain to rapidly perceive patterns and trends from visual representations.

In today’s workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts. Microsoft® Visio® provides you with an intuitive, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes. By following the exercises in this course, you will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.

This material will benefit users of any current Office version. The classroom environment setup is based on Office 2019.

This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of Visio.
Microsoft Visio 2019/2021: Part 1 (this course)
Microsoft Visio 2019/2021: Part 2

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Visio 2019/2021: Part 2

Microsoft® Visio® stands out among similar applications because of its unique ability to draw a wide variety of diagrams, flowcharts, workflows, and organization structures—anything that can be represented by shapes connected by lines. Most importantly, these shapes can be rearranged and with corresponding lines remaining intact. Visio has improved over the years as features common among Microsoft® Office applications have been added. Today, Visio is well integrated with other members of the Office family as well as Microsoft’s cloud-based services. This greatly enriches the sharing and publishing of Visio drawings.

In Microsoft® Visio® 2019/2021: Part 1, you learned the basic skills needed to create and modify various Visio drawings. In Microsoft® Visio® 2019/2021: Part 2, you will learn about more advanced features—making you a more efficient and effective Visio user.

This course is the second part of a two-course series that covers the skills needed to gain a foundational understanding of Visio.
Microsoft Visio 2019/2021: Part 1
Microsoft Visio 2019/2021: Part 2 (this course)

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 2

PivotTables

This is a 2-hour virtual class, and in celebration of our 30th Anniversary, it will be held for $30!

TOTAL DAYS: 1 | TOTAL HOURS: 2

PowerPoint Design & Charting

This is a 2-hour virtual class, and in celebration of our 30th Anniversary, it will be held for $30!

TOTAL DAYS: 3 | TOTAL HOURS: 19.5

Programming and Data Wrangling with VBA and Excel

VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft® Excel® and other applications in the Microsoft® 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users.

Completion of this course will earn 1.8 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

SharePoint Modern Experience: Site Owner with Power Platform

Microsoft® SharePoint®, in conjunction with the Microsoft 365 suite of productivity and office automation tools, provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location. By default, SharePoint provides end users with a generous set of permissions, enabling users to create and customize their own sites as site owners, and create and collaborate on team site content. Users who have grown comfortable with these fundamental content-authoring capabilities may want to move on to more advanced features, such as connecting multiple SharePoint sites through a hub, importing list data from external sources, implementing user input validation features, applying conditional formatting, and using Power Apps® to provide custom user interfaces for data collected in SharePoint. This course focuses on issues related to planning and implementing an intranet with multiple communication sites and team sites interconnected through a hub site to provide unified navigation search, and formatting.

This course is the second part of a three-course series that covers the skills needed to gain a foundational understanding of SharePoint.
– SharePoint Modern Experience: Site Basics
– SharePoint Modern Experience: Site Owner with Power Platform (this course)
– SharePoint Modern Experience: Advanced Site Owner

Completion of this course will earn 0.6 CEUs.