Tag: Microsoft O365 Project 1

Power Query: Data Transformation Mastery

Power Query: Data Transformation Mastery

Course Length: 1 Day 

Audience: Business analysts, Excel users, Power BI beginners

Prerequisites: Basic knowledge of Excel or Power BI

 

Module 1: Introduction to Power Query 

  • What is Power Query?
  • Power Query vs. Excel formulas vs. VBA
  • Where Power Query lives (Excel vs. Power BI)
  • The Power Query interface (Navigator, Formula Bar, Query Settings)

Activity: Load a simple CSV file into Power Query and explore the interface.

Module 2: Connecting to Data Sources 

  • Importing from Excel, CSV, Web, and databases
  • Combine multiple files from a folder
  • Refreshing and managing connections

Activity: Connect to multiple CSVs in a folder and append them.

Module 3: Transforming Data 

  • Removing rows/columns
  • Filtering and sorting
  • Splitting and merging columns
  • Changing data types
  • Fill down/up and transpose

Activity: Clean up a messy sales report using these tools.

Module 4: Shaping Data for Analysis 

  • Unpivot and pivot columns
  • Grouping and summarizing
  • Creating calculated columns
  • Using the “Applied Steps” panel efficiently

Activity: Reshape survey data from wide to long format and summarize responses.

Module 5: Combining Queries 

  • Append vs. Merge explained
  • Merge join types (Inner, Left Outer, etc.)
  • Creating relationships for modeling

Activity: Merge customer and order tables to build a single clean dataset.

Module 6: Intro to the M Language 

  • Viewing and modifying the formula bar
  • Common M functions: Text, Table, List, Record
  • Custom columns and basic logic

Activity: Write a custom column using M to classify sales as “High,” “Medium,” or “Low”.

Module 7: Loading and Using Queries (30 mins)

  • Load to Excel sheet vs. Power Pivot
  • Load to Power BI Model
  • Refresh strategies and query dependencies

Activity: Load cleaned data into Excel pivot table or Power BI table visual.

Wrap-Up & Q&A (30 mins)

  • Best practices for Power Query projects
  • Where to go next: M Language deep dive, performance optimization, Power BI integration

 

This event ticket will close at 12:00 pm the day before the event.

Microsoft Project Level 1

Microsoft Project Level 1

$250

Course Length: 1 day

Course Objectives:

In this course, you will learn to create and engage in basic management of a project using Microsoft Project Professional O365 – Desktop Version.

You will:

  • Identify project management concepts and navigate the Project O365 – Desktop Version environment.
  • Create and define a new project plan.
  • Create and organize tasks.
  • Manage resources in a project plan.
  • Finalize a project plan.

This event ticket will close at 12:00 pm the day before the event.

Microsoft Project Level 1

Microsoft Project Level 1

$250

Course Length: 1 day

Course Objectives:

In this course, you will learn to create and engage in basic management of a project using Microsoft Project Professional O365 – Desktop Version.

You will:

  • Identify project management concepts and navigate the Project O365 – Desktop Version environment.
  • Create and define a new project plan.
  • Create and organize tasks.
  • Manage resources in a project plan.
  • Finalize a project plan.

This event ticket will close at 12:00 pm the day before the event.

Project Management for Non-Project Managers

Project Management for Non-Project Managers

$250

Course Length: 1 day

Course Number: 095015

Course Length: 1 day

Course Description

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.

Course Objectives:

In this course, you will examine the elements of sound project management and apply the generally recognized practices to successfully manage projects.

You will:

  • Identify the key processes and requirements of project management.
  • Initiate a project.
  • Plan for time and cost.
  • Plan for project risks, communication, and change control.
  • Execute, manage, and control a project.
  • Close a project.

 

Target Student:

This course is designed for individuals whose primary job is not project management, but who manage projects on an informal basis. Also, anyone who is considering a career path in project management and desiring a complete overview of the field and its generally accepted practices can benefit from this course.

Course Content

 

Lesson 1: Getting Started with Project Management

Topic A: Identify the Characteristics of a Project

Topic B: Identify the Project Management Life Cycle

Topic C: Identify the Role of a Project Manager

Lesson 2: Initiating a Project

Topic A: Determine the Scope of a Project

Topic B: Identify the Skills for a Project Team

Topic C: Identify the Risks to a Project

Lesson 3: Planning for Time and Cost

