Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

Microsoft Dynamics GP and Excel are made for each other. With this book you’ll learn to use Excel to present the information contained in Dynamics in a data-rich dashboard. Step-by-step instructions come with real-life examples.

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

Mark Polino

Microsoft Dynamics GP and Excel are made for each other. With this book you’ll learn to use Excel to present the information contained in Dynamics in a data-rich dashboard. Step-by-step instructions come with real-life examples.
eBook
$10.00
RRP $29.99
Save 66%
Print + eBook
$49.99
RRP $49.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$10.00
$49.99
RRP $29.99
RRP $49.99
eBook
Print + eBook

Frequently bought together


Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 Book Cover
Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013
$ 29.99
$ 10.00
Microsoft Dynamics GP 2013 Cookbook Book Cover
Microsoft Dynamics GP 2013 Cookbook
$ 35.99
$ 10.00
Buy 2 for $20.00
Save $45.98
Add to Cart

Book Details

ISBN 139781849689069
Paperback268 pages

Book Description

Accounting systems like Microsoft Dynamics GP 2013 hold a wealth of information. Excel 2013 provides a great tool for linking to, extracting, analysing, and presenting that rich data to help companies make better, faster, and smarter decisions.

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 covers how to get the rich, detailed information contained in Microsoft Dynamics GP 2013 and present it in an attractive, easy-to-understand way using Excel 2013. The book shows in detail how to build great-looking dashboards that enhance a company’s decision-making process.

This book shows you how to get at the rich, detailed information contained in Microsoft Dynamics GP 2013 and present it in an attractive, easy-to-understand way using Excel 2013. This guide will take you from the basics of setup and deployment to creating secure, refreshable Excel reports. Using a whole host of tools available within Excel, this tutorial will show you how to visualize your data using simple conditional formatting techniques, easy-to-read charts, and allow you to make your data interactive with Slicers.

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 provides a way for you to easily build that interactive dashboard that your CFO keeps asking for.

Table of Contents

Chapter 2: The Ultimate GP to Excel Tool: Refreshable Excel Reports
Chapter 6: Adding Interactivity with Slicers and Timelines

What You Will Learn

  • Get Dynamics GP 2013 information into Excel 2013
  • Set up, deploy, and secure refreshable Excel reports in Dynamics GP 2013 to get live GP data to Excel
  • Consolidate and present GP 2013 data using Excel pivot tables
  • Improve the look and feel of a dashboard with conditional formatting
  • Enhance data clarity with charts and sparklines
  • Add interactivity to a dashboard using Slicers
  • Link dashboard data back to Dynamics GP 2013
  • Approach more complex dashboards and sources using PowerPivot

Authors

Table of Contents

Chapter 2: The Ultimate GP to Excel Tool: Refreshable Excel Reports
Chapter 6: Adding Interactivity with Slicers and Timelines

Book Details

ISBN 139781849689069
Paperback268 pages
Read More

Read More Reviews

These popular $10 titles might interest you

Microsoft Dynamics GP 2013 Cookbook Book Cover
Microsoft Dynamics GP 2013 Cookbook
$ 35.99
$ 10.00
PowerPivot for Advanced Reporting and Dashboards Book Cover
PowerPivot for Advanced Reporting and Dashboards
$ 23.99
$ 10.00
Microsoft Dynamics GP 2013 Cookbook Book Cover
Microsoft Dynamics GP 2013 Cookbook
$ 35.99
$ 10.00
Excel 2010 Financials Cookbook Book Cover
Excel 2010 Financials Cookbook
$ 23.99
$ 10.00
PowerPivot for Advanced Reporting and Dashboards Book Cover
PowerPivot for Advanced Reporting and Dashboards
$ 23.99
$ 10.00
Excel 2010 Financials Cookbook Book Cover
Excel 2010 Financials Cookbook
$ 23.99
$ 10.00