Where do I start?
Course Guide
We have many training options, so here is a quick guide for determining where to begin.
If you are new to Excel
If you are a new Excel user ... welcome! I'm excited for your Excel journey!
We offer free lessons for beginners:
Once you finish the Excel 100 lessons, you would be ready to study our Undergraduate lessons offered in our courses or Campus Pass.
If you are already comfortable with Excel
We have three groups of courses: Undergraduate, Masters, and Guest Lectures. These courses are available for Continuing Professional Education CPE credit for CPAs and others that require it to maintain their professional license.
The Undergraduate and Masters curriculum are also available in our monthly Campus Pass subscription (without CPE credit).
Here is a comparison chart that explains the differences between Courses and a Subscription.
Undergraduate Courses (1-4)
Undergraduate courses 1-4 teach classic Excel features and functions. These are the big topics you'd expect to learn, such as PivotTables, VLOOKUP, INDEX/MATCH, SUMIFS, EOMONTH, Conditional Formatting, Tables, Data Validation, Named Ranges, best practices, and so on. There are over 80 topics in the undergrad courses.
Most students, even if they've been using Excel a while, benefit by starting with the Undergraduate courses and taking them in order 1-4. The undergrad courses are designed for people who would say they know the basics but are ready to improve their skills.
If you are already proficient with the classic Excel topics covered in the undergrad courses (PivotTables, VLOOKUP, INDEX/MATCH, etc.) then you are free to skip them and head straight into the Masters courses.
Masters Courses (1-2)
Masters courses 1-2 teach technical topics, including Power Query, Power Pivot, data modeling, table and graph design practices, Power BI, VBA, and Macros.
The six Excel University Undergraduate and Masters courses are designed and taught by Jeff Lenning. So, students can experience an organized learning path by taking undergrad and then masters. However, for students who want a single course on a specific topic, then you'll want to check out the Guest Lectures.
Guest Lectures
Guest Lectures dig deep into specific topics taught by experts in their field. These are Excel MVPs and experts who have created courses to help people learn specific skills.
For more information about a specific course, just click the course link to reveal the details for the course. The details include the topics, timed agenda, and more.
Please contact us if we can provide any additional information or assistance ... thanks!