July 4, 2024 Rick de Groot Power Query 37 IF Statements in Power Query M (Incl Nested IFs, OR, AND) In this article, we delve into the capabilities of the IF ... Read more
November 17, 2023 Rick de Groot Excel 40 Open Excel files in Separate Instances or Multiple Windows This post describes how to open Excel files in separate instances. ... Read more
November 17, 2023 Rick de Groot Excel 7 2 Awesome Tips on How to Use the SWITCH Function in Excel The SWITCH Function is one of Excel’s logical functions that can ... Read more
November 17, 2023 Rick de Groot Power Query 10 4 Ways to SUM Null Values in Power Query M Trying to sum columns with null values in Power Query but ... Read more
November 17, 2023 Rick de Groot Power BI 6 Showing Negative Numbers Between Parentheses in Power BI Formatting is key in financial reporting. It helps users consume the ... Read more
October 3, 2023 Rick de Groot Excel 2 Advanced Hack: Add References to Cells in Bulk There are times when you want a set of cells to ... Read more
August 2, 2024 Rick de Groot Excel 7 Using SUMPRODUCT with Multiple OR Criteria in Excel (2/2) In previous post you learned how to combine AND and OR ... Read more
November 17, 2023 Rick de Groot Excel 6 How to use SUMPRODUCT with Multiple OR Criteria (1/2) You can use SUMPRODUCT with multiple or criteria for powerful filtering. ... Read more
November 17, 2023 Rick de Groot Excel 11 An Intro to Cube Functions for Power Pivot in Excel In an earlier post, I wrote about the advantages of using ... Read more
October 3, 2023 Rick de Groot Power Query 10 Change Column Type By Position in Power Query Introduction As a Power Query beginner, it is comfortable to use ... Read more
January 10, 2023 Rick de Groot Power Query 13 Fix XLSB File Errors in Power Query A XLSB File error can come to you by surprise. Recently ... Read more
November 17, 2023 Rick de Groot Power Query 6 Define Data Type While Creating Custom Column in Power Query In this post, you learn how to define a Data Type ... Read more
