How do I do data analysis in Excel? How to use Excel for Data analysis:- Performing data analysis in Excel…