Excel Foundations
Learn foundational techniques to efficiently analyze pharmacy data.
Getting Started
FREE PREVIEWExcel Foundations Files
Exercise File Overview
Pre-course Survey
1. Navigation and Formatting
FREE PREVIEW2. Filtering and Sorting
3. Data Types
Knowledge Check #1
4. Data Tab
5. Function Syntax & Cell References
6. Logical Comparisons
Knowledge Check #2
7. Conditional Aggregation
8. Lookup Functions
Knowledge Check #3
9. PivotTables
10. Charts & PivotCharts
Skills Test: MUE
Skills Test: MUE File Download
MUE Quiz
Course Completion
Post-Course Survey & Feedback
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.
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 is estimated to take 5 hours to watch all videos and complete the project. However, this can vary depending on your previous experience.
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.
Yes! Groups of 3+ that would like to enroll at the same time are eligible for a discount. Email [email protected] for details.