Compare 2 Microsoft Excel Files using Inquire (Video)

Have you ever needed to compare data in 2 Microsoft Excel Spreadsheets? 

In this video, I show how I compare the addresses on the Microsoft Dynamics GP Vendor card with the addresses in the Vendor Address card.  One of my followers asked me about this comparison due to concerns that the data imported in each table might not match.  I’ll use the Excel Add-on, Inquire, to compare data from each of these tables.

The Spreadsheet Inquire window can compare any Excel files, and do so much more!

Have you ever needed to compare data in 2 Microsoft Excel Spreadsheets?   In this video, I show how I compare the addresses on the Microsoft Dynamics GP Vendor card with the addresses in the Vendor Address card.  One of my followers asked me about this comparison due to concerns that the data imported in each table might not match.  I’ll use the Excel Add-on, Inquire, to compare data from each of these tables.  The Spreadsheet Inquire window can compare any Excel files, and do so much more!

Have you ever needed to compare data in 2 Microsoft Excel Spreadsheets?

In this video, I show how I compare the addresses on the Microsoft Dynamics GP Vendor card with the addresses in the Vendor Address card.  One of my followers asked me about this comparison due to concerns that the data imported in each table might not match.  I’ll use the Excel Add-on, Inquire, to compare data from each of these tables.

The Spreadsheet Inquire window can compare any Excel files, and do so much more!

Continue reading “Compare 2 Microsoft Excel Files using Inquire (Video)”

Obtaining Microsoft Dynamics GP Employee Head Count (Part 4) in Power BI (Video)

This 9-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the Historical Payroll Checks in Microsoft Power BI.

Last week a Microsoft Dynamics GP user asked a question in the user group form www.GPUG.com about obtaining the employee Head Count in Power BI.  I offered a suggestion and another user offered a different suggestion.  I thought about it over the weekend and realized this would be a great opportunity to review the importance of knowing your data, or being a Data Consultant. 

Part 4 of a 4-Part Series

This 9-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the Historical Payroll Checks in Microsoft Power BI.

Continue reading “Obtaining Microsoft Dynamics GP Employee Head Count (Part 4) in Power BI (Video)”