Excel 101: Tables, Formulas, Conditional Formats, Sort and Filter

2014-12-07

Here we take some weight lifting results from a PDF, get it into a workable Excel table, convert the data from kilograms to pounds, clean up some outliers, apply conditional formatting to visualize the stand-out results, sort the data and filter it to a range of interest to us.

A 13-minute walkthrough of the unglamorous core of data work: PDF to table, unit conversion, outlier cleanup, conditional formatting, sort and filter — direct link. Lifting data as the example, obviously.