University of Illinois Chicago
Browse

A Microsoft Excel Approach to Reduce Errors and Increase Efficiency in Systematic Searching

Download (1.3 MB)
preprint
posted on 2021-02-10, 17:52 authored by Amelia BrunskillAmelia Brunskill

Developing a search strategy for a systematic review is a time-consuming process in which small errors around the formatting and compilation of terms can have large consequences. Microsoft Excel was identified as a potentially useful software to streamline the process and reduce manual errors. Ultimately a spreadsheet was created that largely automates the process of creating a single-line search string with correctly formatted terms, Boolean operators and parentheses.

History

Publisher Statement

The final version of this paper is available online at: https://doi.org/10.1080/02763869.2020.1704598

Citation

Brunskill, A. (2020). A Microsoft Excel Approach to Reduce Errors and Increase Efficiency in Systematic Searching. Medical Reference Services Quarterly, 39(1), 15-26. doi: 10.1080/02763869.2020.1704598

Publisher

Taylor & Francis

Language

  • en

Usage metrics

    Exports

    RefWorks
    BibTeX
    Ref. manager
    Endnote
    DataCite
    NLM
    DC