Advanced Excel - Vlookup, Pivot Tables, Index Match, Sort, Conditional Formatting, Data Validation, Macro Automation
Conditional/Logical Functions:
IF, IFS, IFERROR: Perform different actions or return different values based on whether a condition is true or false, or to handle errors gracefully.
AND, OR, NOT: Used to combine multiple logical conditions.
SUMIF, COUNTIF, AVERAGEIF (and their "S" counterparts - SUMIFS, COUNTIFS, AVERAGEIFS): Perform calculations based on specified criteria. For example, SUMIFS can sum values that meet multiple conditions (e.g., total sales for a specific product in a specific region)
FILTER, SORT, UNIQUE, XLOOKUP, SEQUENCE, and ARRAYFORMULA
Macros: Recorded sequences of actions that can be replayed to automate repetitive tasks. You can record a macro or write VBA code directly.
Dashboards: Combining multiple advanced features (PivotTables, charts, slicers, conditional formatting, formulas) to create interactive and visually appealing summaries of key performance indicators (KPIs) and data trends.