Ad Clicks :Ad Views :

    Excel formulas and tutorials

    Excel formulas and useful tools

    img

    Excel countif formula

    By
    |
    In Data analysis
    |
    On September 11, 2014
    Whenever you need to count the elements inside data series the excel countif formula is available to help you reach your target easy and fast. The Countif formula has the following structure: =COUNTIF(Range,Condition) Note that the Range can be a large table not only one column. Examples of Excel Countif Formula Let’s say we need […]
    img
    Comboboxes are user friendly data input forms that can make the difference between a quality looking form and a archaic data input screen. Defining combobox in Excel For this step you must go to the Excel Developer menu, make sure you have this menu since it doesn’t come activated in Excel Options. Select the Insert […]
    img

    Making Excel file unsavable

    By
    |
    In VBA
    |
    On May 8, 2014
    Some companies use Excel files through intranet networks for all their staff to have access to certain information and automated reports. This usually means that this kind of file should be unsavable by the staff in order to preserve a certain degree of accuracy and format. Making Excel file unsavable Without altering the menu of […]
    This div height required for the sticky sidebar