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

BizNetSoftware 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

Get Your Motor Runnin' - BizInsight for MAM Autopart

Posted by Floyd Stanley |
May 17, 2016

BizNet Software – connecting your world to Excel with BizInsight for MAM Autopart, the reporting and analysis solution that directly integrates Autopart data with Excel on the desktop.

Read More

Topics: BizNet Software, Biz|Blog~, Excel Analytics, Excel Help, Excel reporting, MAM Autopart, MAM Software

BizInsight Tip: Basic Reporting 102 - Data Validation Lists for Segmented Reporting

Posted by Art Simmons |
May 11, 2016

BizInsight Tip for Basic Reporting 102 - Data validation lists for segmented reporting

Read More

Topics: Biz|Blog~

Excel Tip: Zero Row Suppression

Posted by Art Simmons |
May 10, 2016

Excel Tip: Zero Row Suppression

Add an Excel formula 'Zero Row Suppression' to show rows with zero values.
Combine the Zero Row Suppression formula with an Excel filter to filter rows with data and without

Read More

Topics: biznet, Biz|Blog~, Excel reporting, excel tips, zero row suppression

Visit BizNet at SYSPRO Simply Smarter 2016, May 22-25 in Anaheim

Posted by Floyd Stanley |
May 06, 2016

Visit BizNet at SYSPRO Simply Smarter 2016, May 22-25 in Anaheim, and make sure to register for one of our two speaking sessions https://simplysmarter.us/.  BizNet will be at Table 19, so please stop by and say hello.

Read More

Topics: BizInsight, Biz|Blog~, Data Analysis, Excel business reporting, Excel Help, SYSPRO

Friday Funny - Spreadsheet Sarcasm

Posted by Art Simmons |
May 06, 2016

Read More

Topics: Biz|Blog~

BizNet Software Joins Aplicor’s Growth Partner Network®

Posted by Art Simmons |
May 05, 2016

BizNet Software, the market leader for Microsoft Excel® in memory business reporting and analytics, today announced that the company has joined the Aplicor Growth Partner Network®. With this partnership, BizNet Software joins a network of companies providing applications and solutions that extend Aplicor product functionality in new ways.

Read More

Topics: Aplicor, aplicor reporting, biznet, BizNet Software, Excel reporting, Biz|Press~

Subscribe to Email Updates

Recent Posts

Posts by Topic

see all