Managing Data with Excel - Residents/Fellows (2024)

Resources

• Microsoft Excel - Link

  • One of best starting points, learning how to use Microsoft’s built in help functions

• Open Courseware - Link

  • Lab curated collection of open courseware for data in healthcare

• Statology, Excel - Link

  • Good review of tests, great section in "software tutorials" to explain how to conduct tests in Excel, Google Sheets, Python, R, etc

• Excel 2019 for Health Services Management Statistics, Pitt HSLS/ULS - Link

  • Stats focus (Sample size, Confidence Interval, t-Tests, ANOVA)

  • Downloadable PDF textbook with end of chapter practice problems/answers

• Data Carpentry (Data Org in Spreadsheets for Ecologists) - Link

  • Great series focuses on “spreadsheet” as concepts, not necessarily Excel

Why do an open resource for material?

• Versioning - Easier to keep up with updates for links and content

• Sharing - Open source education for a "bottom-up" approach to evolving course material and ensuring wide-spread opportunity for application (see the book or wiki summary of the book:"The Cathedral and the Bazaar")

Disclosures/Legal:

• The content is not endorsed nor represented by any group or institution. Every effort has been made to appropriate cite source material and respect relevant license.

• This material is available to others with a goal of Creative Commons (CC-BY-SA) in which:

  • This license enables reusers to distribute, remix, adapt, and build upon the material in any medium or format, so long as attribution is given to the creator. The license allows for commercial use. If you remix, adapt, or build upon the material, you must license the modified material under identical terms. CC BY-SA includes the following elements:

    • BY: credit must be given to the creator.

    • SA: Adaptations must be shared under the same terms.