Excel & Office
Excel techniques, Office integration, Word templates, Outlook and Office 365 with GP.
Articles
2021
- 2021-04-05Don’t Default to Excel
- 2021-02-08Underused Software Syndrome
2018
- 2018-05-28Historical Excel Reporting for Dynamics GP Updated to Version 1.3
- 2018-04-11Who needs a vacation?
2017
- 2017-11-08Dynamics GP Word Templates – Page Numbers Broken – Get Interfaced; Observations of an ERP Support Team Leader
- 2017-10-23Excel Shootout, Key Learnings
- 2017-07-31Historical Excel Reports for MEM
- 2017-07-26Historical Excel Reporting for GP
- 2017-03-08Historical Excel Reporting
2016
- 2016-02-23Exporting Dynamics Management Reporter Reports to Excel – Boyer & Associates | Boyer & Associates
- 2016-01-08Friday Fun: Spreadsheets and Dilbert
2015
- 2015-12-15Historical Reporting in Excel for Dynamics GP – You’ll want this at year end
- 2015-11-09Microsoft Power Query: An Excel User’s Dream for Data Extraction and Cleansing – MSDynamicsWorld.com
- 2015-09-08Historical Excel Reporting for Dynamics GP
- 2015-04-27GP Reporting Tip: Turn Any GP Report into a Word Template
- 2015-04-21Building Dashboards with Microsoft Dynamics GP and Excel | MSDynamicsWorld.com
- 2015-04-20Weekly Dynamic: Dynamics GP and Hosted Exchange
- 2015-03-12Addressing Dynamics GP Copy & Paste from Excel Issues – Etelligent Solutions-
- 2015-02-12Budget Spreadsheets are Complex! – Energized Accounting
- 2015-02-03Microsoft announcing FREE Power BI : Business Intelligence, Analytics & Excel
2014
- 2014-10-13Weekly Dynamic: Excel Deployment Problem
- 2014-09-25Dynamics GP Word Template for Upgraded SOP Blank History Invoice Confounds – Etelligent Solutions-
- 2014-08-18Options to be aware of with Excel Budget Imports into Dynamics GP 2013 – Etelligent Solutions-
- 2014-08-11Weekly Dynamic: Excel import GL without Excel
- 2014-08-11What is Dynamics GP Workspace For Office 365 – Etelligent Solutions-
- 2014-06-11Microsoft Dynamics GP and Office 365 Compatibility – What You Need To Know – Etelligent Solutions
- 2014-06-09Weekly Dynamic: GP 2013 R2 Paste to GL from Excel
- 2014-05-12Dynamics GP: Word Template Documentation & Resources
- 2014-04-24SmartList to Excel with the Dynamics GP Web Client
- 2014-04-14Weekly Dynamic: Find Duplicates in Excel
- 2014-04-01Dynamic Dashboards: Auto Refresh Power Pivot for Excel
- 2014-03-31New Microsoft Office Excel on iPad Native App : Impact Analytix: Business Intelligence, Predictive Analytics & Excel
- 2014-03-26Come Hang Out with us and Talk Excel on April 4!
- 2014-03-25Dynamic Dashboards: Pivot Tables, Power Pivot and 1 million rows
- 2014-02-03Weekly Dynamic: Managing Dates with Pivot Table Groups
- 2014-01-21Analytics for Dynamics GP
- 2014-01-13Weekly Dynamic: Revisting SmarList Excel Exports with GP 2013
2013
- 2013-11-20Dynamics GP: Web Client Wednesday – An Early Recommendation
- 2013-11-12Weekly Topic: Excel – Inside Microsoft Dynamics GP
- 2013-10-07Excel Mashup Example
- 2013-04-22Weekly Dynamic: Excel Paste Tips
- 2013-04-15Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 – Inside Microsoft Dynamics GP – Site Home – MSDN Blogs
- 2013-04-01Weekly Dynamic: Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013
- 2013-03-13Microsoft Dynamics GP 2013 SmartList Export to Excel values are 0 | Dynamics University
- 2013-02-19Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013
- 2013-02-11Excel Advanced Reporting for Microsoft Dynamics GP: Jet Essentials
- 2013-02-06United Nations Energy Consumption Insights Done with Microsoft Excel 2013, PowerPivot, Power View and the Azure Marketplace | Extended Results, Inc.
2012
- 2012-12-10Weekly Dynamic: Excel Financial Statement Formatting Updated
- 2012-12-03Weekly Dynamic: Excel Financial Statement Formatting
- 2012-11-12Weekly Dynamic: Excel File Name
- 2012-11-05Weekly Dynamic: Flash Fill in Excel 2013
- 2012-10-01Weekly Dynamic: Excel Report Builder Pivot Table
- 2012-09-24Excel–Changing Values and reversing sign
- 2012-08-29Buckle Up, Here Comes Windows 8, Excel 2013 and GP 2013
- 2012-08-08Printing the Header on the First Page Only in Word Templates
- 2012-06-18Mohammad R. Daoud: Dynamics GP Journal Entry: Paste From Excel–Free Add-in
- 2012-06-05CFO.com and Financial Reporting Spreadsheets
- 2012-06-04Weekly Dynamic: GP 2010 R2 Excel Reports Deployment
- 2012-05-29Error Exporting to Excel from Business Portal 5.1 for Microsoft Dynamics GP 2010 in Internet Explorer 9 – Microsoft Dynamics GP Support Blog – Site Home – MSDN Blogs
- 2012-05-09Using an Excel Data Connection as the Starting Point for a New Excel Report
- 2012-05-02Making the Most of Word In GP 2010 by Using The Word Template Generator
- 2012-04-25Project Accounting Alternate PO with Word Templates – Video – Microsoft Dynamics GP Support Blog
- 2012-04-18Outlook 2010–Schedule an Email or “Delay Delivery” for emails in Dynamics GP.
- 2012-04-18Word Templates not printing to the screen on a Citrix Environment – Microsoft Dynamics GP Support Blog
- 2012-03-26Word Templates – When emailing documents as PDF, a save as window opens and email fails – Microsoft Dynamics GP Support Blog
- 2012-03-14Error message when printing or emailing multiple Word Templates – Microsoft Dynamics GP Support Blog
- 2012-03-13Feature of the week: Excel Report Pivot Tables in GP 2010 | onza blog
- 2012-03-12Weekly Dynamic: ODBC and Excel
- 2012-03-05Moving SQL Server Reporting Services from Native Mode to SharePoint Integrated Mode – Microsoft Dynamics GP Support Blog
- 2012-02-13Weekly Dynamic: Remove Duplicates in Excel
- 2012-01-30Drill Down to Microsoft Dynamics GP windows from Excel – Dynamics GP Support and Services Blog
- 2012-01-23Imagine There is No Excel
2011
- 2011-10-17Printing Subtotals in the Footer of the last page using Microsoft Dynamics GP Word Templates – Dynamics GP Support and Services Blog
- 2011-10-12How to resize your logo in Microsoft Dynamics GP Word Templates | onza solutions
- 2011-10-10Mohammad R. Daoud: Dynamics GP Workflow Installation – The selected website is not a SharePoint site
- 2011-10-05When trying to email a Word Template you get the following message: An unknown error has occurred – Dynamics GP Support and Services Blog
- 2011-09-14Field List button missing in Word Templates – Dynamics GP Support and Services Blog
- 2011-08-22Weekly Dynamic: Dealing with Leading Zeros in Excel
- 2011-08-04Helpful tips when upgrading Business Portal 4.0 (for GP 10) to Business Portal 5.1 (for GP 2010 and SharePoint 2010) » Summit Group Software Blog
- 2011-07-27Keeping Report Writer in Synch with Word Templates – Video – Dynamics GP Support and Services Blog
- 2011-07-19Copy Cell Contents in Microsoft Excel | Interesting Findings & Knowledge Sharing
- 2011-07-13Securing Word Template Documents in Dynamics GP 2010 when using Word 2010 – Video – Dynamics GP Support and Services Blog
- 2011-06-29Microsoft Dynamics GP and Microsoft Office 365 – Better Together! – Inside Microsoft Dynamics GP
- 2011-06-13Belinda, the GP CSI: GL Summary Trial Balance made easy with Excel Pivot Tables
- 2011-06-02How to Surface Excel Data in the Business Analyzer – Inside Microsoft Dynamics GP
- 2011-05-04Helpful Hints for Logos in Word Templates for Dynamics GP 2010 – Dynamics GP Support and Services Blog – Site Home
- 2011-05-04Looking for Office 365 Beta Customers – Inside Microsoft Dynamics GP
- 2011-04-25iSolutions – Import Journal Entries from Excel into Dynamics GP
- 2011-04-08Feature of the Day: Multicompany Excel Reports in a single worksheet – Inside Microsoft Dynamics GP
- 2011-04-05Slicing Dynamics GP 2010 Data in Microsoft Excel Dashboards
- 2011-03-15Feature of the Day: Word Template Generator – Inside Microsoft Dynamics GP
- 2011-03-10Feature of the Day: SOP Return Word Templates – Inside Microsoft Dynamics GP
- 2011-01-20Excel Dashboarding in GP 2010
- 2011-01-10Office 2010: A copy sold every second
2010
- 2010-12-15Build Your Excel Skill, Get CPE and a Free Book
- 2010-12-01How to Setup Word Templates in Dynamics GP 2010
- 2010-12-01Dynamics GP 2010 “DIY” Fixed Assets Excel Report
- 2010-11-08PowerPivot for Excel Book
- 2010-10-25Weekly Dynamic: PowerPivot and Multiple Cubes
- 2010-10-11Weekly Dynamic: Integration Manager and Excel
- 2010-10-07Dynamics GP 2010 and Outlook 2010
- 2010-09-20Excel Team Favorite Keyboard Shortcuts
- 2010-09-02Weekly Review: Excel Reports
- 2010-05-25Dynamics GP 2010 Excel Based Table Reference
- 2010-05-14GP 2010 + Office 2010 + Sharepoint
- 2010-05-13Dynamics GP 10 Microsoft Excel and Excel Reports Snack
- 2010-04-13MS Excel files in GP v10 – refreshing indeed
- 2010-03-17Microsoft Office Word Template Maintenance in GP 2010
- 2010-03-08Dynamics GP 2010: Microsoft Office Word Templates
- 2010-03-03Dynamics GP 2010: Excel Report Totals
- 2010-02-25Excel Pivot Table Builder in GP 2010
2009
- 2009-08-25Microsoft Forecaster 7 vs. Excel
- 2009-08-06Weekly Review: Excel-ing with Smartlists
- 2009-07-20Do You Know…Excel Report Builder?
- 2009-06-26Sharepoint, Dynamics GP and Month End Close
- 2009-06-22Did you Know? Excel Reports
2008
- 2008-12-18Report Writer To Excel
- 2008-11-09Excel Reports Knowledge Base
- 2008-09-29Dynamics GP 10 Analysis Cubes for Excel: Notes from the Field
- 2008-09-17Analysis Services For Excel: Currency Formatting
- 2008-09-02Excel and Excel Services with Analysis Services 2008
- 2008-07-23Excel Fuzzy Lookups
- 2008-03-31Eating My Sharepoint Dog Food
- 2008-03-26Weekly Dynamic:Excel Reports in Dynamics GP 10
2007
2005
- 2005-10-25Weekly Feature:Excel Subtotals
- 2005-10-06Weekly Feature: Excel-ing with Smartlists
Links to other writers
2020
- 2020-10-26Microsoft Dynamics GP Fall 2020 Release fixes recent Word template issue – azurecurve
- 2020-09-22Error opening Word templates from Microsoft Dynamics GP Workflow Action emails – azurecurve
- 2020-09-22Word Templates will not Email/Print after Office Update – Microsoft Dynamics GP Community
- 2020-09-22Microsoft Dynamics GP Workflow Payables Batch Approval email not including Word template – azurecurve
- 2020-08-10Getting Custom with Excel Refreshable Reports – Microsoft Dynamics GP Community
- 2020-08-04Getting more Advanced with Excel Refreshable Reports – Microsoft Dynamics GP Community
- 2020-08-04Starting off with Excel Refreshable Reports – Microsoft Dynamics GP Community
- 2020-08-03SmartList Export: Excel cannot open error – JenKuntz.ca
- 2020-05-11Errors in Microsoft Dynamics GP after applying an Office update with Word, Outlook, or Excel – Microsoft Dynamics GP Community
2019
- 2019-11-21Automatically Highlight Active Row in Excel – Life Hacks 365
- 2019-07-31What are bookmarks and how are they used in Microsoft Dynamics GP’s Word Templates? – Microsoft Dynamics GP Community
- 2019-07-29Excel’s hidden gem: IFERROR – JenKuntz.ca
- 2019-07-25Excel tip – “corner” copy – JenKuntz.ca
- 2019-03-20Removing GP Workflow 1.0…yes 1.0 or Sharepoint workflow
2018
- 2018-07-31Missing Dexterity Shared Components cause Word Templates processing to hang
- 2018-07-30I love Dynamics GP and Microsoft Excel. What are the options to use them together?
- 2018-07-17Find Unique Records in Microsoft Excel
- 2018-06-25Functional beauty: Laying out a proper Excel model
- 2018-01-02How to print Document Comments on the SOP Blank Picking Ticket Word Templates
2017
- 2017-12-18Disable Workflow SharePoint in Dynamics GP | Encore Business Solutions
- 2017-11-27Microsoft Dynamics GP Macros: Macro By Excel Formula
- 2017-10-18Logo no longer appears or missing data on Word Template in Microsoft Dynamics GP
- 2017-06-29Workaround to Workflow Notification View/Edit Link Doesn’t Work on Outlook 365 Online | azurecurve
- 2017-06-12Congrats to Mr. Excel on 2,000 Excel Videos
- 2017-04-13=GetGP(), the Excel Function that gets data from Dynamics GP database into your spreadsheet, one cell at a time. – ERP Software Blog
- 2017-03-29Disable Word Templates in GP to Print | Boyer and Associates
- 2017-03-01Dynamics GP Essentials: Smartlist Export Failure – Excel Cannot open file because the File Fomrat or File Extension is not valid
- 2017-02-21Import all CSV files from a folder with their filenames in Excel – PowerPivotPro
- 2017-01-27The Dynamics GP Blogster: Deploying Microsoft Dynamics GP Web Client with Office 365 Identity and Azure Active Directory – Part 1
2016
- 2016-11-15Dynamics GP Essentials: General Ledger Journals with Analytical Accounting Details (with Drill Down Capabilities from Excel) –SQL Script
- 2016-08-23Word Template borders not printing correctly after making modifications? – Microsoft Dynamics GP Community
- 2016-08-01Dynamics Confessions Blogspot: Quick and Dirty Checklist for Modifying Word Templates
- 2016-06-02The lack of 64 bit Outlook support prevents us from implementing and using Power BI and other Excel tools | Microsoft Connect
- 2016-06-02GP Paste From Excel With Intercompany | Rambles of a non-IT person
- 2016-05-19I Repeat . . . For Financial Reporting, The Client Is Excel
- 2016-05-19Microsoft and Jet Reports Announce Excel-based Reporting for Dynamics GP – MSDynamicsWorld.com
- 2016-05-11Microsoft Dynamics GP 2016 – Ability to export numbers to Microsoft Excel as numbers and not text format – SmartList – Microsoft Dynamics GP Community
- 2016-05-10Tip Jar – Report Signing from Outlook
- 2016-04-18On Demand Learning: Word Template Tips – Microsoft Dynamics GP Community
- 2016-04-14Dynamics GP 2016 Feature of the Day: Word Templates for Batch Approval Workflow – Microsoft Dynamics GP Community
- 2016-04-08Dynamics GP 2016 Feature of the Day: Excel Export as Numbers – Microsoft Dynamics GP Community
- 2016-03-23Analyzing and Visualizing Data with Excel | edX
- 2016-02-29Creating a Word Template in Microsoft Dynamics GP – ERP Software Blog
2015
- 2015-12-16Tech quiz: How Excel-savvy are you? – CGMA Magazine
- 2015-12-11Friday Fun: Man doesn’t want to waste money on software, creates brilliant illustrations on Excel instead
- 2015-11-30How to debug Excel spreadsheets
- 2015-10-26The Dynamics GP Blogster: Excel Copy/Paste feature not working on General Entry modified window
- 2015-10-21Autodiscover: Some quick methods to get it working – HowTo-Outlook
- 2015-09-21Excel for Data Analysis and Visualization | edX
- 2015-09-10Excel logical formulas: 5 simple IF statements to get started | PCWorld
- 2015-08-12Word Template RM Statements Formatting when Emailing as PDF – Microsoft Dynamics GP Community
- 2015-05-1910 Most Popular Articles of Excel Tips and Tricks
- 2015-04-30MSDW presents: Building Dashboards with Microsoft Dynamics GP and Excel
- 2015-03-30Course Prep: Excel 2010 and Excel 2013 PowerPivot Differences « PowerPivotPro
- 2015-02-12The Quickest Guide to Getting Started with PowerPivot – SQLServerCentral
- 2015-02-12Word Templates XML Update – Make Sure Word Is Closed Before Modifying | azurecurve
- 2015-01-15Power Query for Excel: Combine multiple files of different file types « PowerPivotPro
2014
- 2014-12-02Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask
- 2014-11-10Downloading formulas to Excel – Feedback and Hotfix – Dynamics Financial Reporting
- 2014-11-10Dynamics GP Essentials: Analytical Accounting Entry (Excel to Dynamics GP) – Free Tool (Beta)
- 2014-10-07Formatting report headers when downloading Management Reporter reports to Microsoft Excel (CU10 Feature) – Dynamics Financial Reporting – Site Home – MSDN Blogs
- 2014-10-07Microsoft adds new Excel export tools to Management Reporter 2012 CU 10 | MSDynamicsWorld.com
- 2014-10-02Download TOT formulas to Microsoft Excel from a Management Reporter report (CU10 Feature) – Dynamics Financial Reporting
- 2014-09-11Word Template Image Content Control – Microsoft Dynamics GP Community
- 2014-08-18Importing Excel budgets with Calculated fields – Microsoft Dynamics GP Community
- 2014-07-29Dynamics GP Essentials: GP 2013 R2 – Copy paste GL journals from Excel “with Analytical Accounting Details”
- 2014-07-08From data to doughnuts: How to create great charts and graphics in Excel | PCWorld
- 2014-07-01Microsoft Dynamics GP 2013 R2 Sales and Purchasing Dashboards with Office 365 – Dynamics GP Support and Services Blog
- 2014-06-20Our June 2014 Excel Hangout recording is up
- 2014-06-20Friday Fun: Excel on an iPad
- 2014-06-10Excel Hangout This Friday
- 2014-05-29Copy/Paste journal entries from Microsoft Excel into Transaction Entry
- 2014-05-29Dashboards with Office 365 – Dynamics GP Support and Services Blog
- 2014-05-21Dynamics Confessions Blogspot: Concatenating a range of cells in EXCEL
- 2014-05-12Excel Hangout – June 2014 | MSDynamicsWorld.com
- 2014-04-09Excel Hangout: April 2014 (Recorded Webcast) | MSDynamicsWorld.com
- 2014-04-09Dynamics GP – New Zealand GST Reporting in Excel
- 2014-04-08Dynamics GP – New Zealand GST Reporting in Excel
- 2014-03-26Data Analysis Expressions: PowerPivot’s Secret Weapon – AICPA Insights
- 2014-03-20PowerPivot: A Game Changer for Excel Pivot Table Users – AICPA Insights
- 2014-03-17Excel enhancements in Management Reporter CU8 – Dynamics Financial Reporting
- 2014-03-10Weekly Dynamic: Excel Pivot Tables, Clear Old Items
- 2014-02-10Excel Cube Functions: Exclude a Single Member from a Set | Dynamics Care Services
2013
- 2013-12-17Microsoft Dynamics GP – Make Excel Data refreshing easier (video)
- 2013-12-10Microsoft Dynamics GP – Why avoid 3D charts in Excel? (video)
- 2013-12-02About Dynamics, Development and Life: Dynamics GP Dashboard template for Office 365 now available
- 2013-11-19Microsoft Dynamics GP – Excel Power Pivot SOP Dashboard (with video)
- 2013-11-19Join our new survey: Fall 2013 Microsoft Dynamics Community Trends and Outlook | MSDynamicsWorld.com
- 2013-11-12Microsoft Dynamics GP – Excel AR Trial Balance with SQL (with video)
- 2013-11-11Using Cube Functions in Excel to Create MTD Calculations | Dynamics Care Services
- 2013-11-11Even Microsoft Needs Help Avoiding Spreadsheet Errors
- 2013-11-06Microsoft Dynamics GP – Excel AR Trial Balance (with video)
- 2013-10-02Getting in Control of Your Excel Dashboards: Combining Cube Functions and Form Controls | Dynamics Care Services
- 2013-09-30A Slicer and a Macro Walk Into a Bar: Filtering Multiple Pivot Tables With a Click of a Button | Dynamics Care Services
- 2013-09-17Power View and Power Pivot videos – Excel – Office.com
- 2013-09-16Excel Blog – Excel Web – What’s in Our Pipeline and Why?
- 2013-09-11Smartlist and Navigation Lists export currency values with 5 decimals in Excel using Microsoft Dynamics GP 2013 – Dynamics GP Support and Services Blog – Microsoft Dynamics GP – Microsoft Dynamics Community
- 2013-09-04Adding or Summing Time in Microsoft Excel
- 2013-08-26Microsoft Dynamics NAV Users Weigh Benefits, Risks of Broader use of PowerPivot | MSDynamicsWorld.com
- 2013-08-22The eOne Dynamics GP and CRM Blog: SmartConnect Excel Data Entry Templates for Microsoft Dynamics GP 2013
- 2013-08-19Hey Software Bullies, Stop Picking on Excel | MSDynamicsWorld.com
- 2013-07-29Creating a Word Template for Dynamics GP | Dynamics GP Insights
- 2013-07-24PowerPivotPro School: Affordable Video Training Makes You Awesome at PowerPivot « PowerPivotPro
- 2013-07-18Work Smarter with SmartLists and Excel | onza blog
- 2013-07-10SOP Blank History Word Template does not Email – Dynamics GP Support and Services Blog – Microsoft Dynamics GP – Microsoft Dynamics Community
- 2013-07-08My Conversion to PowerPivot: Guest Post By Geoff McNeely
- 2013-07-02Why PowerPivot is Great For Accountants (Guest Post by Robert Stamsnijder) « PowerPivotPro
- 2013-07-01Self-Serve BI Tool Scorecard: PowerPivot vs. the Others, and Why Not All Checkboxes Are Equal « PowerPivotPro
- 2013-06-13Dynamics GP Land: Word Templates and Report Sections
- 2013-06-11Low-Tech Excel Tips | Intuit News Central
- 2013-06-10The Ideal PowerPivot Professional: How to Hire, Grow, or Become One « PowerPivotPro
- 2013-06-10More Uses for Data Explorer for Excel
- 2013-05-29Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino – A (short) Review | azurecurve
- 2013-05-28The Dynamics GP Blogster: GP 2013: Why are my SmartLists not formatted when exported to Excel?
- 2013-05-23BI on the Microsoft stack: Can PowerPivot in the cloud steer Dynamics customers to more insight? | MSDynamicsWorld.com
- 2013-05-23Book Review: Instant Creating Data Models with PowerPivot How-to
- 2013-05-22Rob Collie’s Open Letter to My Friends at Microsoft: The Power of Excel’s Internal Network Effect « PowerPivotPro
- 2013-05-20Dynamics GP Land: MR 2012 UR 4- Quirky Excel Linking Behavior with RPO
- 2013-05-20Analyze Dynamics GP Data Using Microsoft PowerPivot for Excel
- 2013-05-20Two ways to Export data from SSMS to Excel
- 2013-05-14BI on the Microsoft stack: Can PowerPivot in the cloud steer Dynamics customers to more insight? | MSDynamicsWorld.com
- 2013-05-09In Touch with Dynamics (GP): 32766 maximum row export to excel from smartlists in Dynamics GP2013
- 2013-05-06GP2themax – Helping users get the ‘max’ from Dynamics GP: Book Review – Building Dashboards with GP 2013 and Excel 2013
- 2013-05-02In Touch with Dynamics (GP): Cheque (check for US readers) Remittance word template not emailing from Dynamics GP
- 2013-04-24Mohammad R. Daoud: Excel Paste Tips
- 2013-04-23Mohammad R. Daoud: Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013
- 2013-04-22eBook Giveaway: Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 | MSDynamicsWorld.com
- 2013-04-14Friday’s Live Chat: Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 | MSDynamicsWorld.com
- 2013-04-10Great Microsoft Dynamics GP 2013 and Excel 2013 Resource!
- 2013-04-08Weekly Dynamic: Stored Procedures in Excel
- 2013-03-20Dynamics GP Land: Updating Records with Excel
- 2013-02-28Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 | Packt Publishing
- 2013-02-27Creating Linked Tables in PowerPivot for Excel
- 2013-02-26Copying Report Formats between Reports… and a warning about Word Templates – Developing for Dynamics GP – Site Home – MSDN Blogs
- 2013-02-26Importing SQL Server Data from Multiple Data Sources into PowerPivot for Excel
- 2013-02-26Stairway to PowerPivot and DAX – Level 3: The DAX DISTINCT() Function and Basic Distinct Counts – SQLServerCentral
- 2013-02-21More PowerPivot and Excel 2013
- 2013-02-20Occupy Excel
- 2013-02-20Mary Jo Foley has the PowerPivot Protest story on ZDNet too!
- 2013-02-18Microsoft peed on my PowerPivot
- 2013-02-11Chandoo Launches PowerPivot Course! « PowerPivotPro
- 2013-02-11Excel Blog – Open Excel workbooks in separate windows and view them side by side
- 2013-02-05PowerPivot with Excel 2013
- 2013-01-31Q&A with Rob Collie: Is Microsoft Excel the Next Great Business Intelligence Tool?
- 2013-01-29Mohammad R. Daoud: Dynamics GP Excel Paste V 4.0
- 2013-01-23Dynamics Blogger: How to Publish Management Reporter Reports to SharePoint
- 2013-01-22Management Reporter – Quick tips on linking to Microsoft Excel workbooks – Dynamics Corporate Performance Management – Site Home – MSDN Blogs
- 2013-01-03Excel Based Table and Field Reference for Dynamics GP 2013
2012
- 2012-12-17Mohammad R. Daoud: Dynamics GP Excel Paste has been ranked in DynamicsWorld Microsoft Dynamics Top 50 Add-Ons 2013
- 2012-12-17Excel Blog – Introduction to PowerPivot in Excel 2013
- 2012-11-27The Dynamics GP Blogster: Microsoft Dynamics GP Excel Dashboards
- 2012-11-05Excel Reports in Microsoft Dynamics GP – Security Setup
- 2012-10-03The eOne Dynamics GP and CRM Blog: Tech Tuesday – New Excel Template (Again)
- 2012-09-12How to display more than four line item comments in the SOP Blank Invoice Word Template
- 2012-09-06Using Dynamics GP 2010 R2 with the Microsoft Excel 2013 Preview | Dynamics GP Insights
- 2012-08-28The Dynamics GP Blogster: How to add a “Cover Letter” page to a Microsoft Dynamics GP Word Template document
- 2012-08-27About Dynamics, Development and Life: Importing/Exporting a Dynamics GP Transaction to Excel
- 2012-08-06Dynamics GP Excel Paste
- 2012-07-30Mohammad R. Daoud: Dynamics GP Excel Paste Updates
- 2012-07-24How to Configure Microsoft SharePoint with Management Reporter 2012 – Dynamics Corporate Performance Management – Site Home – MSDN Blogs
- 2012-07-19Weekly Review: PowerPivot and Multiple Cubes
- 2012-07-12Weekly Review: PowerPivot
- 2012-07-05Weekly Review: Integration Manager and Excel
- 2012-07-03Mohammad R. Daoud: Microsoft Dynamics GP Excel Paste is now Online
- 2012-06-21How To Deploy Excel Reports In Microsoft Dynamics GP 2010 R2 | azurecurve
- 2012-06-20Mohammad R. Daoud: Excel Paste for “Any Screen” in Microsoft Dynamics GP
- 2012-06-12Dynamic Future – Vote – Copy and Paste from Excel to the Dynamics GP General Journal Transaction Entry Window
- 2012-05-09Mini-Post 2 of 2: PivotLink, Birst, QlikView, and “Desktop-Only” PowerPivot added to ROI Quadrant « PowerPivotPro
- 2012-05-08For Business Intelligence and Reporting, the Client is Excel | MSDynamicsWorld.com
- 2012-05-08PowerPivot Security Architecture Technical Diagram « Marcello Tonarelli Blog
- 2012-04-26Weekly Review: Export Navigation Lists to Excel
- 2012-04-17PowerPivot “Owns” Excel Now! « PowerPivotPro
- 2012-02-27Opening reports in Microsoft Excel – Management Reporter 2012 Feature Highlight – Dynamics Corporate Performance Management
- 2012-02-14E-mail reports using SharePoint alerts – Management Reporter 2012 Feature Highlight – Dynamics Corporate Performance Management
- 2012-02-07The Dynamics GP Blogster: Debugging Microsoft Dynamics GP Word Templates Revisited
- 2012-02-01The Dynamics GP Blogster: Word Templates rendering report in Internet Explorer
- 2012-01-2615 Spreadsheet Formatting Tips « PowerPivotPro
- 2012-01-24Configuring Microsoft Word Templates in Dynamics GP | Dynamics GP Insights
- 2012-01-18How To Use The Microsoft Dynamics GP Word Template Generator | azurecurve
- 2012-01-10An aggregate answer to two Excel questions
2011
- 2011-12-21Stairway to PowerPivot and DAX – Level 1: Getting Started with PowerPivot and DAX – SQLServerCentral
- 2011-12-12Word Template Generator, Where Art Thou? | azurecurve
- 2011-12-12Problem With SOP Word Templates | azurecurve
- 2011-11-30Trouble Importing Microsoft Dynamics GP Excel Budgets using the Excel Budgeting Wizard » Summit Group Software Blog
- 2011-11-14Integrity Data Launches U-LINC Flexible Workflows for Microsoft Dynamics GP and SharePoint | MSDynamicsWorld.com
- 2011-10-27Pivot Tables with SQL? The Sum of Payments Posted Per Vendor Per Month
- 2011-10-13Dynamics GP Land: Word Templates and Synchronization
- 2011-10-12Dynamics GP Land: Adding Fields To Word Templates
- 2011-09-29Dynamics GP Tip: Syncing Report Writer Changes in Word Templates | Socius
- 2011-09-13Pivotal Advance Boosts Excel’s Power
- 2011-09-07Documentation for the Word Templates feature in Microsoft Dynamics GP 2010 – Dynamics GP Support and Services Blog – Site Home – MSDN Blogs
- 2011-08-25In Touch with Dynamics (GP): Emailing POs using new GP2010 word templates
- 2011-08-16Excel Report Builder – bug in SQL views created – Blog – Kuntz Consulting
- 2011-08-15Value Proposition of PowerPivot (in CIMA Insight) « PowerPivotPro
- 2011-08-02SharePoint Going Away? « Charlie Maitland’s Blog
- 2011-08-01Weekly Dynamic: Filtering a Pivot Table with a Formula – Technology
- 2011-07-07Helpful tips when modifying Word Templates in Microsoft Dynamics GP 2010 – Video – Dynamics GP Support and Services Blog
- 2011-06-15Using FRx or Management Reporter to create an Excel Pivot Table | FRxBuzz
- 2011-06-08Stored Procedure as Data Source in PowerPivot – Issue & Solution – Microsoft Dynamics GP Learn & Discuss –
- 2011-05-31Office 365 and Dynamics GP – the skinny « DynamicsGP.ie
- 2011-05-25Microsoft Excel – Where to begin: PowerPivot for Excel
- 2011-05-09Keeping Word Templates in synch with Report Writer – Developing for Dynamics GP
- 2011-05-09Microsoft Excel – Portable formulas: A PowerPivot benefit you’ll never believe you lived without
- 2011-04-26Word Templates will not print to screen – Developing for Dynamics GP
- 2011-04-20Microsoft Excel – Add the date, time, file name, and page numbers to your headers or footers
- 2011-04-06Word Template Debugging – Developing for Dynamics GP
- 2011-03-16Dynamics GP2010 Word Templates and Activating the Developer Tab in Word
- 2011-02-28Frequently asked questions about the Excel Reports in Microsoft Dynamics GP 10.0 and 2010
- 2011-02-28Making Word Template Documents Read Only When Sent To Customers – Developing for Dynamics GP
- 2011-02-24Weekly Review: GP 10+Citrix+Outlook Fix
- 2011-02-10Excel Pivot Table – Filling Blank Cells
- 2011-02-08DynamicsBlogger: GP Basics: Historical Inventory Trail Balance in Excel
- 2011-01-24Send To E-Mail Problem with Office Outlook 2010
- 2011-01-20Tame Pivot Table Sequencing
- 2011-01-12Dynamics GP 2010 Word templates (more required fields SOP Blank History Invoice)
2010
- 2010-12-09Word Templates, Office 2010 and the Maintain Compatibility option
- 2010-12-08Enabling a Report Writer document as a Word Template
- 2010-11-30The War Against Spreadsheets
- 2010-11-11Spreadsheets: Why Pivot Tables Won’t Sum
- 2010-11-11Making the Case for PowerPivot – Top 5 Ways PowerPivot Helps Excel Pros
- 2010-10-26Using PowerPivot with Excel 2010 to Mash Up Data
- 2010-10-19Excel Tip: Count the Number of Occurrences of a Single Character in One Cell
- 2010-10-18Weekly Dynamic: PowerPivot
- 2010-10-15Why won’t my modified Word template in Dynamics GP email.
- 2010-10-11New Licensing Guide available for SharePoint and Dynamics GP
- 2010-10-05Top 5 Ways PowerPivot Helps Excel Pros
- 2010-10-04How to resize logo in Microsoft Dynamics GP Word Templates
- 2010-10-04Microsoft Dynamics GP 2010 Word Templates summary
- 2010-09-28How to add a “Terms and Conditions” page to a Microsoft Dynamics GP Word Template document
- 2010-09-28Debugging Microsoft Dynamics GP 2010 Word Templates
- 2010-07-27Free PowerPivot Webinar
- 2010-07-26Want your Dynamics GP GL Trial Balance in Excel?
- 2010-07-26Excel Templates in SmartConnect for Dynamics GP
- 2010-07-23Excel Report Builder Pivot Tables in Dynamics GP 2010 Pivot Tables
- 2010-07-05The Excel Web App and its missing API
- 2010-06-02Modifying Microsoft Dynamics GP 2010 Word Templates
- 2010-06-01Weekly Dynamic: Export Navigation Lists to Excel
- 2010-05-24Smartlist: Exports slowly to Excel – Part 2
- 2010-05-14READ THIS RIGHT NOW: Smartlist: Exports slowly to Excel – Part 1
- 2010-05-03Weekly Dynamic: Portable Excel Reports, the Best of Both Worlds Part 2
- 2010-05-03Excel Drill Down Builder
- 2010-04-05More Excel 2010 Posts
2009
- 2009-07-20Dynamics GP Trial Balance in Excel using FRx
- 2009-01-29Another Excel Resource
2008
- 2008-12-15Weekly Dynamic: GP 10+Citrix+Outlook Fix
- 2008-10-02Letter Writing with Microsoft Outlook and Dynamics GP
- 2008-09-16Sharepoint or Performance Point for Dashboards?
- 2008-09-11Ultimate List of Excel Feeds from J-Walk
- 2008-09-10Excel Services Training Course
- 2008-07-11Excel as a Source for Account Modifier/Combiner
- 2008-07-10Dynamics GP Excel Reports and Excel Report Builder
- 2008-07-07Filtering in Excel 2007 Pivot Tables
- 2008-06-18Sloppy Spreadsheets
- 2008-03-28It’s Mr. Excel to You!
2007
- 2007-07-25It’s All About the SharePoint…Stupid
2005
- 2005-09-28Office 2003 SP2 Now Available