Topic A: Create a WBS

Topic B: Sequence the Activities

Topic C: Create a Project Schedule

Topic D: Determine Project Costs

Lesson 4: Planning for Project Risks, Communication, and Change Control

Topic A: Analyze the Risks to a Project

Topic B: Create a Communication Plan

Topic C: Plan for Change Control

Lesson 5: Managing a Project

Topic A: Begin Project Work

Topic B: Execute the Project Plan

Topic C: Track Project Progress

Topic D: Report Performance

Topic E: Implement Change Control

Lesson 6: Closing the Project

Topic A: Close a Project

Topic B: Create a Final Report

This event ticket will close at 12:00 pm the day before the event.

Project Management for Non-Project Managers

Project Management for Non-Project Managers

$250

Course Length: 1 day

Course Number: 095015

Course Length: 1 day

Course Description

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.

Course Objectives:

In this course, you will examine the elements of sound project management and apply the generally recognized practices to successfully manage projects.

You will:

  • Identify the key processes and requirements of project management.
  • Initiate a project.
  • Plan for time and cost.
  • Plan for project risks, communication, and change control.
  • Execute, manage, and control a project.
  • Close a project.

 

Target Student:

This course is designed for individuals whose primary job is not project management, but who manage projects on an informal basis. Also, anyone who is considering a career path in project management and desiring a complete overview of the field and its generally accepted practices can benefit from this course.

Course Content

 

Lesson 1: Getting Started with Project Management

Topic A: Identify the Characteristics of a Project

Topic B: Identify the Project Management Life Cycle

Topic C: Identify the Role of a Project Manager

Lesson 2: Initiating a Project

Topic A: Determine the Scope of a Project

Topic B: Identify the Skills for a Project Team

Topic C: Identify the Risks to a Project

Lesson 3: Planning for Time and Cost

Topic A: Create a WBS

Topic B: Sequence the Activities

Topic C: Create a Project Schedule

Topic D: Determine Project Costs

Lesson 4: Planning for Project Risks, Communication, and Change Control

Topic A: Analyze the Risks to a Project

Topic B: Create a Communication Plan

Topic C: Plan for Change Control

Lesson 5: Managing a Project

Topic A: Begin Project Work

Topic B: Execute the Project Plan

Topic C: Track Project Progress

Topic D: Report Performance

Topic E: Implement Change Control

Lesson 6: Closing the Project

Topic A: Close a Project

Topic B: Create a Final Report

This event ticket will close at 12:00 pm the day before the event.

Project Management for Non-Project Managers

Project Management for Non-Project Managers

$250

Course Length: 1 day

Course Number: 095015

Course Length: 1 day

Course Description

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.

Course Objectives:

In this course, you will examine the elements of sound project management and apply the generally recognized practices to successfully manage projects.

You will:

  • Identify the key processes and requirements of project management.
  • Initiate a project.
  • Plan for time and cost.
  • Plan for project risks, communication, and change control.
  • Execute, manage, and control a project.
  • Close a project.

 

Target Student:

This course is designed for individuals whose primary job is not project management, but who manage projects on an informal basis. Also, anyone who is considering a career path in project management and desiring a complete overview of the field and its generally accepted practices can benefit from this course.

Course Content

 

Lesson 1: Getting Started with Project Management

Topic A: Identify the Characteristics of a Project

Topic B: Identify the Project Management Life Cycle

Topic C: Identify the Role of a Project Manager

Lesson 2: Initiating a Project

Topic A: Determine the Scope of a Project

Topic B: Identify the Skills for a Project Team

Topic C: Identify the Risks to a Project

Lesson 3: Planning for Time and Cost

Topic A: Create a WBS

Topic B: Sequence the Activities

Topic C: Create a Project Schedule

Topic D: Determine Project Costs

Lesson 4: Planning for Project Risks, Communication, and Change Control

Topic A: Analyze the Risks to a Project

Topic B: Create a Communication Plan

Topic C: Plan for Change Control

Lesson 5: Managing a Project

Topic A: Begin Project Work

Topic B: Execute the Project Plan

Topic C: Track Project Progress

Topic D: Report Performance

Topic E: Implement Change Control

Lesson 6: Closing the Project

Topic A: Close a Project

Topic B: Create a Final Report

This event ticket will close at 12:00 pm the day before the event.

Share Our Website

Share to Friends Now!