Advance Excel includes Pivot and slicers, complex lookups, logical functions, conditional formatting, excel dashboards and VBA macros. As Advanced Excel user you should familiar with how to structure and visualize data so that it looks impressive.