advanced excel

Lookup on Pictures

Dynamic Picture Lookup in Excel Just 5 easy steps - No VBA How can you lookup different pictures based on the value of a cell? Just to give you a heads up. This is a VBA-free tutorial! We saw the dynamic picture

Excel INDIRECT Function

Lookup Values in Different Sheets / Excel Tabs Excel INDIRECT Function The INDIRECT() function comes very handy when need to feed different ranges to certain formulas. It is most useful when you want to refer to tables that are found in different

Excel OFFSET Function for Dynamic Calculations

Do you want to create formulas that "move" with your raw data set? That's when you need to use Excel's OFFSET function. OFFSET is a great formula whenever you have dynamic ranges involved. Some examples are: Calculating the average of the last three months when

Master Excel’s SUMPRODUCT Formula

Are you currently using the SUMPRODUCT formula in your Excel files? I wouldn't be surprised if you say "No". Many know of it, but hesitate to use it. Or they don't think it's the right formula for the task at hand. Chances are it is.