This session covers topics such as need for data integration, various data integration methods and how to integrate data in excel using vertical look up (VLookUp)function. Data Summarisation using pivot tables is demonstrated in excel. At the end of the session, participants will be able to identify and perform suitable data integration techniques to combine data from different sources into one dataset using excel.