Become a Pro in Excel - Paste Special Option
In this video I have focused on excel paste special options.
Now, we all must be using excel in our day to day life and for sure we will be using copy paste options, but in this video we get to learn in detail about various different types of pasting options. This video is not just made to show the paste options, but also to help you use these options wisely with the help of shortcuts so that you can derieve at your results quickly and accurately.
The below are the points covered in this video:
1. Regular Copy Paste
2. Paste Values using Paste special option
3. Paste only Formulas using Paste special option
4. Paste only Formats using Paste special option
5. Paste Comments using Paste special option
6. Paste validation using Paste special option
7. Multiplying & Adding values using Paste special option
8. Transpose using Paste special option
If you practice daily using the shortcuts explained in this video, you would definitly reach the pro level.