{"title":"How to structure Microsoft Excel documents for systematic reviews.","authors":"Lea Godino","doi":"10.7748/nr.2023.e1866","DOIUrl":null,"url":null,"abstract":"<p><strong>Background: </strong>Systematic reviews are complex and involve time-consuming, deep research in the academic literature to search, extract data, assess their quality and report the results. Digital tools and software have been developed to simplify different phases of this process but some of these are not free to use. Microsoft Excel is typically accessible to a great many researchers free of charge, so using it involves no further costs.</p><p><strong>Aim: </strong>To explain how to use Microsoft Excel to create transparent and complete reports for systematic reviews.</p><p><strong>Discussion: </strong>The author's method includes six steps: downloading the references, preparing worksheets, removing any duplicate references, screening the references by title and abstract, screening the full text of references, and listing the articles for inclusion in the review.</p><p><strong>Conclusion: </strong>The Excel method is efficient and free and can produce transparent and complete reports of systematic reviews. It is a valid alternative to the systematic reviews produced by advanced tools and software.</p><p><strong>Implications for practice: </strong>The documents produced by this method are a good source for the direct production of scientific texts.</p>","PeriodicalId":47412,"journal":{"name":"Nurse Researcher","volume":"31 1","pages":"40-46"},"PeriodicalIF":1.0000,"publicationDate":"2023-03-08","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Nurse Researcher","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.7748/nr.2023.e1866","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"2023/3/1 0:00:00","PubModel":"Epub","JCR":"Q3","JCRName":"NURSING","Score":null,"Total":0}
引用次数: 1
Abstract
Background: Systematic reviews are complex and involve time-consuming, deep research in the academic literature to search, extract data, assess their quality and report the results. Digital tools and software have been developed to simplify different phases of this process but some of these are not free to use. Microsoft Excel is typically accessible to a great many researchers free of charge, so using it involves no further costs.
Aim: To explain how to use Microsoft Excel to create transparent and complete reports for systematic reviews.
Discussion: The author's method includes six steps: downloading the references, preparing worksheets, removing any duplicate references, screening the references by title and abstract, screening the full text of references, and listing the articles for inclusion in the review.
Conclusion: The Excel method is efficient and free and can produce transparent and complete reports of systematic reviews. It is a valid alternative to the systematic reviews produced by advanced tools and software.
Implications for practice: The documents produced by this method are a good source for the direct production of scientific texts.
背景:系统性综述非常复杂,需要耗费大量时间深入研究学术文献,以搜索、提取数据,评估其质量并报告结果。为了简化这一过程的各个阶段,人们开发了一些数字工具和软件,但其中有些工具和软件并不是免费使用的。许多研究人员通常都可以免费使用 Microsoft Excel,因此使用它无需额外费用。目的:解释如何使用 Microsoft Excel 为系统综述创建透明、完整的报告:作者的方法包括六个步骤:下载参考文献、准备工作表、删除重复的参考文献、按标题和摘要筛选参考文献、筛选参考文献全文、列出纳入综述的文章:Excel 方法高效、免费,可生成透明、完整的系统综述报告。结论:Excel 方法是一种高效、免费的方法,可以生成透明、完整的系统综述报告,是高级工具和软件生成的系统综述报告的有效替代方法:对实践的意义:该方法生成的文件是直接生成科学文本的良好来源。
期刊介绍:
Additionally, the website provides a range of Internet links to the latest research news, conference information, jobs and grants, and other resources. We hope that this site becomes an invaluable interactive resource for both novice and experienced researchers. If you have any comments or suggestions to improve the site, or details of additional websites that could be usefully added, please let us know. We very much welcome your ideas so that we can provide the kind of online resource that will best help you to develop your research.