When dealing with inconsistent data from multiple departments, the first step I would take is to perform a thorough data validation process. This involves checking for any discrepancies or anomalies in the data entries. I would use Google Sheets to apply data validation rules and conditional formatting to highlight any inconsistencies. Next, I would collaborate with the respective departments to understand the source of these inconsistencies and work together to correct them. It's crucial to maintain open communication to ensure everyone is aligned on data standards. I would also use pivot tables and charts to visualize the data, making it easier to spot trends and outliers. Finally, I would ensure that all data is securely stored and backed up, maintaining its confidentiality and integrity. This approach helps in preparing accurate and reliable MIS reports that support informed decision-making.