Advanced Excel includes topics like advanced formulas and functions (

INDEX/MATCHcap I cap N cap D cap E cap X / cap M cap A cap T cap C cap H

𝐼𝑁𝐷𝐸𝑋/𝑀𝐴𝑇𝐶𝐻

,

IFcap I cap F

𝐼𝐹

,

SUMIFScap S cap U cap M cap I cap F cap S

𝑆𝑈𝑀𝐼𝐹𝑆

), data analysis tools such as PivotTables, PivotCharts, and Power Query, automation with macros and VBA, data visualization including advanced charts and dashboards, and data management features like conditional formatting, data validation, and advanced filters. What-if analysis and scenario modeling are also key components.