There are no immediate benefits to being an Excel "expert" UNLESS you are at a job OR looking for a job that requires you to be one.
I work in Finance. I have used Excel for almost 10 years. I have not gone beyond pivot tables and v-lookups. These are great skills but not necessarily useful unless you're dealing with shit loads of data.
This being said, if you are in professions that require you to process SHIT TONS of data, then knowing some "macros" and more "advanced" functionality will get you far.
Overall, depends on what you need it for and always assume that everyone you're competing against will likely have "non-advanced" skills already BUT they can be learned easily.
I work in Finance. I have used Excel for almost 10 years. I have not gone beyond pivot tables and v-lookups. These are great skills but not necessarily useful unless you're dealing with shit loads of data.
This being said, if you are in professions that require you to process SHIT TONS of data, then knowing some "macros" and more "advanced" functionality will get you far.
Overall, depends on what you need it for and always assume that everyone you're competing against will likely have "non-advanced" skills already BUT they can be learned easily.