## 7 Ways to Open Multiple Instances of Excel

This post describes how to open a new instance of Excel. When working with multiple workbooks in Excel, you may sometimes experience issues. During a …

## 2 Awesome Tips on How to Use the SWITCH Function in Excel

The SWITCH Function is one of Excel’s logical functions that can function as an alternative to the conditional if-statements. Many excel users use if-statements to …

There are times when you want a set of cells to reference a parameter. For example, you’re budgeting and the result needs to be dynamic. …

## SUMPRODUCT with Multiple OR Criteria – Part 2/2

In previous post you learned how to combine AND and OR criteria for SUMPRODUCT. The approach results in a long and difficult to maintain formula. …

## SUMPRODUCT with Multiple OR Criteria – Part 1/2

Previous posts (here and here) introduced you to filtering with SUMPRODUCT. It shows that SUMPRODUCT is a very powerful formula for filtering several AND criteria …

## An Intro to Cube Functions for Power Pivot in Excel

In an earlier post I wrote about the advantages of using the Data Model in Power Pivot. Not only does it save you time by …

## How to Use the Data Model in Excel

Excel can analyze data from many sources. But are you using the Data Model to make your life easier? In this post you learn how …

## How to Use SUMPRODUCT With Multiple AND Criteria

There are situations where several criteria are required to add up the right numbers. That’s straightforward if the numbers are found in a single column …

## Beginners Guide: How to Use the SUMPRODUCT Function in Excel

SUMPRODUCT is a multi-purpose formula. In essence, it multiplies arrays and returns the sum of those products. It is different from most Array formulas in …

## How to ROUND a Number to the Nearest 1000

Financial reports can sometimes be very messy to look at. Whereas consumers want to understand the big picture, sometimes the numbers are so detailed, they …