Course Curriculum

    1. Welcome

    2. Advanced Excel Files

    3. Exercise File Overview

    4. Pre-course Survey

    1. 1. Tables

    2. 2. MINIFS & MAXIFS

    3. 3. Text Functions

    4. 4. Wildcards

    5. 5. IFS

    6. Checkpoint 1

    7. Checkpoint 1 Quiz

    8. 6. COUNTIFS with Operators

    9. 7. XLOOKUP with Multiple Criteria

    10. 8. UNIQUE & FILTER

    11. Checkpoint 2

    12. Checkpoint 2 Quiz

    13. MUE

    14. MUE Quiz: Advanced Excel

    1. Advanced Excel Complete

    2. Post-Course Survey & Feedback

Course Overview

  • 20 lessons
  • 0.5 hours of video content
  • Guided Exercises and 1 MUE

Course Activities

  • Lessons

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

  • Medication Use Evaluation

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

Enroll in the Sparx Academy

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

Enroll

Frequently Asked Questions

  • How do I enroll?

    This course is included in all Sparx Academy memberships. Click "Enroll" in the header of this webpage 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?

    This course builds on the skills of the Excel Foundations course. Participants should be comfortable with those topics prior to starting this course.

  • How long does the program take to complete?

    It is estimated to take 5 hours to watch all videos and complete the exercises and projects. However, this can vary depending on your previous experience.

  • 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.