Excel Power Query & Dashboards

Share

Live Webinar – October 4th, 2023 12:00 pm – 1:30 pm EDT
Activity Type: Education – Course or Training  1 Hour  1 PDU
Provider: MPUG WebnLearn ( REP 1369 )
Mpug Member Free – Members only event

Excel’s dashboarding capabilities empower users to transform raw data into meaningful insights.

Whether for business reporting, financial analysis, or project management, Excel dashboards provide a user-friendly and visually striking way to analyze, interpret, and communicate data effectively.

Building a dashboard necessitates data, which can originate from various sources like databases, CSV files, and web pages. Often, this raw data isn’t “fit for purpose” and requires cleaning, merging, and combining.

Does the phrase “it’s taking too long” resonate with your feelings towards the time it takes to format your data for reports?

Are you frequently performing repetitive, time-consuming tasks like “data cleaning and transforming”?

This includes removing unnecessary rows and columns, filtering out unneeded data, converting text to numbers or dates, splitting or merging columns, eradicating odd characters, or combining files.

Would you appreciate being able to accomplish all of the above with a single click? If your answer is yes, you need Power Query, also known as Get and Transform in Excel 2016 and later.

Learning Objectives: (Part 2 – Power Query’s)

  • Calculations without formulas – the power of The Query Editor Ribbon
  • Combining data using Append & Merge Queries (and the difference between them)
  • Convert a single text string into multiple rows
  • Un“ the hidden gem and unsung hero of The Query Editor

If you are NOT ALREADY a member JOIN MPUG!

This event is for members only BUT… You can take one of the MPUG Certificated Masterclass (Usually 6 Category A PDUs) Or over 30 other Category A PDUs for free each year.  The $129 Per Year Membership Fee is a terrific value!

MPUG Membership includes:

  1. MPUG’s Project Server and SharePoint certificated courses available to members
  2. Over 30 other virtual PDU events per year
  3. You can network with other MPUG (Microsoft Project Users Group) members at in person meetings and events.
  4. Work with Microsoft MVPs in MS Project Project Server & SharePoint
  5. And so much more …

Seriously consider joining MPUG if you work with SharePoint or Project & earn all the PDUs you will need as a member of MPUG!

Click to register for:
Excel Power Query & Dashboards

0 0 1.0
Ways Of Working Technical
Power Skills
Leadership
Business Acumen Strategic / Business

NOTE: For PMI® Audit Purposes – Print Out This Post! Take notes on this page during the presentation and also indicate the Date & Time you attended. Note any information from the presentation you found useful to your professional development and place it in your audit folder.

Share

Online Webinar – Recorded  August 1st, 2019
Activity Type: Education – Online or Digital Media 1 PDU – Free
Provider: Training Magazine Network

Whether it’s an online meeting, a presentation via webinar, or live online training, engagement is the main question on everyone’s mind:

Will it be worth my time to attend, or
Will it be an opportunity to check email instead?

Online meeting technology is powerful and has made it easy to connect with people from anywhere in the world at any time, yet  professionals often still struggle with getting everyone to interact.

Interaction is the answer to successful engagement and using the features of the platform is the answer to interaction.

However, the features alone do not engage the participants. It is what you choose to do with those features that will make the difference in your next virtual training, webinar, or meeting.

During this session, you will learn what you can do to be successful in the virtual environment and avoid having everyone ask for a recording or a copy of the slides five minutes into your next virtual event.

In this session:

  • You’ll analyze the activities demonstrated and brainstorm where the techniques could be applied to your virtual training programs.
  • You’ll explore the specific challenges of managing the technology, and brainstorm solutions to the engagement problems you are likely to experience with your live online attendees when technical problems arise.

Activities are the key to your success. Through them you’ll learn to manage the technology, get attendees to actively engage, and help presenters have a great time too!

Application on the Job

  • Define virtual learner engagement to effectively design the appropriate activities.
  • Analyze activities for specific engagement techniques and feature usage to apply to your own activity design.
  • Create your own customized activities for immediate use in your virtual classroom programs.

Presenter:  Kassy LaBorie (LinkedIn profile) Director of Virtual Training Services for Dale Carnegie Training, is an indemand keynote speaker & leads a consultancy  to develop online training strategies for organizations . Her book Interact and Engage! 50+ Activities for Virtual Training, Meetings, Webinars, has received rave reviews.  Previously Kassy served as the Product Design Architect and was a Master Trainer for InSync Training, & ExecuTrain.  Kassy also helped create the WebEx University.

Click to register for:
Online Meetings – Interact & Engage!
Activities For Spectacular Training

0 1.0 0
Technical Project Management Leadership Strategic & Business Management

NOTE: For PMI® Audit Purposes – Print Out This Post!  Take notes on this page during the presentation and also indicate the Date & Time you attended. Note any information from the presentation you found useful to your professional development and place it in your audit folder.

Present Like A Mouse

Share

Live Webinar – October 3rd, 2023 3:00 pm – 4:00 pm EDT
Activity Type: Education – Course or Training  1 Hour  1 PDU free
Provider: Training Magazine Network

Walt Disney was a creative genius, a master showman, and an amazing teacher who once firmly proclaimed, “The normal gap between what is generally regarded as ‘entertainment’ and what is defined ‘educational’ represents an old and untenable viewpoint.”

The entertainments Disney created were both informative and enjoyable—unlike many learning programs. When entertainment and learning are aligned, as Walt Disney would deliver them, the result is magical; participants pay attention, they absorb information, and they change behavior.

In this insightful and engaging presentation, 25 year Walt Disney World training leader Lenn Millbower shares the ways in which Walt’s entertainment strategies can be, and were, applied to actual learning challenges.

Focusing on your needs, you will then identify specific tactics you can use to make your presentations, training programs, classes, or communications more successful.

