|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-fundamentals-for-healthcare/
课程评论：没有评论
课程名称：医疗保健Excel基础 课程概述：欢迎参加医疗保健Excel基础课程！本课程旨在提升您在医疗保健领域的工作能力，帮助您使用Excel分析电子病历（EMR）或电子健康记录（EHR）中的数据。同时，本课程还将教您如何利用Excel进行项目管理。课程内容提供Excel基本知识的扎实基础，并介绍一些强大的高级Excel功能，以深入解析您的医疗保健组织的数据。该课程最适合在医疗保健领域工作的学习者，无论是完全没有使用过Excel，还是已有基础但希望熟悉更多功能并增强实际应用信心的学员。 本课程特别不冗长，不会深入讲解每一个Excel功能或那些在日常使用中不太常见的功能，而是专注于简明扼要地教授在医疗保健工作中最重要和高影响力的Excel功能和技巧。本课程是Udemy上首个以真实的EMR数据进行教学的课程！课程使用的模拟EMR数据集包含1000行数据，两个选项卡代表两个可能来自EMR系统的样本报告，让您可以练习处理与您组织相似的数据。 课程分为以下几个部分： 1. Excel基础：从零开始学习，包括格式设置、公式和函数基础，以及在我作为医疗项目经理和数据分析师时近乎每日使用的最实用和简单的公式。 2. 高级功能：深入探讨解锁数据分析能力的更多高级功能，学习如何有效使用MATCH函数比较两个数据集，如何在下一次演示中利用可视化吸引观众等。 3. 整合 - 数据分析：利用数据集实时展示如何应用所学进行数据分析，获取新见解，同时创建图表以可视化数据。 4. 整合 - 项目管理：在最后一部分，我们将从一个空的Excel文件开始，运用所学的知识创建一个美观的项目管理工具，以确保您下一个项目的顺利推进。
Welcome to Excel Fundamentals for Healthcare!This course was created to improve your ability to work in health care and use Excel to analyze data from your EMR or EHR. It is also designed to show you how to use Excel to manage projects.It is intended to give you a solid foundation of the basics of Excel, while also introducing you to advanced Excel functions that are powerful for providing in-depth insights into your healthcare organization's data. This course is best for learners who work in health care and have either never used Excel before or have used it, but would like to become more familiar with its features and gain confidence applying it to real-life scenarios.This course purposely DOES NOT last hours and hours, teaching every single function Excel has or going in-depth into functions you would be unlikely to encounter on a regular basis.It DOES focus on being concise and teaching the most important, high-impact Excel functions and techniques YOU NEED for your health care job.This is the only course on Udemy to teach from simulated, realistic EMR data!The simulated EMR data set used in this course contains 1000 rows, with two tabs representing two different sample reports that might come out of an EMR system, so you get practice working with data that will look very similar to your organization's.This course is divided into the following sections:Excel fundamentals: Here, we'll start from zero and go through formatting, the basics of formulas and functions, and some of the most useful yet simple formulas in Excel that I used on a near-daily basis in my role as a healthcare project manager and data analyst.Advanced functions: Now the fun begins as we delve into more advanced functions that unlock your ability to really delve into the data. Learn how to effectively use the MATCH function to compare two data sets, how to use visuals to win over your audience at the next presentation, and more!Putting it all together - Data Analysis: In this section, I'll use our data sets so you can see, in realtime, how to use what you've just learned for data analysis to gain new insights into over 1000 rows of data! We'll also create charts to visualize the data.Putting it all together - Project Management: Finally, we'll start with a blank Excel file and use what we've learned to create a beautiful project management tool so you can keep your next initiative on track!
