Getting Started with Jet Express Reports
Since the sunset of Management Reporter, many end users of the Dynamics suite have been looking towards their next reporting solution. While there are many
March 10, 2017
Tag: Excel
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
January 26, 2017
Microsoft Excel Connections to SQL databases
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
January 18, 2017
Short & Useful Visual Basic Scripts to Use
A quick word about Visual Basic (VB) Visual Basic is a foundation of automation in Microsoft office. When you create a macro using action, i.e.
December 19, 2016
Conditional Formatting in Excel
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
December 13, 2016
Dynamic Security – additional thoughts
Introduction Recently I posted a blog titled “How to implement Analysis Services Dynamic Security based on Microsoft CRM User Access Rights.” That post talked about
November 29, 2016
3 Interesting Excel Formulas to Save Time and Frustration
As a project manager, one of the tools I live by is the Excel spreadsheet. Budgets, reports, even project schedules begin in this Microsoft powerhouse
November 17, 2016
Should I Move from Management Reporter to Jet Express?
Anyone who has utilized Dynamics Great Plains (GP) has gone through many different Financial Report Writer packages and the decision on what to do when
October 25, 2016
Microsoft Project Madeira
Microsoft recently released the preview of a new Software as a service (SAS) accounting system. This is their first pure SAS delivered system. I decided to take a look at it to evaluate the features available in this system.
For those of you that don’t know, Microsoft has been diving into the lower end of the accounting system going all the way back to when Great Plains designed Microsoft Profit. There has been a fascination with Microsoft to compete with QuickBooks and compete in that market space.
May 20, 2016
Getting Hyper about Hyperlinks
You can increase productivity and efficiency by using hyperlinks in your Excel documents. Hyperlinks are incredibly easy to setup and even easier to use.
The easiest method for inserting a hyperlink is to create a link to a website. Excel recognizes the syntax of ‘www.something.’ When you type a website into a cell, Excel will automatically create the link for you. Try typing a familiar website into a cell in Excel.
April 7, 2016
