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

WELCOME TO

Biznet Software Blog

Our dedicated team of self-proclaimed software geeks and creative nerds have come together in BizBlog to offer advice, how-to’s and insights into our products and beyond. Oh, and maybe some stuff about Excel.

Microsoft Excel Is The Systems "Integrator"

How often do you use Excel to consolidate and analyze data from more than one system?

BizNet Software is a Gold Sponsor for Acumatica Summit

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...

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

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

BizInsight is now Office 2016 Compatible!

BizInsight 5.0 is now compatible with Microsoft Office 2016!

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

Let's Take A Whole-New Look

Excel’s custom view functionality lets you save a combination of display settings and then call that view by name. This is...

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

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...

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

Here's How to Do It!

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

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

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

Excel Tip & Trick: Named Range

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

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

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

A previous video showed you how to create a dynamic data validation list in native...

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

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

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

Excel Tip & Trick: Leading Zero

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...

BizInsight Tip & Trick: DrillDowns

BizInsight Tip & Trick: DrillDowns

DrillDown on a Specific Cell

BizInsight provides the ability to drill down to view the detail of the data being...

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

Data Validation Made Easy

Excel’s Data Validation, often called a drop-down list, is an essential tool when you need to make the functions in a worksheet...

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

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...

4 Excel Tips You Wish You Knew About Sooner

4 Excel Tips You Wish You Knew About Sooner

 

Excel Tip & Trick: DIV/0 Error

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...

Excel Tip & Trick: Data Validation

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...

Post navigation