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

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.