Live Webinar – September 20th, 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.

Suitable for business reporting, financial analysis, or project management, Excel dashboards offer a user-friendly and visually impactful means to analyze, interpret, and communicate data effectively.

Building a dashboard requires data that can be sourced from various locations such as databases, CSV files, and web pages.

Often, this raw data isn’t immediately suitable for use, necessitating cleaning, merging, and combining processes.

1. Do you often find yourself saying, “It’s taking too long” when referring to the time spent formatting your data for reports?
2. Are you regularly tasked with repetitive and time-consuming data cleaning and transformation activities?

These might include removing unnecessary rows and columns, filtering out irrelevant data, converting text to numbers or dates, splitting or merging columns, removing unexpected characters, or combining files together.

Would you appreciate a solution that can perform all of these tasks with the click of a button? If your answer is yes, then Power Query (also known as Get and Transform in Excel 2016 and later) is what you need.

Learning Objectives:

• Import data into Excel from sources such as text files, web pages and databases
• Keep the imported data in sync with the source data using just two clicks
• The Power Query Editor – the key to data cleaning and transformation
• Save a ton of time – automate the cleaning and transformation process

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

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.