Discuss the below:
You have been hired to analyze car sales for a company which owns 5 Toyota dealerships in different cities where they sell several models of Toyota. You have asked each dealer to send you monthly sales numbers by each model for the last 12 months in Excel Template you have provided. Explain the steps to consolidate and summarize the data to prepare a visual representation of the results so that they can be presented to the owners.