7 Ways to Open Multiple Instances of Excel
When you work with multiple workbooks in Excel, you may sometimes experience issues. During a resource intensive task in one spreadsheet, other spreadsheets within the …
Excel
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 …
Read more2 Awesome Tips on How to Use the SWITCH Function in Excel
Advanced Hack: Add References to Cells in Bulk
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 …
Read moreAn Intro to Cube Functions for Power Pivot in Excel
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 …
Read moreBeginners Guide: How to Use the SUMPRODUCT Function in Excel
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 …
