<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

4 Excel Tips You Wish You Knew About Sooner

Posted by Art Simmons |
June 15, 2016

4 Excel Tips You Wish You Knew About Sooner

 

Read More

Topics: Biz|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

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~

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

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

Friday Funny - Spreadsheet Sarcasm

Posted by Art Simmons |
May 06, 2016

Read More

Topics: Biz|Blog~

Subscribe to Email Updates

Recent Posts

Posts by Topic

see all