ExcelProject

This Repository are dataset that were cleaned and visualized using excel. Excel formulas of trim and clean were used to remove unprintable characters, vlookups where used to expand and make dataset very comprehensible. Both dataset were converted into tables, datatypes were appropriated and dates were customised to capture the whole transaction year for easy calculation. Data model were created amongst sheet to establish relationship by the use of datakey. Pivot tables were created to summarise dataset Chart visuals were selected based on the pivot tables create to give apt pictorial view of the sales activity for the year.