<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=371557583225568&amp;ev=PageView&amp;noscript=1">

BizNetSoftware Blog

Top 4 Problems with Excel Reporting and How to Fix Them

Posted by Art Simmons |
June 13, 2016

 Top 4 Problems with Excel Reporting - and How to Fix Them

Working with your data can be challenging, but working with your data in Microsoft Excel can be even more of a struggle!  

Read More

Topics: BizInsight, biznet, Biz|Blog~, connecting to data, Excel reporting, problems with excel reporting, top 4, webinar

BizInsight for SYSPRO

Posted by Floyd Stanley |
June 10, 2016

Read More

Topics: BizInsight, Biz|Blog~, Excel Analytics, Excel reporting, SYSPRO

Top 5 Factors to Consider in a Reporting Solution

Posted by Floyd Stanley |
June 03, 2016

Data is coming at you faster and from more sources than ever before.  Is your reporting solution up to the job?  Find out by watching the informational webinar, "Top 5 Factors to Consider in a Reporting Solution."

Read More

Topics: Biz|Blog~

How to Use Excel More Effectively - Create a "Live" Transposed Copy of a Table

Posted by Art Simmons |
June 02, 2016

Create a "Live" Transposed Copy of a Table

 

Read More

Topics: Biz|Blog~

BizInsight Tip: Data Range Properties

Posted by Art Simmons |
May 31, 2016

BizInsight Tip: Data Range Properties

Making Analysis Sets preserve column changes and Fill down formulas upon refresh

Sometimes an analysis set that contains the values you want to use in your report contains more columns than you want to display. To preserve changes made to the Analysis follow the steps below.

  • Right-click on the list and choose Data Range Properties

 

Read More

Topics: Biz|Blog~

Use Power Query To Consolidate Data From Two Excel Workbooks

Posted by Art Simmons |
May 23, 2016

Use Power Query To Consolidate Data From Two Excel Workbooks

Excel is one of the most widely used software programs in the world – and with good reason. It is a powerful tool for handling large amounts of data, and it’s so flexible that you can use it for almost any type of reporting and calculation.

Read More

Topics: Biz|Blog~

Create More Powerful Queries in Microsoft Excel

Posted by Floyd Stanley |
May 20, 2016

Want to create more powerful queries in Microsoft Excel?  Well, Microsoft does offer a couple of free add-ins for that purpose – Power Query, built into Excel 2016 as “Get and Transform,” and Power Pivot.  Then there’s the free Power BI Desktop download, which makes a lot of data mining tools look like picks and shovels by comparison.

Read More

Topics: Biz|Blog~

Excelapalooza Early Bird Rate Ends in 12 Days!

Posted by Art Simmons |
May 18, 2016

Read More

Topics: Biz|Blog~

BizInsight Tips & Tricks - Using The Expression Editor

Posted by Art Simmons |
May 17, 2016

http://www.youtube.com/watch?v=PeOfnOrBY8s&feature=youtu.be

Read More

Topics: bizinsight tip, BizNet Software, Biz|Blog~, excel tip, expression editor, video tutorial

The Cloud Comes to Excel With BizInsight for Aplicor

Posted by Floyd Stanley |
May 17, 2016

The cloud comes to Excel with BizInsight for Aplicor, the reporting and analysis solution that directly integrates Aplicor cloud data with Excel on the desktop.

Read More

Topics: Aplicor, BizInsight, BizNet Software, Biz|Blog~, Cloud, Excel Analytics, Excel reporting, Microsoft Excel

Subscribe to Email Updates

Recent Posts

Posts by Topic

see all