October 17, 2018 - In this video, we learn about removing duplicates, building a SUMIF, and creating a chart. Because it's full of shortcuts, you may also pick up on how to create a copy of a sheet without a lot of extra steps, and you'll now know how to select all the data in a range without having to highlight and drag. We hope you picked up a trick or two on Autofill and its options.