• Twitter
  • Google+
  • Pinterest
  • RSS
Excel Unplugged

Monthly Archives: April 2020

Extract Columns that Contain Actual Values
April 28, 2020

We often work with large datasets containing multiple columns, but only need a few. In this tutorial we’ll show how to extract the columns that contain Actual ...

Transforming a Table to Top 10 (by values) and Others with Power Query
April 14, 2020

How to get the top 10 values in a table, and an aggregate for all the other data? Our goal today is to turn a table of countries with attributes into a table of ten ...