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

BizNetSoftware Blog

MR not meeting your needs for a FRx Replacement? Discover the BizNet Excel Suite. Presented by Integrated Business Group

Posted by Art Simmons |
April 09, 2014

Meet the most innovative and intuitive FRx Replacement. An Excel reporting and budgeting solution pre-built for Microsoft Dynamics.

Read More

Topics: Biz|Blog~

How to Use Excel More Effectively Series #5 - Create a "Live" Transposed Copy of a Table

Posted by Art Simmons |
April 08, 2014

How to Use Excel More Effectively

Create a "Live" Transposed Copy of a Table

How to transpose rows and columns, part II. Let's say you want to see the same table in two parts of your worksheet, with one of them a transposed version of the other, and with any data that you change in the first version instantly changed in the other. This takes a bit of forethought, but it's easy when you get the idea. Select a table; count its rows and columns--for example, if the table is at A1:H11, then it has 11 rows and 8 columns. Select a blank region of your worksheet with the dimensions transposed--in this example, 8 rows and 11 columns. In the upper-left cell enter the formula =(TRANSPOSE(A1:H11), but with the addresses of your actual table. Press Ctrl-Shift-Enter, which is the little-known Excel keystroke that creates an array formula. Excel will put curly braces around the formula to indicate that it's an array formula. Any change you make in the original table will also appear in the transposed version, but you can't make changes directly to the transposed version.

Read More

Topics: Biz|Blog~

Deltek Vision Users - Get to know BizNet Software before Vision LFUG

Posted by Art Simmons |
April 02, 2014

BizNet Software will be attending

Vision LFUG in Austin 4/21/ - 4/23.

Attend our Speaking Session Wednesday, April 23rd at 1:15pm

 

Read More

Topics: Biz|Blog~

Excel-lent April Fool's Pranks for the Spreadsheet Jockeys in Your Life

Posted by Art Simmons |
April 01, 2014

Excel-lent April Fool's Pranks

Let's see how you can April fool's prank your coworkers by making subtle changes to their Excel settings.  No, you're not wasting company time, you're testing your colleague's Excel skills.

Read More

Topics: Biz|Blog~

Subscribe to Email Updates

Recent Posts

Posts by Topic

see all