This month, Susan Harkins introduces an Excel user to advanced filtering and helps a PowerPoint user reduce his work when positioning pictures in PowerPoint.

Master Excel’s FILTER function to simplify data filtering, save time, and tackle complex datasets with ease. Learn advanced techniques now!

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.