This session will … 

  • Explore the connection between entertainment and learning so you can pixie-dust your learning objectives with messages that matter to your learners
  • Identify the strategies Walt Disney’s theme parks use to draw people into the experience so you can apply specific tactics to capture learner attention and maintain focus
  • Examine the techniques Disney’s team used to transform rides into immersive environments and so you can create your own captivating learning experiences
  • Discover Disney’s approach to making a message so memorable that the meaning sticks for years afterwards so you can create magical memories for your audience

For Another Great Lenn Millbower PDU Check Out:
Care Like A Mouse. Engage Your Castomers

Presenter: Lenn Millbower, (LinkedIn profile) The Mouse Man™ author of Care Like a Mouse: The Key to Disney Quality Service, teaches Walt Disney inspired customer service, leadership and presentation skills methods. Lenn  spent 25 years at Walt Disney World, starting in Epcot Operations, stage managing at Disney-MGM Studios, opening Disney’s Animal Kingdom, writing training for Disney University and Disney Institute and leading training at Walt Disney Entertainment. Lenn will inspire you to create your own magic. Give it a shake & watch the magic take place!

Click to register for:
Present Like A Mouse

0 1.0 0
Ways Of Working Technical
Power Skills
Leadership
Business Acumen Strategic / Business

NOTE: For PMI® Audit Purposes – Print Out This Post! Take notes on this page during the presentation and also indicate the Date & Time you attended. Note any information from the presentation you found useful to your professional development and place it in your audit folder.

Share

Live Webinar – September 28th, 2023 2:00 pm – 3:00 pm EDT
Activity Type: Education – Course or Training  1 Hour  1 PDU free
Provider: Training Magazine Network

Becoming a micro-influencer takes a combination of compelling content and engagement from your targeted audience to build a reputation of a thought leader and subject matter expert.

Brynne will cover how to:

  1. Position your profile to be seen as a resource and subject matter expert
  2. Create compelling and reputation building content
  3. Engage and amplify other influencers and prospects
  4. Become a guest on podcasts, LIVE streams and beyond
  5. Write and publish book that your industry wants to read

Well-known coach, and author of  The LinkedIn Sales Playbook: A Tactical Guide to Social Selling and the LinkedIn for Business Development: Workbook & Guide | Second Edition  Brynne Tillman (LinkedIn profile) helps you acquire more opportunities and close more business.

Click to register for:
How To Become a Micro-Influencer On LinkedIn:
Grow Your Followers

0 1.0 0
Ways Of Working Technical
Power Skills
Leadership
Business Acumen Strategic / Business

NOTE: For PMI® Audit Purposes – Print Out This Post! Take notes on this page during the presentation and also indicate the Date & Time you attended. Note any information from the presentation you found useful to your professional development and place it in your audit folder.

The Team Charter

Share

Online Webinar  – Recorded December 5th, 2017
Activity Type: Education – Online or Digital Media 1 PDU – Free
Provider: ProjectManagement.com / Gantthead (REP #2488)
Once viewed your PDU Will automatically Be recorded with PMI®

ProjectManagement.com / Gantthead premium content
Is available to PMI® members.

  • Project Management relies heavily on people to design and deliver services, products and results.
  • Project Managers are accountable for ensuring teams remain focused, in tune and motivated.

It’s in the Human DNA that we are motivated by different goals, desires & aspirations. We have different levels of skills, work ethics and emotional intelligence.

We even have preference on how we like to work, communicate and solve problems. So how can a project manager ensure that his/her project won’t suffer from problems linked to people issues?

In this presentation Benjamin Govindsamy (LinkedIn profile) will unpack what a Team Charter is and how it can be positioned as an effective tool for creating a cohesive team. Yes you read correctly – A Team Charter and not the Project Charter.

This presentationalso covers practical examples to ensure these aren’t just concepts, so that you may apply them successfully in your projects and working environments.

Note: You have to sign in to ProjectManagement.com with your PMI® credentials to register for this opportunity. If you are not signed in with your PMI® credentials you will not see the “Register for this webinar” link

Click to register for:
The Team Charter

0 1.0 0
Technical Project Management Leadership Strategic & Business Management

NOTE: For PMI® Audit Purposes – Print Out This Post!  Take notes on this page during the presentation and also indicate the Date & Time you attended. Note any information from the presentation you found useful to your professional development and place it in your audit folder.

Share

Live Webinar – September 27th, 2023 12:00 pm – 1:00 pm EDT
Activity Type: Education – Course or Training  1 Hour  1 PDU free
Provider: Training Magazine Network

Join Dr. Britt Andreatta (LinkedIn profile) as she walks you through insights from building an award-winning leadership training for healthcare professionals.

This brain-based program leverages the latest research on healthcare organizations and workplace well-being as defined by the AMA and the U.S. Surgeon General.

This session will feature successful examples from several healthcare organizations and will demonstrate several tools and strategies you can use to actively address burnout, change fatigue, and moral injury. Discover how various learning technologies are utilized to create a rating of “excellent” in 95-100% of learners.

You will:

  • Explore insights from an award-winning program leadership training in healthcare
  • Utilize learning science best practices (habit design, memory enhancement, transfer) to design and deliver effective training
  • Discover new tools and strategies for enhancing workplace well-being, engagement, and retention

Click to register for:
Brain-Based Strategies To Address Burnout &
Increase Well-Being For Healthcare

0 1.0 0
Ways Of Working Technical
Power Skills
Leadership
Business Acumen Strategic / Business

NOTE: For PMI® Audit Purposes – Print Out This Post! Take notes on this page during the presentation and also indicate the Date & Time you attended. Note any information from the presentation you found useful to your professional development and place it in your audit folder.