Ad Clicks :Ad Views :

    Excel formulas and tutorials

    Excel formulas and useful tools

    img
    Work with excel as efficient as you can using keyboard shortcuts instead of clicking the mouse. If you take one hand from the keyboard to click the mouse you loose precious time and energy. All you need to know is key shortcuts that do certain action you used to do with the mouse. Excel useful […]
    img

    SUMIFS across multiple sheets

    By
    |
    In Formulas
    |
    On February 28, 2018
    First you have to define a SheetList range name (the range of sheet names being the sources of SUMIFS). You can input the name of the sheets in a separate sheet of your excel file. Select all the cells containing this sheet names, then go to the name box field (the upper left field where […]

    VBA macro print as PDF

    By
    |
    On February 22, 2018

    A very helpful VBA macro that turns any printable excel document into a PDF file. Convert excel to pdf or save excel to pdf Sub savepdf() mo= Month(Date) d = Day(Date) y = Year(Date) h = Hour(Now) m =

    img

    RGB color map

    By
    |
    In Colors
    |
    On February 14, 2018
    Using colors in excel and VBA is very simple. The most used function is RGB(x, y, z). Where x is the variable for red color, y is for green and z is for blue. All variables can have values from 0 to 255, where 0 is no color and 255 is the maximum level for […]
    1 2 5
    This div height required for the sticky sidebar