Where do I start?
We have many courses, so here is a quick guide for determining where to begin.
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 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. Also, feel free to contact us if we can provide any additional information or assistance ... thanks!