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 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

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: 1 | TOTAL HOURS: 6.5

SQL Querying: Advanced

In the course SQL Querying: Fundamentals, you learned the basics of SQL querying. Now that you have a foundation in how to query databases, you will learn in this course how to identify and use advanced querying techniques. In addition, you might find that you need to perform tasks such as modifying the structure of a table; inserting, updating, or deleting data; and indexing tables to optimize query performance. In this course, you will learn how to complete these tasks and more.

In today’s competitive environment, information is one of the most important factors in determining the success of an organization. If you are able to manage and retrieve information efficiently, you can streamline the organization’s processes and give it a competitive edge. As the organization grows, you will need to handle large amounts of data. Under such circumstances, you might need to query multiple tables simultaneously and with increasing frequency. You must step up the speed of generating query output to cope with the increasing demands of data storage, management, and retrieval.

This course is the second part of a two-course series that covers the skills needed to gain a foundational understanding of SQL.
– SQL Querying: Fundamentals
– SQL Querying: Advanced (this course)

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

SQL Querying: Fundamentals

Many organizations use databases to store their most critical information: the information that manages their day-to-day operations. After the data is stored in databases, however, it is useless unless you can retrieve it for further business analysis. One example of a database management system is Microsoft SQL Server 2012. The language you use to retrieve information from SQL Server 2012 databases is the Structured Query Language (SQL). This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.

This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of SQL.
– SQL Querying: Fundamentals (this course)
– SQL Querying: Advanced

Completion of this course will earn 0.6 CEUs.