Basics 5: Paste Special Time to learn: 20 minutes The Paste Special function allows you to easily transfer data, formulas, formats or even perform mathematical operations just by using good old copy and paste! This aspect of Excel seldom gets much attention as most do not understand how it works.  That is going to change…