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 WORKDAY & NETWORKDAYS Functions: Exclude Weekends and Holidays

Excel's workday function is great when you need to calculate an end date based on a given number of working days - which means you need to exclude weekends and holidays. Some examples are: creating a project timeline creating a reporting timetable Excel's standard

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 Arrays: Count Unique Items with MMULT, INDIRECT & ROW Functions (Part 3/3)

You'll learn a few methods to replace the TRANSPOSE function In Part 3, I show you how you can use the INDIRECT, ROW, ADDRESS and later INDEX functions to avoid the use of TRANSPOSE which requires CSE Make sure you watch PART 1 and

Excel Arrays: Count Unique Items with MMULT Function (Part 2/3)

You'll learn all about the Amazing MMULT Function in this Lecture! In Part 2 we will create an Excel Array Formula using SUMPRODUCT and MMULT. In this lecture I will show you how you can use Excel's Matrix Multiplication formula, MMULT function to solve

8 Formulas to get Unique Count Across Rows in Excel (Part 1/3)

You'll learn 3 of them in this video! Learn Excel Array formulas by going through the example While I solve this problem, I also explain how array formulas work in Excel. They can be difficult to get the hang of. This video shows you how

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.

Easiest Waterfall Chart in Excel From Scratch (works with negative cumulative values)

Watch the video to learn how to create a Waterfall or Bridge Chart in Excel. From Scratch! It uses simple but unusual techniques to quickly and easily get a Waterfall Chart that also works with negative cumulative values. If you prefer to read instead of watching,

Why you Need This Feature Before Distributing Your Excel Files

In most cases when you start to work at a new company, you take over the existing Excel workbooks of your predecessor and continue to update and expand on these. Normally, these Excel files are quite large and contain many tabs and it’s not