Advanced Microsoft Excel refers to the expert-level skills and functionalities in Excel such as mastering pivot tables, using advanced formulas, creating visualisations, implementing macros and VBA, and data analysis tools like Power Query and Power Pivot. It allows more sophisticated data management and analysis.