Here\'s my entire playlist of Excel tutorials: http://bit.ly/tech4excel Learn many of the intermediate skills, tips, and tricks that you\'ll need in order to be able to use Excel effectively. This is the second of several video tutorials on Excel. Please consider watching my other video: The Beginner\'s Guide to Excel. In this intermediate video you\'ll learn some advanced formatting tools such as conditional formatting, how to save time by using the Autofill Handle, the basics of formulas and functions, sorting and filtering, and a few random useful tips such as Freeze Panes. Find my whole Excel playlist here: http://bit.ly/tech4excel Join this channel to get access to perks: https://www.youtube.com/channel/UCYUPLUCkMiUgiyVuluCc7tQ/join ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents Here\'s the practice file that goes with the video: http://bit.ly/intermexcel Click below for more information about some of the movies mentioned in this tutorial: Dirty Rotten Scoundrels: http://amzn.to/2xTpck1 The Princess Bride: http://amzn.to/2yk3tDc Ladyhawke: http://amzn.to/2xOhLsA Stardust: http://amzn.to/2yjJvs9 Young Sherlock Holmes: http://amzn.to/2xaJJNv Mystery Men: http://amzn.to/2yRmQ3r