Microsoft Excel Power Maps in Power BI

This AWESOME Power BI tool allows you to “Visualize” your data not only in a map, but as a video over a period of time.

Originally Posted 6/2/14

This AWESOME Power BI tool allows you to “Visualize” your data not only in a map, but as a video over a period of time.  It allows you to SEE your data in ways you never even thought amount.  Take a tour with me of Elevator Complaints in New York City for Q1, 2014.

Continue reading “Microsoft Excel Power Maps in Power BI”

Microsoft Dynamics GP – Excel AR Trial Balance (with video)

This is part 1 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Originally Posted 11/4/13

This is part 1 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Continue reading “Microsoft Dynamics GP – Excel AR Trial Balance (with video)”

AP aging in Excel thanks to Victoria Yudin in Microsoft Dynamics GP

A GPUG (Microsoft Dynamics GP User Group) member was asking about building a report in Excel that displayed open payables that actually matches GP.  There were several great responses to his question, but now I want to add my two cents!

A GPUG (Microsoft Dynamics GP User Group) member was asking about building a report in Excel that displayed open payables that actually matches GP.  There were several great responses to his question, but now I want to add my two cents!

My Friend and fellow Microsoft MVP, Victoria Yudin has made this process a lot easier for you.  She has a SQL view that will organize your open payables and age them for you.

A GPUG (Microsoft Dynamics GP User Group) member was asking about building a report in Excel that displayed open payables that actually matches GP.  There were several great responses to his question, but now I want to add my two cents!

Continue reading “AP aging in Excel thanks to Victoria Yudin in Microsoft Dynamics GP”

Microsoft Dynamics GP Payables Management Batch Review using Excel

The attached videos and steps show how to use Microsoft Excel to check unposted Payables entries along with their distributions for Microsoft Dynamics GP.

Originally Posted October 14, 2011

The attached videos and steps show how to use Microsoft Excel to check unposted Payables entries along with their distributions for Microsoft Dynamics GP.

Continue reading “Microsoft Dynamics GP Payables Management Batch Review using Excel”