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.

TOTAL DAYS: 1 | TOTAL HOURS: 3

Working with New Excel 365 Functions

Newer Excel functions are designed to be easier to use and easier for others to learn and edit. Get familiar with some these newer Excel functions like XLOOKUP, IFS, FILTER, SORT, and TEXTJOIN. Learn more about dynamic arrays and spilling into ranges. Find out if some of these new functions can make your work in Excel easier.