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

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.

Completion of this course will earn 0.6 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: 5 | TOTAL HOURS: 35

Project Management Professional (PMP) Boot Camp

Are you a project management professional with knowledge and experience in leading your team to success? Is it time to take the next step and certify your project management skills? Stand out from the pack. Attend the PMP Boot Camp and prepare to earn your PMP Certification!

TOTAL DAYS: 2 | TOTAL HOURS: 15

Prerequisite:
Must have taken the 35-hour PMP Boot Camp course for the previous version of the PMP exam

Course Overview:
The new Project Management Professional (PMP) exam (effective January 2, 2021) is based on three domains – People, Process, and Business Environment. This may seem very different than the five domains in the previous version (Initiating, Planning, Executing, Monitoring & Controlling, and Closing), especially if you prepared for the exam prior to 2021.
This two-day course is to help candidates successfully bridge-the-gap between the old and new exams.

Learning Objectives
– Understand what the different domains are on the current exam
– Learn to successfully execute a project while maintaining risk and change
– Learn Leadership styles to keep your team performing and on track
– Practice the new format of the PMP exam – Agile and Hybrid Methodologies

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.

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.