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

BizNetSoftware Blog

Microsoft Excel Is The Systems "Integrator"

Posted by Floyd Stanley |
January 29, 2016
How often do you use Excel to consolidate and analyze data from more than one system?
Read More

Topics: Big Data in Excel, Biz|Blog~, Business Reporting, Data Consolidation, Excel Data in Cloud, Microsoft Excel

BizNet Software is a Gold Sponsor for Acumatica Summit

Posted by Art Simmons |
January 29, 2016

BizNet Software will be in Orlando next week for the Acumatica Summit! 

Stop by table #13 to get a one-on-one demo of the true cloud Excel powered software, BizInsight.

Read More

Topics: Biz|Blog~

Mindover Software Joins BizNet Software Partner Network to Bring Easy Financial Reporting to Sage and Acumatica Users

Posted by Art Simmons |
January 28, 2016

Mindover Software Joins BizNet Software Partner Network to Bring Easy Financial Reporting to Sage and Acumatica Users

Read More

Topics: Biz|Blog~

BizInsight is now Office 2016 Compatible!

Posted by Art Simmons |
January 27, 2016

BizInsight 5.0 is now compatible with Microsoft Office 2016!

Read More

Topics: Biz|Blog~

Excel Tips and Tricks Powered by BizBroadcast: A Whole New View on Custom Reports

Posted by Floyd Stanley |
January 25, 2016

Excel’s custom view functionality lets you save a combination of display settings and then call that view by name. This is handy for when you need to hide sensitive information, or when you want to show only a subset of data in a worksheet - like flagging which deals don't meet margin requirements.  It's even better with BizBroadcast, because those views can be sent again and again with no additional setup.

Read More

Topics: Biz|Blog~

Excel Tips and Tricks Powered by BizInsight 7.0: Analyzing Multiple Data Sources In The Same Worksheet

Posted by Floyd Stanley |
January 25, 2016

Bringing data together from multiple systems is obviously a big deal – a simple Google search yields more than 4.7 million results about analyzing multiple data sources in Excel.

Read More

Topics: Biz|Blog~

Excel Tip & Trick: Named Range

Posted by Art Simmons |
January 19, 2016

Excel Tip & Trick: Named Range

Steps to create a Named Range:

A named range is a selection of cells that are highlighted and given a name in the name box

Read More

Topics: Biz|Blog~

Excel Tips-Tricks With BizInsight 7.0 - Data Validation Made Easy

Posted by Floyd Stanley |
January 15, 2016

Excel Tips-Tricks With BizInsight 7.0 - Data Validation Made Easy.

Read More

Topics: Biz|Blog~, Excel Tips-Tricks

Introducing BizNet Vision - BizNet Isn't Just for Financials Anymore!

Posted by Art Simmons |
January 14, 2016

Read More

Topics: Big Data in Excel, biznet vision, Biz|Blog~, Excel, Excel business reporting

Excel Tip & Trick: Leading Zero

Posted by Art Simmons |
January 13, 2016

Excel Tip & Trick: Leading Zero

When you import or copy/paste numbers codes  into a workbook, Excel interprets them as numbers and applies a general or number format to them. As a consequence, any leading zeros are removed. The following formula can be used along with cell anchoring to add the leading zeros back to the number. '=TEXT(H3,"#00")

Read More

Topics: Biz|Blog~

BizInsight Tip & Trick: DrillDowns

Posted by Art Simmons |
January 12, 2016

BizInsight Tip & Trick: DrillDowns

DrillDown on a Specific Cell

BizInsight provides the ability to drill down to view the detail of the data being returned by a function in either a list of a pivot format. DrillDown is available for all BizInsight User Types (Designer, Power, and DrillDown User). To drill down on a function, right click and select BizNet DrillDown on the right-click menu and select the desired drill down target.

Read More

Topics: Biz|Blog~

Excel Tips and Tricks: Here's How to Make Dynamic Data Validation Work for You

Posted by Floyd Stanley |
January 08, 2016

Excel’s Data Validation, often called a drop-down list, is an essential tool when you need to make the functions in a worksheet automatically reflect different parameters – like dates, locations, warehouses or sales people.

Read More

Topics: Biz|Blog~

4 Excel Tips You Wish You Knew About Sooner

Posted by Art Simmons |
January 08, 2016

4 Excel Tips You Wish You Knew About Sooner

 

Read More

Topics: Biz|Blog~, excel tip, excel tips, lifehack

Excel Tip & Trick: DIV/0 Error

Posted by Art Simmons |
January 07, 2016

Excel Tip & Trick of the Week: DIV/0 Error is used communally used for a percentage variance calculation to fill a zero or dash if the results is divided by zero. The IFERROR function will return a specified value if the operation returns an error like #DIV/0

Read More

Topics: Biz|Blog~

Excel Tip & Trick: Data Validation

Posted by Art Simmons |
January 04, 2016

Excel Tip & Trick: Data Validation

Steps to Create a Validation List:

Excel Tip of the Week; Data Validation is used to add data pick lists to your report design. For example, users can add a valid list of Fiscal Years and Periods for users to choose from. All formulas within the report can be anchored so the data will reflect the changes of years and periods.

Read More

Topics: Biz|Blog~

Subscribe to Email Updates

Recent Posts

Posts by Topic

see all