Jon Peltier

Use Power Query to Manipulate Your Data

Power Query (Get & Transform) is a powerful yet easy technique for manipulating data in Excel. This example shows how to prepare data for a box plot. The post Use Power Query to Manipulate Your...

continue reading...

Dynamic Arrays, XLOOKUP, LET – New Excel Features

In this tutorial, learn new Office 365 features to help prepare data for charting. Dynamic Arrays, XLOOKUP, and the new LET function make data manipulation easy. The post Dynamic Arrays, XLOOKUP,...

continue reading...