Enroll in Live Course
Need help enrolling?
Watch our video tutorial.
- Thumbnail
-
- Course name
-
Advanced Excel
- Summary
-
Most working professionals haven’t mastered what this course teaches. Advanced Excel covers dynamic arrays, Power Query, VBA programming, user forms, Python in Excel, and Microsoft Copilot — tools that are reshaping how data-driven decisions are made and that remain rare even in today’s workforce. Students who complete this course won’t just be ahead of their peers — they’ll be ahead of most adults. Taught by a former NASA Space Shuttle Engineer and active SE&I consultant for NASA’s Commercial Crew and Commercial LEO Destinations programs. Sign up today.
Course Description :
Advanced Excel is built for students ready to work like professionals. The course opens with modern lookup functions including XLOOKUP, which overcomes the well-known limitations of traditional VLOOKUP, then moves into dynamic array formulas — FILTER, SORT, UNIQUE, SPILL, and related functions — that fundamentally change how data flows across a spreadsheet. Power Query equips students to import, clean, and transform data from multiple sources with repeatable, automated steps. Advanced PivotTable techniques including slicers, timelines, and calculated fields bring analysis to a professional level. The course then goes into VBA programming and custom user form development, enabling students to build interactive, automated tools within Excel. It closes with genuinely cutting-edge territory: Python integration within Excel and Microsoft Copilot — AI-powered capabilities that most of today’s workforce has yet to adopt. Students completing this course will be well positioned for college and careers in engineering, data science, business, finance, and beyond.
Instructor : Domenico Ruggiero, MS-EM
Microsoft Excel application must be installed on the student’s computer. Excel for Windows is covered in the course. Students using Excel for Mac will still benefit from the course, but the user interface may be different at times. Some topics (Python in Excel, Copilot) may require a Microsoft 365 subscription with relevant features enabled. The instructor will provide all other necessary materials free to students. Recommendations for other resources will be provided with no obligation to purchase.
- Course name
-
Advanced Excel
- Instructor
-
Domenico Ruggiero
- Semester
-
Spring 2027
- Meeting days
-
Monday
- Category
-
Computer Science ➤ Editing/Computer Skills
- Grade levels
-
High School, Middle School
- Start time
-
January 11th, 2027 at 7:00 PM ET
- Course type
-
Live
- Price
-
$252
- Seats available
-
25 seats available
- Seats remaining
-
25 seats remaining
- Relative due dates
- Enhanced quiz security
- Enhanced assignment security
- This material is only to be used for its intended purpose by active subscribers of Homeschool Connections or purchasers of the course. Any other use without explicit permission is in violation of the seventh commandment, and in violation of US and International copyright laws.
- You may print or download to your own storage extracts for your personal homeschool and non-commercial use only. Use for homeschool co-ops is permitted after contacting customer support and receiving written permission from Homeschool Connections.
- Upon completion of the course, you must delete all copies of course materials from any storage on which you saved permissible extracts.
Special notes
This course pairs well as a follow-on to Basic Excel, but Basic Excel is not a prerequisite. Students should have sufficient familiarity with Excel to be effective in the more complex tasks of the course. Students new to Excel are encouraged to enroll in Basic Excel first.
Total classes
Class dates
Starting time
Duration
Prerequisites
Basic Excel is not a prerequisite for this course; however, students should have sufficient familiarity with Excel to be effective in the more complex tasks covered. Excel for Windows is covered in the course. Students using Excel for Mac will still benefit from the course, but the user interface may be different at times. Some topics (Python in Excel, Copilot) may require a Microsoft 365 subscription with relevant features enabled.
Suggested grade level
Suggested credit
Outline
Course Outline:
Topics are subject to slight change. These topics will be covered in an interspersed manner throughout the course.
· XLOOKUP and modern lookup functions
· Dynamic arrays (FILTER, SORT, UNIQUE, SPILL, and related functions)
· Power Query — importing, transforming, and cleaning data
· Advanced PivotTables — slicers, timelines, and calculated fields
· VBA programming
· User forms
· Python in Excel
· AI and Copilot integration in Excel
· Advanced data visualization
Materials
Homework
Students will develop workbooks individually, applying advanced techniques covered throughout the course. Course grades are based on online quizzes with questions drawn from what students have learned through their hands-on use of Excel.
Fees
Fee : For all 14 classes: $232 if you register on or before November 15; $252 if you register after Nov. 15. (Registration closes one week before the first day of class. After that date, registrations are not guaranteed. There is a $25 surcharge for late enrollments after the course is closed.)
Domenico Ruggiero
domenicoandsonia@gmail.com
About Domenico Ruggiero
Domenico Ruggiero holds a Bachelor’s of Science in Aerospace Engineering from the University of Florida and a Master’s degree in Industrial Engineering – Engineering Management from the University of Central Florida.
About Domenico Ruggiero
For most of his professional career, Domenico has worked at or near the NASA Kennedy Space Center. He has worked on the Space Shuttle Program as an Orbiter Structures Engineer for United Space Alliance. Currently, he works for a large government consulting firm where he has held many roles including Systems Engineer on the NASA Constellation Program and the NASA Commercial Crew Transportation Systems Program. More recently, Mr. Ruggiero works as a data analyst & productivity automation expert for a variety of government agencies.
© 2027 Homeschool Connections; Domenico Ruggiero. All Rights Reserved.
Violation of the above copyright policies may result in expulsion without any refund and/or legal action.