Live Webinar – October 11th, 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.

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 impactful way to analyze, interpret, and communicate data effectively.

Building a dashboard requires data. That data can come from a variety of sources such as databases, CSV files and web pages. In many cases, that raw data is not “fit for purpose. It requires cleaning, merging and combining.

Does the phrase “it’s taking too long” describe how you feel about the time it takes to get your data into the right format for your reports?

Do you regularly perform repetitive time-consuming “data cleaning and transforming” tasks such as removing unnecessary rows and columns, filtering out data that you dont need, converting text to numbers or dates, splitting or merging columns, removing “weird” characters or combining files together?

Would you like to be able to do all the above with the click of a button? If the answer Is yes, you need Power Query (known as Get and Transform in Excel 2016 and later).

Dashboards:

• Understand the key principles of effective dashboard design
• Learn how to create interactive and visually appealing dashboards in Excel
• Discover best practices for data visualization
• Gain insight into how to use dashboards to drive business decisions

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.