featured article
Open Excel files in Separate Instances or Multiple Windows
Latest articles
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 … Read more
Advanced Hack: Add References to Cells in Bulk
There are times when you want a set of cells to reference a parameter. … Read more
SUMPRODUCT with Multiple OR Criteria – Part 2/2
In previous post you learned how to combine AND and OR criteria for SUMPRODUCT. … Read more
SUMPRODUCT with Multiple OR Criteria – Part 1/2
YOu can use SUMPRODUCT with multiple or criteria for powerful filtering. Previous posts (here … Read more
An Intro to Cube Functions for Power Pivot in Excel
In an earlier post I wrote about the advantages of using the Data Model … Read more
How to Use the Data Model in Excel
Excel can analyze data from many sources. But are you using the Data Model … Read more
How to Use SUMPRODUCT With Multiple AND Criteria
Using SUMPRODUCT with multiple AND criteria is can be very powerful. There are situations … Read more
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 … Read more
How to ROUND to Nearest 1000 in Excel
Financial reports can sometimes be very messy to look at. Whereas consumers want to … Read more
Receive the latest article in your mailbox