Course Curriculum

    1. Welcome to the Pharmacy Analytics Excel Certificate Program!

    2. Pre-course Survey

    1. Getting Started

    2. Excel Foundations Files

    3. Exercise File Overview

    4. 1. Navigation and Formatting

      FREE PREVIEW

    5. 2. Filtering and Sorting

    6. 3. Data Types

    7. 4. Data Tab

    8. 5. Function Syntax & Cell References

    9. 6. Logical Comparisons

    10. 7. Conditional Aggregation

    11. 8. Lookup Functions

    12. 9. PivotTables

    13. 10. Charts & PivotCharts

    14. Skills Test: MUE

    15. Skills Test: MUE File Download

    16. MUE Quiz: Excel Foundations

    1. Getting Started

    2. Advanced Excel Files

    3. Exercise File Overview

    4. 1. Tables

      FREE PREVIEW

    5. 2. MINIFS & MAXIFS

    6. 3. Text Functions

    7. 4. Wildcards

    8. 5. IFS

    9. Checkpoint 1

    10. Checkpoint 1 Quiz

    11. 6. COUNTIFS with Operators

    12. 7. XLOOKUP with Multiple Criteria

    13. 8. UNIQUE & FILTER

    14. Checkpoint 2

    15. Checkpoint 2 Quiz

    16. MUE

    17. MUE Quiz: Advanced Excel

    1. Getting Started

    2. Data Visualization Foundations

    3. Dashboard Assignment

    4. Dashboard Quiz

    5. Dashboard Quiz Answer Key

    1. Pharmacy Analytics Excel Certificate Complete

    2. Post-Course Survey & Feedback

Course Overview

  • 42 lessons
  • 2.5 hours of video content
  • Exercises, 2 MUEs & 1 Dashboard

Course Activities

  • Lessons

    Complex topics are broken into small, easy to understand videos accompanied with guided exercises.

  • Medication Use Evaluations

    Reinforce key topics that translate back to real-world analytics.

  • Data Visualization

    Build a dashboard utilizing data visualization best practices.

Enroll in the Sparx Academy

Already a member? Find this course in your dashboard to start learning.

Enroll

Testimonials

5 star rating

Outstanding Certificate Program!!!!

Brian McKinzie

Decided to sign up for this because I wanted to expand my analytics knowledge beyond simple Excel functions- very glad I did! This is a well thought out program that gets you comfortable with more basic analytic functions and slowly expands into ...

Read More

Decided to sign up for this because I wanted to expand my analytics knowledge beyond simple Excel functions- very glad I did! This is a well thought out program that gets you comfortable with more basic analytic functions and slowly expands into the advanced including graphs and presenting findings via a dashboard. Adam was also very responsive with questions I had and issues I had going through the exercises. Would recommend to anyone wanting to go beyond the basics!

Read Less
5 star rating

Highly Applicable

Tyler Colvard

Very refreshing to have a pharmacy-based analytics course with a multitude of information presented via video and with exercises to accompany the material.

Very refreshing to have a pharmacy-based analytics course with a multitude of information presented via video and with exercises to accompany the material.

Read Less

Frequently Asked Questions

  • How do I enroll?

    This course is included in all Sparx Academy memberships. Click "Enroll" to register if you aren't already a member. If you are a member, the course will be located in your dashboard.

  • Do I need any experience prior to starting this program?

    No prior experience is needed. This program is great for those new to excel or those with prior experience who want to learn new approaches. It starts with foundational concepts and builds into more advanced techniques.

  • How long does the program take to complete?

    It is estimated to take 15 hours to watch all videos and complete the exercises and projects. However, this can vary greatly depending on your previous experience and the amount of effort you put into the projects.

  • Do I need software?

    You will need your own access to Microsoft Excel prior to enrollment. The videos were created using Excel on Windows 365. You can still take the class if using Excel on a Mac.

  • Are there group discounts?

    Yes! Groups of 3+ that would like to enroll at the same time are eligible for a discount. Email [email protected] for details.