К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Excel Fundamentals for Healthcare · LearnSpace
Назад в каталог
courseraIT и технологии

Excel Fundamentals for Healthcare

Курс от Packt
Начальный≈ 5.7 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

This course features Coursera Coach! A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. Unlock the power of Excel in the healthcare industry with this comprehensive course that equips you with essential skills for managing healthcare data. Whether you're handling patient records, analyzing prescriptions, or managing healthcare projects, this course will provide the tools to help you work more efficiently and accurately. Learn key Excel functions and techniques that can transform complex data into actionable insights, enabling you to optimize decision-making in a healthcare setting. The course starts by covering the basics of Excel, including formatting, formulas, and rounding, which are crucial for anyone working with healthcare data. You'll also dive into specialized functions such as drop-down menus, pivot tables, and data filters, which will make your data easier to manage and more insightful. As the course progresses, you’ll apply your skills to real-world healthcare scenarios, such as analyzing prescriptions and creating project management tools. Throughout the course, you'll engage with interactive exercises and examples that apply directly to healthcare data, ensuring that each concept is both relevant and practical. The course is designed for healthcare professionals and others working in the field who need to leverage Excel to improve data handling and decision-making in their work. By the end of the course, you will be able to create advanced Excel tools tailored to healthcare data, including pivot tables, complex formulas, and project management tools. You will also gain the ability to clean and analyze healthcare data to reveal meaningful trends and insights.

Навыки, которые вы освоите

Spreadsheet SoftwareData CleansingHealthcare Project ManagementData ValidationData ManagementElectronic Medical RecordHealth Information ManagementData Analysis Software

Программа курса

5 модулей · 35 учебных материалов

01Introduction2 материалов

Introduction

IntroductionВидеоFull Course ResourcesЧтение
02The fundamentals17 материалов

The fundamentals

IntroductionВидеоFormatting

Учитесь у экспертов

Packt - Course Instructors

Преподаватель курса

Excel Fundamentals for Healthcare
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 5.7 ч

5 модулей

Язык: Английский

Субтитры: Арабский, Французский, Итальянский, Бразильский португальский, Корейский, Немецкий, Пушту, Испанский, Дари, Японский

Часть программы вашего университета
Видео
The basics of formulasВидео
RoundingВидео
Drop down menusВидео
Relative and Absolute ValuesВидео
FiltersВидео
Dummy variablesВидео
Pivot tablesВидео
Split text to columnsВидео
Remove duplicatesВидео
Counting functions (COUNTA, COUNTIF, etc.)Видео
Summing functions (SUM, SUMIF, SUMIFS)Видео
ConcatenationВидео
More ConcatenationВидео
Understanding Excel Cells, Formulas, and FunctionsDIALOGUE
The fundamentals - AssessmentЗадание
03Advanced Excel Functions7 материалов

Advanced Excel Functions

COUNT and SUM based on a partial text matchВидеоConverting a date to a weekdayВидеоThe MATCH functionВидеоVisualsВидеоSparklinesВидеоApplying Excel Functions for Data AnalysisDIALOGUEAdvanced Excel Functions - AssessmentЗадание
04Putting it all together: Excel for data analysis6 материалов

Putting it all together: Excel for data analysis

What day of the week does Dr. Doe write the most prescriptions?ВидеоMatching two data setsВидеоPivot Tables and VisualsВидеоWhat antiplatelet agents are being prescribed in the organization?ВидеоUnderstanding Data Analysis and Visualizations in ExcelDIALOGUEPutting it all together: Excel for data analysis - AssessmentЗадание
05Putting it all together: Excel for Project Management3 материалов

Putting it all together: Excel for Project Management

Creating a project management tool from start to finishВидеоFull Course Practice AssessmentЗаданиеFull Course AssessmentЗадание