Microsoft Excel connections to SQL databases – Part II: “Calculations”
In my last blog, we discussed creating, refreshing, and updating a Connection to a SQL database from Microsoft Excel. In this blog, I wanted to
In my last blog, we discussed creating, refreshing, and updating a Connection to a SQL database from Microsoft Excel. In this blog, I wanted to
Microsoft Excel can be a powerful tool to evaluate SQL data. In Excel, a connection can be created to directly link to a particular database
This is another addition to my continuing series on Excel and the Project Manager. This time I want to demonstrate some advanced functionality using conditional
This year Convergence was held in Atlanta. While this conference is a huge Dynamics Users conference, they highlight applications that are not necessarily part of the Dynamic stack. One of the most captivating sessions I attended focused on Power BI, Microsoft’s excel based Business Intelligence tool.
Sign up for our mailing list to get the latest updates and offers.