Category Archives: Office

Sales Analytics Dashboard Available Now From DynamicAccounting.net

In what looks to be the first in a set of analytics dahsboards, Mark Polino has released a Sales Analytics dashboard on his DynamicAccounting.net site.

The dashboard builds on the ideas covered in Mark’s recent Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 and can provide a really good shortcut to getting started using an Excel dashboard rather than rolling your own from scratch.

Continue reading

Posted in DynamicAccounting.net Analytics, Dynamics, GP, Microsoft, Office, Office 2010, Office 2013, Third Party Add-on | Tagged , , , , , , , , , , , , , | Leave a comment

Outlook.com: Send Without Attachments?

I’ve been a bit quiet on the posting front recently because my second book is in the later stages of the publishing process and I need to review and respond to feedback from the editors at Packt Publishing.

To do this we’ve been emailing drafts of the chapters to and fro. And (again) this morning a feature of Outlook.com saved me from looking slightly silly when I replied to an email intending to send back an updated draft, but clicked Send without actually attaching the file;

Send without attachments?Send without attachments? Just checking. It looks like you’ve mentioned attachments but haven’t added any.

I was presented with the above message. Clicked Go back, added the file and sent the message.

I’ve talked to various people who dislike this type of message, but I really don’t see the problem with it. I’ve only ever been presented the message when I have meant to attach a file and forgotten; I’ve never received it for a false positive so I quite like it. I wish Outlook 2010 had it (or perhaps it does and I just don’t know where the setting is.

Posted in Microsoft, Outlook.com, Site | Tagged , , , , | 3 Comments

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino – A (short) Review

A few weeks ago Mark Polino, in conjunction with Packt Publishing published another book, the Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013;

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

I got a copy of Mark Polino’s Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 the other week with the intention of working through it following all of the examples. However, the reality is I don’t have the time to do this due to other commitments (both work and outside of work ones).

Continue reading

Posted in Dynamics, GP, Microsoft, Office, Office 2013, Packt Publishing, Review | Tagged , , , , , , , , , , , | 2 Comments

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino

Following on relatively quickly from Leslie Vail’s new Microsoft Dynamics GP book, , available from Packt Publishing, comes Mark Polino with Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013.

This book will teach you how to build a dashboard using Excel 2013 with information from Microsoft Dynamics GP 2013, how to make Excel a true business intelligence tool with charts, sparklines and slicers and show how to utilise PowerPivot’s full potential to create even more complex dashboards;

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino

Continue reading

Posted in Dynamics, GP, Microsoft, Office, Office 2013, Packt Publishing, Review | Tagged , , , , , , , , , , | 3 Comments

Consumer Preview Of New Microsoft Office Available

Microsoft Office PreviewMicrosoft have just announced the availability of the Consumer Preview of Microsoft Office which delivers Office as a cloud service using all the innovations of Windows 8.

Okay, that sounds like a press release because it is; it was quoted from Microsoft’s press release. The Consumer Preview is available here and offers lots of new functionality and integration with Windows 8.

Full details of the new features are here but there is no news on the eventual pricing. I am a little suspicious of pricing with the tie-in to the cloud and especially the Sky Drive service.

I’ve signed up and will be taking a look first thing tomorrow morning when I get to work (probably badly timed as the second thing I have tomorrow is a Microsoft Dynamics GP exam.

Posted in Microsoft, Office, Office 365 | Tagged , , , , | 1 Comment

Extracting Images From Microsoft Word 2007/2010

Yesterday David Musgrave posted an article which outlines how you can extract images out of a Word 2007/2010 document quickly and easily by changing the extension from .docx to .zip and opening with WinZip.

Great idea, but it occurred to me that this could possibly be done with a little less work. Continue reading

Posted in Microsoft, Office, Office 2007, Office 2010 | Tagged , , , | 5 Comments

Management Reporter Migration Wizard: ACE.OLEDB.12.0 Provider Is Not Registered On The Local Machine

Microsoft Dynamics GPThis particular problem is going to occur if you either do not have Microsoft Office installed or, on an x64 OS, you have installed the x86 version of Microsoft Office when you try to install the Management Reporter Migration Wizard (in particular Microsoft Access);

Management Reporter Migration Wizard: ACE.OLEDB.12.0 Provider Is Not Registered On The Local Machine

Continue reading

Posted in Dynamics, Management Reporter, Microsoft, Office | Tagged , , , , , | 2 Comments

Microsoft Office 365 Launched

Microsoft Office 365Earlier today Microsoft launched their Microsoft Office 365 productivity suite which combines Office, SharePoint, Exchange and Lync in a cloud based version of their earthbound variant.

The service, which replaces Microsoft Business Productivity Online Suite, was launched today by Microsoft CEO Steve Ballmer in a live webcast with over 20 partners already signed up to resell the service alongside their own services.

Kurt DelBene, president, Microsoft Office Division said, “Our partners represent some of the best-known, most-trusted brands in their local markets. Our customers will be able to rest easy knowing their cloud services are backed by Microsoft and some of the greatest service providers in the world.”

Microsoft Dynamics GP and Office 365 work together now! Microsoft Dynamics GP leverages Office 365’s functionality, such as reporting and Excel-based analysis, presence and instant messaging, transaction initiation through Lync, and many of the other features of Office that you have come to enjoy when deployed on-premises, but now available through the Cloud with Microsoft Office 365.

With Microsoft Dynamics GP, you build a foundation for the future that goes beyond standalone applications to extend their traditional ERP systems throughout their organization and into the cloud.

Posted in Microsoft, Office 365 | Tagged , , , | Leave a comment