In SQL Lesson #2 I demonstrate how to write a SELECT statement with a WHERE clause to filter your data using a Star Wars database. Also covered is how to use CONCATENATION operators to interconnect your output. You can download a...

In SQL Lesson #3 I demonstrate how to write a SELECT statement with an IMPLICIT JOIN that pulls data from two or more database tables using a Star Wars database. Also begin to show you how to debug a SQL statement. More on that in a...

In this SQL intro I demonstrate how to write an SQL simple select statement using Microsoft SQL Server Management Studio. The exercise is the first in a series of tutorials that teach you how to write SQL. The data used for this example...

This video is focused on preparing us for the advanced course, ensuring we have the tools to succeed in more advanced topics exercises that are downloaded and easily accessible on our PC. It explains how the activities are distributed...

In Part 1 of the calculated custom fields lesson, we will understand the concept of computed custom fields and how to create them to perform specific calculations related to project data.
<
br/>
This clip is from the chapter "Custom...

This video illustrates the Project 2021 ribbon and its commands. Learn to use the ribbon to access commands and customize it to suit your needs. Learn how to work with contextual tabs that appear when specific objects are...

In this exercise video, we will shift our focus back to custom task fields. We will use a custom field of the type “Outline Code” to reflect the project's structure to put a design into this project that is fixed and under...

In this lesson, we will learn to save a project as a template and reuse it for future projects. We will learn to specify default settings, create custom fields, and save templates.
<
br/>
This clip is from the chapter "Saving...

This video overviews the Project 2021 user interface and its various elements. We will become familiar with the ribbon, backstage view, and the interface's multiple panes and views.
<
br/>
This clip is from the chapter "Get Familiar...

In this video, we will delve deep into macro creation by learning to write and customize macros using Microsoft Project's scripting language. We will create more advanced and tailored automation solutions.
<
br/>
This clip is from...

In this video, we will understand how to export project data from Microsoft Project 2021. We will discover how to create output formats compatible with other applications and tools, facilitating data sharing and reporting with...

In this video, we will be introduced to the Microsoft Project 2021 advanced course. We will receive an overview outlining its objectives, topics, and what we will learn and achieve through the course.
<
br/>
This clip is from the...

In this lesson, we will learn to use the tracking table, task usage view, and resource usage view to monitor project progress and resource utilization and resolve resource allocation.
<
br/>
This clip is from the chapter "Track...

In this lesson, we will learn to update project progress, reschedule incomplete work, and analyze project performance using the earned value analysis technique.
<
br/>
This clip is from the chapter "Track Project Progress" of the...

This lesson shows how to add another timeline to our project in Project 2021. This video demonstrates how to create a second timeline, link it to our project, and customize the timeline settings.
<
br/>
This clip is from the chapter...

In this lesson, the focus is on assigning resources to tasks. This step is essential in project management because it ensures that resources are effectively utilized to complete tasks on time and within budget.
<
br/>
This clip is...

In this continuation video, we will examine another crucial fundamental question. How do we maintain a resource pool? We will discuss the different options for sharing, consolidating, or maintaining the resource pool.
<
br/>
This...

In this video, we will focus on consolidating multiple projects into a unified view, a critical skill for project managers handling complex projects with interdependencies.
<
br/>
This clip is from the chapter "Consolidation and...

In this video, we will delve into advanced techniques for resource sharing and the use of resource pools. We will learn to optimize resource allocation across multiple projects and manage shared resources more effectively.
<
br/>...

In this video, we will overview the topics covered in this section and understand the importance of project consolidation and resource sharing in complex project management scenarios.
<
br/>
This clip is from the chapter...

In this video, we will understand the concept of outline numbering and WBS codes. We will explore how to effectively structure and label project tasks using these codes, facilitating better organization and categorization of project...

In this video, we will discover the concept of targeted reporting, which involves creating reports that address specific project reporting needs and objectives and looking at the different types of charts.
<
br/>
This clip is from...

In the previous two videos, we have seen how to customize a project overview report using themes, colors, fonts, and effects. Here, we will concentrate on creating or building a new report from scratch and look at some of the elements...

In this continuation video, we will further explore the customization of project reports. We will delve into more styling, discuss themes, which are important concepts, change the overall theme, and look at different templates that we...