Archive for February, 2015

Did you know? Argus Tips and Tricks

Did you know that one way to quickly identify Reference Accounts is to label them as “REF.”  For example, “Management Fee REF” could be used for an expense that you want to set up to pass through to a tenant but that is not actually expensed (perhaps the building Management Fee expense is 3% but a lease only allows you to pass through a maximum management fee of 2%).  This comes in handy when building Detailed Reimbursements to ensure you choose the correct line item to use in your method.

Excel Tips: Grouping vs Hiding Celling

Grouping rows and/or columns can be preferable to hiding them.   When rows or columns are grouped, Excel creates a small “+” button along with a header column or row with a little “1” and “2” header.   Clicking on these “+” buttons will quickly expand or contract the selection or header columns/rows.   Try it…it is pretty cool.

Excel Tips: Tracing Formulas

“Trace Dependents” and “Trace Precedents” are terrific ways to audit a large workbook.  We use these frequently when we inherit complicated spreadsheets from others.  These tools allow you to quickly view which cells and formulas in the entire workbook pull from the target cell in question.

Did you know? Argus Tips and Tricks

Did you know that to use shortcuts for accessing any of the drop down menus in Argus, you may click the “Alt” key and then the highlighted letter for each Menu (for example, “Alt + T” to access the “Tenant” dropdown menu).  Using the keyboard instead of your mouse will increase the speed at which you are able to complete any model.

Excel Tips: Quick Way to Format Cells

Did you know that you can hit Ctrl + 1 to create a quick short cut to the menu item of Format Cells.  From here you can change the Category, the Alignment, the Font, the Border, the Fill or the Protection on any given cell.