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

BizNetSoftware Blog

Art Simmons

Recent Posts

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~

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~

BizInsight Quick Tip: Complex Expression

Posted by Art Simmons |
November 30, 2015

BizInsight Tip: Use Complex Expression to accommodate unique account groupings and to return subtotals and totals.

Read More

Topics: Biz|Blog~

BizNet Software to Sponsor Intacct Advantage 2015!

Posted by Art Simmons |
November 02, 2015

BizNet Software is ready to attend Intacct Advantage 2015!

We will see you in sin city at Booth #709! Come see us and whats new with BizNet!

BizInsight for Intacct empowers users to easily access and analyze all of their data on demand. It combines all of the advantages of a cloud solution with the power and familiar of Excel for reporting. Our software includes a set of pre-built financial functions for Intacct data in Excel and also delivers BizNet's next-generation "Super Functions," which are created on-the-fly through an intuitive, menu-driven formula builder.

Read More

Topics: Biz|Blog~

Excel FAQ Check Figure

Posted by Art Simmons |
October 08, 2015

Excel Tip: Check Figure

Double check totals for accuracy using the Check Figure formula.
Check Figure formula can be inserted as a row below each total and easily hidden from view when the report is complete.

Read More

Topics: Biz|Blog~

Excel FAQ Cell Anchoring

Posted by Art Simmons |
October 07, 2015

Excel Tip: Cell Anchoring

Cell anchoring can be cycled by using the F4 key on your keyboard.
The levels of cell anchoring are as follows:

Read More

Topics: Biz|Blog~

Excel FAQ CONCATENATE

Posted by Art Simmons |
October 06, 2015

Tip: Excel Concatenate

Using the CONCATENATE function allows you to combine text from different cells into one cell.
For example, when setting up a report you can use the CONCATENATE function to dynamically display a report title or dates.
Update a hardcoded report date heading to a dynamic report date heading using CONCATENATION and cell referencing.

Read More

Topics: Biz|Blog~

BizInsight FAQ #NAME? error

Posted by Art Simmons |
October 05, 2015

Tip: BizInsight Error #NAME? error

Trick:
1. Verify the 'Offline' button is not clicked (highlighted).
[Deslect and right click within a cell, click BizNet Refresh.]

Read More

Topics: Biz|Blog~

Subscribe to Email Updates

Recent Posts

Posts by Topic

see all