Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

Posts Tagged ‘microsoft excel’

How Do You Know if You’ve Outgrown Using Excel for Accounting

View our free webinars Sign up for WebSan University It’s no surprise that every business somehow uses Excel in their everyday routine. It’s the easiest and the most popular tool to organize your company’s data. But eventually your data starts to outgrow Excel possibilities. Here are 3 signs that your business needs to switch from spreadsheets […]

continue reading...

Media Dashboards for Microsoft Dynamics GP

In this article, we’ll explore media dashboard solutions to upgrade your Microsoft Dynamics GP data analytics.  As a media organization, whether your focus is television, radio, the internet, or another medium, a comprehensive dashboard tool can substantially help you to achieve disruption, based on real metrics.  Dashboards deliver accessible and business user friendly analytics with […]

continue reading...

Creating 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 filtered according to your requirements.   This connection must be validated by a SQL login to ensure the contents of your databases remain secure. The connection can be refreshed to update […]

continue reading...

Getting Hyper about Hyperlinks

You can increase productivity and efficiency by using hyperlinks in your Excel documents. Hyperlinks are incredibly easy to set up 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 […]

continue reading...

Four Useful New Features in Dynamics GP 2015

Microsoft recently rolled out Dynamics GP 2015, and with it, a number of significant new features and abilities. In some ways, this is an update that completely rethinks aspects of the program, while adding features that users have long asked for. So what are some of the top features in GP 2015? Service-Based Architecture One […]

continue reading...

Maximizing Dynamics SL with Business Intelligence

With a slow but steady 8% growth, the Business Intelligence (BI) and Analytics solutions market continued to develop in 2013, according to Gartner.  Some might say that this is a stalling growth, but the progress is stable – and it could be the calm before the storm.  Nowadays, BI tools and processes are educating company […]

continue reading...

OLAP Cube vs. Data Warehouse

Data continues to trend upward as a topic in the world of business as the quantity of data that a company maintains, evaluates, and organizes continues to expand.  Holding onto and utilizing pertinent information is vital for analyzing company strengths and weaknesses, while preparing for successful maturation in the future.  That said, without having IT […]

continue reading...

Look Ahead to the Future

There has always been a need to report. In the past, whether it was a document, letter, book, or recording, our reports looked back. We reported on past events. Compare this to driving while looking in the rear-view mirror. Yes, it is important to know where you came from, but isn't it better to know […]

continue reading...

Why Excel Skills are Essential for All ERP Implementers

As an ERP implementer I’m always surprised by the number of people who aren’t comfortable with Excel.  Sure everyone knows how to add up a few numbers, but when I start talking about vlookup and pivot tables, the comfort level drops dramatically.  I would argue that no matter where you are in the ERP process – from running your business […]

continue reading...