Or I can create other tables or use Sparklines (play with these, they can be handy in some situations), but the other most useful for my analysis is the “Chart” Option. Now there is a lot here, including the ability to quickly get an Average or a Sum (In the ‘Totals” option in the Quick Analysis Tools Not so much with the quick tools as it makes a high-balance green and a low balance red, but with this one I could go to the home tab and use the “Conditional Formatting” code to switch up the colors. Look at that, an amazing visual of who has the highest and lowest running balance in my GP and it’s super easy to see as it lays over the actual amounts. We’ll look at some of these analyses using this same data-set: We can see pretty quickly that we can setup multiple types of analysis with just one or two clicks. Let’s then simply highlight the data points and click the ‘Quick Analysis Tools’ button that appears. We start by running a SmartList of Customer Balances and then shooting it out to Excel.

Let’s look at a scenario using GP and the CFO wants to see the customer running balances in order to implement new credit lines to customers.

Excel has quick analysis tools for data visualization, a seriously useful tool when used with Microsoft Business Applications in today’s analytical world where the ability to visualize and consume data in order to make informed business decisions is of utmost importance.Īlong with the fact that most accountants already know and use Excel, then this Microsoft wonder when used in conjunction with any of the Microsoft Business Applications, such as Dynamics GP and Dynamics Business Central can allow accountants to quickly send the necessary visualizations to management without hours and hours of coding.

Excel quick analysis button