How do i analyze data in Excel?

How do I analyze the data in Excel as there are lot of blank fields. What is the best way to perform data analysis in Excel ? Any ideas or suggestions ?

@ssinha1966, this is something outside the KoboToolbox topic. But my advice here would be maybe assigning a system missing value for it (like using the 99 or 9 value in it).

Maybe our community should have more handy workarounds for this.