Another thing it does is give you access to lots of capabilities and functionalities. In this post you will learn the basics of how to write a VBA Macro in Excel. Also read: How to Insert a Trendline ...

If you are unfamiliar with working with VBA, here is the short version of how to make use of this: Open your worksheet in Excel. ALT-F11 (opens the VBA coding window) ...