MICROSOFT EXCEL

Course Competency

  • Use spreadsheet software to summarize and report healthcare data.

Learning Objectives

Introduction to Excel

  • Describe how to navigate worksheets and select cells.
  • Discuss the steps involved with adding and revising content in cells.
  • Explain how to modify cells, rows, and columns.

Formatting in Excel

  • Describe how to format cells, including formatting numbers and text, adjusting text alignment and orientation, and adding borders.
  • Discuss how to work with multiple worksheets within a workbook.
  • Describe how to print an active spreadsheet.

Excel Formulas, Functions, and Tables

  • Describe how to create a formula.
  • Explain the difference between relative reference and absolute reference.
  • Discuss how to insert a function in a worksheet.
  • Discuss alternative options for viewing a worksheet.
  • Describe how to sort and filter data.
  • Describe how to create and modify a table and chart.

License

Icon for the Creative Commons Attribution 4.0 International License

Using Computers in Healthcare Copyright © 2024 by WisTech Open is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.