"Advanced Excel" is a phrase from job listings, and sooner or later someone checks it: a screening test before the interview, or an interviewer with a dataset and a shared screen. Better to find out first, in private, where your skill tops out, and what the phrase asks of you in the first place.
Free · nothing to install · your level when you finish
Less than people fear, more specific than people hope. In most listings it comes down to this:
What it usually does not mean: VBA, macros, and Power Query. Those belong to a tier listings tend to call "expert". Some vendors' advanced tests reach into them, but for most roles the list above is the whole claim.
Every employer draws the line between the tiers somewhere else, so calling yourself one or the other is a guess. The test removes the guess: you don't pick a level, it places you, whether that turns out to be intermediate, advanced or somewhere in between.
An "advanced Excel" line on a CV is an invitation: interviewers probe it, and a claim that wobbles costs more than the modest one you could have defended. The free test gives you something firmer than the adjective: your level when you finish, and with a free account a skill map showing which of the list above you've shown you can do. Then the CV line can name them: "joins datasets with lookups, builds pivot tables, writes multi-criteria formulas." Whatever doesn't hold yet, the practice pages cover.
Lookups, conditional sums, pivot tables: the free test goes as far as your skill does and shows your level at the end. Nobody sees the result but you.
Take the free Excel test