Archive for September, 2014

Excel Tips: Get More Information from Excel’s Status Bar

It is easy to ignore the wealth of data that Office apps provide at a glance on the status bar. By default, Excel’s status bar displays the Average, Count, and Sum of the selected cells.  If you right-click on the status bar, a menu lets you customize the display. You can add, for example, the Minimum and Maximum of the currently selected items, or the “Numerical Count”—which means “the count of cells with numeric data,” as opposed to “Count,” which means “the count of cells that contain anything.”

Job Hunting Tip #19: Research the Company

How much do you know about the company that just contacted you to schedule an interview? It should be plenty, and all the information you need is available online.  Get the inside scoop on the company culture and use connections who can help you get an interview advantage.  Who you know at the company you are interviewing with really does matter.

Argus Limitation #1: Recovery Caps

ARGUS cannot calculate an annual cap any differently than a cumulative cap.  The calculations are always cumulative in ARGUS.

WORKAROUND: None.

Excel Tips: Display cell formulas and not results

If you want to see the cell in your worksheet display formulas rather than the results of those formulas then you can do it one of two ways.   Use the keyboard shortcut Ctrl + ~ to toggle formula display on and off.   You can also use Formulas |  Show Formulas.

Excel Tip: Data Validation

One guaranteed way to mess up a worksheet is to enter the wrong kind of data in a cell. For example, text instead of numbers, or a decimal instead of a whole number. Prevent yourself—or anyone else who uses your worksheets—from entering the wrong type of data by using Excel’s Data Validation feature. In a table, select the cells that should only contain one kind of data. On the Table Tools tab, click Data Validation and specify the kind of data that can go into the cells.