Tips on How Microsoft Dynamics GP integrates with Microsoft Office Products including Excel and Word.
Recently, many Microsoft Dynamics GP users have gotten an error [...]
Everyone loves a shortcut. Eric Ligman, Microsoft Director of Sales [...]
When you receive a .csv or .txt file, how do [...]
The following predefined Word templates are installed with Microsoft Dynamics GP. Predefined templates cannot be modified or removed. You can make copies of the predefined templates and make your changes such as changing the font. Predefined templates do not have logos assigned to them.
Using Microsoft Dynamics GP and Excel are a powerful combination for any finance team. Many of our clients are asking about the steps to copy and paste General Ledger transactions from Excel into Dynamics GP. Here is the process in four simple steps.
Microsoft Dynamics GP has automatic pre-built Excel Report Dashboards available for Financial, Sales, Purchasing and Inventory.
Did you know that there are built in Excel Reports in Microsoft Dynamics for all the modules: Sales, Financial, Purchasing Inventory and more.
One of our distribution clients using Microsoft Dynamics GP would [...]
Once you have your data from Microsoft Dynamics GP into Microsoft Excel, there is so much more you can do with it. This short video will show you how to use formatting tools to pin point Item Quantities. Learn how to; quickly format your database as a table and use Conditional Formatting to automatically draw attention to specific quantities.
Microsoft Dynamics GP was built to work with Microsoft Dynamics Excel. In this short video you will learn how to: Create a PivotTable, Quickly reproduce Pivot table background data and Insert and use Slicers to filter data from Microsoft Dynamics GP.
Once you export your General Ledger report from Microsoft Dynamics GP to Microsoft Excel there is so much you can do with it. This video will show you a few helpful tricks around pivot tables. Pivot tables are the best way to summarize large amounts of data and focus on the information you need.
Finance professionals love Excel charts, especially fancy pivot charts and [...]
Today’s financial reports are out of date almost before they are sent out. Microsoft Dynamics GP with Microsoft Office Data Connection for Excel 2007 is the answer. Excel users within your organization can have secure access to up-to-date live reports from your Microsoft Dynamics GP accounting software – all the time.
If you want to do math with Excel, your only [...]
Use the Ctrl-Key for Quick Navigation When you want to [...]
After you create a table in Microsoft Office Excel, you [...]
ENTERING ARGUMENTS To quickly enter the arguments for a function, [...]
EXPORTING A BLANK BUDGET Go to Financial>>Cards>>Budget Choose New Then [...]
This example is available in FRx sample data: IS_Dynamics_WKS We [...]
Export Solutions are not a new feature. They will work [...]
The tip this month was inspired by a recent support [...]
You can use the Auto-Fill feature to format worksheets [...]
Microsoft has an extensive online library of templates that you [...]
I love Excel. I also love how easy it is [...]