Ad Clicks : Ad Views :

Excel formulas and tutorials

Excel formulas and useful tools

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 create PDF print as

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
It is main inner container footer text