Microsoft Excel is a powerful tool for data analysis that is widely available and commonly used in many industries, including healthcare. By learning how to use Excel for data analysis, clinicians can gain valuable skills that will help them to analyze and interpret data more effectively. Using simulated clinical data as part of the training can make it easier to connect the skills they are learning back to the real world. This is in contrast to other training programs that typically use non-clinical datasets, which can make it difficult to apply back to your practice setting.

Excel

Excel is a powerful tool for healthcare data analysis, enabling professionals to efficiently organize, process, and extract valuable insights from complex data sets. Learn the fundamentals of sorting, filtering, and aggregating your data. Plus, learn techniques to connect data with lookups to save time and reduce copy and paste errors!

This 3-hour online class is taught with live demonstration.

Topics include:

  • Navigating data efficiently

  • Filtering and sorting

  • Function syntax

  • Analyzing Dates

  • Conditional IF statements

  • Aggregate functions

  • Lookup functions, such as XLOOKUP

  • Introductory PivotTables and PivotCharts

Advanced

The advanced class builds on foundational concepts to unlock more powerful data insights. and features of one of the most commonly used tools for data analysis. This course consists of live instruction followed by hands-on practice as you evaluate a simulated clinical data set.

This 3-hour online class is taught with live demonstration.

Topics include:

  • Conditional aggregate functions

  • Text Functions

  • Wildcard Matches

  • Lookup functions with multiple criteria

  • Analyzing data in tables

  • Array Functions

Who Should Take Each Course?

This class is for anyone looking to gain exposure to foundational skills analyzing clinical data. Whether you are new to Excel or are looking to brush up on lookup functions, this course is for you!

$200 Per Person

Foundations

Foundations

No prior experience necessary

Review foundational features

Learn with clinical scenarios

Live online instruction

Advanced

This class if for anyone looking to advance their skills to complete more complex data analysis tasks. Those enrolling in this class should have prior knowledge of the topics in Excel I: Foundations.

Prior knowledge of concepts in Excel I: Foundations

Review more complex data analysis tasks

Learn with clinical scenarios

Live online instruction

$200 Per Person

Prior foundational knowledge

Review intricate data analysis tasks

Learn with clinical scenarios

Live online instruction

Looking to customize the curriculum or interested in student discounts?

Want to learn how to analyze your data for a project or initiative?