Its 2025 and I am having the same issue. I have searched several areas to learn how to filter values in excel for this same exact lesson and none of the suggestions above have worked entirely to provide the intended results. I am able to get the values less than 10Mil to show by opening each of the year's dropdowns, then applying the filter to each column but after that I am unable to even understand what I am doing anymore.

In this case, it best to use google sheets to complete this assignment and any on the job duties that requires this type of filtering. The lesson did not provide a resource or steps on this to use excel either so I would assume it's a complex process that we are all missing. The more we explore and understand what we are doing I am sure we can find a workaround that works in the future.