TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft PowerPoint for Office 365 (Desktop or Online): Part 2

Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible. But Microsoft® PowerPoint® provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don’t consume all of your available time.

Note: Most Office 365™ users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using PowerPoint for the Web and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.

This course may be a useful component in your preparation for the PowerPoint Associate (Microsoft 365 Apps and Office 2019): Exam MO-300 certification exam.

This course is the second part of a two-course series that covers the skills needed to gain a foundational understanding of PowerPoint.
Microsoft PowerPoint for Office 365 (Desktop or Online): Part 1
Microsoft PowerPoint for Office 365 (Desktop or Online): Part 2 (this course)

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Project 2019/2021/365: Part 1

Welcome to Microsoft® Project® 2019/2021/365: Part 1. This course is designed to familiarize you with the basic features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment.

This course covers the critical knowledge and skills a project manager needs to create a project plan with Project during the planning phase of a project. In other words, if your supervisor assigns you to lead a project, this course will enable you to draft a project plan with Project and share it with your supervisor (and others) for review and approval.

Note: This course is for anyone who has Project on the desktop, regardless of whether they purchased an “on-premise” edition or subscribed to a “cloud-based” (online) edition. Most project managers and project team members use the desktop application, so that is the main focus of this course. The main features of the online app are presented in an appendix.

This material will benefit users of any current version of Microsoft Office, and of the Microsoft Project desktop software. The classroom environment setup uses the Project 2019 desktop software.

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

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Project 2019/2021/365: Part 2

Welcome to Microsoft Project 2019/2021/365: Part 2. This course is designed to familiarize you with some of the advanced features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment.

In Microsoft® Project® 2019/2021/365: Part 1, you learned the basic features of Microsoft Project during the planning phase of a project. This course covers the advanced knowledge and skills a project manager needs to update a project plan in Project during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope.

Note: This course is for anyone who has Project on the desktop, regardless of whether they purchased an “on-premise” edition or subscribed to a “cloud-based” (online) edition. Most project managers and project team members use the desktop application, so that is the main focus of this course. The main features of the online app are presented in an appendix. This material will benefit users of any current version of Microsoft Office, and of the Microsoft Project desktop software. The classroom environment setup uses the Project 2019 desktop software.

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

Completion of this course will earn 0.6 CEUs.

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: 3 | TOTAL HOURS: 19.5

Project Management Essentials

If you are taking this course, you probably have some exposure to managing projects, or you may be considering embarking on a career as a professional project manager. Your ability as a project manager to demonstrate best practices in project management on the job is becoming the standard to compete in today’s fast-paced and highly technical workplace. In this course, you will apply the generally recognized practices of project management to successfully manage projects.

Project managers are always under severe pressure to complete projects on time and within budget. However, most projects fail to meet these demands, and, as a result, many projects are terminated early. Successful project management requires knowledge and experience. This course is designed to provide you with the skills needed to be a successful project manager in today’s rapidly changing world. The skills and knowledge you gain in this course will help you avoid making costly mistakes and increase your competitive edge in the project management profession.

Completion of this course will earn 1.8 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Project Management Fundamentals (Third Edition)

Successfully managing a project requires effective planning and adherence to the industry’s best practices in every step of the process. By understanding the fundamentals of project management, you will be better prepared to initiate a project in your organization and position it for success. In this course, you will identify effective project management practices and their related processes.

At this point in your professional development, you are ready to take on the responsibility for managing projects. You can manage a project by developing a solid understanding of the fundamentals of project management and its underlying structure and elements, including project phases, project life cycles, stakeholders, and areas of expertise. These, coupled with the ability to identify the project management processes that are recognized industry-wide as good practice, will help you to apply effective project management techniques to improve the efficiency of your projects and ensure their success.

Completion of this course will earn 0.6 CEUs.

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.