Ad Clicks :Ad Views :

    Excel formulas and tutorials

    Excel formulas and useful tools

    img
    Does NFC icon appear on the screen of your smartphone, or are you reading the specifications of some electronic device and you do not know what is NFC and what does it mean? In few words, the abbreviation comes from Near Field Communication and is a type of RFID technology (Radio Frequency Identification). What does […]

    Run macro on open file event

    By
    |
    On October 14, 2016

    In order to run macro on open file event you need to have the VBA code (macro) inside the Workbook_Open() event in ThisWorkbook element on Project Explorer. You must first open the VBA editor in Excel

    img

    Excel VBA Macro

    By
    |
    In VBA
    |
    On October 12, 2016
    This is a tutorial for anyone wanting to learn how to write their first excel vba macro. These macros are very useful when we need to do a lot of manual work on large data tables and these manual actions can be automated by using a macro to execute every operation that we usually did […]
    img
    Adding amounts greater than zero or another given value in Excel is sometimes required and can be acquired by using the SUMIF or SUMIFS formulas. The formula for adding amounts greater than a given value =SUMIFS(sum range, sum range, “>0”) You can replace 0 with the value you need. The condition inside the formula can […]
    This div height required for the sticky sidebar