Connect with US at Excelapalooza 2016!

Posted by on Comments (0)

height=200

We invite you to connect with Mike DeRosa at this year's Excelapalooza.  Exelapalooza is THE place to learn Excel tips and tricks, learn from industry experts, and a great place to network.  It's not too late to register, you still have one more day! 

Learn More about the 5th Excelapalooza! The Excel User conference of the year!

This year's Agenda

Register Here

Don't forget to come and say hello to Mike DeRosa! 

 About DeRosa Mangold Consulting

DeRosa Mangold Consulting are experts of Sage 100 ERP Software (formerly Sage MAS 90 ERP) and a partner with companies like Sage Manufacturing (formerly JobOps Manufacturing Solutions)Acumatica, and BizNet Software to give you and your business the tools for success. DeRosa Mangold Consulting helps companies find solutions to their accounting and business information system needs and successfully implement those solutions. DeRosa Mangold Consulting is a full-service accounting software consulting firm, offering consulting and system design, implementation, training, and technical support services.   We have many locations to serve you that include Waco, Austin, Dallas/Ft. Worth, San Antonio, South Bend, Bakersfield and San Diego.  DeRosa Mangold Consulting is proud to serve clients throughout the US that currently include Texas, California, Louisiana, New York, Arkansas, Colorado, Georgia, and Wisconsin.

 Follow us:

  

 

 

 

 

 

 

Your Reporting Dreams Answered! Lists Are Your Friends

Posted by on Comments (0)

This week’s video example will show you how easy it can be to break down your data using lists.  Last week we were able to use a SuperFunction to grab Excel data. 

That SuperFunction crunched some numbers for us, but we always want more, right?

Creating a list through DeskTop follows a lot of the same steps used to create a Superfunction.  Instead of calculating a figure, it will return a list that can be used to filter and break down information.  The example uses the same SuperFunction from last week’s video and answered the question, how many items were returned.  Using a list of warehouses allows us to break down that number so we can see how many items were returned to a warehouse.

Today’s video is a little longer at 2 minutes 39 seconds.  You may even want to watch the previous blog videos again since they do build on each other. 

Your Reporting Dreams Answered!

Your Reporting Dreams Answered! All About Superfunctions

I truly believe that every business can benefit from this tool.  Don’t forget that you can contact us here at DeRosa Mangold Consulting, Inc. with any questions or interest you may have.

 About the Author:

Liz Ortega emerged 7 years ago at DeRosa Mangold Consulting after relocating back to Texas from California.  She has previously worked with a variety of distribution and service companies from shipping and receiving to accounting.  As a former user of MAS 90 and other professional accounting technology, Liz became an adequate fit for our company and naturally progressed to the technical side of the trade.  Liz prides herself on being someone who has a wide knowledge of the software packages she uses.  Succeeding expectations with her ability to go above and beyond the norm to collaborate and guide those who require assistance. 

 For more information contact us HERE

DeRosa Mangold Consulting are experts of Sage 100 ERP Software (formerly Sage MAS 90 ERP) and a partner with companies like JobOps Manufacturing Solutions, Acumatica, and BizNet Software to give you and your business the tools for success.  DeRosa Mangold is here for you and your business needs.  We have many locations to serve you that include Waco, Austin, Dallas/Ft.Worth, San Antonio, Indiana, Bakersfield and San Diego, CA.  DeRosa Mangold Consulting is  proud to serve clients throughout the US that currently include Texas, California, Louisiana, New york, Arkansas, Colorado, Georgia, and Wisconsin. 

 

Your Reporting Dreams Answered! All About Superfunctions

Posted by on Comments (0)

Last week, I introduced you to a powerful reporting tool called BizInsight Desktop Edition that DeRosa Mangold Consulting has been using to create powerful reports for our customers. 

If you didn’t get to see the first part of this short 7-part video blog titled "Your Reporting Dreams Answered! Click HERE. 

This week’s video is only 1 minute and 22 seconds long, and shows you the power of the SuperFunction.  I really think the name speaks for itself!  Using SuperFunctions allows us to customize your reports by filtering dynamic data and giving you real time results.

When you watch this video, imagine that you have tabs of data in Excel that you want to report on.  We can use a SuperFunction to calculate specific figures from that data and create a report that speaks to your personal reporting needs. 

You may be wondering what makes this different from BizInsight reports that you may already have?

Since these SuperFunctions are reporting off of data that is already in Excel, one big difference is SPEED!

 No more waiting on caches and database connections to run your report.

ALSO, because SuperFunctions are calculating data that is in Excel, you can report on any data you want.  If you want Sales Order or Purchase Order reporting, we can bring that data into Excel and use a SuperFunction to do all of the work.  Data from ANY SOURCE that can be brought into Excel is up for grabs.

 

Enjoy this short video on Superfunctions!

 

Written by Liz Ortega, Consulting Manager at DeRosa Mangold Consulting.

About the Author: Liz Ortega emerged 7 years ago at DeRosa Mangold Consulting after relocating back to Texas from California. She has previously worked with a variety of distribution and service companies from shipping and receiving to accounting. As a former user of MAS 90 and other professional accounting technology, Liz became an adequate fit for our company and naturally progressed to the technical side of the trade. Liz prides herself on being someone who has a wide knowledge of the software packages she uses. Succeeding expectations with her ability to go above and beyond the norm to collaborate and guide those who require assistance. 

DeRosa Mangold Consulting are experts in Sage 100 and Acumatica ERP Software as well as BizNet Business Intelligence Software. We are committed to providing timely, exceptional support services to give you and your business the tools for success. We have many locations in Texas to serve you that include Waco, Austin, and San Antonio. We are also proud to serve clients located in California, Louisiana, Arkansas, Colorado, Georgia and New York.  

For more information contact us HERE

 

 

 

 

Your Reporting Dreams Answered!

Posted by on Comments (0)

Do you struggle to get all of the data you need from Sage 100 into one report? 

Do you need a customized way to analyze your data across various modules, companies, or other data sources? 

In this 7 part blog, I’ll be introducing you to BizInsight Desktop Edition.  If you can get your data into Excel, you can report on it.  BizInsight Desktop Edition allows you to build “SuperFunctions” that will calculate any data you have in Excel.  With this user friendly tool, I have been able to build stunning and accurate reports with data from Purchase Order, Sales Order, Inventory, and other modules.

 

The videos in this blog series are very brief, and will give you a quick look at how powerful this tool really is.  The best part is that if you already own BizInsight, you have free access to BizInsight Desktop Edition.

 

Take a breather, watch this introduction video (59 seconds long), and get excited about the possibilities that BizInsight Desktop Edition can provide you and your company!

Written By: Liz Ortega, Consulting Manager at DeRosa Mangold Consulting