Raw data only look like garbage. When we try to put in graphs and charts then it looks awesome. It is then helpful in problem-solving and setting the right direction. We use multiple methods in Excel for data analysis. I have command over Vlookup and Pivot table in Ms. Excel and can convert summaries into charts and pdf. Moreover, I can convert Pdf to excel as well.