Research Methodology - Merge data from multiple workbooks to a single spreadsheet in excel using power query

5.0 (5)

46 learners

What you'll learn

This course includes

18.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

Power Query Microsoft Excel Systematic Reviews Data analysis Systematic literature reviews Bibliometric

Full Transcript

Most often, researchers struggled to combine data from many sources in various workbooks into a single spreadsheet that could be utilised for bibliometrics and systematic literature reviews. In this video, I have outlined a straightforward technique for combining multiple workbooks into a single spreadsheet for bibliometrics and systematic review using the power Query option in Microsoft Excel.