November 23, 2023 Rick de Groot Excel 21 The Data Model in Excel: What It Is And Why It’s Useful Excel can analyze data from many sources. But are you using ... Read more
October 3, 2023 Rick de Groot Power Query 2 Split Column by Carriage Return in Power Query Scraping content from the web is getting easier and easier. Sometimes, ... Read more
August 2, 2024 Rick de Groot Excel 22 How to Use SUMPRODUCT With Multiple AND Criteria in Excel Using SUMPRODUCT with multiple AND criteria is can be very powerful. ... Read more
November 17, 2023 Rick de Groot Power Query 17 Creating a Crossjoin (All Combinations) in Power Query This post shows how to perform a cross join between tables ... Read more
December 22, 2023 Rick de Groot Power Query 0 2 Ways to Rank With Ties Using Power Query Recently I worked on a challenge from Ken Puls, where I ... Read more
October 3, 2023 Rick de Groot Power Query 7 Transform Stacked Column into a Table with Power Query Data comes in countless ways and forms. Sometimes structured, with an ... Read more
October 3, 2023 Rick de Groot Power Query 19 How to Group By Maximum Value using Table.Max – Power Query In an earlier article, I showed a basic example of how ... Read more
October 3, 2023 Rick de Groot Power Query 3 Grouping or Summarizing Rows in Power Query Grouping rows in Power Query can help show your data in ... Read more
November 17, 2023 Rick de Groot Power Query 16 Import Multiple Files from a Folder with Power Query In this post, you will learn how to import files from ... Read more
November 17, 2023 Rick de Groot Excel 9 How to Use the SUMPRODUCT Function in Excel (Step-by-Step) SUMPRODUCT is a multi-purpose formula. In essence, it multiplies arrays and ... Read more
November 17, 2023 Rick de Groot Excel 0 How to ROUND to Nearest 1000 in Excel Financial reports can sometimes be very messy to look at. Whereas ... Read more
