We shall learn how to record macros in excel the vba environment recording macros data filter charting and userforms. Microsoft excel 2010 2013 2016…